… long this would take). I was also the first MySQL Consultant from MySQL Inc to work at eBay on an extended basis… several months) In 2008, eBay both won a Community Award and presented that the O’Reilly conference on their first deployed MySQL… supports tens of thousands of actual connections. As with any functionality, testing and benchmarking is necessary. I would also caution people…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… it is many month projects. Why is that ? Performing MySQL upgrade two things should normally worry you. It is Regressions – functionality regressions when… is safest if you’re running application which uses simple MySQL functionality which is unlikely to be affected. If you’re something…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
…MYSQL, upgrade MySQL, 10x start/stop MySQL, upgrade MySQL, downgrade MySQL, upgrade MySQL, install a security fix for something, 20x start/stop MySQL, upgrade MySQL, … . Restarting and changing MySQL…. There isn’t a month that I log in…why all of this extra functionality was stripped from Percona …
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… SQL is dynamically generated by the flexviews.get_sql() function call. This function reads the meta-data stored in the Flexviews data… sales amounts are calculated (for all time) from a monthly summary. The monthly summary is actually another MV. This saves a significant… refresh MV which use those aggregate functions. Now I delete some line items from orders: mysql> delete -> from order_lines -> where order…
Post: Sphinx 2.0.2 Beta is released, Sphinx Users Conference in December
November 17, 2011 By 6 Comments
… of Sphinx – Sphinx 2.0.2. It includes about 6 months of development and includes over 30 new features and tons… next 3 to 6 months. In fact Sphinx 2.0.3-rc is promised within 1 month. What MySQL Users will find interesting… number of functions such as SET NAMES which make it possible to connect to Sphinx as if it were MySQL Server with…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…ranges for year-over-year analysis, aggregate again by month. Then write your queries to use the …maintain, back up, and restore. And the partitioning functionality is not done yet and not fully integrated …that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, …
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… we go over binary logs for the last month to see how frequently this functionality is used. Happily there are only few… being trivial. This was the best choice as with New MySQL version upgrade involves new Operating System and hardware and any… especially makes sense. The team, even if it includes skilled MySQL DBA typically does not need to go through major version…
Post: MySQL Quality of old and new features
October 4, 2007 By 24 Comments
… can see this bug is reported in February – over 6 months ago and it is still in verified state even though… VERY basic functionality gets broken and passes quality control. And why it is broken ? Because minor optimization was implemented in MySQL 5… questions in my head: What is MySQL Current Bug Policy ? A long time ago MySQL had Monty’s bug policy of “no…
Post: thread_concurrency doesn't do what you expect
June 4, 2012 By 3 Comments
Over the last months I’ve seen lots of customers trying to tune the thread concurrency inside MySQL with the variable thread… idea of thread_concurrency for Solaris is using thr_setconcurrency() function to give a hint to the operating system about the… is causing lot of confusion and there are hundred of MySQL tuning howtos that explain how to tune the variable to…
Post: Finding your MySQL High-Availability solution - The definitions
October 9, 2009 By 10 Comments
… for MySQL. I have done dozen of MySQL HA related engagements while working for Sun/MySQL over the…availability solution is running in recovery mode for months without nobody caring about it, the risk …year. The cost is approximately an exponential function of the level of availability and has to…
