last_insert_id() query

Hi, I have a big problem with last_insert_id() query. I am adding records to a table with about half a million records in it. The insert takes well under a second. I then call last_insert_id as I need to make a link to another table. The last_insert_id takes around 2 minutes!!! Yes

Mystery files

Hi, I my mysql server database directory (that is the directory that holds the .err and .pid files) so strange files have apeared. They look line machine-name-bin.001 machine-name-bin.002 etc machine-name-bin.index Some of them are huge! They seem like binary files, but are full

Re: MySQL Server Installation Problem

Sounds as though you haven't got Perl installed, or more particularly the DBI modules for MySql. If you on Linux, almost certainly to be found on your Linux CDs. HM Suresh R. Soni writes: Hi All, I am getting following error msg when I try to install MySQL using rpm -i My*

Explanation of error message

Hi, In my mysql .err file I get a lot of the following error... Aborted connection 121031 to db: ..connection details... (Got an error reading communication packets) What does this mean, and is it bad, and what do I do about it? Any help appreciated. Howard

Error message

Hi, In my mysql .err file I get a lot of the following error... Aborted connection 121031 to db: ..connection details... (Got an error reading communication packets) What does this mean, and is it bad, and what do I do about it? Any help appreciated. Howard

Re: Table RAID

I have a very large mysql table (1.5G) and so will need to implement the table RAID option soon. How do I pick the CHUNKSIZE and number of chunks values? Howard - Before posting, please check:

Re: Optimization And Memory Size

You have written the following: I have a mysql database table that is currently 1.5G in size with well over a million records. It is running on a twin pentium 3 1G processor machine with SuSE Linux version 1.4. Recently inserts have become VERY slow (several seconds). As I am adding around

Re: Table RAID

Hi, Thanks I DID read the documentation. BUT there documentation gives no information about how to choose values for these settings. There are no clues at all. What are good values, and/or what is the effect on performance etc. of the values? Howard Egor Egorov writes: mysql,

User specific queries.

Hi all, We want to set up a user in mysql and allow him to send his queries to our database from his server. (PHP) The data in our database contains our other customers' as well as the guy who wants to directly access it. We would like to check his queries before send it to the database. For

Re: problems startting MySQL under R.H. 7.1

Hi Andy, Try to kill the process first, then restart mysql server. Hope that helps. Thanks, Xi Jiang ITSportsNet Technical Support - Original Message - From: Andy De Paoli [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 12,