September, 2008
SHOW STATUS considered harmful
First of all, I know this is a known problem, but it struck me so hard, I just had to write about it! As Peter Zaitev points out calling SHOW STATUS might have a huge performance impact. We recently replaced one of our servers with a DELL R900 with 96GB RAM. Having a disk-bound workload [...]
LuaSQL fetches results about 15% faster than MySQL Proxy?
While evaluating LuaSQL as backend connection replacement I came across this. I did a quick performance test using mysqlslap and it showed that just reading and copying the result can be significantly faster with LuaSQL. Benchmark details What I did was just sending the query to the backend and building up a new result-set in [...]
Version 0.3 of HSCALE is almost in the door
After working on build and test improvements (for example incorporating lualint and LuaCov) as well as other lua “side-projects” (i.e. Log4LUA) we are running towards HSCALE 0.3. The focus of the forthcoming version 0.3 of HSCALE is Dictionary Based Partition Lookup. Using this partition lookup module lets you take full control over how your partitions [...]
Log4LUA version 0.2 and project page
Everything is available at the project page Please report issues and feature request here. Version 0.2 is a bug fix release but with 2 significant changes in syntax: Changed all constructor methods from create(…) to new. Seems to be more common in the LUA world. The logger class is now returned by the module. So [...]
More fun with LUA – Introducing Log4LUA
UPDATE Log4LUA 0.2 released. Go to the project page. After the dust about backend connection handling in MySQL Proxy had settled, I begun working on other parts of HSCALE again. (I’ll return to the backend handling later after talking to Jan Kneschke about their plans.) One of the issues that bothered me the most was [...]