June 18, 2013

Post: Reasons for MySQL Replication Lag

July 29, 2011 By 9 Comments

…questions our MySQL Support customers ask is MySQL Replication Lag. The story is …small” batch job being ran which does a lot of updates can … but also how much IO they are causing and how many rows they …MySQL is doing to IO going to devices from OS standpoint. If this is external and not recorded…

Filed Under: Insight for DBAs, MySQL Tagged With:

Post: High-Performance Click Analysis with MySQL

December 22, 2008 By 13 Comments

…?  Is it enough to know how many times the ad was clicked each day… sets are very expensive.  If MySQL supported sort-merge or hash joins, you’… to avoid joins. Watch Data Types Does your ad ID look like “8a4dabde…have the clicks column record the total, and the blue_clicks column record only blue …

Filed Under: Insight for Developers Tagged With: , , , ,

Post: Analyzing air traffic performance with InfoBright and MonetDB

October 2, 2009 By 50 Comments

…. After that load statement is: mysql -S /tmp/mysql-ib.sock -e “LOAD DATA …does not like to scan many records, there is query select year,count(*) as c1 from ontime group by YEAR which shows how many records… success Worth to note that MonetDB supports all INSERT / UPDATE / DELETE statements (and …

Filed Under: Benchmarks, MySQL Tagged With: , , ,

Post: Using any general purpose computer as a special purpose SIMD computer

May 16, 2011 By 5 Comments

… how to count the number of unique words, an how many…Records: 3088896 Duplicates: 0 Warnings: 0 Here is the serial version as run by the native database interface (MySQL): mysql…serialization at the end. How does this work? Here … technologies can not support such a degree. mysql> select min(id),max(…

Filed Under: MySQL

Post: Full Text Search Webinar Questions Followup

August 24, 2012 By 5 Comments

… emailed a link to the recording. During my webinar, a number…Sphinx does the relevance sorting by default, adding relevance sorting to the MySQL…SHOW META command in Sphinx shows how many rows each keyword matched, and… also supports a supplementary in-memory RT index type that supports direct row…

Filed Under: Events and Announcements, Insight for Developers, MySQL

Post: Emulating global transaction ID with pt-heartbeat

November 4, 2011 By 6 Comments

…many many binary logs. This was a lot of work, even when automated. Wouldn’t it be nice if the replication heartbeat record…how many servers were missing, we’d have some guidepost for where everything is relative to everything else upstream from it. So how does…tool supported …: mysql> select * from …

Filed Under: Insight for DBAs, MySQL

Post: Heikki Tuuri Innodb answers - Part I

October 26, 2007 By 19 Comments

…we need to know the whole record R. Also, a gzip compression…how many read-ahead requests can be queued at once. Q13: Is there any IO concurrency control – how many… new features in MySQL 5.1 Q15: How frequently does Innodb fuzzy checkpointing is…if you disable the new XA support (which we don’t use)…

Filed Under: Insight for Developers Tagged With: ,

Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A

October 28, 2012 By 4 Comments

… replication here, with many parallel threads, this…record. This means that if you have “hot database areas (single records…galera and built-in mysql replication are independent from…support is experimental. Apart from some very special, edge cases, I would not recommend using MyISAM. Q: How does…

Filed Under: MySQL, XtraDB Cluster

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…MySQL 5.6, MyISAM was the only storage engine with support for full-text search (FTS). And I’ve encountered many…to find out how to make…sec) Records: 0 Duplicates: 0 Warnings: 1 mysql> show warnings; +———+——+————————————————–+ | Level | … table does not …

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: How much overhead DRDB could cause ?

June 2, 2008 By 4 Comments

…MySQL 5.0 – there is event written to the binary log to “prepare” XA transaction, when there is record… how Filesystem does it job. Rates of 40-50 transactions per second are not encouraging for many … interesting to see DRBD to have direct support for Infiniband or Dolphin interconnect sockets which…

Filed Under: Uncategorized Tagged With:
« Older Posts