… to an existing node in…the script. If xinetd is not installed yet, …create a database and a userfor it. mysql> create database sbtest; Query OK, 1 row affected (0.01 sec) mysql…mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
…Percona Server (and others) using the User Statistics patch. By enabling ‘userstat_running…(just be careful not to break replication!). mysql> create schema index_analysis; If our index_…to use that information: mysql> drop view if exists droppable_indexes; mysql> create view droppable_indexes as…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 4 Comments
… Triggers in your replication servers if you need different actions for…Error ‘FUNCTION test.this_year does not exist‘ on query. Default database: ‘test’. … are logged and not the Event itself. Example: mysql> create event year ON SCHEDULE… STATUS’ output when using SET user-variables and then using it…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…to a lot of users with monitoring systems over…if a database isn’t owned by MySQL, you won’t have any problems until you try to create…mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of contention in the processlist. The pmp-check-mysql… the replica is not logically identical to …
Post: High availability for MySQL on Amazon EC2 – Part 4 - The instance restart script
August 19, 2010 By 6 Comments
…might not be …MySQL EC2 instance if running Make sure the MySQL EC2 instance is stopped Prepare the user-data script for the new MySQL…MySQL instance IP to the application servers Kill the MySQL EC2 instance In order to kill the existing MySQL… if [ "$NEW_INSTANCE_ID" == "" ] then echo “Error creating…
Post: Recovery after DROP & CREATE
August 22, 2012 By 1 Comment
…mysql> CREATE TABLE actor ( -> actor_id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, -> first_name VARCHAR(45) NOT NULL, -> last_name VARCHAR(45) NOT…
Post: Connecting orphaned .ibd files
May 13, 2011 By 19 Comments
…tables, but they’re hidden from a user(you can see them in information_…MySQL server. 0. Create empty InnoDB tablespace. 1. Create the table: mysql>CREATE TABLE actor ( actor_id SMALLINT UNSIGNED NOT… exists in the tablespace InnoDB: memory cache! To refrain from such error ibdconnect does check if…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… site which exists in single installation – Wordpress, vBulletin etc. With such software, if you’re not upgrading …wide set of MySQL versions. Safe Approach So what if you actually care about your user experience or … on different MySQL version is taking a lot of time you may wish to create second …
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
…users. On other hand it is well known with customers like Google, Yahoo, LiveJournal,Technocarati MySQL…MySQL. If you design your data wisely considering what MySQL can do and what it can’t you will get great perfomance if not… remember – not all indexes are created equal…. This problem exists for all …
Post: Migrating to XtraDB Cluster Webinar follow up questions
June 6, 2012 By 3 Comments
… of the cluster’s databases? Well, if you noticed, all the current SST…mysql user accounts replicated? Yes, provided you use CREATE USER or GRANT. DML on the mysql.* tables directly will not… recommendations from Codership. There does not, however, AFAIK, exist any dedicated checks specifically for …
