June 19, 2013

Post: Upgrading MySQL

January 5, 2010 By 24 Comments

…known incompatibilities and fix them. The data storage is however only small part of…FROM users WHERE id=5 you can probably go to the earliest MySQL version… perform stress testing to ensure both MySQL does not crash under your load …before upgrading and make sure to keep binary logs for some time, in…

Filed Under: Insight for DBAs, MySQL

Post: MySQL Storage Engines - PBXT

May 14, 2007 By 6 Comments

… We did not check writes because this is where a lot of changes are expected to happen …cached in most cases. As PBXT does not use pages for data storage, which tend to lead to …keep data files compact and efficient. As I heard someone joked at the conference “Now so many years after PostgreSQL, MySQL…

Filed Under: Insight for DBAs Tagged With:

Post: Shard-Query EC2 images available

May 11, 2011 By 2 Comments

… >> /dev/null 2>&1 < /dev/null done; Where to find the images Amazon…data. The ICE schema was discussed in the comments of the last post. ICE does… avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show … fewer nodes in order to keep data entirely in memory. This frees…

Filed Under: MySQL

Post: Data Corruption, DRBD and story of bug

November 29, 2010 By 6 Comments

… and mysqldump your data. What makes problem even worse is that InnoDB does not report tablename, …, which can be long process. The moment where DRBD come in play, is if you …worked with), you screwed, as DRBD mirroring physical data, and MySQL keeping crashing on both instances – active and passive…

Filed Under: Hardware and Storage, MySQL Tagged With: ,

Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1

October 15, 2009 By 16 Comments

…and only 1G is in memcached, I keep pushing data out of memcached to make room for … MySQL to using MySQL + Memcached, and then to other solutions like Tokyo Tyrant or Cassandra. My Application does…of writes in MySQL coupled with the still large # of reads takes its toll. Another place where I have…

Filed Under: Benchmarks, Cloud and NoSQL, MySQL Tagged With: , ,

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

…all the notes and generally keeping in touch with what the lead consultant does. We want two sets…where there’s a /var/lib/mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql…the settings and status pretty quickly. Analyzing MySQL‘s workload and data After I’m done with that…

Filed Under: Insight for Developers Tagged With:

Post: Falcon Storage Engine Design Review

January 12, 2007 By 19 Comments

… run well too frequently if I keep them close. Manual does not say much on this matter… frequently with MySQL :) [+] Compact Indexes Compact Indexes are great. Huge indexes is where large portion of…[-] No Clustering Index support Unlike Innodb Falcon does not cluster data by Primary Key or any other …

Filed Under: Insight for DBAs Tagged With:

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

February 26, 2013 By 1 Comment

…data. NOTE 3: Also, keep in mind that I used the community editions of MySQL 5.5.30 and MySQL… generated by InnoDB when the table does not contain a suitable column,” but …mysql> insert into dir_test_innodb3 (fts_doc_id, full_name) values (1, ‘john smith’); mysql> select * from dir_test_innodb3 where…

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

Post: Is disk Everything for MySQL Performance ?

April 25, 2008 By 7 Comments

…data archive storage. On BoardReader for example we’re limited by space and how much data we can comfortably put in MySQL… have BBU most likely data files is where all IO will go…. can keep the same RAID volume. I tend to keep Innodb data files (…to swap actively – if it does your’re in trouble anyway…

Filed Under: Hardware and Storage Tagged With:

Post: Flexviews - part 3 - improving query performance using materialized views

April 4, 2011 By 20 Comments

… stored in the data dictionary: mysql> select * from flexviews.mview_table where mview_id= flexviews…incrementally refreshable one, then you can keep the complete views transactionally consistent with… the incrementally refreshable version does not take long to refresh: mysql> call flexviews.refresh( …

Filed Under: Insight for DBAs, MySQL
« Older Posts
Newer Posts »