…the queue. This is done by adjusting innodb_thread_sleep_delay variable. Value is specified in microseconds. mysql tables in use 1, locked 0 is number of tables…queries in queue 1 read views open inside InnoDB Main thread process no. 10099, id 88021936, state: waiting for server activity Number of…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…number of cases when this optimization is not applicable: UNIQUE indexes in ALTER TABLE are ignored to enforce uniqueness where necessary when copying the data to a temporary table…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 16 Comments
…What queries did I use? I used a version of the queries in that same blog post. The original queries tend to filter on the Year column. I partitioned the table…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
…of looking at the query and analyzing which tables this query is using. This works in much larger amount of cases, but not all of…to them – you can use number of such filtering servers. The good thing about BLACKHOLE filtered server is – it is generally rather lightweight as it only needs to fetch…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…to bring you automated reports or to perform actions such as: list users by the number of queries issued or any other information find active tables…
