… Files\Percona Inc\XtraBackup\xtrabackup.exe” –defaults-file=C:\MySQL\my.ini –backup –innodb_data_home_dir=E:\MySQLData\data –innodb_data_file_path=ibdata1:10M:autoextend –target…:\TempBackupFiles Any hints on any other options I should be setting for such a large database? Thanks! Scott
Comment: Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas
February 10, 2010 By 20 Comments
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
… the my.cnf file used and the computer hardware specs that produced this benchmark. I am interested in general, innodb, and myisam settings… per transaction. here is data from my tests: computer 1: My.ini [client] port=3306 [mysql] default-character-set=latin1 [mysqld] port=3306 basedir… 1166 inserts per second into that one table. using autocommit for innodb inserts I got 1125, and 1158 inserts per second into…
Comment: How to change innodb_log_file_size safely
March 18, 2013 By 17 Comments
… change the innodb setting in my local machine. 1) shutdown mysql 2) change the following parameters in my.ini innodb_buffer_pool_size = 256M innodb_additional_mem… 0 events 130319 0:10:27 [Note] mysql\bin\mysqld.exe: ready for connections. Version: ’5.1.33-community’ socket: ” port: 3306 MySQL…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…for this is the excellent compression that RLE techniques provide. I have not loaded InnoDB compressed tables yet but since InnoDB…a script provided to generate the shards.ini file for testing an cluster of 1 to…set up a cluster from 1 to 20 nodes for testing. This way you can verify the numbers in my…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…=1) unique server_id in the my.cnf log_slave_updates=1, if…ini.example file to consumer.ini and edit it, making appropriate changes. The file is well commented. The example settings file should work for… int auto_increment primary key, > c2 int > ) > engine=innodb; Query OK, 0 rows affected (0.00…
