If you need to restore a single table from a full MySQL backup, you may find yourself wondering “how do I do that?”. There are a few steps required, I outline them here for you to restore the contents of just one table back into the database from the mysqldump using Bash.
Are you running into MySQL load problems? Learn how how I tuned my MySQL servers for a heavy InnoDB workload, by configuring
innodb_buffer_pool_instances. Dividing the InnoDB Buffer Pool into multiple instances improves Disk I/O. By doing so, you run your database and website more efficiently and faster. Here is a little help for you.
Learn how to replace content in your MySQL database in bulk with MySQL REPLACE. Sometimes it’s useful to know how to bulk edit content in your WordPress MySQL database, using MySQL’s REPLACE() function. Here is how to string replace content in WordPress
wp_posts table to bulk edit WordPress posts through MySQL.
Why MySQL indices are so important? At Vevida, we like to help our customers as much as possible. Even with optimizing a MySQL database when they don’t ask for it, or when a customer doesn’t know performance can be improved. For example by adding an index because we spotted a slow query in our slow-query log.
In the earlier days of MySQL, the default storage engine for your database was MyISAM. This is also why you still encounter a lot of examples with
engine=MyISAM online. Nowadays, the default storage engine is InnoDB, and MyISAM is no longer actively developed. Therefore, all MySQL performance optimizations are for InnoDB, and it’s recommended to switch to this as your table storage engine.
query_cache to prevent fragmentation of free query cache memory space. Clear MySQL cache unattended using a cronjob and on the
mysql command-line prompt. Here is how…
How to use mysqlcheck when your MySQL table gets corrupted. MySQL’s mysqlcheck is a command line table maintenance program: it checks, repairs, optimizes, or analyzes tables. Very handy for automated optimizations of MySQL databases and tables. In this post I’ll show you how to use
mysqlcheck to optimize all MySQL tables using a cronjob.
Grootste MySQL tabellen opvragen via
information_scheme tabel. Dankzij de
information_scheme tabel in MySQL 5.0+ is het relatief eenvoudig om op te vragen wat de grootste tabellen in een MySQL-database zijn. Deze query is handig voor in het archief, om later terug te kunnen vinden.
InnoDB: ERROR: the age of the last checkpoint is ‘n’, which exceeds the log group capacity ‘o’. Eén van de MySQL servers die ik beheer gaf een waarschuwing: