…. Driver information: Fusion-io driver version: 2.3.10 build 110; Firmware v5.0.7, rev 107053 Following the format of previous benchmarks… more interesting when we go to read sync IO, with 1-64 threads. Throughput: Response time: For same cases (i.e… !function(d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s);js.id…
Comment: How to replace a NDB node on EC2
February 22, 2012 By 10 Comments
…=4 @10.0.0.1 (mysql-5.1.56 ndb-7.1.13, Nodegroup: 0, Master) id=5 @10.0.0.3 (mysql-5.1.56 ndb-7.1.913 starting, Nodegroup: 0) ndb_mgm> all status; Node 4: started (mysql-5.1.56 ndb-7.1.13…
Post: Percona welcomes Drizzle 7.1
April 10, 2012 By Leave a Comment
… patches have been merged Since Drizzle 7.0 (which was released last year), there have been over 3,500 commits to Drizzle from… be implemented in relatively small amounts of code. Installing Drizzle 7.1.33-stable The source tar package is available from the…. Please see the Drizzle manual on how to install Drizzle 7.1.33-stable from source tar package. The Ubuntu packages are…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 9 Comments
…and o_orderdate < date_add( '1993-08-01' ,interval '3‘ month) and l_returnflag = ‘R’ and c_nationkey =…1 1 1 1 1 Created_tmp_tables 1 1 1 1 1 Handler_mrr_init N/A 0 0 1 1 Handler_mrr_rowid_refills N/A N/A N/A 1 0…_custkey 5 dbt3.customer.c_custkey 7 100.00 Using where 1 SIMPLE lineitem ref PRIMARY,i_l…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… the export files SET GLOBAL innodb_import_table_from_xtrabackup = 1; ALTER TABLE data IMPORT TABLESPACE; After those being done i…: 9 indexes have been detected. InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15… 99 100 done. 120323 4:38:52 InnoDB: Error: page 0 log sequence number 6094071743825 InnoDB: is in the future! Current…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
…11.04 (Natty) and CentOS 5.7 includes packages with this feature,… Merged: 2.3% mysql-data: Merged: 0.2% mysql-data: Merged: 0.0% Merge of…emp_no = 10001; +———-+ | count(*) | +———-+ | 0 | +———-+ 1 row in set (0.00 sec) mysql> show tables; +———————+ | Tables_in_employees…
Post: Best kept MySQLDump Secret
March 23, 2012 By 11 Comments
…B | | C | +——————–+ 3 rows in set (0.00 sec) mysql> select count(*) from A; +———-+ | count(*) | +———-+ | 2359296 | +———-+ 1 row in set (1.73…03-23 7:27:18 SESSION1: mysql> select * from C; +——+—+ | t | i | +——+—+ | test | 0 | +——+—+ 1 row in set (0.00 …
Comment: Avoiding auto-increment holes on InnoDB with INSERT IGNORE
March 11, 2012 By 7 Comments
… your my.ini file. # =0 is traditional lock mode == > funcionality of auto_increment like before 5.1.22 # =1 is default value – consecutive… don’t investigate what it do innodb_autoinc_lock_mode=0 2. restart mysql server now is working perfectly id – is…’),(‘Oto’),(‘Jan’),(‘Jan’),(‘Jan’),(‘Romco’); select * from tab order by 1; 1 Peter 2 Oto 3 Jan 4 Romco ===> not 7 Romco as before
Comment: InnoDB thread concurrency
March 19, 2012 By 4 Comments
…thread 0 (thread id: 18578) state: waiting for completed aio requests (insert buffer thread) I/O thread 1… aio requests (read thread) I/O thread 3 (thread id: 18581) state: waiting for completed …completed aio requests (write thread) I/O thread 7 (thread id: 18585) state: waiting for completed …
Post: XtraDB storage engine release 1.0.3-7
August 17, 2009 By 6 Comments
… XtraDB release 7. This is the last release based on InnoDB plugin version 1.0.3, as you might know Innobase has released 1.0.4. The release includes following new features: MySQL 5.1.37 as… are located on http://www.percona.com/mysql/xtradb/5.1.37-7/ The latest source code of XtraDB, including development branch…
