4
votes
1answer
78 views

strace shows long time reading from mysql socket - mysql takes long time to execute query?

My Apache server takes long time to process request. I attached strace to it and can see the two following delays: 1) Very critical (143 seconds to process) 1335 0.000037 write(16, ...
3
votes
3answers
249 views

MySQL hangs if connection comes from outside the LAN

I have a MySQL Server operating just fine if I access him from his local LAN (192.168.100.0/24). If I try to access hin from another LAN (192.168.113.0/24 in this case) it hangs for a really long time ...
0
votes
0answers
35 views

MySQL sandbox strace option

Latest MySQL Sandbox version uses environment variable SBDEBUG to start mysql instances in debug mode, but i can't pass mysql --debug option. export SBDEBUG=d:t:O,/tmp/client.trace cd ...
3
votes
0answers
299 views

mysql client slow login strace

I am experiencing an issue with slow connections/logins to a loaded mysql server, even when connecting via the unix socket file (CentOS 6.3). Queries are completing very quickly -- (0.00 sec) in this ...
0
votes
2answers
341 views

Mysql killing the CPU with gettimeofday

I have a problem with mysql killing the CPU on a Debian Squeeze 64. This is a development machine on a VPS so I stopped all the other services, including apache2. The mysql version is 5.1.49. This is ...
0
votes
3answers
822 views

Remi Repo Mysql Server Not Starting

Executing the command to start the mysql service fails to start the mysql server. [root@localhost]# service mysqld restart Stopping mysqld: [ OK ] MySQL ...