…in additional memory pool (so you can check if it is sized right), total number of pages in buffer pool, number of pages free, pages allocated by database…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
…for online applications. Limited amount of usable memory – Queries are constantly being invalidated from query cache by table updates, this means number of queries in…total number of queries as if query…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…Database changed mysql> show table…Query for yourself. Spin up the desired number of EC2 instances using on of the the AMI images. You should spin a number of…query script will run one more more semicolon terminated SQL statements. The queries for the benchmark are in ~ec2-user/shard-query/queries.sql…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…table accounting to the database, accessible with a new set of commands such as SHOW TABLE…for only a few customers simply because their skills in SQL…number of queries issued or any other information find active tables which do not have any indexes used meaning table…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
…table). In order to demonstrate the power of Shard-Query it is important to test complex queries…servers, it performs about 6x better as the degree of parallelism is controlled by the number of…
Post: Advanced index analysis with mk-index-usage
November 11, 2010 By 2 Comments
…tables in a database, so you can query them with SQL. I logged all queries to the blog for a little while, and then secure-copied the query…query these tables any way you want. The documentation includes a number of other canned queries…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
…tables can contain partially completed statements as well as some of updates totally…server with real servers (ie clone queries from other slave) before putting traffic to it. In…number of tables (Some users have hundreds of thousands of tables per database host). This one is pretty much part of…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…number (revision)=IB_3.2_GA_5316(ice) MonetDB version: server…Query execution So I really have data for InfoBright and MonetDB, let see how fast they are in different queries. First favorite query for any database…
Post: Sphinx: Going Beyond full text search
July 23, 2007 By 18 Comments
…for SQL databases rather than full text search applications. Group By was added to Sphinx so we could search number of matches per day, or number of…number of posts in total for forum or in thread but most of other stuff is built with Sphinx. This also uses fair amount of…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…database contained only the table I used in my previous examples): $ mysqldump -uroot test > dump_unoptimized.sql…for a specific table. There’s also a number of cases when this optimization is not applicable: UNIQUE indexes in ALTER TABLE…
