Dedicated Dual Xeon 2.8 HT

[orban]

--------------------------------------------

1. dedicated (one other site, load before the forums was <0.3 0.3 0.3)

2. your server specs. For example:

cpu speed/type single or dual cpus): dual xeon 2.8 HT
how much memory installed: 1024mb ram
hard drive type/configuration: 2x 80GB EIDE non raid
linux distributor or windows version: debian stable, 2.6 kernel
apache/IIS version: apache 2.0.52
PHP version: php 5.0.3 (I use mysqli, rewrote db_mysql.php)
MySQL version: mysql 4.1.8a

3. No

4. CC=&quot;gcc&quot; CXX=&quot;gcc&quot; ./configure \
--prefix=/usr \
--exec-prefix=/usr \
--libexecdir=/usr/sbin \
--datadir=/usr/share \
--sysconfdir=/etc/mysql \
--localstatedir=/var/lib/mysql \
--includedir=/usr/include \
--infodir=/usr/share/info \
--mandir=/usr/share/man \
--enable-shared \
--enable-static \
--enable-thread-safe-client \
--without-debug \
--with-unix-socket-path=/var/run/mysqld/mysqld.sock \
--with-mysqld-user=mysql \
--with-embedded-server \
--without-docs \
--without-bench \
--with-extra-charsets=all \
--with-vio \
--with-charset=latin1 \
--with-collation=latin1_swedish_ci \
--with-extra-charsets=all

5. 10:25:43 up 14 days, 13:25, 1 user, load average: 0.34, 0.35, 0.33
104 processes: 103 sleeping, 1 running, 0 zombie, 0 stopped
CPU states: 5.9% user, 0.5% system, 0.0% nice, 93.6% idle
Mem: 1034884K total, 913384K used, 121500K free, 119968K buffers
Swap: 2097136K total, 0K used, 2097136K free, 597112K cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
12617 nobody 17 0 11512 5760 9028 S 1.9 0.5 0:00 apache2
12775 root 17 0 1800 980 1636 R 1.9 0.0 0:00 top
1 root 16 0 1292 500 1236 S 0.0 0.0 0:07 init
2 root 0K 0 0 0 0 SW 0.0 0.0 0:02 migration/0
3 root 34 19 0 0 0 SWN 0.0 0.0 0:00 ksoftirqd/0
4 root 0K 0 0 0 0 SW 0.0 0.0 0:00 migration/1
5 root 34 19 0 0 0 SWN 0.0 0.0 0:00 ksoftirqd/1
6 root 0K 0 0 0 0 SW 0.0 0.0 25:28 migration/2
7 root 34 19 0 0 0 SWN 0.0 0.0 0:00 ksoftirqd/2
8 root 0K 0 0 0 0 SW 0.0 0.0 0:00 migration/3
9 root 34 19 0 0 0 SWN 0.0 0.0 0:00 ksoftirqd/3
10 root 5 -10 0 0 0 SW< 0.0 0.0 0:00 events/0
11 root 5 -10 0 0 0 SW< 0.0 0.0 0:00 events/1
12 root 5 -10 0 0 0 SW< 0.0 0.0 0:00 events/2

6.
[mysqld]
port = 3306
socket = /var/run/mysqld/mysqld.sock
skip-locking
key_buffer = 128M
max_allowed_packet = 1M
table_cache = 1024
sort_buffer_size = 2M
read_buffer_size = 1M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size= 64M
thread_cache_size = 64
myisam_sort_buffer_size = 64M
max_connections = 500
thread_concurrency = 8
log-bin
server-id = 1

[mysqld]
port = 3306
socket = /var/run/mysqld/mysqld.sock
skip-locking
key_buffer = 128M
max_allowed_packet = 1M
table_cache = 1024
sort_buffer_size = 2M
read_buffer_size = 1M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size= 64M
thread_cache_size = 64
myisam_sort_buffer_size = 64M
max_connections = 500
thread_concurrency = 8
log-bin
server-id = 1

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 4M
write_buffer = 4M

