…to store multiple users per table it is best way to go, however quite typically this is way…to use VIEWs to reduce number of tables dramatically – merging say 1000 of users to the same table as VIEWs are significantly less expensive and cheap to…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
…view concepts. This post begins with an introduction to change data capture technology and describes some of the ways… the third method, log based capture as the best option because it imposes less overhead than …have MySQL 5.1 or aren’t using RBR, then it is possible to set up a dedicated MySQL slave…
Post: Logging MySQL queries from the client instead of the server
February 2, 2011 By 2 Comments
…log” is the single most valuable way to examine query execution on your MySQL server. Queries are logged …s valuable to be able to see both views of query execution time. Why would you want to see…to decode the MySQL wire protocol, it is certainly the easiest and best solution for most needs. Just use…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…ways to do general-purpose work without aggregating (see the section below on technologies), but if you’re doing this with vanilla MySQL…use GUIDs. Which brings me to my next point: Use InnoDB Assuming that you will use the stock MySQL server, InnoDB is usually your best…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
…view. The nasty thing with counters as they are implemented the most trivial way – they convert read load to…to MySQL server. If you rather use existing solutions you can use memcache + another mysql instance (or simply the database which is not replicated) to…
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
… does not work for subselects, inline views, parts of the UNION. This is… their result set but MySQL has no way to identify which one of …be offering best speed up. So when it is good idea to use query cache ? Third party application – You can’t change how it works with MySQL to…
Post: Fishing with dynamite, brought to you by the randgen and dbqp
November 16, 2011 By Leave a Comment
… be mildly biased. The best description of the randgen…to use the following command to execute the test: ./dbqp.py –default-server-type=mysql –basedir=/path/to…_name != ‘If you need to translate Views labels into other languages, consider … there may be other ways to go about hitting that particular …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…view) is that performance bugs don’t receive very hi priority. Yet, a lot of us are using MySQL because it seems to…to InnoDB’s buffer pool. For this, you need to find a way to tell Linux to…
Post: What’s a good buffer pool read/write ratio?
May 31, 2011 By 6 Comments
… the most useful way to approach the graphs. It really comes down to the difference between discovery and diagnosis. In general, it’s best to use the graphs for diagnosing problems that you already know about, not for trying to discover problems. Your monitoring… — maybe once a week I’d look at the monthly view — to see if there were any sharp changes during the past…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 Comments
…to mention them separately. Running MySQL won’t be much different whether one or another distribution is used. All use common Linux kernel – the heart of Linux operating system – which in principle will behave the same way… annoying at best. Resolving problems can easily lead to …
