Query sloooow

2007-08-26 Thread Jim Douglas 

I installed MySQL on Fedora 6 and simple queries are very slow.

I have ten databases with very few hundred records and there are only a few 
hundred records in the table I am querying.  I only have this issue on 
Fedora ONLY.  The same query on on my Windows machine is as expected.


What can I do to speed things up on Fedora?

Jim

_
See what you’re getting into…before you go there 
http://newlivehotmail.com/?ocid=TXT_TAGHM_migration_HM_viral_preview_0507



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

socket error

2006-03-13 Thread Jim Douglas 

I can connect to mysql with

mysql -u dbname  -p

When I start MySQL Administrator v 1.1.6 it says

Could not connect to host 'localhost'.
MySQL Error Nr. 2002
Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)

...then I Click on Details and enter, '/var/lib/mysql/mysql.sock'

And can connect, no problem.

Doesn't the Administrator look to /etc/my.conf for the socket location info?

This is my my.conf file
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

log-error=/var/lib/mysql/mysqlerrorlog
old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


Thanks

Jim



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]