…capture tool included with Flexviews. It continues with an overview of how …) it will exit with an error. It will exit with a message “…and you want to track changes on all of them. You may …the source table is `test`.`demo`. mysql> select * from flexviews.test_demo\G *************************** 1. row…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… requirements, the InnoDB versions are only available on 64 bit instances. MySQL will fail to start on a micro instance, simply decrease the…-size=16M key-buffer-size=64M local-infile=on lock-wait-timeout=300 log-error=/var/log/mysqld-innodb.log max-allowed…-table-size=64M transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued You can now set up a cluster…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
…continues cache experiements and has compared performance of MySQL Query Cache and File Cache. Jay uses …performance so I did not do much of error control or other precausions like string escaping …you might be better off storing your data on network with memcached. Memcache performs worse than file…
Post: Percona Testing: Innodb crash / recovery tests available
December 21, 2011 By Leave a Comment
… been created for the main MySQL branch. The MySQL at Facebook branch has …crash_commit_*”. The test will then continue to issue DML until the …stack. kewpie/randgen/backtrace.gdb:20: Error in sourced command file: No registers. … workload was having an effect on the test tables between crash/recovery…
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
… with MySQL you might need to deal with RAID recovery every so…26 13:51:11 2011 mdadm: size set to 2925544704K Continue creating array? y mdadm: Defaulting to version 1.2 …mount it, find LVM volumes on it etc, and you can go back and correct your error. ReadyNAS1:/# cat /proc/mdstat Personalities…
Post: InnoDB memory allocation, ulimit, and OpenSUSE
August 23, 2010 By 7 Comments
… an interesting case. A customer reported that mysqld crashed on start on OpenSUSE 11.2 kernel 2.6.31.12-0.2… GB. I decided to try it with 76 GB. The error message was an assert due to a failed malloc() in… to fail on the 76 GB of the buffer pool, due to some weird memory mapping issue and a continuous block of…
Post: Active Cache for MySQL
January 10, 2010 By 11 Comments
… the cache, unless there is an error. From existing tools this probably lies out best on registering the jobs with Gearman. The… is expired cache could decide to refresh such keys based on available bandwidth. Another extension to common caching methods I’d… avoid bad experience. At the same time other users can continue reading stale data – if they see comment appearing 10 seconds…
Post: Percona Server and XtraBackup weekly news, February 5th
February 6, 2011 By 2 Comments
…editing changes to awkwardly worded and badly spelled error messages and the like. There is work …per_table a session variable. There was discussion on a bug that makes the INDEX_STATISTICS … In general, demand for and usage of XtraBackup continues to grow extremely quickly, and innobackupex is …
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… when updating. Instead, the application can hit a “optimistic lock error” if a record is updated by another user. Now PBXT… major changes to MySQL itself). Â What war stories can you report on in plugging into MySQL? Unfortunately the “war” continues. I have already received several e-mails that PBXT does not compile with the recently released MySQL…
Post: Conflict Avoidance with auto_increment_increment and auto_increment_offset
January 12, 2011 By 2 Comments
… running MySQL Master-Master replication pairs in Active…it atomically (such as some scripts continue to write to old master) …errors, if you set slave_exec_mode=IDEMPOTENT both duplicate key error and row not found errors… in manually resolving inconsistencies later on as they allow to identify …
