List:General Discussion« Previous MessageNext Message »
From:Vincent Stoessel Date:May 26 1999 6:40pm
Subject:Created_tmp_tables vs. Opened_tables
View as plain text  
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
Thread
Created_tmp_tables vs. Opened_tablesVincent Stoessel26 May
  • Created_tmp_tables vs. Opened_tablesMichael Widenius2 Jun