…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 26 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: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…way or if you have some other natural candidate for primary key which gets a lot of lookups is frequent reason to use…view ? Is there any management required or server does everything itself. Especially when using a CMS where DB structure is prepdefined A: MySQL… it. The best thing to start with…
Post: How Can Percona MySQL Server Development Services Help ?
January 28, 2013 By 3 Comments
…MySQL. Here are some ways: Bugs – There are Bugs in MySQL, Percona Server, and other products. By far the best and most cost efficient way to…view of your MySQL server needs. Chances are custom MySQL server development should be one pillar of your strategy, and Percona MySQL…
Post: Fun with the MySQL pager command
January 21, 2013 By 6 Comments
…useful to view the result of a command spanning over many lines (for instance SHOW ENGINE INNODB STATUS): mysql> pager less PAGER set to ‘less’ mysql…to use and it can solve problems in an elegant and very efficient way…
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 70 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 …
