…TPCC-like Workload on MySQL 5.5, which was a response to my post, MySQL 5.5.8 and Percona…_pages_data+Innodb_buffer_pool_pages_free). This is the exact formula that … doublewrite; that is, set innodb_doublewrite=0. Now, although throughput is not a …and only 60 gives stable throughput. (Post edited …
Comment: MySQL 5.0 Community Edition Regression
May 22, 2008 By 2 Comments
how can i download MySQL 5.0 Community Edition free easy ,and start the work on a wow servar?
Post: Connecting orphaned .ibd files
May 13, 2011 By 12 Comments
… file match. The second is to edit space_id inside .ibd file with … `ID` bigint(20) unsigned NOT NULL default ‘0‘, `N_COLS` int(10) default NULL, `TYPE…, FIL_PAGE_INODE, FIL_PAGE_IBUF_FREE_LIST FIL_PAGE_FILE_FLUSH_LSN …MySQL 5.1 on CentOS 5.6 x86_64. However it expected to work on all versions of MySQL…
Post: XtraDB storage engine release 1.0.2-2 (New Year edition)
December 29, 2008 By 20 Comments
… on flush IO and mutex when there is no enough free buffers. It helps if you have performance drops when data…-xtradb-1.0.2-2 as source code in tar.gz as binaries, percona xtradb is compiled in into MySQL-5.1.30 RPM as separated shared library, to use as drop-in plugin for existing MySQL-5.1.30…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… the original functionality offered by Microslow patch. The new edition is free of a tiny bug which was to treat long_query… is 0.3s! # Query_time: 0.503016 Lock_time: 0.000048 Rows_sent: 56 Rows_examined: 1113 LOGGING OF THE REPLICATED STATEMENTS Normally MySQL… or on any important system! The patch is available for MySQL Community 5.0.45 on Linux. May not work on other systems…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…20 nodes. The Infobright Community Edition (ICE) images are available …64bit x86_64 Percona Server 5.5.11 with XtraDB. Requires m1…1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like …1616904192 Max_data_length: 0 Index_length: 539279360 Data_free: 4194304 Auto_increment: …
Post: Different flavors of InnoDB flushing
January 13, 2011 By 9 Comments
… MySQL 5.5 to get stable performance (as you may see from Dimitri’s post, http://dimitrik.free.fr/blog/archives/2010/12/mysql… writes: LRU N, flush list 0, single page 0 where N>0, and flush list is 0. A second way to detect … better I/O subsystem should also be helpful. (Post edited by Fred Linhoss)
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
… 2000 Avg_row_length: 0 Data_length: 0 Max_data_length: 0 Index_length: 0 Data_free: 0 Auto_increment: NULL … summary table at the bottom) Query Q1: mysql> SELECT DayOfWeek, count(*) AS c FROM ontime … version shows Server version: 5.1.39-community InfiniDB Community Edition 0.9.4.0-5-alpha (GPL), so …
