I am getting this error in my log files from mysql
(Got timeout reading communication packets)
I'm starting safemysql with the variables
-O key_buffer=16M -O sort_buffer=1M -O back_log=200 &
mysql> show status
-> ;
+--------------------------+----------+
| Variable_name | Value |
+--------------------------+----------+
| Aborted_clients | 0 |
| Aborted_connects | 1 |
| Bytes_received | 9204605 |
| Bytes_sent | 13211959 |
| Connections | 23 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_tables | 0 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 0 |
| Handler_read_first | 39275 |
| Handler_read_key | 97534 |
| Handler_read_next | 79518 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 0 |
| Handler_read_rnd_next | 39287 |
| Handler_update | 0 |
| Handler_write | 0 |
| Key_blocks_used | 485 |
| Key_read_requests | 1575217 |
| Key_reads | 19971 |
| Key_write_requests | 0 |
| Key_writes | 0 |
| Max_used_connections | 20 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 30 |
| Open_files | 37 |
| Open_streams | 0 |
| Opened_tables | 36 |
| Questions | 136803 |
| Select_full_join | 0 |
| Select_full_range_join | 0 |
| Select_range | 0 |
| Select_range_check | 0 |
| Select_scan | 0 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 0 |
| Sort_rows | 0 |
| Sort_scan | 0 |
| Table_locks_immediate | 136813 |
| Table_locks_waited | 0 |
| Threads_cached | 0 |
| Threads_created | 22 |
| Threads_connected | 21 |
| Threads_running | 1 |
| Uptime | 1084 |
+--------------------------+----------+
There is a large amount selects made to the database.
I have tried to tune it but no luck.
Vien Huynhle
Clearsail Communications
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
