… basis in 2007. (as a side story I lived in NY on weekends and worked in SF during the week for several months) In 2008, eBay both won a Community Award and presented that the O’Reilly conference on their first deployed MySQL system… few threads in a thread pool were necessary to supports tens of thousands of actual connections. As with any functionality, testing and…
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… in MySQL 4.1 or changing JOIN evaluation in 5.0 (which could both cause different result set or make query not runnable in MySQL…
Post: Sphinx 2.0.2 Beta is released, Sphinx Users Conference in December
November 17, 2011 By 6 Comments
… 6 months. In fact Sphinx 2.0.3-rc is promised within 1 month. What MySQL Users will find interesting in … functions such as SET NAMES which make it possible to connect to Sphinx as if it were MySQL … something like it in 2012. Another thought – with Innodb Full Text Search coming up in MySQL 5.6 and …
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…generate summaries and reports in many different ways on demand, often to support the functionality of the …for year-over-year analysis, aggregate again by month. Then write your queries to use … change the lifecycle of your application in advance. What about partitioning in MySQL 5.1? I know …
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…’t a month that I log in to a system…why all of this extra functionality was stripped from Percona …
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
… upgrade problems in number of other environments. INSERT ON DUPLICATE KEY UPDATE had a unfair share of replication issues in MySQL 5.0… problems spotted and in the meanwhile we go over binary logs for the last month to see how frequently this functionality is used… tool for MySQL to see what is different in the tables. It turned out one of the float columns stored “-0″ in MySQL 5…
Post: MySQL Quality of old and new features
October 4, 2007 By 24 Comments
… was pointed to number of bugs in MySQL 5.0 which again seriously shakes the confidence in both MySQL Quality Control and bug fix… can see this bug is reported in February – over 6 months ago and it is still in verified state even though it has… VERY basic functionality gets broken and passes quality control. And why it is broken ? Because minor optimization was implemented in MySQL 5.0…
Post: Getting around optimizer limitations with an IN() list
January 9, 2010 By 9 Comments
… a discussion on LinkedIn one month ago that caught my eye: Database search by “within…and created a “search within x numer of miles” function ? Thankful for any tips you can throw my way…..why these sorts of geographic search queries are problematic in MySQL, it’s best to show some execution plans on…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… use Flexviews. In the following example, the total sales amounts are calculated (for all time) from a monthly summary. The monthly summary is… refresh MV which use those aggregate functions. Now I delete some line items from orders: mysql> delete -> from order_lines -> where order…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… of months there have been no updates to our msl patch, however recently I managed some time to change this. The functionality was extended a little bit and what’s even more important the patch is available for all the recent MySQL releases… -f – mysql-5.0.51a/ mysql-5.0.51a/bdb/ mysql-5.0.51a/bdb/Makefile.in mysql-5.0.51a/bdb/btree/ mysql-5.0…
