… number of columns in a MySQL table. So what’s the maximum number of columns in a MySQL table? Well.. I tried a few… (accepts command line parameter of number of columns to create) to produce the CREATE TABLE sql statement: sub cname ($) { my $c=shift; my… $sql; This gets you a 46kb CREATE TABLE statement and a 76kb FRM file for a table with 2,829 columns. I believe…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… MariaDB for the upstream bug #63144. CREATE TABLE or CREATE TABLE IF NOT EXISTS statements on an existing table could wait on a metadata lock… caused MySQL client to abort the connections on terminal resize. Bug fixed #925343 (Sergei Glushchenko). Percona Server for MySQL would re-create the… (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing. Bug fixed #1041981…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… #1 mysql> change master to master_auto_position = 1; mysql> start slave; and let’s create a new table on the master: mysql> create table test.t (id int not null auto_increment primary key); Executing SHOW TABLES FROM test on both slaves shows that the table…
Post: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 1, 2013 By 10 Comments
… XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users…one PXC node. This is because before Galera can create writesets for the replicated events, binlog events must … to Inconsistencies and May Not Even Work! MyISAM tables are supported within Percona XtraDB Cluster, however, MyISAM …
Post: MySQL alternative Percona Server 5.1.68 -14.6 now available
April 19, 2013 By 3 Comments
… id=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.1.68-14.6[/caption] Percona is glad… log is enabled. Bug fixed #1162085. Percona Server would re-create the test database when using rpm on server upgrade, even…. Percona Server was missing help texts in the MySQL client because the help tables were missing. Bug fixed #1041981. Other bugs fixes…
Post: Repair MySQL 5.6 GTID replication by injecting empty transactions
March 26, 2013 By 1 Comment
… to ignore that transaction. The way to do it is creating a new empty transaction with it the GTID we want…-table-checksum can help you here, which is found in Percona Toolkit for MySQL. Last week I gave a talk at Percona MySQL University @Toronto about GTID. It includes an overview of MySQL 5…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… workload (which actually is closer to what I need). Tables looks like: CREATE TABLE `sbtest1` ( `hid` int(10) unsigned NOT NULL DEFAULT ’0…: sysbench –test=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on –max…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… so the server deals with an empty transaction list when creating read views. However, the more general descriptors optimization in …120 –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… create/restore a slave can be found in this blogpost. Percona XtraBackup option xtrabackup –export now supports transportable tablespaces introduced in MySQL… crash when preparing the 5.6 backup with partitioned tables. Bug fixed #1169169. Tables that were dropped between taking a full backup…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… create/restore a slave can be found in this blogpost. Percona XtraBackup option xtrabackup –export now supports transportable tablespaces introduced in MySQL… crash when preparing the 5.6 backup with partitioned tables. Bug fixed #1169169. Tables that were dropped between taking a full backup…
