mysql
How to install Sysbench on OS X
Before I start this post, I want to thank Alexey Kopytov for his assistance. Alexey, you’re a cool guy. Also, for reference sake, I’m running Mac OS X 10.6.4 and installed mysql-5.5.6-rc-osx10.6-x86.dmg Sysbench is a tool for MySQL DBAs to performance test or burn-in installations. I like to use it as a sanity check for [...]
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 [...]
MySQL Conference 2009
A fast way to grow your skills The 7th annual MySQL Conference & Expo, co-presented by Sun Microsystems, MySQL and O’Reilly Media. Happening April 20-23, 2009 in Santa Clara, CA, at the Santa Clara Convention Center and Hyatt Regency Santa Clara, brings over 2,000 open source and database enthusiasts together to harness the power of [...]
