Logging in is a fairly expensive operation. Try increasing the session time out to see if it helps your load at all. Also, since your users will be hitting the same pages constantly, look into caching such as memcached or eAccelerator, as well as switching to InnoDB as your engine. It takes up more resources but it's more responsive.
Re: MySQL running at 100% on beefy server with auto-login
by Elvedin Trnjanin -
Number of replies: 0