Skip to content

Tag Archives: mysql

Get next auto_increment value in MySQL

Sunday, June 12, 2011

I was recently working on some MySQL 5.5 performance testing. I had to generate a lot of SQL queries I would then use for my testing. To make my tests repeatable I needed to hardcode the values for IDs. That is, I couldn’t simply use: INSERT INTO TABLE_NAME SET column1 = ‘value1′; because this query [...]

Filed in linux, PHP | Also tagged | Comments (1)

Master slave replication in MySQL 5.5

Saturday, May 21, 2011

I’d like to share a quick guide on how to set up master/slave replication for the MySQL 5.5 server. The procedure below should be used for development/testing only. If you want to create a production-ready setup, you should follow instructions from MySQL official documentation or use MySQL server packaged by your favorite Linux distribution. 1. [...]

Filed in linux | Also tagged | Comments (0)

How to display all MySQL queries your application generates.

Tuesday, May 25, 2010

Sometimes it’s a good idea to intercept the SQL queries exactly as they are generated by your Java application. One way to do it (in MySQL) is to enable general_log. Another really handy option is to use MySQL JDBC driver option: autoGenerateTestcaseScript. It will dump all the queries to standard error, as they are being [...]

Filed in Java | Also tagged | Comments (0)