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

[eluser]WanWizard[/eluser]
I don't think switching session classes would be wise at this point, since you don't know the root cause of your problem.

12 seconds waiting on an insert in a simple table with only 1500 records and a low update rate is not normal. Is this the only thing that is slow? How are your other queries performing? What does the profiler say?

On what platform is this running? Dedicated or hosted (shared)? Are there other applications using this database engine that could affect the performance? Is the performance consistent? Is your mysql engine properly tuned. Do you have PHPMyAdmin handy? It has an option called status, which dumps the operational status of the database engine. Any figures reported in red?

There's a quick analysis tool at http://www.fromdual.com/mysql-performance-tuning-key. Past your server info and see what it comes up with.

For comparison, the site I mentioned earlier also has a forum section. Per user, per forum and per thread it keeps track of the read status of messages. Currently, it has close to a milion records, and inserts happen all the time, every time someone reads a forum message. I currently have 210 users reading messages. And no performance issues. This on a standard off-the-shelf Dell R200 with 2Gb, running 12 websites, including two Trac installations syncing with svn repositories. It processes on average 99.86 queries per second.


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