June 19, 2013

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

June 7, 2013 By Leave a Comment

…where even under just a moderate load on the host system, DRBD … For example, if you see a large number of long-running queries … Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers… insert a few rows into an InnoDB table, but trying to run a…

Filed Under: Insight for DBAs, Insight for Developers, MySQL, MySQL Webinars Tagged With: , , ,

Post: More on MySQL transaction descriptors optimization

April 26, 2013 By Leave a Comment

…by Dimitri Kravchuk, we have received a large number of questions on why the …innodb_log_buffer_size = 16M innodb_buffer_pool_size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file_per_table = true innodb…=0 warmup To warmup server and load data and indices to the buffer …

Filed Under: Benchmarks, MySQL Tagged With: ,

Post: Is your MySQL buffer pool warm? Make it sweat!

April 16, 2013 By 6 Comments

…as the buffer pool pages were loaded from disk. Replaying Queries Working with…null, and only have a log file for debugging purposes. Streaming logs …-line option, we set the option innodb_fake_changes to prevent INSERTs, UPDATEs… This is necessary when running a large stream of queries. Benchmarks We …

Filed Under: Insight for DBAs, Insight for Developers, MySQL, Percona Software Tagged With: , , , , , , ,

Post: How to load large files safely into InnoDB with LOAD DATA INFILE

July 3, 2008 By 29 Comments

… a customer ask me about loading two huge files into InnoDB with LOAD DATA INFILE. The goal was to load this data on many servers… the very large transaction caused by the single statement. We didn’t want to split the file into pieces for the load for… bigger file was about 20GB and had wider rows with textual data and about 60M lines (as I recall). When InnoDB loads the file…

Filed Under: Benchmarks, Insight for Developers Tagged With: ,

Post: Predicting how long data load would take

May 24, 2007 By 14 Comments

… to consider especially while loading large schemas with a lot of different table structures. So which variables affect the load speed: Table Structure… increase. Innodb typically needs large innodb_buffer_pool_size and large innodb_log_file_size to perform load effectively Load Options There two main ways to load data in…

Filed Under: Insight for DBAs Tagged With: ,

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

… the same (modulo any new features introduced with InnoDB full-text search), that’s largely where the similarities end. NOTE 1: I… yet. Having loaded the data, the first thing we notice is that there are a lot of “new” InnoDB tablespace files in our database directory: -rw-rw—-. 1 mysql mysql 8632 Feb 20 15:54 dir_test_innodb.frm -rw…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Heikki Tuuri Innodb answers - Part I

October 26, 2007 By 19 Comments

…in an ascending order of the file address, then InnoDB schedules the read of all …€™s buffer pool. In high load situations where INNODB is using most of the …innodb_thread_concurrency ? Is it suggested to set this value to a LARGE value (somewhat like 200) for additional throughput? HT: ha_innodb…

Filed Under: Insight for Developers Tagged With: ,

Post: Optimizing InnoDB for creating 30,000 tables (and nothing else)

December 22, 2011 By 5 Comments

… can set some InnoDB options! I’m going to try the obvious first: innodb-flush-method, sync-frm and innodb-flush-log-at… an fsync() call when extending the data file, so I tried setting a higher innodb-autoextend-increment and a larger initial size… it is clear that loading large amounts of DDL could be a lot faster than it is currently (although loading the data into…

Filed Under: MySQL Tagged With: , , , , ,

Post: Binary log file size matters (sometimes)

May 24, 2012 By 6 Comments

… few seconds. This was MySQL 5.0 running MyISAM/InnoDB mix, not heavily loaded. We used pt-stalk (at that time it… was really puzzled, looking for answers in MySQL status counters, innodb status, memory info and what not. It seemed that the… if your file system is slow at deleting files (both customers systems ran on ext3, which can be very slow deleting large files), then…

Filed Under: Insight for DBAs, MySQL Tagged With: , ,

Post: Ultimate MySQL variable and status reference list

January 8, 2011 By 4 Comments

…large_files_supportblogpercona.commanual large_page_sizeblogpercona.commanual large…

Filed Under: Insight for DBAs, MySQL
« Older Posts