… 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 ?
April 9, 2008 By 29 Comments
… 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?
April 8, 2010 By 10 Comments
… 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
April 9, 2008 By 3 Comments
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…
