… of the mysql-data logical volume taken named ‘mysql-data-201202230157′ using a script* I…) mysql> drop table salaries; — Ooops! Query OK, 0 rows affected (0.49 sec) mysql> alter…sec) Records: 300024 Duplicates: 0 Warnings: 0 mysql> update employees set age = ((YEAR(CURDATE())-YEAR(birth_date…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… mysql> STOP SLAVE; we don’t want schema changes to be replicated to db1 now. 3. on db2: load the sql scripts $ mysql… are assigned to db1 at this stage. If you’re altering gigabyte size tables, this step may take some time. Go…: start replication mysql> START SLAVE; db1 will receive the updates that were executed by changes.sql or some other script and rebuild its…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… to save work. Avoid operations that update huge chunks of aggregated data at …it on the filesystem and write custom scripts to do special-purpose tasks on it…save you from the downtime caused by ALTER TABLE — a typical reason to think… either using MySQL 5.1′s row-based replication, or in MySQL 5.0 …
Post: Migrating to XtraDB Cluster Webinar follow up questions
June 6, 2012 By 3 Comments
…. Q: Are adding/updating mysql user accounts replicated? Yes, provided you use CREATE USER or GRANT. DML on the mysql.* tables directly will… here. Q: Any settings that require a mysql restart or can they all be updated with a reload? All the documentation I… are all scripts, so it should be easy for you to fix yourself as well. Q: what about humongous ALTER TABLE? Does…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
… build option for build-binary.sh script, new –valgrind option has been introduced…ALTER TABLE and SHOW ENGINE INNODB STATUS. Bug fixed #1017192 (Sergei Glushchenko). The server could crash when executing an INSERT or UPDATE… option innodb_changed_pages_limit. MySQL option handling would then shadow …
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…of outages can happen? Someone runs UPDATE or DELETE and forgets the …loop through each DB write out ALTER DATABASE DEFAULT CHARACTER SET
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…interval you want to have, if you’re writing scripts to look at SHOW INNODB STATUS it is …struct(s), heap size 320 MySQL thread id 30898, query id 100626 localhost root Updating update iz set pad=’a’ …of tables locked normally stays 0, unless it is ALTER TABLE or similar statement, or if LOCK TABLES …
Comment: Feature in details: Incremental state transfer after a node crash in Percona XtraDB Cluster
January 31, 2013 By 2 Comments
… sequence number directly and just restart mysql via your init script: [root@node3 ~]# cat /var/lib/mysql/grastate.dat # GALERA saved state version….dat (I use vi) and update the uuid and seqno fields): [root@node3 ~]# cat /var/lib/mysql/grastate.dat # GALERA saved state… from the Innodb redo logs. Any updates to any MyISAM tables, or any ongoing DDL (ALTER or similar) are not transactional. It…
