… is dual. I would encourage MySQL Team at Oracle, MariaDB team or Drizzle team to take a look into solving this… * from information_schema.global_temporary_tables \G *************************** 1. row *************************** SESSION_ID: 7234 TABLE_SCHEMA: test TABLE_NAME: my ENGINE: InnoDB NAME: …
Post: Percona welcomes Drizzle 7.1
April 10, 2012 By Leave a Comment
The Drizzle team has published the first Drizzle 7.1 stable release. The … include: authentication via PAM, authentication via HTTP, various DATA_DICTIONARY tables, the Drizzle protocol plugin, authentication from a file, MySQL UNIX socket protocol, javascript plugin, authentication via tables (similar to MySQL), RabbitMQ, regex policy, logging to syslog, authentication…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 5, 2012 By 9 Comments
Is there any performance report about the tool? My team deal with a big table, and always need to alter it by adding a column for business need. And i also want to know if it’s usefull for MySQL5.5 GA or it’s just for Percona?
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… on coming MySQL User Conference, both Codership and Percona development team will be there, you will have a chance to ask…, Rolling Schema Update. Schema change does not block operations against table This is an General Availability release. We did our best…
Post: MySQL Optimizer team comments on TPC-H Results
April 14, 2008 By 1 Comment
… a chance to speak to Igor – head of MySQL optimizer team and Timur – both of them expressed concern with TPC-H…-H queries are not targeted ? The reason is MySQL Optimizer Team did not have the goal of optimizing TPC-H queries… what needs to be done first. Another reason is “Derived Tables” AKA “Subselects in FROM Clause” are not optimized yet even…
Post: How adding another table to JOIN can improve performance ?
August 1, 2008 By 12 Comments
… retrieve the rows from original table: mysql> show create table dl \G *************************** 1. row *************************** Table: dl Create Table: CREATE TABLE `dl` ( `myday` date NOT NULL… yet another table though why it does not work for multiple group remains question to check with MySQL Optimizer team 
UPDATE: I…
Post: Drop table performance
April 20, 2011 By 22 Comments
…, looking at the MySQL 5.6.2 announcement, the InnoDB team has implemented “cleaning thread”, which is also supposed to fix… bigger buffer pool: The more memory used, the slower DROP TABLE operates. MySQL 5.6.2 shows some improvement compared to… than MySQL 5.6.2. (Disclaimer: The “innodb_lazy_drop_table” feature in Percona Server and this benchmark are sponsored by…
Post: Lost innodb tables, xfs and binary grep
November 9, 2010 By 11 Comments
… the production master Luckily (or rather, unfortunately) backup only had table definitions but not the data so no data was written… XFS is possible. Just a month ago we had a team meeting in Mallorca where we went through various data loss… no longer identify correct PK id for specific tables by just mapping data dictionary table records to index records. Instead I had…
Post: Great work Innodb Team
November 30, 2009 By 8 Comments
I thought I should praise Innodb team for all the work they have been doing recently. We … even further with long standing caching issues of large full table scan wiping off the cache. The Group Commit bug is…
Post: Quickly preloading Innodb tables in the buffer pool
May 1, 2008 By 9 Comments
… information. But lest first start with feature request for Innodb Team: All ways I mention here are hacks and they can… would be great if Innodb would implement command to preload table to Innodb buffer pool, which would simply go through .ibd… scan Clustered key Anyway. Now, say you have bunch of tables having few indexes – should you run multiple queries in parallel…
