Welcome Guest, Not a member yet? Register   Sign In
Why is the "ci_sessions" table type MyISAM?
#14

[eluser]RaZoR LeGaCy[/eluser]
i have other queries running slow as well. I am listing a few from each table so you get the idea. ci_sessions is still about 50% of the mysql

Code:
# Query_time: 15  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE `hh_rViews` SET `hits` = hits+1 WHERE `rid` = '23582';
# Query_time: 16  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE `hh_rViews` SET `hits` = hits+1 WHERE `rid` = '23787';
# Query_time: 12  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
UPDATE `fa_user_profile` SET `user_score` = '0.88', `new_msgs` = 0, `tot_msgs` = 1, `tot_friends` = '0', `tot_collections` = '0', `tot_comments` = '0', `tot_profile_comments` = 0 WHERE `id` = 'XXXXXXXXXX';

I am on a VPS with Linux.

Not sure if other applications are using the database engine. Do you mean other websites? If so yes but these sites get really low traffic. How can I tune mysql properly, not a mysql guru so any recommended resources are welcome.

I have phpmyadmin and status reports these in red plus values. My god this is a mess :O)
Slow_queries = 1
Innodb_buffer_pool_pages_dirty = 3
Innodb_buffer_pool_reads = 385 k
Handler_read_rnd = 3,958 k
Handler_read_rnd_next = 114 M
Qcache_lowmem_prunes = 147 k
Created_tmp_disk_tables = 4,626
Select_full_join = 970
Sort_merge_passes = 480
Opened_tables = 2,598
Table_locks_waited = 123

I am working on the analysis tool right now and will post results soon.


Messages In This Thread
Why is the "ci_sessions" table type MyISAM? - by El Forum - 01-21-2009, 01:43 PM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 01-21-2009, 10:35 PM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 01-21-2009, 11:03 PM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 01-22-2009, 12:48 AM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 01-22-2009, 01:01 AM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 02-10-2010, 06:45 AM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 02-10-2010, 07:26 AM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 08-03-2010, 10:00 AM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 08-03-2010, 10:18 AM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 08-03-2010, 11:31 AM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 08-03-2010, 12:44 PM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 08-03-2010, 01:50 PM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 08-03-2010, 03:54 PM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 08-03-2010, 05:07 PM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 08-04-2010, 12:39 AM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 08-04-2010, 02:00 AM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 08-04-2010, 03:11 PM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 08-04-2010, 03:22 PM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 08-04-2010, 09:34 PM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 09-09-2010, 06:24 PM
Why is the "ci_sessions" table type MyISAM? - by El Forum - 09-10-2010, 12:32 AM



Theme © iAndrew 2016 - Forum software by © MyBB