…anything. Now bumping this up to 2GB actually makes the TPS jump around a lot, sometimes hitting… simple. A classic example is a simple online game. An online game may only require that an application… called email address ). Seems simple enough right? My two tables each contain 5M rows of data. let’s…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… customers who do click analysis, site analytics, search engine marketing, online advertising, user behavior analysis, and many similar types of work… rows. That will make the indexes less than half the size. In real life this technique often makes the table+index much less… can make the application believe it has a custom table, which is really constructed behind the scenes from the name-value tables in…
Post: Percona Toolkit 2.1.9 is ready
February 15, 2013 By Leave a Comment
… new –utc option. * Fixed bug 918056: pt-table-sync false-positive error “Cannot nibble table because MySQL chose no index instead of…” error, if those chunks had diffs. * Fixed bug 1099836: pt-online-schema-change fails with “Duplicate entry” on MariaDB MariaDB 5… bug 1103672: pt-online-schema-change makes bad DELETE trigger if PK is re-created with new columns pt-online-schema-change 2…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… option can help creating tables a lot faster. You can also use pt-online-schema-change tool for online migration. Q: Should we… get to former execution plan either by updating statistics (ANALYZE TABLE) or disabling some of the optimization/statistics related features in… enabled any special Percona Server features which are marked as making database binary incompatible with MySQL. Our focus on compatibility is…
Post: Intro to OLAP
July 12, 2010 By 10 Comments
… series of posts about business intelligence tools, particularly OLAP (or online analytical processing) tools using MySQL and other free open source…? What is that? OLAP is an acronym which stands for online analytical processing. OLAP analysis, which is really just another name… way. What makes a ROLAP so great? An OLAP server usually returns information to the user as a ‘pivot table‘ or ‘pivot…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…-write splitting without breaking the user experience, how to take online non-blocking backups, or things like that. But in general…_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_size | 268435456 | | tmp_table_size… better. If the client approves it, we may make a copy of the table, make the proposed modifications to it, and show the…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… indexes which I mentioned in more details later. How does online backup work in PBXT, and is incremental backup possible? A…. The Backup API makes it possible to pull a consistent snapshot of an entire database even when tables use different engine types… to be rebuilt, which can be done by REPAIR TABLE. The table data page size does not require a rebuild because…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… as well as much more queries per page which will make > performance improvement much smaller. Notable exception being > AJAX applications which… OPTIMIZE TABLE > now locks small table for few seconds rather than giant 100GB table > for few hours so can be done pretty much online. You also get good > data clustering so table becomes hot…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
… resources available online. It should also allow running MySQL without too much hassle. Unless there are individual circumstances, it actually makes the… not only starts database, but also updates system tables (if needed), scans all tables for consistency problems, etc. I mean, that works…
Post: When should you store serialized objects in the database?
January 21, 2010 By 47 Comments
… operations like adding a secondary index on an InnoDB table require the whole table to be rebuilt (now just the index is… I’ve always been able to emulate online index adds. Projects like MMM and Flipper make this even easier. In Friendfeed’s…’ tables. What are the downsides? I would say that the first serious downside is write amplification. If you are constantly making small…
