…Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5….`), KEY `pdc` (`price`,`dateandtime`,`customerid`) ) ENGINE=InnoDB AUTO_INCREMENT=11073789 DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE…. Another thing I would like to share is that, the size of the …
Post: How much memory Innodb locks really take ?
July 13, 2006 By 11 Comments
… NOT NULL auto_increment, `j` varchar(255) default NULL, PRIMARY KEY (`i`), KEY `j` (`j`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 mysql> show table… it take: mysql> begin; Query OK, 0 rows affected (0.00 sec) mysql> select count(i) from sample lock in share mode; +———-+ | count…
Post: A workaround for the performance problems of TEMPTABLE views
May 19, 2010 By 7 Comments
… NULL, `c2` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c2`), KEY `c1` (`c1`) ) ENGINE=InnoDB AUTO_INCREMENT=2949071 DEFAULT CHARSET=latin1 1 row… way that it can be shared between views. This example is somewhere in between those two extremes: mysql> create table params ( view…
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
…) like crazy. Why ? Because by default mysql_query uses mysql_store_result C library call and … table though which can be quite high. Sharing connection no more works If you use … the temporary table with auto_increment column and fetch data from this table using auto increment column ranges instead. …
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
…length: 0 Index_length: 0 Data_free: 0 Auto_increment: NULL Create_time: NULL Update_time: NULL Check_…in summary table at the bottom) Query Q1: mysql> SELECT DayOfWeek, count(*) AS c FROM ontime …fg which cooperate each with other using IPC shared memory and semaphores. To clean system I rebooted…
Comment: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… being more sound, also the usability would improve over MySQL replication. I’ll share my own opinion once I touch it. There… (depending on application design). However, it is more solid than MySQL semi-sync in that the transaction is guaranteed to apply… test the code where slaves approve transactions for commit. Are auto_increment and other gotchas handled properly? – Implement a solution that makes…
Post: Percona testing: Quick test clusters with kewpie!
January 13, 2012 By Leave a Comment
… instructions for setting up a test cluster, I wanted to share a quick way to set up an ad-hoc cluster… statement. mysql> create table t1 (a int not null auto_increment, primary key(a)); Query OK, 0 rows affected (0.11 sec) mysql> insert… | | 10 | | 13 | +—-+ 5 rows in set (0.00 sec) mysql> exit; Bye $ mysql -uroot –protocol=tcp –port=9320 test Reading table information…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… well when all you want is to remove auto_increment or change ENUM values. When it comes to…our MySQL support customers as they were upgrading their application and mysql schema. We deployed and used MySQL …”downtime” was really trivial. I’d like to share my experience. The article does not cover …
Post: Innodb row size limitation
April 7, 2011 By 12 Comments
… CREATE TABLE example ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, fname TEXT NOT NULL, fcomment TEXT, ftitle …=InnoDB; Now you insert some test data into it: mysql> INSERT INTO example -> VALUES ( ->Â Â NULL, ->Â …things one should consider. No overflow pages are shared, so a 769 byte blob will get …
Post: Another scalability fix in XtraDB
January 23, 2009 By 13 Comments
… EXISTS sbtest ( id int(10) unsigned NOT NULL auto_increment, name varchar(64) NOT NULL default ”, email varchar(64… after 8 connections, si I decided to test MySQL-5.1.30 with standard InnoDB. It was …mutex is used as mutex even in places where shared read lock is enough – and we replaced page_…
