Advertisement:

Author Topic: MySQL Optimization Notes  (Read 5081 times)

Offline Joshua Dickerson

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 12,777
  • Gender: Male
    • joshuaadickerson on GitHub
    • joshuaadickerson on LinkedIn
MySQL Optimization Notes
« on: September 19, 2005, 04:54:56 PM »
Start off by reading -- http://dev.mysql.com/doc/mysql/en/mysql-optimization.html and more specifically -- http://dev.mysql.com/doc/mysql/en/optimizing-the-server.html

  • skip_networking should be ON unless you are expecting connections from outside sources. Remember, Apache/PHP is the connection. If Apache is on the same machine as MySQL, you don't need to have networking so skip it. Most people will want this to be ON. See this for more info.
  • The easier the user priveleges are, the faster everything will be. For instance, if you grant a user to have privs on only certain tables in your database, it needs to check the privileges everytime the table is opened. If you used a database-wide grant, it would only have to check privs when the database is opened (when SMF opens a connection to the MySQL server)
  • Persistent connections aren't beneficially to 99% of users. Use your thread_cache. Make it greater than 0. Read more
Need help? See the wiki. Want to help SMF? See the wiki!

Did you know you can help develop SMF? See us on Github.

How have you bettered the world today?