June 19, 2013

Post: Be productive with the MySQL command line

…| | 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…

Post: Ultimate MySQL variable and status reference list

MySQLalter_db_upgradeblogpercona.commanual Com_alter_eventblogpercona.commanual Com_alter_functionblogpercona.commanual Com_alter_procedureblogpercona.commanual Com_alter_serverblogpercona.commanual Com_alter_tableblogpercona.commanual Com_alterchange_dbblogpercona.commanual Com_change…skip_name_…

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

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

Post: Find and remove duplicate indexes

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

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

…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 …

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

…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

Post: devops webinar - follow up Q&A

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 …

Post: Finding your MySQL High-Availability solution – Replication

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

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

… 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 …

Post: On Character Sets and Disappearing Tables

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