mysql
MySQL Proxy Lua scripts cannot be written as a module?
Yesterday I went through hell while testing the MySQL Proxy partition Lua scripts I am working on in a high concurrency environment. I am sending multiple queries to the server and build up a combined result set in read_query_result – something like this. The proxy returned weird results complaining about multiple result sets being sent [...]
Progress on MySQL Proxy Partitioning
As posted here I started to think about possible ways to implement database sharding/partitioning. I finally found the time to start prototyping a MySQL Proxy based solution that would allow you to analyze and rewrite queries to direct them to different databases. So this would going to be a nearly 100% transparent solution (some queries [...]
MySQL Partitioning on Application Side
After following the scale up path (i.e. buy bigger boxes) for a while now, we definitely need to scale out as things start to become “unhandy” and simply HUGE. (See small things are better) We are running an OLTP application with about 200 million transaction per month. Currently we have some very large tables with [...]
Beware: MySQL – Implicit Transaction Commit and Rollback
Today I had a hard time dealing with mysql and transactions. Somehow my transaction has been committed in the middle of the statements. A short look into the manual revealed that there are SQL command that implicit commit a transaction. While I do understand that CREATE TABLE commits a transaction, I was surprised that LOAD [...]
Where to start mysql performance tuning?
I recently found a great article on mysql performance blog giving you a short and precise description of what to tune in the first place. This is a must!