Hello,
After reading through the docs and searching the mail
list I can't figure out how Created_tmp_tables
relates to Opened_tables. Can someone please explain?
I starting to learn C so hopefully I'll be able to answer
a lot of my own questions by looking at the code.
my current output on a 233 pentium 1 running linux 2.0.36
with glibc 2.1 ecgs 1.1.2:
[root@datahouse tmp]# mysqladmin exte
+--------------------------+-----------+
| Variable_name | Value |
+--------------------------+-----------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
| Created_tmp_tables | 713 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 10 |
| Delayed_errors | 0 |
| Flush_commands | 5 |
| Handler_delete | 1 |
| Handler_read_first | 0 |
| Handler_read_key | 10142649 |
| Handler_read_next | 177565946 |
| Handler_read_rnd | 97588369 |
| Handler_update | 27450 |
| Handler_write | 5601853 |
| Key_blocks_used | 898 |
| Key_read_requests | 6804136 |
| Key_reads | 857 |
| Key_write_requests | 4616 |
| Key_writes | 3317 |
| Max_used_connections | 152 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 64 |
| Open_files | 48 |
| Open_streams | 0 |
| Opened_tables | 255 |
| Questions | 337850 |
| Running_threads | 133 |
| Slow_queries | 269 |
| Uptime | 61460 |
+--------------------------+-----------+
I'm trying to optimize some parameters, my current settings are:
[root@datahouse tmp]# mysqladmin vari
+----------------------------+---------------------------------+
| Variable_name | Value |
+----------------------------+---------------------------------+
| back_log | 5 |
| connect_timeout | 5 |
| basedir | /usr/local/ |
| datadir | /usr/local/data/ |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| join_buffer | 131072 |
| flush_time | 0 |
| key_buffer | 8384512 |
| language | /usr/local/share/mysql/english/ |
| log | OFF |
| log_update | OFF |
| long_query_time | 10 |
| low_priority_updates | OFF |
| max_allowed_packet | 999424 |
| max_connections | 300 |
| max_connect_errors | 10000 |
| max_delayed_insert_threads | 20 |
| max_join_size | 4294967295 |
| max_sort_length | 2048 |
| net_buffer_length | 16384 |
| port | 3306 |
| protocol-version | 10 |
| record_buffer | 4190208 |
| skip_locking | ON |
| socket | /tmp/mysql.sock |
| sort_buffer | 4194296 |
| table_cache | 200 |
| thread_stack | 65536 |
| tmp_table_size | 8388600 |
| tmpdir | /tmp/ |
| version | 3.22.22 |
| wait_timeout | 28800 |
+----------------------------+---------------------------------+
--
Vincent Stoessel - Corporate Accounts, Manager
vince@stripped - 301 847 6548 (direct) 301 847 5082 (fax)
24-hour Support Line - 301 847 5200 or 1 800 969 9090
Intermedia Communications Business Internet
