…to the schema file create a schema-post file that has the triggers # mysqldump … -d -t How to…queries to…stop-never” Useful to mirror the binlogs on the master to a second server. Allows you to…MySQL…
Post: Distro Packages, Pre-built Binaries or Compile Your Own MySQL
September 4, 2012 By 7 Comments
…MySQL (and variants) for the last couple of years and it has always been interesting to hear customer thoughts on how…to alter MySQL‘s default behavior i.e. disabling and totally disallowing use of query…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
…from the database’s standpoint. And, nothing stops you from running two databases on …queries on last month. All last month will be hot on the slave which is doing reads but only last…to ensured consistency – MySQL Replication can out of sync – and there is bunch of tips in documentation of how to…
Post: Percona Toolkit 2.0.1 and 1.0.2 released
January 3, 2012 By 5 Comments
…to get that one last table checksummed when there is a lot of load and set up pt-kill to kill the queries…to read the documentation on 99 command-line options to learn how to…to stop it for any reason, it’s graceful about that, and then it’s easy to resume. Many thanks to…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…to do atomic snapshot of many volumes. Lets speak a bit about how…to MySQL and run FLUSH TABLES WITH READ LOCK Note – this command may take a while to complete if you have long running queries… to keep some of last…stopping them – you just need to use SHOW SLAVE STATUS instead of SHOW MASTER STATUS to…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…how many disks they have instead of how many systems they have” on MySQL…hours reporting query or 5 …to stop the database, but they usually can keep the same RAID volume. I tend to…to keep Binary Logs on the separate volume – you may need them to do point in time recovery if you want to recover to last…
Post: Introducing tcprstat, a TCP response time tool
August 31, 2010 By 13 Comments
…last inbound packet until the first outbound packet. For many simple protocols such as HTTP and MySQL, this is the moral equivalent of a query‘s response time. The statistics we chose to…to tune this exchange, so if you have suggestions on how to… production servers without stopping it and have …
Post: Living with backups
November 6, 2008 By 28 Comments
…from MySQL data directory will result in a total disaster after MySQL stops responding to the incoming queries quick …a utility called ionice. It allows to affect how I/O scheduler will be dealing … WNOHANG); if ($kid > 0) { last; } sleep(1); } What this script does is to check MySQL status every …
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
…? Let me show you quickly how. This howto assumes that …Query OK, 300024 rows affected (6.51 sec) Rows matched: 300024 Changed: 300024 Warnings: 0 With the last…to the original LV. [root@sb logs]# /etc/init.d/mysql stop Shutting down MySQL (Percona Server)….. [ OK ] [root@sb logs]# umount /mysql…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 7 Comments
…or slave’s MySQL code. If you want to check the master…TO to re-point replication to Relay_Master_Log_File:Exec_Master_Log_Pos: localhost:(none)> slave stop; Query…all the logs needed to re-fetch events. How would you know…to resync them. Last method works in particularly well in case you can afford to…
