RE: MySQL starts using a lot of CPU resources

2001-12-28 Thread Mike Blain
related question: Does MySQL label as slow (as I believe PostgreSQL does) any query that is not referencing an indexed table? -Original Message- From: Carsten H. Pedersen [mailto:[EMAIL PROTECTED]] Sent: Friday, December 28, 2001 2:42 PM To: Jurrien Wijlhuizen; [EMAIL PROTECTED]

Uninstall source distribution?

2001-12-20 Thread Mike Blain
what is the best/safest way to uninstall a MySQL distribution that was installed from source (rather than RPMs)? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

mysql.sock??

2001-12-19 Thread Mike Blain
I just recently installed MySQL from source. Trying to set the root password and keep getting this error: /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)' Check that mysqld is running and

RE: mysql.sock??

2001-12-19 Thread Mike Blain
PROTECTED]] Sent: Wednesday, December 19, 2001 5:44 PM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: mysql.sock?? Hi, mysqld will create it when it runs - have you started the server? Quentin -Original Message- From: Mike Blain [mailto:[EMAIL PROTECTED]] Sent: Thursday, 20

RE: mysql.sock??

2001-12-19 Thread Mike Blain
To: [EMAIL PROTECTED] Cc: Quentin Bennett; [EMAIL PROTECTED] Subject: RE: mysql.sock?? Check your error log. What does it say? There is a reason that it won't start. Cal On Wed, 2001-12-19 at 21:19, Mike Blain wrote: I keep trying to start it and get this: [root@linuxdev1 mysql-3.23.46]# /usr

RE: mysql.sock??

2001-12-19 Thread Mike Blain
distribution, the data dir is in /var/lib/mysql -- On December 19, 2001 06:19 pm, Mike Blain wrote: I keep trying to start it and get this: [root@linuxdev1 mysql-3.23.46]# /usr/local/mysql/bin/safe_mysqld --user=mysql [1] 1822 [root@linuxdev1 mysql-3.23.46

RE: mysql.sock??

2001-12-19 Thread Mike Blain
, 2001 5:50 PM To: [EMAIL PROTECTED] Cc: Quentin Bennett; [EMAIL PROTECTED] Subject: RE: mysql.sock?? Check your error log. What does it say? There is a reason that it won't start. Cal On Wed, 2001-12-19 at 21:19, Mike Blain wrote: I keep trying to start it and get this: [root