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

[eluser]RaZoR LeGaCy[/eluser]
To start; thank you both for the help.

WanWizard
I removed/optimized (Added better indexes) to a few more queries but I think I will still need to increase the Qcache. How can I do that?

Crimp
I changed some tables that do not have frequent writes to MyISAM. That should free up memory.

How long will it take in order to re-check phpMyAdmin status tab to see what is now red after these changes? Should I restart and wait 2-3 days or can I just leave the system and then re-check in 2-3 days.

I still have the issue of 5 ci_session writes per page view. I use db_session.

I know that one ci_session write writes to the
flash:new:flashMessage\";s:32:\"You have successfully logged in.\";,
then the other writes to
flash:new:flashMessage\";s:32:\"You have successfully logged in.\";s:22:\"flash:old:flashMessage\";s:32:\"You have successfully logged in.\";
the other
flash:old:flashMessage\";s:32:\"You have successfully logged in.\";
the other
flash:old:flashMessage\";s:32:\"You have successfully logged in.\";
then
flash:old:flashMessage\";s:32:\"You have successfully logged in.\";s:22:\"flash:new:flashMessage\";b:0;

Hope that helps in finding out this problem.


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