… buffer file incorrectly. File path of the doublewrite buffer wasn’t added to the backup-my.cnf and after the restore old doublewrite buffer file… reached when using the safe-slave-backup option, SQL_THREAD was left in stopped state causing the slave thread to lag behind… ignore innodb_use_native_aio when it’s specified either in my.cnf or as a command line option. Bug fixed #1068459 (Alexey…
Post: Get Me Some Query Logs!
November 22, 2012 By 14 Comments
One of my favorite tools in the Percona Toolkit is pt-query-digest. This tool is indispensable for identifying your top SQL queries…. -c config allows you to specify a MySQL config file other than $HOME/.my.cnf, so you can store host, user, and password… this script a useful complement to my upcoming talks at the Percona Live MySQL Conference in London, UK on December 3-4…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… and in the webinar, I mean wsrep_cluster_address=’gcomm://’ and not ‘pc.bootstrap=true’. Q: Can you quickly show the my.cnf… won’t store or serve data. Q: Is the configuration file my.cnf ? A: Yes. Q: If the cluster blocks write while it… SQL, the rest just has to apply RBR events. Q: I saw an rm -rf * in the demo what folder is that in…
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
…53:28 [Note] Slave SQL thread initialized, starting replication in log ‘bin.000025′ …In a MySQL replication slave the last master binlog file InnoDB: position 0 12501110, file name bin.000025 InnoDB: Last MySQL binlog file…/Linux Also currently: these config (my.cnf) were all disabled from 20 servers:…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… You’re a corporate application developer who wants a small SQL development & test box You’re a Internet startup that just… use Windows+Tunnelier and have saved your password in the configuration file, update it in Tunnelier now also) Re-connect to see if… “ok/fine” in most situations If you want to edit the configuration file, you can find it in /etc/mysql/my.cnf If you setup…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… performance enhancement, Should also be used in 5.5 to reduce purge overhead. innodb_open_files is now dynamic at startup, based… expect most tables to be InnoDB and use innodb_file_per_table. sql_mode also uses STRICT_TRANS_TABLES by default. You… out because we don’t do it in the server defaults but in the default my.cnf file that we ship. It’s also done…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
… SELECTed table, I went for MYISAM. My my.cnf variables were as follows on a …_queries=/var/log/mysql-slow.log sql-mode=TRADITIONAL concurrent_insert=2 low…to realize, is as good as a file system on steroids and nothing more…. have to do this check in the application. Just my experience. I know some…
Comment: Be productive with the MySQL command line
December 21, 2012 By 14 Comments
Also you can use readline shortcuts in Linux (won’t work in Windows): CTRL-r (search backward in history) CTRL-a (go to… client source (\.) will execute an SQL file prompt – you can change the prompt. this is useful in you .my.cnf. You can make root’s…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
… to sync the metadata of the file also (size, name, access time, etc.),…in restart performance and has the advantage of persisting across machine restarts. The configuration variables for my.cnf…SQL thread. Bugs Fixed #813587 / #51196 and #61790 in MySQL (Alexey Kopytov). Uninitialized values in…
