… the server might see something quite different. Sometimes it’s valuable to be able to see both views…-to-analyze amount of traffic that the server might receive in total, much of which might have nothing to… lot of work for you. Or, you can log queries to a database table and then use SQL to analyze …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…for table `test/child`: , CONSTRAINT `child_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `parent` (`id`) ON DELETE CASCADE Trying to add in child table, in…in this case database pages will not be equal to total…
Post: Intro to OLAP
July 12, 2010 By 9 Comments
…for the convenience of an RDBMS. These servers almost always query over a database…tables in sync. Part five of my series will introduce materialized views which attempt to address these challenges in…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…SQL tend to get really bogged down. In contrast, moving the processing outside the database…unique ads per day. Viewed this way, suddenly you start… the clicks column record the total, and the blue_clicks column … Replication Building aggregated tables is hard work for the database server. If you…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…table. But just as frequently, I want to look up blog posts on variables, or look for content in…in_cacheblogpercona.commanual Qcache_total…server…views…
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
…For example I’m using Query Cache on server which runs this blog. Updates are rather rare so per-table… does not work for subselects, inline views, parts of…different states of the database, depending on …in default mode you can also use SQL_NO_CACHE to block caching for…select to get total number of …
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
… of the server‘s total capacity. But…for all situations. For example, mixtures of transactional and non-transactional tables…database is fully independent, then on the replica, we could start up a thread for each database we see in… point of view. Solution 3) …, and new SQL syntax for administering …