[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 16M
write_buffer = 16M

[mysqlhotcopy]
interactive-timeout


7. mysql> SHOW STATUS;
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 22 |
| Aborted_connects | 1 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 625532016 |
| Bytes_sent | 1648211587 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 3 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 251469 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 5846 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 82448 |
| Com_insert_select | 1514 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 1 |
| Com_optimize | 2 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 9476 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 1581675 |
| Com_set_option | 287967 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_collations | 0 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 89 |
| Com_show_databases | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 89 |
| Com_show_grants | 0 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 90 |
| Com_show_variables | 0 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 1 |
| Com_update | 203291 |
| Com_update_multi | 0 |
| Connections | 287945 |
| Created_tmp_disk_tables | 14793 |
| Created_tmp_files | 485 |
| Created_tmp_tables | 56950 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 45659 |
| Handler_discover | 0 |
| Handler_read_first | 311873 |
| Handler_read_key | 24223777 |
| Handler_read_next | 20300233 |
| Handler_read_prev | 551972 |
| Handler_read_rnd | 12410274 |
| Handler_read_rnd_next | 1200375774 |
| Handler_rollback | 0 |
| Handler_update | 258648 |
| Handler_write | 7617503 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 4735 |
| Key_blocks_used | 5341 |
| Key_read_requests | 51786542 |
| Key_reads | 80551 |
| Key_write_requests | 898958 |
| Key_writes | 227809 |
| Max_used_connections | 37 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 113 |
| Open_streams | 0 |
| Open_tables | 64 |
| Opened_tables | 7482 |
| Qcache_free_blocks | 0 |
| Qcache_free_memory | 0 |
| Qcache_hits | 0 |
| Qcache_inserts | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_queries_in_cache | 0 |
| Qcache_total_blocks | 0 |
| Questions | 2712029 |
| Rpl_status | NULL |
| Select_full_join | 225 |
| Select_full_range_join | 0 |
| Select_range | 570424 |
| Select_range_check | 0 |
| Select_scan | 224668 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 241 |
| Sort_range | 169739 |
| Sort_rows | 21441567 |
| Sort_scan | 81062 |
| Table_locks_immediate | 3058329 |
| Table_locks_waited | 670 |
| Threads_cached | 0 |
| Threads_connected | 28 |
| Threads_created | 287944 |
| Threads_running | 1 |
| Uptime | 53832 |
+--------------------------+------------+
156 rows in set (0.01 sec)

mysql> STATUS;
--------------
mysql Ver 14.7 Distrib 4.1.8a, for pc-linux-gnu (i686)

Connection id: 287823
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 4.1.8a
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8
Db characterset: latin1
Client characterset: latin1
Conn. characterset: utf8
UNIX socket: /var/run/mysqld/mysqld.sock
Uptime: 14 hours 58 min 15 sec

Threads: 4 Questions: 2713885 Slow queries: 0 Opens: 7486 Flush tables: 1 Open tables: 64 Queries per second avg: 50.355
--------------




8. one other site, load before the forums was <0.3 0.3 0.3, before: ~4-5 queries/sec, now 50 queries/sec.

9. average: 200? (forum is only three days old lol), max: 373, cookie: 900

10. http://hannes.magiccards.info/phpinfo.php 11.

Timeout 30
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 5
<IfModule prefork.c>
MinSpareServers 5
MaxSpareServers 10
StartServers 5
MaxClients 256
MaxRequestsPerChild 0
</IfModule>

12. 3.0.4

--------------------------------------------

My problem is the following: vBulletin performes extremly good. 150 users online and load is only 0.37, 0.36, 0.35. Yesterday we had >300 users online and the load was ~0.7 0.7 0.7. But suddenly the load grew up to 2.x 1.x 1.x (350+ users) and then slowly went down and up again. There were no cron jobs during that time and the error logs were &quot;empty&quot; and the log files are >400mb and rotated daily.

I didn't save a &quot;top&quot; but I'll try next time. There was no swapping (90mb RAM unused) but a lot of apache processes (maybe ~150) and ~170 total (not very much I think and hardly one is > 0.01-3s).

I don't have eAccelerator nor thttpd installed.

Users viewing this forum/thread is disabled and I enabled post cache 5 days (that didn't help though). Attachments in the database (but only some megabytes).

Threads: 1,256, Posts: 13,533, Members: 1,332 (the board is only three days old).

EDIT: At the moment there are 212 online load oscillates between 0.4 and 1.7 (~15 MySQL processes & 50-70 Apache processes). Now it's down to 0.5 again. I don't get it.

EDIT2: That netstat thing:
1 CLOSE_WAIT
1 LAST_ACK
9 FIN_WAIT1
9 LISTEN
20 FIN_WAIT2
46 ESTABLISHED
279 TIME_WAIT

EDIT3: Bottom of stat.php
Key Reads/Key Read Requests = 0.001688 (Cache hit = 99.998312%)
Key Writes/Key Write Requests = 0.232656
Connections/second = 5.199 (/hour = 18717.435)
KB received/second = 10.718 (/hour = 38584.255)
KB sent/second = 20.967 (/hour = 75482.582)
Temporary Tables Created/second = 1.062 (/hour = 3822.617)
Opened Tables/second = 0.133 (/hour = 477.326)
Slow Queries/second = 0.000 (/hour = 0.000)
% of slow queries = 0.000%
Queries/second = 47.850 (/hour = 172261.075)

[MRaburn]

Im having the exact same issues on a VERY Similar machine... I have 2Gigs and and in Raid0. It's almost like the server just freaks out... loads up to around 5. Seems like a lot of lag between posts. This machine prior was doing the exact same thing running Windows 2003 with Mysql for Win on the box. Wiped the thing and installed RHEL v3 on the box and I am right back in same boat. What are my symptoms... exactly as you have posted above, and for the life of me cannot figure it out. I have disabled searching, not it, etc etc every little flip. Im curious if could be a cron being an issue. It goes from 20 second lags between pages to zoom loading like crazy, then here we go again lag. Frustrating to say the least. I do not believe it is a USER issue. We go from 6 or 700 all day to about 800 users here and there. That does not seem to be a part of the equation that is causing the problems.

:sigh:

[orban]

Hmm, yes, looks like we have the same problem. The load was just up to 2 again and now slowly goes back to 0.5 with 230 users online. I'll try to catch a peak next time and save a ps aux and netstat. I have "top" on at the moment and there are only ~10-20 apaches and very rarely a mysql process.

EDIT: It's back to 0.4 now with even more users (~250).

[MRaburn]

Here is my extended live status...
http://forums.stangnet.com/status.php

I have some serious number of mysql clients and lost connections. Im not 'geeky' enough to read and find an issue. Our server load gets up around 5 or so. I believe full load on a dual Xeon HT would be 4.00 as it sees 4 processors. I wish I could find the trigger that is causing this.

I have turned the cookie timeout down to 1400 and see if that makes a diff.

Roger that Zach, was just sharing the similarities.

[Zachery]

You may want to switch back to mysql 4.0.22 and php 4.3.10.

The most powerfull server in the world with the default mysql config can bring any server to its knees in notime.

There was a slight slowdown in time with php5 php processing wise, and We havent finished testing php5 or mysql4.1.

But best wait for george to stop by and lend a hand.

[Zachery]

MRaburn if yo9u need help please start your own thread :)

[orban]

MRaburn: You have lots of mysql/apache processes running. I have only 50 apache and <18 mysql. And I don't use any swap. And I have only <200 waiting apaches.

Zachery: I never had a problem with PHP 5 and MySQL 4.1. It performs really good!

[Zachery]

What does your my.cnf look like, should be in /etc/ most of the time

[orban]

Everything's in my first post (6.)? (I don't think it's a mysql problem since I can hardly catch a mysql process. Maybe my harddisk is too slow? ~15-20GB traffic/day....2 million hits...)

[Zachery]

It could be your EIDE Disks, SCSI would be much much faster overall. But I'm not seeing any IO wait. (notirous with some linux kernel builds).

[orban]

I know but when I looked for a new server six months ago (ThePlanet owns) the SCSI was 50$ more expensive (+200$ more setup) and I didn't know that I was getting a forum with 300 online users soon :)). But my next server will definatly feature 35 SCSI hard drives RAID 10. :D

EDIT: Same thing happened again. Five minutes ago the load was 1.8-1.9 (275 users) not the load is down to <1 again (280 users).

EDIT2: Going up and down. From 1.7-1.9 down to 0.4 again....this is weird.

[orban]

300 * 5 secs

~200-230 users online. See those spikes?

[eva2000]

you seem to have doubled up in some settings in my.cnf this seems to have cancelled out and disabled query_caching according to your extended-status output

i'd downgrade to PHP 4.3.10 and MySQL 4.0.23 as suggested and try this new my.cnf first

You also had binary logging enabeld in my.cnf you used which drives up cpu loads and disk activity as well. New my.cnf below has disabled the binary logging


[mysqld]
port = 3306
socket = /var/run/mysqld/mysqld.sock
skip-locking
skip-innodb
max_connections = 650
key_buffer = 32M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 64
wait_timeout = 10800
connect_timeout = 10
tmp_table_size = 32M
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1

[mysqld_safe]
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 4M
write_buffer = 4M

[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 16M
write_buffer = 16M

[mysqlhotcopy]
interactive-timeout

[orban]

you seem to have doubled up in some settings in my.cnf this seems to have cancelled out and disabled query_caching according to your extended-status output

i'd downgrade to PHP 4.3.10 and MySQL 4.0.23 as suggested and try this new my.cnf first

You also had binary logging enabeld in my.cnf you used which drives up cpu loads and disk activity as well. New my.cnf below has disabled the binary logging

This is actually a copy and paste error I think. Don't know why this happened. But I'll try the values with MySQL 4.1.8a, if it's not going to be better I'll consider a downgrade.

How do you know whether query_caching is enabled?

Thanks!

EDIT:mysql> SHOW VARIABLES;
+---------------------------------+-------------------------------+
| Variable_name | Value |
+---------------------------------+-------------------------------+
| back_log | 50 |
| basedir | /usr/ |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | utf8_general_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| concurrent_insert | ON |
| connect_timeout | 5 |
| datadir | /var/lib/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 4 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
| group_concat_max_len | 1024 |
| have_archive | NO |
| have_bdb | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | YES |
| have_isam | NO |
| have_ndbcluster | NO |
| have_openssl | NO |
| have_query_cache | YES |
| have_raid | NO |
| have_rtree_keys | YES |
| have_symlink | YES |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_fast_shutdown | ON |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_log_arch_dir | |
| innodb_log_archive | OFF |
| innodb_log_buffer_size | 1048576 |
| innodb_log_file_size | 5242880 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | ./ |
| innodb_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_table_locks | ON |
| innodb_max_purge_lag | 0 |
| innodb_mirrored_log_groups | 1 |
| innodb_open_files | 300 |
| innodb_thread_concurrency | 8 |
| interactive_timeout | 28800 |
| join_buffer_size | 131072 |
| key_buffer_size | 8388600 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| log_error | |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_update | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 1048576 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 100 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 4294967295 |
| max_length_for_sort_data | 1024 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 4294967295 |
| myisam_data_pointer_size | 4 |
| myisam_max_extra_sort_file_size | 2147483648 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 8388608 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | OFF |
| open_files_limit | 1024 |
| pid_file | /var/lib/mysql/magiccards.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 0 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 131072 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| relay_log_purge | ON |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 0 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_net_timeout | 3600 |
| slow_launch_time | 2 |
| socket | /var/run/mysqld/mysqld.sock |
| sort_buffer_size | 2097144 |
| sql_mode | |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| system_time_zone | CET |
| table_cache | 64 |
| table_type | MyISAM |
| thread_cache_size | 0 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| tmp_table_size | 33554432 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.1.8a |
| version_comment | Source distribution |
| version_compile_machine | i686 |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 28800 |
+---------------------------------+-------------------------------+
177 rows in set (0.00 sec)

Looks like it's enabled now.

[eva2000]

yeah looks like it's enabled now :)

try the new my.cnf give it 24-48hrs to gather some stats and then repost your mysqladmin extended-status output again to see how they look and whether it has helped or not

[orban]

This is from the last 25 minutes (300*5 seconds). I'll run it again in 24h and 48h...

~270-300 users online. Still having those peaks....are they normal?

[eva2000]

depends you need to look at top stats

1min, 5min, 15min

intervals

now spikes in 1-5min interval for dual xeons are normaly - ~spikes of 1-8 for 1min interval are find and normal, only when those spikes persist for 15min or longer you are having problems..

and generally it comes down to is your forum performing okay

[orban]

Ok. The user report that everything's blazing fast, maybe I'm a little bit too picky. :)

Thanks for your help, though.

[eva2000]

no probs :)

