MySQL is installed as a service running locally. Also, this error occurs with version 3.23.53 onwards (I never tested on older versions than this).
Thanks, Dan -----Original Message----- From: Dan Cumpian [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 10:27 PM To: [EMAIL PROTECTED] Subject: Help with 4.0.12 on WinXP Hello, I am having the following problem that I've been able to consistently replicate: I am using code written in Delphi with Zeos Database components and am having a problem with a query returning "server connection error". I am inserting a row into a table and then immediately selecting a row from a table . This error occurs whether I select out of the table I inserted the new row into or from any other table. After inserting 3700-3900 rows, the select will be unable to connect. For at least 10-30 seconds, I cannot connect to MySQL, even with MySQL-Front (I get a "Can't connect to server" error). There are no errors being logged. After the 10-30 seconds passes, I can resume the program and it happens again after 3700-3900 rows. This does not happen on Windows 2000, only Windows XP (both Home and Pro). All connection are through Localhost. My configuration file is: [mysqld] set-variable=key_buffer_size=18M set-variable=myisam_sort_buffer_size=8M set-variable = max_allowed_packet=16M Table type is MyISAM. Machine is a P4-2.2Ghz with SCSI hard disks. Can anyone please suggest what I might be able to do to resolve this issue? Thank you, Dan Cumpian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
