Apache / PHP / MySQL
MySQL Partitioning and open_file_limit
We ran into an interesting problem recently and wanted to share the research. MySQL partitioning is a great way to improve performance in some circumstances, but it has a behavior that’s not widely noted. That is specifically with the MyISAM storage engine. MySQL seems to open two (2) file pointers for each table or partition [...]
Backing up your MySQL databases
MYSQLDUMP is a utility for outputting database contents into text files. This is nice, but has many configuration options. One, often missed detail is the specific permissions required to accomplish the job. I made a note on the mysql manual (bottom of page) to illustrate what I consider to be a best practice for automated [...]
MySQL memory usage stored procedure
Want to know a close approximation of how much RAM MySQL is consuming right now? There’s a simple formula posted at MySQL.com. Want to add a function to your MySQL database that will allow you to access this value without having to remember the formula? Answer: Create a Stored Procedure I’m assuming your using a [...]
