www.lonerunners.net
lab.lonerunners.net
secdocs.lonerunners.net
Tuning and Optimizing Performace of MySQL
A lot of times i found a LAMP server with the MySQL server poorly configurated.
There are a lot of tips, for example enable and tune the query cache, that can enhance the performance of MySQL.
Here is a little check list:
- Enable the query cache and other caches
- Tune the settings of query cache and other caches
- Disable unused logging options
- Disable unused DBMS engine
- Disable binary logging if unused
Following the simple below how to you can get great performances from your MySQL server.
Links:
- Performance Tuning Mysql for Load
- High Performance MySQL Server Performance Tuning
- Tuning a MySQL server in 5 minutes
- Fine-Tuning MySQL Full-Text Search
- MySQL Tuning: Disable Query Cache on Frequently Updated Databases
- MySQL, Linux, and Thread Caching
- A Practical Look at the MySQL Query Cache
- Tuning your MySQL server
- InnoDB Performance Tuning Tips
- Optimizing for read performance
- What to tune in MySQL Server after installation
- Optimizing for write performance
Did you enjoy this post? Why not leave a comment below and continue the conversation, or subscribe to my feed and get articles like this delivered automatically to your feed reader.
Comments
No comments yet.
Leave a comment