… traffic from MySQL 5.6 is to use a caching layer to store expensive result sets or objects. Some typical use cases include… is where a persistent cache can be invaluable. Enter MySQL 5.6 with the memcached plugin… As part of the standard MySQL 5… show any multi-threading or other advanced operation, it is using identical code to eliminate variation due to client libraries. The…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… a modular system where the storage engines themselves owned their own metadata. This was a radical departure from the MySQL philosophy, and… Drizzle code base. However… for those using MySQL, Percona Server, MariaDB or any other of the MySQL branches/forks, you get to have… into the SQL based MySQL, with MySQL 1.0 being released in 1995. The FoRM file specified what fields where on what screen…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… important baseline that offers the best response times (MySQL server does not use multiple threads to execute query in parallel at this… terms of benchmarks, Mark Callaghan published an example where 8 sysbench tables are used which means the lowest concurrency you can run… performance? Come to Percona Live MySQL Conference and Expo April 22-25 in Santa Clara, California, where “performance” is going to be…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… pool we use following queries: select avg(id) from sbtest$i force key (primary) select count(*) from sbtest$i WHERE k like… –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… –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=9 –oltp…
Post: Percona XtraDB Cluster for MySQL and encrypted Galera replication
May 3, 2013 By 2 Comments
… have a mixed cluster where some have SSL and …mysql]# service mysql stop [root@node1 mysql]# service mysql stop [root@node1 mysql]# service mysql start –wsrep_cluster_address=gcomm:// [root@node2 mysql]# service mysql start [root@node3 mysql… to Codership, IST transfers use the same socket settings …
Post: Why use encrypted backup with Percona XtraBackup 2.1 for MySQL?
April 10, 2013 By 2 Comments
… released our first alpha of Percona XtraBackup 2.1 for MySQL and with it we included the ability to encrypt backups… using multiple CPU cores. One advantage of encrypting your backups is it means you can place less trust in the place where….1.0-alpha1 supports industry standard AES encryption and we use an existing software library (libgcrypt) to do the heavy lifting…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… type where it would make sense it is still zero. If you know how InnoDB uses `PREC` please let me know. mysql> select * from SYS_COLUMNS WHERE TABLE_ID=741; +———-+—–+————-+——-+———+——+——+ | TABLE_ID…
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
… software some 70% of revenue used to come from licenses – OEM licenses. I do not know where this number is now but it is not zero. We also see Open Core models with MySQL getting traction… source software so people use proprietary licensed software as there is no choice. I think this is where the advantages of TokuDB…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…which should produce updates in-place (I will use INSERT .. ON DUPLICATE KEY UPDATE statements for … understand that my PRIMARY KEY (`hid`,`mid`,`id`) where `id` is sequential, and `hid`,`mid` is …_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-…
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
… or not? e.g. I choose MySQL, then I go write my app to use MySQL. Later I may want to move to… be able to choose from multiple suppliers of MySQL but it’s still MySQL, even if it’s some fork like Maria…”. I’ve worked under a few different senior management types where the first thing they ask is – “Is there a way…
