… situations where even under just a moderate load on the host system, DRBD can end …it occurs. For example, if you see a large number of long-running queries in the …libexec/mysqld: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…followup by Dimitri Kravchuk, we have received a large number of questions on why the benchmark results…size = 52G innodb_log_file_size = 2000M innodb_log_files_in_group = 2 innodb_file_per_table = true innodb…performance_schema=0 warmup To warmup server and load data and indices to the buffer pool we…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…after failover as the buffer pool pages were loaded from disk. Replaying Queries Working with Groupon, …to /dev/null, and only have a log file for debugging purposes. Streaming logs from stdin …connection reuse. This is necessary when running a large stream of queries. Benchmarks We benchmarked 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… the very large transaction caused by the single statement. We didn’t want to split the file into pieces for the load for… way to load the single file in chunks as though it were many small files, which avoided splitting the file and let us load 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…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…
Post: Binary log file size matters (sometimes)
May 24, 2012 By 6 Comments
… was MySQL 5.0 running MyISAM/InnoDB mix, not heavily loaded. We used pt-stalk (at that time it was aspersa… created and, if expire_logs_days is not zeroish, log files older than expire_logs_days are removed. &LOCK_log mutex… if your file system is slow at deleting files (both customers systems ran on ext3, which can be very slow deleting large files), then…
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
… treatment. DNS TTL Settings The system was using DNS based load balancing, using something like img23.domain.com to serve some… true if you server static content from memory or serving large files (in which case read-ahead helps) but if you’re… it gets from PHP script which means many megabytes for large files. Partial file sending happily was added in lighttpd 1.5 which…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…writesblogpercona.commanual languageblogpercona.commanual large_files_supportblogpercona.commanual large_page_sizeblogpercona.commanual large_pagesblogpercona.commanual last…commanual Slave_heartbeat_periodblogpercona.commanual slave_load_tmpdirblogpercona.commanual slave_net_timeoutblogpercona….
Post: Speedup your LAMP stack with LigHTTPD
May 21, 2006 By 14 Comments
… shrink number of needed children dramatically. One more benefit is load balacing and HA – you may have round robin or random… time while you do not really care about latency for large files download. If your mostly static contents are few images used… from Reverse proxy to web server Async IO for serving large large files The good thing I hear most of these are already…
Post: read_buffer_size can break your replication
June 6, 2012 By 12 Comments
… block_len #Begin_load_query: file_id: 1 block_len: 33554432 #Append_block: file_id: 1 block_len: 33554432 #Append_block: file_id: 1… from MasterB and the replication breaks because packets are too large. No, the replicate_same_server_id is not enabled 
What… servers: #Begin_load_query: file_id: 1 block_len: 16777216 #Append_block: file_id: 1 block_len: 16777216 #Append_block: file_id: 1 block…
