Re: Intermittent connect errors

[Stefan Linden]

Hi

Thanks for answering. I check those parameters quite often in order to tune system accordingly and I have never seen that we have ran out of connections.

Today:


mysql> SHOW VARIABLES LIKE 'max_connections';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 200 |
+-----------------+-------+
1 row in set (0.01 sec)

mysql> SHOW STATUS LIKE 'Max_used_connections';
+----------------------+-------+
| Variable_name | Value |
+----------------------+-------+
| Max_used_connections | 122 |
+----------------------+-------+
1 row in set (0.00 sec)


I will try to fix all of the MyIsam-tables to see if it helps.

Is it safe to script myisamchk so that it traverse all databases that contains MYI-files?

I have noticed that it is a good idea to do it when the db is shutdown, which in our case is hard to accomplish.

Regards Stefan