May 25, 2012

Post: MySQL Performance on Memory Appliance

… out MySQL Performance on “Memory Appliance” by Violin Memory which can be used as extremely high speed storage system. I helped Violin Memory to optimize… which did not seems to give any significant performance benefit, may be even reducing performance few percents. I also tried running with…

Post: State of MySQL Market and will Replication live ?

… things happen – MySQL kept being “simple” and introduced relatively simple performance boosters – Query Cache and Replication, which were clearly not enough… in the database efficiently. The other Wave is appliances – you can see Violin Memory appliance which can be used with MySQL to get…

Post: Should I buy a Fast SSD or more memory?

… buffer pool of between 2G and 22G (to test performance compared to memory fit). Hardware was our Dell 900 (specs here). To… painful point for many customers – because while memory decreased by only ~10% the performance dropped by 2.6 times!  In production…, since they are all relatively small.  There are already appliances on the market which use 8 Intel SSD devices). Is…

Post: How fast can MySQL Process Data

Reading Barons post about Kickfire Appliance and of course talking to them directly I learned a … longer rows affect performance and created the following table: CREATE TABLE `m4` ( `c` char(128) NOT NULL ) ENGINE=MEMORY DEFAULT CHARSET=latin1… table status like “m4″ \G *************************** 1. row *************************** Name: m4 Engine: MEMORY Version: 10 Row_format: Fixed Rows: 5000000 Avg_row_length…