dvdtalk
Thu 8th Feb '01, 1:35am
We've made switch from UBB to VB tonight and I want to make sure that I've got everything as Optimized as I can before the morning RUSH.
Any help would be MORE than appreciated...
We are running on a Dual PIII 650 w/ 512MB Ram and 9Gig SCSI HD.
We are running Vb 1.1.5 w/ MySQL (3.23.32), PHP (4.04pl1) and The Latest Zend Optimizer
Here's our MySQL Extended Stats:
Thu Feb 8 11:52:03 EST 2001
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 7744 |
| Aborted_connects | 0 |
| Bytes_received | 388431433 |
| Bytes_sent | 1947197609 |
| Connections | 7871 |
| Created_tmp_disk_tables | 1 |
| Created_tmp_tables | 40459 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 262231 |
| Handler_read_first | 11153 |
| Handler_read_key | 95176824 |
| Handler_read_next | 283985802 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 3422980 |
| Handler_read_rnd_next | 269010928 |
| Handler_update | 262151 |
| Handler_write | 1750452 |
| Key_blocks_used | 16794 |
| Key_read_requests | 129319695 |
| Key_reads | 16787 |
| Key_write_requests | 3426745 |
| Key_writes | 1224939 |
| Max_used_connections | 144 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 245 |
| Open_files | 260 |
| Open_streams | 0 |
| Opened_tables | 251 |
| Questions | 1921430 |
| Select_full_join | 45619 |
| Select_full_range_join | 0 |
| Select_range | 18913 |
| Select_range_check | 0 |
| Select_scan | 363610 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 74 |
| Slow_queries | 18 |
| Sort_merge_passes | 0 |
| Sort_range | 70054 |
| Sort_rows | 11532218 |
| Sort_scan | 164582 |
| Threads_cached | 0 |
| Threads_created | 7870 |
| Threads_connected | 124 |
| Threads_running | 20 |
| Uptime | 27291 |
+--------------------------+------------+
Key Reads/Key Read Requests = 0.000130 (Cache hit = 99.99987%)
Key Writes/Key Write Requests = 0.357464
Temporary Tables Created/second = 1.483 (/hour = 5337.012)
Slow Queries/second = 0.001 (/hour = 2.374)
% of slow queries = 0.001%
Queries/second = 70.405 (/hour = 253458.943)
Uptime = 7 hrs 34 mins 51 secs
Our Top
11:53am up 7:36, 1 user, load average: 6.27, 11.91, 11.13
246 processes: 242 sleeping, 3 running, 1 zombie, 0 stopped
CPU states: 67.7% user, 18.0% system, 0.0% nice, 14.2% idle
Mem: 517076K av, 449652K used, 67424K free, 242348K shrd, 15428K buff
our my.cnf
# This will be passed to all mysql clients
[client]
#password = my_password
port = 3306
socket = /tmp/mysql.sock
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
set-variable = max_connections=250
set-variable = join_buffer=8M
set-variable = key_buffer=256M
set-variable = record_buffer=8M
set-variable = sort_buffer=8M
set-variable = max_allowed_packet=1M
set-variable = thread_stack=128K
set-variable = table_cache=256
# Start logging
# log
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
set-variable = key_buffer=16M
and finally a link to our PHPinfo:
http://www.dvdtalk.com/forum/phpinfo.php
Most of the tweaks we've done was from research on this forum, and I have to say that I've learned a lot about MySQL in a short amount of time.
Thanks in Advance
Geoff Kleinman
http://www.DVDTalk.com
Any help would be MORE than appreciated...
We are running on a Dual PIII 650 w/ 512MB Ram and 9Gig SCSI HD.
We are running Vb 1.1.5 w/ MySQL (3.23.32), PHP (4.04pl1) and The Latest Zend Optimizer
Here's our MySQL Extended Stats:
Thu Feb 8 11:52:03 EST 2001
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 7744 |
| Aborted_connects | 0 |
| Bytes_received | 388431433 |
| Bytes_sent | 1947197609 |
| Connections | 7871 |
| Created_tmp_disk_tables | 1 |
| Created_tmp_tables | 40459 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 262231 |
| Handler_read_first | 11153 |
| Handler_read_key | 95176824 |
| Handler_read_next | 283985802 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 3422980 |
| Handler_read_rnd_next | 269010928 |
| Handler_update | 262151 |
| Handler_write | 1750452 |
| Key_blocks_used | 16794 |
| Key_read_requests | 129319695 |
| Key_reads | 16787 |
| Key_write_requests | 3426745 |
| Key_writes | 1224939 |
| Max_used_connections | 144 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 245 |
| Open_files | 260 |
| Open_streams | 0 |
| Opened_tables | 251 |
| Questions | 1921430 |
| Select_full_join | 45619 |
| Select_full_range_join | 0 |
| Select_range | 18913 |
| Select_range_check | 0 |
| Select_scan | 363610 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 74 |
| Slow_queries | 18 |
| Sort_merge_passes | 0 |
| Sort_range | 70054 |
| Sort_rows | 11532218 |
| Sort_scan | 164582 |
| Threads_cached | 0 |
| Threads_created | 7870 |
| Threads_connected | 124 |
| Threads_running | 20 |
| Uptime | 27291 |
+--------------------------+------------+
Key Reads/Key Read Requests = 0.000130 (Cache hit = 99.99987%)
Key Writes/Key Write Requests = 0.357464
Temporary Tables Created/second = 1.483 (/hour = 5337.012)
Slow Queries/second = 0.001 (/hour = 2.374)
% of slow queries = 0.001%
Queries/second = 70.405 (/hour = 253458.943)
Uptime = 7 hrs 34 mins 51 secs
Our Top
11:53am up 7:36, 1 user, load average: 6.27, 11.91, 11.13
246 processes: 242 sleeping, 3 running, 1 zombie, 0 stopped
CPU states: 67.7% user, 18.0% system, 0.0% nice, 14.2% idle
Mem: 517076K av, 449652K used, 67424K free, 242348K shrd, 15428K buff
our my.cnf
# This will be passed to all mysql clients
[client]
#password = my_password
port = 3306
socket = /tmp/mysql.sock
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
set-variable = max_connections=250
set-variable = join_buffer=8M
set-variable = key_buffer=256M
set-variable = record_buffer=8M
set-variable = sort_buffer=8M
set-variable = max_allowed_packet=1M
set-variable = thread_stack=128K
set-variable = table_cache=256
# Start logging
# log
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
set-variable = key_buffer=16M
and finally a link to our PHPinfo:
http://www.dvdtalk.com/forum/phpinfo.php
Most of the tweaks we've done was from research on this forum, and I have to say that I've learned a lot about MySQL in a short amount of time.
Thanks in Advance
Geoff Kleinman
http://www.DVDTalk.com