What does this mean to server load issues ?

[waddy]

Aborted_clients 278
Aborted_connects 334
Bytes_received 585762808
Bytes_sent 317125663
Connections 228566
Created_tmp_disk_tables 15
Created_tmp_tables 29840
Created_tmp_files 0
Delayed_insert_threads 0
Delayed_writes 0
Delayed_errors 0
Flush_commands 1
Handler_delete 58360
Handler_read_first 726751
Handler_read_key 11272950
Handler_read_next 1872753960
Handler_read_prev 766078
Handler_read_rnd 18060042
Handler_read_rnd_next 2576159058
Handler_update 566023
Handler_write 1528740
Key_blocks_used 7793
Key_read_requests 224691486
Key_reads 258571
Key_write_requests 328977
Key_writes 251174
Max_used_connections 267
Not_flushed_key_blocks 0
Not_flushed_delayed_rows 0
Open_tables 64
Open_files 117
Open_streams 0
Opened_tables 134809
Questions 7020419
Select_full_join 15
Select_full_range_join 0
Select_range 199867
Select_range_check 0
Select_scan 2119401
Slave_running OFF
Slave_open_temp_tables 0
Slow_launch_threads 1610
Slow_queries 11958
Sort_merge_passes 0
Sort_range 173342
Sort_rows 20785750
Sort_scan 819783
Table_locks_immediate 6608869
Table_locks_waited 57590
Threads_cached 0
Threads_created 228565
Threads_connected 23
Threads_running 2
Uptime 177737


Ever since i upgraded to 2.6.6 i have had massive server load issues ...

But i have no idea what all that above means :(


Any ideas or advice please
-----------------------------------------------------------------------------

[eva2000]

hi waddy i'm actually a member on your forum which has helped me out with some winxp issues :D

an old but still useful article is at http://i4net.tv/marticle/get.php?action=getarticle&articleid=3

what you posted is the mysql extended-status output which is basically mysql's server usage stats - it's more useful viewed live and regularly :)

from the output you posted, it looks like mysql needs tuning for better performance

please provide the following

1. your server specs, such as mysql and php version
2. if possible how mysql was compiled/installed
3. your top stats
4. your mysql configuration variables located at /etc/my.cnf or c:\my.cnf if on Windows server if you don't have that file you need to log into telnet and as root user type

mysqladmin -u root -p variables

copy and paste output here

5. your mysql extended-status output either still telnet as root user type

mysqladmin -u root -p extended-status

copy and paste output here

or preferred is to installed extended-status output script which is located at http://vbulletin.com/forum/showthread.php?threadid=3477

and post url to that here

6. oh and is your vB the only thing on the server? or other scripts? sites?

7. how many average and max concurrent users on your vB forum ?

8. create a file named phpinfo.php and place this code in it and post the url/link to it from your web site

<?
phpinfo();
?>

i.e. yourdomain.com/phpinfo.php

9. if you run Apache and you have your own dedicated server or access to your httpd.conf (apache configuration file) can you post the values you have set for the following :

KeepAlive
MaxKeepAliveRequests
KeepAliveTimeout
MinSpareServers
MaxSpareServers
StartServers
MaxClients