… = innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /usr/local/mysql/data innodb_buffer_… records is taking too long and all my transactions are locked. select count(1),field1 from Table where…Please help to improve performance and suggest if any config changes are to be made…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…where any possible problems might be: is the disk saturated? Is the machine swapping actively? (This is…config, etc, and I don’t see anything wrong there. So at this point, it looks like MySQL is…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
….example file to consumer.ini and edit it, making appropriate changes. The file is well commented. The example settings file should work for most MySQL… the config file to automatically record changes for any table, starting from the first time a change is seen for that table. This is… second transaction: mysql> delete from test.demo where c1=1; Query OK, 1 row affected (0.00 sec) The changelog is flexviews.test…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
… level where we started looking at other ways of achieving higher availability using MySQL replication. One of the weakness of MMM is its…: config: The path of the my.cnf file. Remember that Pacemaker will start MySQL, not the regular init.d script pid: The pid file… is use by Pacemaker to know if MySQL is already running. It should match the my.cnf pid_file setting. socket: The MySQL unix socket file…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
…. Here is our my.cnf # sammple MySQL config file for very large systems. # # # This is for a large system with memory of 1G-2G where the system runs mainly # MySQL. # # You…
Post: FlashCache: more benchmarks
May 18, 2010 By 15 Comments
… data loss, instead it is used as memory by the Intel SATA/flash controller for deciding exactly where to write data..”. So… – it’s XFS alignment by RAID strip size, XFS aligned file allocation, raid partition should be created aligned by 16K block… I encourage you to test yourself (my full scripts and mysql config files are on Wiki page). There are binaries for CentOS 5…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 16 Comments
… the recent optimizations to MySQL still leave a lot of low hanging fruit where these are concerned. This is particularly true for OLAP… much improvement could be made to MySQL so that is could better utilize all available resources (that is, scale better) when running small…, it takes a list of queries in a file (or stdin) and a config file. It runs the SQL via ShardQuery and it…
Post: How to replace a NDB node on EC2
June 9, 2011 By 10 Comments
…, where a node can disappear almost without notice, one would think that it is a good fit. It is… instead of IPs in the config.ini file. What needs to be done is to define, in /etc/hosts, … like: [NDBD DEFAULT] NoOfReplicas=2 Datadir=/var/lib/mysql-cluster/ DataMemory=1G IndexMemory=100M [NDB_MGMD] Id…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… >> /dev/null 2>&1 < /dev/null done; Where to find the images Amazon…InnoDB data directory size is 42GB, which is twice the original size … 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like …file for testing an cluster of 1 to 20 nodes. cd shard-query #generate a config…
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
…5b 6b 7b 8b 9b 10b -> where 10b is master of 1a mysql> show master status; +————+———-+——————————————-+——————+ | File | Position | Binlog_Do_DB | …x86_64 x86_64 GNU/Linux Also currently: these config (my.cnf) were all disabled from 20 servers: # …
