Hi, I've got a *BIG* problem here...
I have a mysql database with some big tables (50,000 - 80,000 records and above) running on a netbsd machine. Users run queries from their windoze machines through a delphi program via myodbc. I didn't write that application so I can only guess the queries that are made... (judging the load -- SELECT * from...???) As long as there is only *one* user doing his queries mysql is running just as smooth as a melting piece of butter in the hot frying pan BUT when more users try to do so things are getting *real* slow - people told me they had to wait ten minutes for the return of 26 records which took 10-15 seconds at most some time before (assuming there was only one user querying..). Besides that my log files fill up with messages of the following kind: Aborted connection 103 to db: 'XXX' user: 'XXX' host: `XXX.XXX.XXX.XXX' (Got timeout reading communication packets) I've already browsed through different forums and lists and all the issues and solutions did not help a bit: TCP config issues: nope, 'cause I can use telnet or the mysql client through port 3306... Ethernet Full duplex bug (??? what the #+*%$§ ???): nope again, ftping big files working ok - no errors safe_mysqld: the ulimit fix for bsd systems is active. I raised the variable values (key_buffer, max_allowed_packets..., ya know) for the mysql daemon in my.cnf, restarted and mysqladmin variables returned proper values. finally some more system info: PIII 933 512MB RAM OS: NetBSD 1.5.2 MySQL 2.23.35 no other application is running on the system Oh - I forgot: because of file system issues (NetBSD users might know what I'm talking about - mysql package standard install path... I should have compiled from source...) the database is symbolically linked... A very nice guy named Mike (thx again) mailed me that the prob might be improperly formatted records, but I wasn't able to contact the app programmer for debugging issues yet... Any other ideas are most welcome, 'cause this is getting *really* hot for me, as the system should be going productive next week - :^(--moan--sweat--groan--:^( thanx in advance marc --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
