…helping customers deploy and maintain MySQL … Using OS specific packages comes with a lot of advantages, one being they have… and repeat) cycle when maintaining your custom builds. My Personal Choice While everybody …install? – my personal preference amongst the 3 would be pre-built binary packages…
Page: Presentations
May 3, 2006 By
… Moscow, Russia, September 2007 Presentations covers basic principle of building scalable LAMP Web applications and scaling existing ones … with Tobias Asplund. Presentation from 3 hour Tutorial, so it has a lot of information not only about MySQL ….0 but covers some tricks which are still helpful….
Comment: 5.0.83-build17 Percona binaries
August 6, 2009 By 19 Comments
… update to make sure its 3) Make sure you use software … a directory on a seperate partition on a standard HDD. It’ll help minimise…if you find your tables fragment a lot. innodb_file_per_table=1 …builds both of which have decent enhancements. Our server listed above comfortably averages 3500 queries a…
Post: Profiling MySQL stored routines
January 19, 2009 By 4 Comments
… MySQL builds … SELECT whatstheweatherlike(3); +———————————————————–+ | whatstheweatherlike(3) | +———————————————————–+ | …a profile for each of the queries individually. I think this is pretty cool and it helped me a lot…
Post: Economics of Performance Optimization
March 13, 2008 By 9 Comments
…hire an experts to help us ? The answer on these questions actually depend on a lot of things, …little improvement or more application changes such as building summary tables, significant schema changes, use of replication,…can buy would be unlikely more than 2-3 times faster than the one in laptop …
Comment: Slow Query Log analyzes tools
June 10, 2008 By 84 Comments
…” => “”, “etc” => “etc” ); # skip the first 3 lines (); (); (); # Process the query log, and build a couple of hashes from it: # #… it, and have learned a lot about how our database behaves. Now – this is not a well tested script -… – please post them back here. Hopefully this will help some-one else…
Post: Percona and the MariaDB Foundation
December 19, 2012 By 3 Comments
… (1,2,3) describing Percona’s stance regarding the…and we are likely to learn a lot more about how exactly it …Oracle MySQL, MariaDB, Drizzle, Percona Server, Amazon RDS – helping our customers to be successful … have spent tens of man-years building Percona software, including Percona Server, Percona…
