Did you try --skip-name-resolve ?
Not sure if you are using any sort of caching, but memcahced may be a
solution to mitigate some of the load for reads.
2009/6/8 Jancsok Akos
> hi,
>
> I need some urgent help. We have encountered a problem, when we try to
> connect in shell with a mysql cli
The New MySQL Release Model
http://forge.mysql.com/wiki/The_New_MySQL_Release_Model
This Thursday (June 11th, 14:00 UTC), Tomas Ulin will give a MySQL
University session on The New MySQL Release Model. Tomas is the MySQL
Server Director, and will explain the new MySQL release model which has
just
hi,
I need some urgent help. We have encountered a problem, when we try to connect
in shell with a mysql client to the mysqld (via socket or via localhost). The
connection takes 5 to 50 seconds, or it happens that the connection is fast,
but then the "use somethingdb;" needs 5 to 50 seconds.
W
If you do not want to use InnoDB at all, add this line to /etc/my.cnf under the
[mysqld] section
skip_innodb
Then do the following
service mysql stop
rm -f /var/lib/mysql/ibdata1 /var/lib/mysql/ib_logfile[01]
service mysql start
This will totally and cleanly disable InnoDB on the DB server
Give
We are running MySQL 5.0.45 on a Linux machine.
Today, when I tried to go into MySQL via the command line, I got an error
message:
Can't connect to local MySQL server through socket
'/usr/local/mysql/tmp/mysql.sock'
The error log was full of the following messages:
InnoDB: Unable to lock ./ibd