…replication, InnoDB Fulltext, Memcached integration, a more complete performance schema, online DDL and several other …Duplicates: 0 Warnings: 0 mysql> SHOW CREATE TABLE test\G *************************** 1. row *************************** Table: test Create Table: CREATE TABLE `test` ( `id` int(11) …
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… tuples in a table with no primary key was not deterministic which could lead to a node failure…case CREATE TABLE AS SELECT statement was running in parallel with the DDL statement on the selected table, … our online documentation. We did our best to eliminate bugs and problems, but this is a software…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… a fix from MariaDB for the upstream bug #63144. CREATE TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait on a metadata… failing or returning immediately if there is a transaction that executed a query which opened that table. Bug fixed #1127008 (Sergei Glushchenko). Fix… in our online documentation. Bugs can be reported on the launchpad bug tracker. UPDATE[18-04-2013]: There was a RPM packaging…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… a fix from MariaDB for the upstream bug #63144. CREATE TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait on a metadata… failing or returning immediately if there is a transaction that executed a query which opened that table. Bug fixed #1127008 (Sergei Glushchenko). Fix… in our online documentation. Bugs can be reported on the launchpad bug tracker. UPDATE[18-04-2013]: There was a RPM packaging…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… of how this information can be used to create/restore a slave can be found in this blogpost….6 backup with partitioned tables. Bug fixed #1169169. Tables that were dropped between taking a full backup and …XtraBackup 2.0.7 are available in our online documentation. Bugs can be reported on the …
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… binlog information wasn’t available. Fixed by not creating xtrabackup_binlog_info file when binlog isn’t …files behind due to a typo. Bug fixed #1172016. Percona XtraBackup would assume the table has been dropped…XtraBackup 2.1.1 are available in our online documentation. Bugs can be reported on the …
Post: MySQL alternative Percona Server 5.1.68 -14.6 now available
April 19, 2013 By 3 Comments
…which could cause a server to hang when binary log is enabled. Bug fixed #1162085. Percona Server would re-create the …missing help texts in the MySQL client because the help tables were missing. Bug fixed #1041981. Other bugs fixes: bug …Server 5.1.68-14.6 are available in our online documentation.
Post: Hacking to make ALTER TABLE online for certain changes
October 29, 2007 By 26 Comments
… TABLES; Query OK, 0 rows affected (0.00 sec) mysql> SHOW CREATE TABLE `huge_table`\G *************************** 1. row *************************** Table: huge_table Create Table: CREATE TABLE `huge_table` ( … auto_increment is removed. I’ve been a bit surprised, that removing value from enum() …
Post: Knowing what pt-online-schema-change will do
November 1, 2012 By 1 Comment
… Starting a dry run. `test`.`t` will not be altered. Specify –execute instead of –dry-run to alter the table. Creating new table… CREATE TABLE `…attendee of webinars knows: pt-online-schema-change creates three triggers: Not creating triggers because this is a dry run. CREATE TRIGGER `pt_osc_test…
Post: pt-online-schema-change and default values
June 21, 2012 By 1 Comment
…-online-schema-change –execute –alter=”add column v varchar(100) not null” D=sbtest,t=sbtest Altering `sbtest`.`sbtest`… Creating new table… Created new table… from `sbtest`.`sbtest` to `sbtest`.`_sbtest_new`: Copying rows caused a MySQL error 1364: Level: Warning Code: 1364 Message: Field ‘v…
