…. I found that ext4 worked really well out of the box, while XFS required poorly documented knobs to be turned and… to above. Disclaimer: I’m just someone who runs their own benchmarks, and am not religious about filesystems.
Comment: Percona Live MySQL Conference & Expo Was A Great Event
April 17, 2012 By 2 Comments
Awesome conference. I had a great time. I have just finished adding all presenters to the Box Slide Sharing site. Feel free to visit, the available slides will grow as presenters upload their own presentations. http://box.com/perconalive2012
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
… Vadim have left MySQL to do MySQL Consulting on our own. Bunch of people have been wondering about our experiences so… change in Corporate MySQL thought. Now I’m finally my own boss without limits. I can do what makes sense for… hours or even days to get access info to the boxes. Other typical cases of wasting time is waiting for developers…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…. At the same time one would likely get couple of boxes to spread Web and Database instances and establish may be… techniques which allow you to scale out to the several boxes. If you do this step properly you may end up… cost of downtime. So now what is about using your Own Resources vs Hiring Consultants ? Again we should think about economics…
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
… have order of magnitude more availability issues caused by their own software bugs, DOS attacks and other issues. However as your… choose to keep single Cisco router because it has its own internal high availability on the component level which makes it… a good sense to get extra performance out of the box. Some installations are using RAID0 for slaves – in these cases…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…. [-] No Spinlocks Falcon does not use Spinlocks. It has its own lock implementation which does operation system wait if resource is… can forget about spinlocks wasting CPU time on single CPU boxes without much of the gain. Spinlocks need to be wise… notice right now each database in Falcon gets its own tablespace and its own set of logs. With typical for MySQL use…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… want their systems to provide the freshest data to their own clients, with no delays. Finally, the analysis is usually multi…’m throwing around — the point is to think outside the box, even to think of things that seem “less advanced” than…, PostgreSQL is clearly better for some workloads out-of-the-box than MySQL is, especially for more complex queries. Percona is…
Post: MySQL Blob Compression performance benefits
January 11, 2008 By 17 Comments
… because you will save CPU on database box and move it to the Web box which is typically easier to scale, plus…, especially for Innodb tables. With Innodb tables BLOB gets its own page (allocated outside of clustered index) if the whole row… not fit in the main row page is given its own page or set of pages potentially requiring a lot of…
Post: Should you have your swap file enabled while running MySQL ?
April 6, 2008 By 31 Comments
… or disable it ? I’ve seen production successfully running on boxes both with and without swap file so it is not… would not have the issue of swapping happening on the box as there is just nowhere to swap. So what is… in memory by using –memlock option but it opens its own can of worms. If you keep swap disabled you can…
Comment: Modeling InnoDB Scalability on Multi-Core Servers
January 27, 2011 By 11 Comments
… data through the key cache. These were on large 128G boxes with 16G of key cache and about 70G of free… better throughput on the big boxes with innodb, even for “read mostly” workloads. Myisam still held its own on some of my ancient 2-4G and 2 core boxes, but on the bigger hardware…
