… it to Search MySQL Forums Notice simple link structure – you can replace mysql.com in it with any other domain to search forums from that domain. For example you can use this link to search our MySQL Performance Forums Second… is too much data to group and quite a hassle to build summary tables as we want to count uniques, but it…
Post: Tools and Techniques for Index Design Webinar Questions Followup
October 4, 2012 By 5 Comments
… MySQL. The logical principles still hold true: using an index really means leveraging a pre-sorted data structure to reduce the work a… table, each index contains only values of its respective subset of the data. The index is more shallow and quicker to search… the search, the index search will be even more efficient than if you were searching for the same rows in an non-partitioned table…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… the relevance sorting by default, adding relevance sorting to the MySQL queries would make them even slower, I’m sure. Indeed… get a lot of speed improvement because you’re searching data without touching the disk, but I assume the search would necessarily do table-scans. Jessy B. also asked: Q: Were these tests performed on a single machine and a common…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… purpose of FlexCDC). Feed search engines like Sphinx or…a dedicated MySQL slave which has log_slave_updates=1 and binlog_format=row to process SBR changes from a MySQL…a moment. Lets create a table, insert some rows, add a change log, delete rows and then insert some more of them: mysql> create table…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… easy and familiar for me to use the example of search engine marketing. I’ll do that throughout this article. Requirements…/XtraDB tables… Optimize For I/O It is pretty much inevitable: if you do this kind of data processing in MySQL, you… tables in a complex query with many joins. I have never seen this approach scale well. Use The Best Technologies You Can MySQL…
Post: Visualization tools for pt-query-digest tables
August 31, 2012 By 6 Comments
… is a tool for visualizing collected data from the MySQL Slow Query Log. The name comes from the instrument in a …by different query conditions; * graphing reports; * explaining queries; * searching and displaying samples; * displaying table status and CREATE statements; * reviewing and commenting …
Post: Sharing an auto_increment value across multiple MySQL tables
October 4, 2010 By 9 Comments
… (NULL); # $connection->insert_id(); Option #2: Use a table with one just row: CREATE TABLE option2 (id int not null primary key) engine… running it, most of the threads are perpetually in a state of ‘Searching rows for update’ – which is what I suspect is better described as waiting on a lock. Option #2 will likely…
Post: Percona's Sessions at the O'Reilly MySQL Conference and Expo
April 7, 2011 By Leave a Comment
…MySQL The Aspersa System Administrator’s Toolkit Percona Server and XtraBackup: painless operations Forecasting MySQL Performance and Scalability Summary tables, aggregate tables…MySQL 5.5 Performance Schema Performance Best Practices for MySQL NoSQL with MySQL Using Sphinx Beyond Full Text Search…
Post: Friends of Percona Get 20% Off at the MySQL Conference!
February 24, 2011 By 5 Comments
…MySQL The Aspersa System Administrator’s Toolkit Percona Server and XtraBackup: painless operations Forecasting MySQL Performance and Scalability Summary tables, aggregate tables…MySQL 5.5 Performance Schema Performance Best Practices for MySQL NoSQL with MySQL Using Sphinx Beyond Full Text Search…
Comment: MySQL wins C'T Database Contest
August 30, 2006 By 27 Comments
… way to fire a query but a range of ways depending on your needs. A small benchmark presented at http://search.cpan.org/src…,140 fetches per second. A boost of 680% in the question of fetching just a single column from a mysql table through perl. On the other hand its fun with mysql at top but in…
