Hi,
I have configured MySQL Cluster on two machines with 2 DB nodes
(NoOfReplicas = 2) and 2 MySQL API nodes, one of each node type on both
systems. The config is almost the same as the one of 2-node demo. The
cluster is working fine as long as all DB nodes are operational, but if one
of them is g
Hi,
I get this error/warning each time server reaches 623 connections and thus
no new clients can connect. What may I do to allow more clients?
I know that the limit on the size of `alarm_queue' is set in
mysys/thr_alarm.c, but is increasing the value in call of init_thr_alarm()
safe?
Regards,
Ma
Hi,
This happens on MySQL 3.23.44
CREATE TABLE ttble (
`k1` varchar(100) NOT NULL default '',
...
`k2` varchar(65) NOT NULL default '',
...
PRIMARY KEY (`k1`, `k2`)
...
) TYPE=InnoDB
When k1 is compared to a string with only one known letter...
EXPLAIN SELECT * FROM ttb
Hi,
How to tell mysql server to kill sleeping sessions after certain time while
using LinuxThreads on FreeBSD 4.4 ? None of wait_timeout and
interactive_timeout values seem to work.
-
Before posting, please check:
http://www
Hi,
Is this correct for MySQL to increment the auto_increment counter if the
INSERT query fails? For example:
mysql> CREATE TABLE test ( i INT NOT NULL AUTO_INCREMENT, c CHAR(16) NOT
NULL, PRIMARY KEY(i), UNIQUE(c)) type=InnoDB;
Query OK, 0 rows affected (0.25 sec)
mysql> INSERT INTO test VALUE
Hi,
Is there any way to check whether I should add new datafile before my
database runs out of free space in the existing ones?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.m
Hey,
I dunno whether it's a bug or just I don't know how to use transactions
properly. I've got 3.23.36 on FreeBSD 4.2-STABLE, and when I do this:
CREATE TABLE test TYPE=Innobase SELECT * otherdb.sometable;
MySQL hangs. If I limit the SELECT query to 10-100 rows, it executes quite
fast (same if
> This is because with the first query it can use the index. With
> the second query, it has to check the whole table. Why? Because
> obviously you're using numbers. And let's make some_value == 10.
I thought that maybe MySQL should check the field type and do the conversion
to string.
--
Hi,
There might be some kind of bug in UPDATE. Let's say there is a 4 row
table, which looks like this:
| fd_01 | int(11) unsigned | | PRI | 0 | |
| fd_02 | text | | | | |
| fd_03 | varchar(4) | | |
> probability of defuncting increases. with 350 connections the bug occurs
> really seldom (once a week or so), with 360 threads in the next hour and
> with 370 threads nearly immediately.
Did you try to increase system resources available for MySQL : number of
sockets (per process as well as tot
fix=/usr/local/mysql i386--free
bsd4.2
Perl: This is perl, version 5.005_03 built for i386-freebsd
--
Maciek Dobrzanski [EMAIL PROTECTED]
INTERIA.PL @ http://www.interia.pl/
11 matches
Mail list logo
