Welcome Guest, Not a member yet? Register   Sign In
Handling large traffic
#1

[eluser]faceh[/eluser]
One of my sites is lucky enough to be receiving thousands and thousands of hits and orders a day, which is great! and generally Codeigniter is handling it all really well.

However looking at the server logs of slow mysql queries, adding to and cleaning the sessions table seems to be struggling a little. I changed this table to InnoDB hoping the single row locking would help, however this caused multiple issues with: "Deadlock found when trying to get lock; try restarting transaction" - which was a fatal error causing issues, so I've reverted back to MyISAM for now.

Does anyone have some tips on handling sessions with very high traffic levels?

Thanks.


Messages In This Thread
Handling large traffic - by El Forum - 01-06-2010, 07:29 AM
Handling large traffic - by El Forum - 01-06-2010, 07:33 AM
Handling large traffic - by El Forum - 01-06-2010, 07:54 AM
Handling large traffic - by El Forum - 01-06-2010, 07:59 AM
Handling large traffic - by El Forum - 01-06-2010, 08:38 AM
Handling large traffic - by El Forum - 01-06-2010, 08:43 AM
Handling large traffic - by El Forum - 02-14-2010, 08:00 AM
Handling large traffic - by El Forum - 02-14-2010, 01:44 PM
Handling large traffic - by El Forum - 02-14-2010, 01:54 PM
Handling large traffic - by El Forum - 02-14-2010, 03:12 PM



Theme © iAndrew 2016 - Forum software by © MyBB