… innodb tables in my production database and i have set files_per_table variable. i executed the following query to know…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 17, 2012 By 11 Comments
Aaron, No particular reasons, it doesn’t matter if you have 4 1G or 2 2GB log files, as they are all concatenated together by InnoDB and written to in a circular fashion.
Comment: Benchmarking single-row insert performance on Amazon EC2
May 17, 2012 By 11 Comments
Any particular reason for choosing 4 1GB log files instead of 2 2GB?
Comment: ext4 vs xfs on SSD
April 24, 2012 By 23 Comments
…, Selecting something as important as an Operating System or major component like a File System on the basis of ONE fairly small issue… in a way that is “fussy” in the extreme. The systems I put on-line have ZFS and we rely on… rather disingenuous. Do you pay license fees for your operating system?
Comment: FlashCache: first experiments
May 3, 2012 By 18 Comments
You said “* InnoDB files layout: ibdata1 and ib_logfile* are placed on separate RAID … ? I think flashcache is good place to store ibdata(innodb system tablespace). And, Is Xtrabackup compatible with Flashcache ? Thanks.
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
…_log_file_size = 64M (without the “B” in “MB” string) This works on my site on a Debian Squeeze system where I… x4 of log file size. On my system I set to 128M, which does not 100% accurately reflect log file size x 4… to import all the data into a clean/fresh innodb system! Good luck! Thomas
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… options innodb_buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group = 4 innodb_buffer_pool_instances = 4…_read_io_threads = 8 innodb_write_io_threads = 4 innodb_file_per_table = 1 ## Disabling query cache query_cache_size = 0…
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 10 Comments
…. If you encounter them, please report to our bug tracking system. Links: We provide tar.gz and RPM binaries for RedHat…
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 10, 2012 By 28 Comments
Statement-based replication transfers the file too. It has worked the way I’m describing for a very long time, since at least MySQL 4.1.
Comment: How to load large files safely into InnoDB with LOAD DATA INFILE
May 10, 2012 By 28 Comments
I’m not suggesting to turn off the binary log. I think you have some assumptions that you may not have validated. The file that’s loaded on the master IS transmitted to replicas, in a number of special binary log events (of type “Load_file” if I recall correctly).
