cron job to kill slow query issue

Code:

<?php

$con = mysql_connect( "localhost", "user", "pass" ) or die( "can not connect" );
if( $con ) echo "Connected<br>";

$result = mysql_query( "SHOW FULL PROCESSLIST", $con );
while( $row = mysql_fetch_array( $result, $con ) )
{

    $process_id = $row["id"];
    if ($row["Time"] > 100 )
    {
        $sql = "KILL $process_id";
        $res = mysql_query( "$sql", $con );
        if( $res )
        {
            echo "Mysql Process ID $process_id has been killed<br>";
        }
    }
    else echo "Row not found?<br>";
}
?>

I tried this code for cron job to kill slow query

but when i run this cron.php then i got this error

Connected

Warning: mysql_fetch_array() expects parameter 2 to be long, resource given in /home/r/public_html/da/cron.php on line 7

 

So guide what change i have to made, my issue is that on high traffic too many slow queries take place that hangs mysql

I have SMF 2.0.4 default theme

 

Code:

[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer_size = 384M
max_allowed_packet = 1M
table_open_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
open_files_limit = 10000
query_cache_size = 32M
query_cache_size = 512M
max_heap_table_size = 16M
table_cache = 400
max_connections = 100
thread_cache_size = 286
interactive_timeout = 25
wait_timeout = 100
connect_timeout = 10
max_connect_errors = 10
query_cache_type = 1
tmp_table_size = 64M
join_buffer_size = 2M
net_buffer_length = 2K
thread_stack = 64K
low_priority_updates=1
concurrent_insert=ALWAYS
long_query_time = 0.1
slow_query_log = 1
slow_query_log_file = /var/log/mysql-slow-query.log
slow_query_log_microseconds_timestamp = 1
log_queries_not_using_indexes = 1
innodb_data_home_dir = /var/lib/mysql
innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql
innodb_buffer_pool_size = 384M
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 100M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50

[mysql]
no-auto-rehash


[mysqlhotcopy]
interactive-timeout

port = 3306
socket = /var/lib/mysql/mysql.sock


[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

I have four quad CPU and 3 gb RAM VPS Server, when load is high then too many tables got open, some running, some lock, I see those here /http://realinfo.tv/status.php

 

I did install it yet

please guide if I change

innodb_lock_wait_timeout = 50
long_query_time = 0.1
wait_timeout = 100
max_connections = 100


then it can be useful to decrease load that occur by mysql

 

I got that data, now please guide me

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.1.70-cll
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 1G (Tables: 397)
[--] Data in InnoDB tables: 32M (Tables: 75)
[--] Data in MEMORY tables: 1M (Tables: 1)
[!!] Total fragmented tables: 92

-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------
[--] Up for: 4d 17h 23m 45s (14M q [34.378 qps], 635K conn, TX: 50B, RX: 3B)
[--] Reads / Writes: 64% / 36%
[--] Total buffers: 442.0M global + 12.4M per thread (151 max threads)
[OK] Maximum possible memory usage: 2.3G (76% of installed RAM)
[OK] Slow queries: 0% (3K/14M)
[!!] Highest connection usage: 100% (152/151)
[OK] Key buffer size / total MyISAM indexes: 384.0M/105.0M
[OK] Key buffer hit rate: 100.0% (2B cached / 221K reads)
[OK] Query cache efficiency: 55.5% (5M cached / 9M selects)
[!!] Query cache prunes per day: 77385
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 255K sorts)
[OK] Temporary tables created on disk: 7% (5K on disk / 77K total)
[OK] Thread cache hit rate: 99% (1K created / 635K connections)
[!!] Table cache hit rate: 2% (512 open / 19K opened)
[OK] Open file limit used: 7% (788/10K)
[OK] Table locks acquired immediately: 99% (11M immediate / 11M locks)
[!!] InnoDB data size / buffer pool: 32.4M/8.0M

-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
Enable the slow query log to troubleshoot bad queries
Reduce or eliminate persistent connections to reduce connection usage
Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
max_connections (> 151)
wait_timeout (< 28800)
interactive_timeout (< 28800)
query_cache_size (> 32M)
table_cache (> 512)
innodb_buffer_pool_size (>= 32M)

 

When i try above my.cnf then I got "The MySQL® server is currently offline. "

guide where is varable wrong that made "The MySQL® server is currently offline. "

Mysql works when i put blank my.cnf

Please guide

 

Actually I just dont have much knowledge about MYSQL, so I don't able to understand why it got hang in high traffic

One more strange thing is that it normally hang near about 6:30 pm Indian Time

So i'm thinking to have cronjob to save mysql from hanging
thanks

 

Now i have blank my.cnf

Previously I have default my.cnf

when I try above variables in my.cnf and reboot server then I got "The MySQL® server is currently offline. "

Sir my issue is that on high traffic too many tables got open(some running, some sleeping, some locked), that we can see at Server Status it's like Total processes: 146 (10 sleeping, 121 running, 10 locked)


If i can have some cronjob that check after 1 min or five min and see if there are too many Total Process then it can kill all query of mysql

please guide or make a cronjob php for me that can do what i needed

 

these are error

please give some solution