[orban]

+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 54 |
| Aborted_connects | 87 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 1727710535 |
| Bytes_sent | 2529783240 |
| Com_admin_commands | 0 |
| Com_alter_db | 2 |
| Com_alter_table | 14 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 2311178 |
| Com_change_master | 0 |
| Com_check | 88 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 1 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 6 |
| Com_dealloc_sql | 0 |
| Com_delete | 46587 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 1 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 4 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 0 |
| Com_grant | 1 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 728402 |
| Com_insert_select | 10383 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 9 |
| Com_optimize | 89 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 86026 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 2 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 15120551 |
| Com_set_option | 2856959 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_collations | 0 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 778 |
| Com_show_databases | 17 |
| Com_show_errors | 0 |
| Com_show_fields | 1375 |
| Com_show_grants | 0 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 8 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 764 |
| Com_show_variables | 3 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 1 |
| Com_unlock_tables | 9 |
| Com_update | 1772715 |
| Com_update_multi | 0 |
| Connections | 2856809 |
| Created_tmp_disk_tables | 190617 |
| Created_tmp_files | 7563 |
| Created_tmp_tables | 602350 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 2 |
| Handler_delete | 507910 |
| Handler_discover | 0 |
| Handler_read_first | 2059828 |
| Handler_read_key | 391234153 |
| Handler_read_next | 287359194 |
| Handler_read_prev | 7392173 |
| Handler_read_rnd | 147443020 |
| Handler_read_rnd_next | 1893546905 |
| Handler_rollback | 1 |
| Handler_update | 2522912 |
| Handler_write | 77569911 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 2158 |
| Key_blocks_used | 7248 |
| Key_read_requests | 883666500 |
| Key_reads | 894737 |
| Key_write_requests | 11544462 |
| Key_writes | 2076771 |
| Max_used_connections | 101 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 110 |
| Open_streams | 0 |
| Open_tables | 64 | 100% of table_cache in use
| Opened_tables | 62424 |
| Qcache_free_blocks | 0 |
| Qcache_free_memory | 0 |
| Qcache_hits | 0 |
| Qcache_inserts | 0 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 0 |
| Qcache_queries_in_cache | 0 |
| Qcache_total_blocks | 0 |
| Questions | 25794213 |
| Rpl_status | NULL |
| Select_full_join | 2671 |
| Select_full_range_join | 0 |
| Select_range | 5345062 |
| Select_range_check | 0 |
| Select_scan | 2482326 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 4 |
| Slow_queries | 0 | (execution time > 10 secs)
| Sort_merge_passes | 3780 |
| Sort_range | 1519286 |
| Sort_rows | 456100357 |
| Sort_scan | 1406873 |
| Table_locks_immediate | 28664179 |
| Table_locks_waited | 10455 |
| Threads_cached | 0 |
| Threads_connected | 1 |
| Threads_created | 2856808 |
| Threads_running | 1 |
| Uptime | 595846 | 6 days 21 hrs 30 mins 46 secs
+--------------------------+------------+


