RE: default table type = innodb is stable??

this is my error log file. InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes InnoDB: than specified in the .cnf file 0 268435456 bytes! Your problem here is that you must have started MySQL when you had a 5MB transaction log file specified, but you then put a new

Re: Non-linear degradation in bulk loads?

Jon, your hardware/OS combination is quite new and unusual. It might indeed be an OS problem. We observed from a 64-bit RHEL 4 that when the file cache of the OS grew bigger than 4 GB, then the file I/O performance dropped to one tenth of the normal. You would not expect that kind of behavior

limited threads to two but 25 waiting?!

Hi, I have searched and tried and have no clue why the db on 4.1.11-Debian_4sarge2 behaves like this. I have no TABLE LOCK query anywhere in my code! About the server (LAMP/ 2x3Mhz, 4GB RAM) 1. prob. the mysql show processlist gives me a list of 25 threads waiting for there work. even on heavy

Re: Connectivity problem (?), mysql_ping ()

I did some extensive testing and it looks like that only the first mysql_ping () fails to reconnect or very possibly returns the wrong result. I am currently using v4.1.14. Regards, Lefteris Begin MySQL is up and running Restart MySQL and

mysql_ping() and multithreading

Hi, The previous subject made me wonder about mysql_ping () in a multithread environment. Since it implements restoring connectivity, should it also be protected by a mutex? Regards and thnx, Lefteris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: limited threads to two but 25 waiting?!

Hello. Please, send to the list your queries and CREATE statements for tables which are used by you queries. Include the output of SHOW PROCESSLIST. 2. When writng in my.cnf the skip-bdb option still the server reserves memmory for berklyDB aswell with innoDB. But writing somthing

Re: Connectivity problem (?), mysql_ping ()

Hello. I've found that mysql_ping doesn't work properly with TCP connection (in your test case you put the hostname to 127.0.0.1). My program was working with localhost - connection through the Unix socket. You may want to add you comments to my bug report at:

Re: Connectivity problem (?), mysql_ping ()

Hi again, This is intresting, the documentation indeed mentions that mysql_ping indicates Zero if the connection to the server is alive and not that zero if the server is alive, as I *naturally expected* also, so it is kind of tricky this one. I would expect the same behavior with Unix sockets

renaming the database

Hi, Is there a command for renaming a MySQL database? Thank you. Teddy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SQL statement help

Hello All, I have two MySQL 4.1 tables. The first table has an ID field which is set to zero. The second one has ID fields and filenames. I need a single SQL statement to set the ID from table 1 to the ID from table 2 ONLY IF the ID on one is zero. That is, if the ID on table one is not set

RE: SQL statement help

I am not the smartest on the list, but I think this would do it for you. UPDATE table_one t1, table_two t2 SET t1.ID = t2.ID WHERE t2.num = t1.num AND t1.ID = 0 J.R. -Original Message- From: C.F. Scheidecker Antunes [mailto:[EMAIL PROTECTED] Sent: Sunday, October 16, 2005 1:45 PM To:

Re: SQL statement help

I actually forgot something. I need a two statements into one. The reason is that table_two has multiple values, so I need the minimal ID from table 2.Thanks. Maybe I am working too much here and tired to see the right statement. J.R. Bullington wrote: I am not the smartest on the list, but

Re: SQL statement help

Another thing is that table2 might not have a match. C.F. Scheidecker Antunes wrote: I actually forgot something. I need a two statements into one. The reason is that table_two has multiple values, so I need the minimal ID from table 2.Thanks. Maybe I am working too much here and tired to

mysql_stmt_prepare after mysql_stmt_execute

Hi, I have problems calling mysql_stmt_prepare in the C-API after mysql_stmt_execute. I want to loop through a resultset by using a prepared statement. I call mysql_stmt_init, mysql_stmt_prepare and mysql_stmt_execute. Next I would loop with mysql_stmt_fetch_row. But before I would like to

RE: Killing a thread -- Urgent

The statement remained in the killed state for 2 hrs and then got out of the processlist. Great sigh of relief then :). Sorry for the late reply. But one thing I still couldn't understand is why it took so long to move out of the processlist from the killed state. sujay -Original

Re: default table type = innodb is stable??

Is that stable if i started mysql server by defining default_table_type = INNODB at the my.cnf file? from which by default my.cnf is defining MYISAM table to be the defaulted. Richard Dale wrote: this is my error log file. InnoDB: Error: log file ./ib_logfile0 is of different size

ALTER TABLE - how to fix truncated data?

My bad. I was renaming some columns in a table. I incorrectly set the type to decimal(4,2) and the data was truncated/hosed. Is there a way to recover the data. I tried a system backup from yesterday. That changed nothing. I have already set the column type back to the correct settings. I am

configuration directives 4.0.18

Hi. Where can I find a good explanation/description of the configuration directives for mysql as they appear in my.cnf? I've downloaded the 4.1 manual but can't seem to find a description of the directives. BTW. Is there a manual for 4.0.18 or 4.0 version? Thanks. Kind regards. -- Luke

mysql connectivity error

hi all, i have a mysql which only localhost can be logged in. if i have created an account [EMAIL PROTECTED], then, i cant login in as that host. mysql -u user -h mymachine.com -p ERROR 2003 (HY000) Cant connect to the MySQL server on 'x.x.x.x' (111) please advise. thanks -- MySQL General

Re: How to test the MySQL Server (windows version) ?

Hi! I tried to run the perl scripts in the windows platform yesterday,but an error occured as following output info: C:\MySQL\MySQLServer5\mysql-test\perl mysql-test-run.pl mysql-test-run: *** ERROR: Could not find C:/MySQL/MySQLServer5/scripts/mysql_fix_privilege_tables I

move log files to a different disk.

Hi All, I am using version 5 of mysql on lunix. I have place my log files in the same disk of datafiles, can you please let me know how i can move log files into a different disk. regards anandkl