… interesting conclusion here that the ALTER waits only at the last stages when its making changes to the table metadata, a… as such I have reported a bug: http://bugs.mysql.com/bug.php?id=67647 Metadata locking behaves differently for queries that are…, and as such I have reported the bug: http://bugs.mysql.com/bug.php?id=67873
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
…tcp_fin_timeout” to reduce recycle delay. Reducing last one however will go against protocol requirements … connections were added to PHP during times of MySQL 3.22/3.23 when MySQL was simple enough …connection ID so if you track web requests in MySQL Logs by connection ID it would still work. MySQL …
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…id, customer_name, sale_when; $ php convert.php demo < sales.sql CALL flexviews.create('demo', 'dashboard_customer_sales', 'INCREMENTAL'); SET @mvid := LAST_INSERT_ID…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…was discussed in the comments of the last post. ICE does not have any …id` (`dest_airport_id`), KEY `DepDelay` (`DepDelay`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT=’Contains all avaialble data from 1988 to 2010′; mysql… (adjust to your number of nodes) php genconfig 20 > shards.ini Running the…
Post: thread_concurrency doesn't do what you expect
June 4, 2012 By 3 Comments
Over the last months I’ve seen lots of customers trying to tune the thread concurrency inside MySQL with the variable thread… deprecated and removed on 5.6.1 http://bugs.mysql.com/bug.php?id=55001 2- It only works on old Solaris versions… is causing lot of confusion and there are hundred of MySQL tuning howtos that explain how to tune the variable to…
Comment: No more MySQL Crash Safe Replication in 5.0 ?
August 10, 2010 By 7 Comments
…://bugs.mysql.com/bug.php?id=34058, this has since been fixed (this bug was marked as duplicate of http://bugs.mysql.com/bug.php?id…: In a MySQL replication slave the last master binlog file InnoDB: position 0 517, file name mysql-bin.000002 InnoDB: Last MySQL binlog file position…: In a MySQL replication slave the last master binlog file InnoDB: position 0 1604, file name mysql-bin.000001 InnoDB: Last MySQL binlog file position…
Post: GROUP_CONCAT useful GROUP BY extension
September 4, 2006 By 49 Comments
…PHP to MySQL server side. Also it can be handy to use result concatenated string as part of IN statement: Sure, last…
Comment: Flexviews is a working scalable database transactional memory example
May 19, 2011 By 3 Comments
… load balancing – my last proposal for the future of the PHP replication plugin….What?…Think of a global transaction ID as a unique… commit a transaction UPDATE the trx id field ..UPDATE trx SET trx id trx id 1.From ….Dear MySQL database administrator please drop us a note if you want this to be implemented in the PHP…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… patch, and the ‘last‘ serious bug in it was only recently found and fixed: http://bugs.mysql.com/bug.php?id=29560 Concerning a… amount of system memory. We just deployed a new Linux/Mysql server for a client, upgrading their main database (from 16GB… – choosing innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent…
Post: XtraDB storage engine release 1.0.3-7
August 17, 2009 By 6 Comments
…, Today we are announcing XtraDB release 7. This is the last release based on InnoDB plugin version 1.0.3, as….36†This fixes also http://bugs.mysql.com/bug.php?id=45749 and http://bugs.mysql.com/bug.php?id=42101 The builds for RedHat4,5 and Debian are located on http://www.percona.com/mysql/xtradb…