Key Reads/Key Read Requests = 0.001013 (Cache hit = 99.998987%)
Key Writes/Key Write Requests = 0.179893
Connections/second = 4.795 (/hour = 17260.353)
KB received/second = 2.832 (/hour = 10193.878)
KB sent/second = 3.520 (/hour = 12670.629)
Temporary Tables Created/second = 1.011 (/hour = 3639.296)
Opened Tables/second = 0.105 (/hour = 377.155)
Slow Queries/second = 0.000 (/hour = 0.000)
% of slow queries = 0.000%
Queries/second = 43.290 (/hour = 155844.240)

+---------------------------------+-------------------------------+
| Variable_name | Value |
+---------------------------------+-------------------------------+
| back_log | 50 |
| basedir | /usr/ |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| concurrent_insert | ON |
| connect_timeout | 5 |
| datadir | /var/lib/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 4 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
| group_concat_max_len | 1024 |
| have_archive | NO |
| have_bdb | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | YES |
| have_isam | NO |
| have_ndbcluster | NO |
| have_openssl | NO |
| have_query_cache | YES |
| have_raid | NO |
| have_rtree_keys | YES |
| have_symlink | YES |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_fast_shutdown | ON |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_log_arch_dir | |
| innodb_log_archive | OFF |
| innodb_log_buffer_size | 1048576 |
| innodb_log_file_size | 5242880 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | ./ |
| innodb_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_table_locks | ON |
| innodb_max_purge_lag | 0 |
| innodb_mirrored_log_groups | 1 |
| innodb_open_files | 300 |
| innodb_thread_concurrency | 8 |
| interactive_timeout | 28800 |
| join_buffer_size | 131072 |
| key_buffer_size | 8388600 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| log_error | |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_update | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 1048576 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 100 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 4294967295 |
| max_length_for_sort_data | 1024 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 4294967295 |
| myisam_data_pointer_size | 4 |
| myisam_max_extra_sort_file_size | 2147483648 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 8388608 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | OFF |
| open_files_limit | 1024 |
| pid_file | /var/lib/mysql/magiccards.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 0 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 131072 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| relay_log_purge | ON |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 0 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_net_timeout | 3600 |
| slow_launch_time | 2 |
| socket | /var/run/mysqld/mysqld.sock |
| sort_buffer_size | 2097144 |
| sql_mode | |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| system_time_zone | CET |
| table_cache | 64 |
| table_type | MyISAM |
| thread_cache_size | 0 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| tmp_table_size | 33554432 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.1.8a |
| version_comment | Source distribution |
| version_compile_machine | i686 |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 28800 |
+---------------------------------+-------------------------------+

