… huge problems (it’s anyway no longer supported from MySQL 5.5). If you want to know more details, please read on! MySQL…_Retry: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave_IO_Running…_Retry: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysql_sandbox35302-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave_IO_Running…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
Post: Be careful rotating MySQL logs
December 9, 2007 By 7 Comments
…or MySQL 5.1 you can get log file to grow huge. Same may happen with general log file. In some cases we’ve got log file sizes… log file is reopened MySQL will be practically unavailable causing unanticipated downtime. The workaround for this problem is very simple – instead of deleting MySQL log file…
Post: How to calculate a good InnoDB log file size
November 21, 2008 By 38 Comments
… versions of MySQL. In 5.0 and newer, you can just watch Innodb_os_log_written from SHOW GLOBAL STATUS, too.) mysql> select… the total log file size, but the number of entries in it. If you’re writing huge entries to the log, fewer log entries will fit into a given log file size, which will generally make…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… at 2000 ? innodb_file_per_table =1 Great! We found it is better choice in 95%+ of installations innodb_log_file_size = 48M… this variable strives to provide as MySQL is typically protected by Firewall to begin with. open_files_limit = 5000 strangely enough this…-huge my-large etc referring to amounts of memory we have in the phones these days, I made in my Optimizing MySQL…
Post: Be productive with the MySQL command line
December 21, 2012 By 14 Comments
… (which can be huge), you can call pager to the rescue: mysql> pager grep sequence PAGER set to ‘grep sequence’ mysql> show engine… set (0.00 sec) mysql> exit And now if you look at the content of the queries.log file, you will see a copy of your session. Conclusion The mysql command line client is not…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
… really isn’t something you should expect to deliver huge wins. If MySQL is actually badly configured, you can hurt its performance… see are not configuring the InnoDB buffer pool size or log file size, and not using InnoDB. If your server really hasn… cases, so keep in mind that the vast majority of MySQL installations don’t suffer from the variety and severity of…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
…I had a customer ask me about loading two huge files into InnoDB with LOAD DATA INFILE. The goal was… the entire 4GB file in one chunk: time mysql -e “set foreign_key_checks=0; set sql_log_bin=0; set… a quick Perl script on the vmstat and mysqladmin log files to grab out the disk activity and rows-per…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…safe –defaults-file=/etc/my.cnf –pid-file=/var/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql 3172 …innodb_log_file_size. I won’t give you a full rundown over every option in the file. But …analysis, and also might show me things like huge tables that should be archived, tables that …
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…data possible to save work. Avoid operations that update huge chunks of aggregated data at once. Among other…out a CSV file and import that with LOAD DATA INFILE. Keep those big fat log files out of the…that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing…
Post: Connecting orphaned .ibd files
May 13, 2011 By 19 Comments
…. The annoying thing about .ibd files you can’t easily copy the an .ibd file to another MySQL server. If you try to very often you’ll get an error in the log: InnoDB: Error… 4 bytes written to every InnoDB page. An .ibd file can be huge, while ibdata1 is usually smaller. Thus, it is easier…
