June 19, 2013

Post: What is the largest amount of data do you store in MySQL ?

November 9, 2012 By 19 Comments

… is How much data do your store in your largest MySQL instance ? I’m interested about single instance not the total amount of data you have in MySQL in your Sharded replicated environment. Feel free to share details in comments – are you using MyISAM or Innodb ? Is…

Filed Under: Insight for DBAs, MySQL, Polls

Post: Product to try: MySQL/MariaDB-Galera 0.8

June 13, 2011 By 34 Comments

… (not a transaction). Transaction is not guaranteed to be applied – what is guaranteed is that every node will … that this solution is available for MySQL users as Free / Open Source Software. “Where is the catch?”, you may… again, it has to copy the whole data set again. But if it was disconnected …

Filed Under: MySQL

Post: What Causes Downtime in MySQL?

March 21, 2011 By 10 Comments

… customers. The numbers contradict the urban myth that bad SQL is the most common problem in databases. There are a number… causes of data loss. This is the companion to my earlier white paper suggesting ways to prevent emergencies in MySQL. It is a re… in IOUG’s SELECT magazine. You can download it for free from the MySQL white papers page on the Percona web site.

Filed Under: Insight for DBAs, MySQL

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…. First, MyISAM, with MySQL 5.5, on the SEO data set: mysql: SELECT id, title, MATCH(…And Background Checks | 4.569097518920898 | | 70 | Montana Free Public Records, Criminal Records And Background Checks | 4….the list. With 5.5, this is exactly what happens: mysql: SELECT id, full_name, MATCH(full_…

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

Post: MySQL Query Cache

July 27, 2006 By 70 Comments

…what MySQL Query Cache is – I’ve seen number of people being confused, thinking MySQL Query Cache is… is not implemented. Cursors get data in chunks so it is…is hard to tell what is good or bad as a lot depends on statement complexity as well as how much work is… even if there is some free space, just …

Filed Under: Insight for DBAs Tagged With:

Post: Implications of Metadata Locking Changes in MySQL 5.5

February 1, 2013 By 9 Comments

… to discuss what these implications exactly are. To read what Metadata Locking exactly is please read this section here in the MySQL manual. Let… | 0.000002 | | Sending data | 0.000040 | | end | 0.000003 | | query end | 0.000002 | | closing tables | 0.000003 | | freeing items | 0.000007 | | logging…

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

Post: Bug#12704861

November 20, 2011 By 1 Comment

…what could potentially be a very serious problem that is fixed in MySQL…free_frag(): Refactored from fsp_alloc_free_page(). Allocate the specified page from a partially free extent. fseg_alloc_free_page_low(), fseg_alloc_free…

Filed Under: MySQL

Post: How to debug long-running transactions in MySQL

March 8, 2011 By 6 Comments

…actually easy to figure out what the long-running transaction is doing. The most obvious is if it’s a …it self-purges its own data, and it won’t run if the disk is getting full. I’ve … then echo “Exiting, not enough free space (${full}%, ${avail}MB free)”>&2 exit 1 fi host=$(mysql -ss -e ‘SELECT p….

Filed Under: Insight for DBAs, MySQL

Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see

February 12, 2013 By 4 Comments

…/Galera and give some helpful instruction about what some migration strategies might look like. Using MySQL Performance Schema to debug performance issues… Maria, and since Perl is a native language to me, this seems compelling. Managing data and data archiving using MySQL 5.6 new features… strong competing talks. Win a free Conference Pass Since we’re talking about interesting talks, what talk would you most like to…

Filed Under: Events and Announcements, MySQL, Percona Live Tagged With: , ,

Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit

November 24, 2011 By 2 Comments

…patch Now let’s see what kind of goodies does Helgrind find on MySQL server. Let’s take… test is chosen for no particular reason except that it is a quick-running one. ==9090== Possible data … (sync0sync.ic:221) ==9090==    by 0x6B39223: fsp_fill_free_list (fsp0fsp.c:1455) ==9090==    by 0x6B3DED8: …

Filed Under: MySQL
« Older Posts
Newer Posts »