[orban]

Load: 0.45, 0.47, 0.53
Users online: 340
Looks like it somehow settled down. Don't know why...

[eva2000]

doesn't seem my new my.cnf is in effect on your server make sure you have my.cnf recommended at http://www.vbulletin.com/forum/showpost.php?p=791648&postcount=13 and restart mysql server

[orban]

This is weird. I moved my.cnf to /etc/my.cnf and now have_innodb is OFF, so it looks like the config file got read. Sorry for all the fuss. Will post variables and extended status in a few days. Weird.

[orban]

If I ****ed it up again...

The three slow queries where on purpose.

+---------------------------------+-------------------------------+
| Variable_name | Value |
+---------------------------------+-------------------------------+
| back_log | 50 |
| basedir | /usr/ |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| concurrent_insert | ON |
| connect_timeout | 10 |
| datadir | /var/lib/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 4 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
| group_concat_max_len | 1024 |
| have_archive | NO |
| have_bdb | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | DISABLED |
| have_isam | NO |
| have_ndbcluster | NO |
| have_openssl | NO |
| have_query_cache | YES |
| have_raid | NO |
| have_rtree_keys | YES |
| have_symlink | YES |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | |
| innodb_data_home_dir | |
| innodb_fast_shutdown | ON |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_log_arch_dir | |
| innodb_log_archive | OFF |
| innodb_log_buffer_size | 1048576 |
| innodb_log_file_size | 5242880 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | |
| innodb_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_table_locks | ON |
| innodb_max_purge_lag | 0 |
| innodb_mirrored_log_groups | 1 |
| innodb_open_files | 300 |
| innodb_thread_concurrency | 8 |
| interactive_timeout | 28800 |
| join_buffer_size | 1044480 |
| key_buffer_size | 33554432 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| log_error | |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_update | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 16776192 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 650 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 4294967295 |
| max_length_for_sort_data | 1024 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 4294967295 |
| myisam_data_pointer_size | 4 |
| myisam_max_extra_sort_file_size | 2147483648 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 67108864 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | OFF |
| open_files_limit | 3260 |
| pid_file | /var/lib/mysql/magiccards.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 33554432 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 1044480 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| relay_log_purge | ON |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 0 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_net_timeout | 3600 |
| slow_launch_time | 2 |
| socket | /var/run/mysqld/mysqld.sock |
| sort_buffer_size | 2097144 |
| sql_mode | |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| system_time_zone | CET |
| table_cache | 1024 |
| table_type | MyISAM |
| thread_cache_size | 64 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| tmp_table_size | 33554432 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.1.8a |
| version_comment | Source distribution |
| version_compile_machine | i686 |
| version_compile_os | pc-linux-gnu |
| wait_timeout | 10800 |
+---------------------------------+-------------------------------+

