Just upgraded from 3.21.33b to 3.22.21. Running
on RH5.2.
Previously, when I'd do a top, mysqld's were using
around 20M of RAM each.
Here's the /etc/my.cnf:
[mysqld]
log-update = /usr/local/var/mysql.update
set-variable = key_buffer=16M
set-variable = table_cache=256
set-variable = sort_buffer=8M
set-variable = record_buffer=1M
Now, when I do a top, mysqld's are using around 6.5M.
Was I just seeing things before?
Thanks!
--jim
Here's the output of mysqladmin variables:
+----------------------------+---------------------------------+
| Variable_name | Value |
+----------------------------+---------------------------------+
| back_log | 5 |
| connect_timeout | 5 |
| basedir | /usr/local/ |
| datadir | /usr/local/var/ |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| join_buffer | 131072 |
| flush_time | 0 |
| key_buffer | 16773120 |
| language | /usr/local/share/mysql/english/ |
| log | OFF |
| log_update | ON |
| long_query_time | 10 |
| low_priority_updates | OFF |
| max_allowed_packet | 1048576 |
| max_connections | 100 |
| max_connect_errors | 10 |
| max_delayed_insert_threads | 20 |
| max_join_size | 4294967295 |
| max_sort_length | 1024 |
| net_buffer_length | 16384 |
| port | 3306 |
| protocol-version | 10 |
| record_buffer | 1044480 |
| skip_locking | ON |
| socket | /tmp/mysql.sock |
| sort_buffer | 8388600 |
| table_cache | 256 |
| thread_stack | 65536 |
| tmp_table_size | 1048576 |
| tmpdir | /tmp/ |
| version | 3.22.21-log |
| wait_timeout | 28800 |
+----------------------------+---------------------------------+
