June 19, 2013

Post: Be productive with the MySQL command line

December 21, 2012 By 14 Comments

…| | ALI FOREVER | | ALICE FANTASIA | | ALIEN CENTER | | ALLEY EVOLUTION | | ALONE TRIP | | ALTER VICTORY | | AMADEUS HOLY | –Plus– Another example of the pager …of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select count(*) from…

Filed Under: Insight for DBAs, MySQL

Post: Ultimate MySQL variable and status reference list

January 8, 2011 By 4 Comments

…MySQL…alter_db_upgradeblogpercona.commanual Com_alter_eventblogpercona.commanual Com_alter_functionblogpercona.commanual Com_alter_procedureblogpercona.commanual Com_alter_serverblogpercona.commanual Com_alter_tableblogpercona.commanual Com_alter…change_dbblogpercona.commanual Com_change…skip_name_…

Filed Under: Insight for DBAs, MySQL

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…database directory: -rw-rw—-. 1 mysql mysql 8632 Feb 20 15:54 dir_test_innodb.frm -rw-rw—-. 1 mysql mysql… warning is generated: mysql> alter table dir_test_innodb ADD FULLTEXT KEY (full_name, details); Query OK… change to the default InnoDB settings for MySQL 5.6, and that was to change …

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Find and remove duplicate indexes

June 20, 2012 By 9 Comments

…name); mysql> alter table t add index(name); mysql> alter table t add index(name); mysql> show create table t\G [...] KEY `name` (`name`), KEY `name_2` (`name`), KEY `name_3` (`name`) [...] MySQL detects that the ‘name…

Filed Under: Insight for DBAs, Insight for Developers, MySQL, Percona Software

Post: Quickly finding unused indexes (and estimating their size)

December 5, 2012 By 2 Comments

…recently who needed to reduce their database size on disk quickly without a …changes over time: mysql> create view all_indexes as select t.table_schema as TABLE_SCHEMA, t.table_name as TABLE_NAME, i.index_name… for your table by simply doing: mysql> alter table mytable ENGINE=Innodb; However, this …

Filed Under: Insight for DBAs, MySQL, Percona Software

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…our InnoDB results change? No, they are exactly the same, although the scores did change slightly. What…of upgrading to 5.6 and running ALTER TABLE foo ENGINE=InnoDB. In theory, yes. …database, and I used double quotes to group the search terms as a single phrase: With 5.5: mysql: SELECT id, full_name…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: devops webinar - follow up Q&A

November 6, 2012 By 5 Comments

…database version? Any opinion? A: First I want to apologize that I didn’t understand the name…and more mature solution used to perform database change management. However there are many other alternatives … run the ALTER statements from your configuration management when a file with those ALTERs is …

Filed Under: MySQL

Post: Finding your MySQL High-Availability solution – Replication

November 13, 2009 By 6 Comments

… specific database …MySQL, altering a table means recreating the whole table and it is a blocking operations. Altering…alter table on the other server. Those online schema change…name imply, manages the availability of the MySQL service. A high availability solution based on MMM requires at the 2 MySQL…

Filed Under: Insight for DBAs, MySQL Tagged With: ,

Post: MySQL Backup tools used by Percona Remote DBA for MySQL

March 13, 2013 By 8 Comments

… loop through each DB write out ALTER DATABASE DEFAULT CHARACTER SET to the… “FLUSH TABLE WITH READ LOCK”. Namely when a select is blocking … term backups Decompressing Percona XtraBackup for MySQL  in parallel using all your …file, for files that don’t change they can be easily hardlinked …

Filed Under: Cloud and NoSQL, Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , , , , ,

Post: On Character Sets and Disappearing Tables

June 21, 2012 By 1 Comment

… [oops4]> alter table dos2 change column fkto3 fkto3 char(32) character set ascii not null, change…database to get the actual filename of the temporary table rather than the temporary table name…MySQL won’t allow us to change an FK-referenced column from INT to SMALLINT, but it will allow us to change…

Filed Under: Insight for DBAs, MySQL
« Older Posts