+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 22 |
| Aborted_connects | 1 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 2543953723 |
| Bytes_sent | 1198743065 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 10 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 967547 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 2 |
| Com_dealloc_sql | 0 |
| Com_delete | 16639 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 3 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 317075 |
| Com_insert_select | 2125 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 4 |
| Com_optimize | 0 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 25802 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 2769325 |
| Com_set_option | 1179871 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_collations | 0 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 270 |
| Com_show_databases | 1 |
| Com_show_errors | 0 |
| Com_show_fields | 270 |
| Com_show_grants | 0 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 14 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 277 |
| Com_show_variables | 0 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 4 |
| Com_update | 720519 |
| Com_update_multi | 0 |
| Connections | 1179848 |
| Created_tmp_disk_tables | 58026 |
| Created_tmp_files | 2293 |
| Created_tmp_tables | 190604 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 195155 |
| Handler_discover | 0 |
| Handler_read_first | 499076 |
| Handler_read_key | 154223590 |
| Handler_read_next | 107787485 |
| Handler_read_prev | 3564283 |
| Handler_read_rnd | 49314818 |
| Handler_read_rnd_next | 2878385089 |
| Handler_rollback | 0 |
| Handler_update | 1136961 |
| Handler_write | 25271630 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 8299 |
| Key_blocks_used | 22795 |
| Key_read_requests | 353983911 |
| Key_reads | 92472 |
| Key_write_requests | 4077121 |
| Key_writes | 890433 |
| Max_used_connections | 139 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 621 |
| Open_streams | 0 |
| Open_tables | 581 | 57% of table_cache in use
| Opened_tables | 686 |
| Qcache_free_blocks | 2559 |
| Qcache_free_memory | 7300616 |
| Qcache_hits | 3619395 |
| Qcache_inserts | 2765743 |
| Qcache_lowmem_prunes | 305125 |
| Qcache_not_cached | 3618 |
| Qcache_queries_in_cache | 5995 |
| Qcache_total_blocks | 15316 |
| Questions | 10799343 |
| Rpl_status | NULL |
| Select_full_join | 610 |
| Select_full_range_join | 0 |
| Select_range | 610854 |
| Select_range_check | 0 |
| Select_scan | 650928 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 7 |
| Slow_queries | 3 | (execution time > 10 secs)
| Sort_merge_passes | 1146 |
| Sort_range | 422998 |
| Sort_rows | 184220215 |
| Sort_scan | 537435 |
| Table_locks_immediate | 7792380 |
| Table_locks_waited | 6861 |
| Threads_cached | 61 |
| Threads_connected | 3 |
| Threads_created | 202 |
| Threads_running | 1 |
| Uptime | 242119 | 2 days 19 hrs 15 mins 19 secs
+--------------------------+------------+


Key Reads/Key Read Requests = 0.000261 (Cache hit = 99.999739%)
Key Writes/Key Write Requests = 0.218397
Connections/second = 4.873 (/hour = 17542.831)
KB received/second = 8.662 (/hour = 31181.954)
KB sent/second = 4.835 (/hour = 17406.024)
Temporary Tables Created/second = 0.787 (/hour = 2834.038)
Opened Tables/second = 0.003 (/hour = 10.200)
Slow Queries/second = 0.000 (/hour = 0.045)
% of slow queries = 0.000%
Queries/second = 44.603 (/hour = 160572.424)