… by one user to lock records for edit/update, so the transaction is not interrupted until the transaction is finished/committed? A example of a program is worth a 1000 instructions. Please do this for us…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… 1690 GB of instance storage 64-bit platform I/O Performance: High API name: m2.4xlarge As for the IO configuration I …(900000000) ENGINE = InnoDB, PARTITION p9 VALUES LESS THAN (1000000000) ENGINE = InnoDB, PARTITION p10 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */ While the structure of the table …
Comment: SHOW INNODB STATUS walk through
May 15, 2012 By 40 Comments
… the monitores working – i created the different tables for the innodb (Standard, Lock,Tablespace,Table) and the server doesn‘t report the data as described every 15 seconds instead it doesn‘t…
Post: New distribution of random generator for sysbench - Zipf
May 9, 2012 By 3 Comments
… needs when I run benchmarks. Uniform is stupidly simple: for a table with 1 mln rows, each row gets equal amount of…), which defines how skewed the distribution is. A physical sense of this parameter, if to apply to database tables, is following: say… how many times each row selected for different θ: 0.5, 0.9, 1.1: The curve is very skewed, so I…
Comment: InnoDB's gap locks
May 7, 2012 By 15 Comments
…， I’ve tried your example “the affect gap locks to SELECT … FOR UPDATE ” on my server ,and my …but it came out my insert still be blocked. The SHOW ENGINE INNODB STATUS information as follow: —TRANSACTION 0 27638… bits 72 index `GEN_CLUST_INDEX` of table `test`.`t` trx id 0 27638 lock_mode X insert …
Post: Zero-Downtime Schema Changes In MySQL
May 3, 2012 By 2 Comments
… the tool exit gracefully while interupted? The tool doesn‘t clean up the temporary table or triggers. It is designed to be resumable, although we don’t… be extremely surprised for such a bug to be happening. In reply to the second question, the 2.1 version of the tool does…
Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release
May 1, 2012 By 10 Comments
… noticed the configuration, but i did not understand where did all of the configuration go for example default_storage_engine, query_cache_size, e.t.c…. Is it something built in or we just don’t need to define it for the cluster. I am new in this field and being a startup company cannot afford to get paid support from…
Comment: Learning about MySQL Table Fragmentation
May 18, 2012 By 19 Comments
… tables in my production database and i have set files_per_table variable. i executed the following query to know the fragmentation SELECT TABLE_SCHEMA, TABLE… it returned the following result xyz abc 1.52MB 4.00MB(free space) after this I executed alter table abc engine=innodb and…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…t graph the performance on the first 100M rows). The minimum performance troughs occur just as the…the primary key because the entire table fits in main memory. Each row is on the order of 30 bytes in the primary table…challenge. The URL for iibench is slightly incorrect. The correct URL for version …
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 16, 2012 By 94 Comments
… Server 12.04 LTS) the pacemaker mysql plugin (ocf:heartbeat:mysql) doesn‘t work, because since mysql 5.5 the statement “CHANGE MASTER TO…. In the function is_slave() the test for an output to a tmpfile, not for the content “Slave_SQL_Running: Yes” is used for to say…
