Re: Disaster with dash on mysql cli interface

2006-06-21 Thread Andrew Nelson
On Wed, 21 Jun 2006 11:12:40 -0400, Kevin Old wrote: Hello everyone, I had a horrible thing happen to me this morning and wanted to make it known to the community. I needed to delete a record from a very large table (yes, it was backed up) and like the cli interface of mysql. I ran this

Compile Problems -- Solaris 10 -- mysql-5.0.22

2006-06-15 Thread Andrew Nelson
Hello, I'm trying to compile mysql-5.0.22 on Solaris 10 using the Forte Compiler (cc: Sun C 5.8 2005/10/13). I'm doing this so I can build the DBI driver for mysql (DBD::mysql). The .pkg versions are missing libmysqlclient.so required to build DBD::mysql

Table Locking Problem? Very Slow MyISAM DB - PLS HELP!

2004-12-01 Thread Andrew Nelson
Hi, I have a MySQL 3.23.55 server managing accounts on my exim mail server.. The table type on all tables MyISAM.. I have the MTA performing various queries for each incoming email - determining mail aliases, vacation messages and filtering rules etc but they're all pretty much SELECT

Re: Table Locking Problem? Very Slow MyISAM DB - PLS HELP!

2004-12-01 Thread Andrew Nelson
Hi Victor, How did you deduce that the database server is the bottleneck? Are all your processes running on the same machine? Because 'ps -aux' shows it running at 94% of the CPU and when I stop/start the mysql server, it seems to be ok again for another hour. Any ideas? Andrew Nelson wrote

Re: Table Locking Problem? Very Slow MyISAM DB - PLS HELP!

2004-12-01 Thread Andrew Nelson
appreciate your help, Thanks, Andrew. Andrew Nelson wrote: Hi Victor, How did you deduce that the database server is the bottleneck? Are all your processes running on the same machine? Because 'ps -aux' shows it running at 94% of the CPU and when I stop/start the mysql server, it seems to be ok