…how to install from the PPA are in the Drizzle manual. CentOS 6 packages are available from download.drizzle.org. Instructions on how to…
Post: AUTO_INCREMENT and MERGE TABLES
September 11, 2008 By Leave a Comment
… how stable merge table auto_increment values are by truncating the table we just inserted data to: mysql> truncate table a2; ERROR 1105 (HY000): MyISAM table ‘a2′ is in use (most likely by a MERGE table). Try FLUSH TABLES. mysql> flush tables…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… merge tables with 1000 of subtables will likely cause your MySQL server to run out of file descriptors. The same is true for Partitioned tables in MySQL 5.1 Disk Space For MyISAM tables hosting providers used to use disk quotas for MyISAM tables. You can also… to MySQL Team. What I’m trying to do is pretty much explain the issue so there is no misunderstandings on how secure is MySQL…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 7 Comments
…how to recover a single tablespace using stock MySQL server. First, you must meet certain prerequisites to be able to… merged and have no uncommitted transactions in order to …to delete some data from one table. In this case we’re going to delete the salary information from the user 10008: mysql…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…. How to get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# … 258.55k 1.46k # Merge passes 0 0 0 0 0 0 0 # Tmp tables 21.36k 0 2 0… Directors would like to know the costs in “utility” model and you do not have to be in the cloud to provide them…
Post: Derived Tables and Views Performance
August 31, 2006 By 14 Comments
…features are quite related to each other but how do they compare in terms of performance ? Derived Tables in MySQL 5.0 seems to have different implementation from views, even though I would expect code base to be merged…
Post: Multi Column indexes vs Index Merge
September 19, 2009 By 30 Comments
…to run, however I do not know of the hint in MySQL which would allow forcing using index merge when MySQL…table. I have reverted table to have i1 and i2 as independent columns in this case to look at more typical case: mysql…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
…point in time recovery) in case of that ‘Oops’ moment? Let me show you quickly how. …to start the merging. So let’s see if our salaries table is restored. mysql> SHOW TABLES; +———————+ | Tables_in_employees | +———————+ … | salaries | … +———————+ 6 rows in…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…Server is the ability to enable logging atomically, not just for new connections as in MySQL. This is very…_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge_passes: 0 #… table. Another thing to note is the last line in the output the # MISC part, it tells you how…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…how to distribute the computation of aggregation queries over time. I realised that I could apply these same mathematical concepts to…have any limitation in resources in a cluster (cpu,…MySQL storage nodes are supported. Amdahl’s law applies to…table: `origin_airport_id` * storage node result set merge…
