Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 31 to 60 of 113 Next 30 Older Entries

Displaying posts with tag: xtradb (reset)

MySQL 5.5.8 and Percona Server: being adaptive
+3 Vote Up -0Vote Down

As we can see, MySQL 5.5.8 comes with great improvements and scalability fixes. Adding up all the new features, you have a great release. However, there is one area I want to touch on in this post. At Percona, we consider it important not only to have the best peak performance, but also stable and predictable performance. I refer you to Peter's post, Performance Optimization and Six Sigma.

In Percona Server (and actually even before that, in percona-patches builds for 5.0), we added adaptive checkpoint algorithms, and later the InnoDB-plugin included an implementation of  "adaptive flushing". This post shows the differences between them and MySQL.

The post also answers the question of whether we are going to have releases of Percona

  [Read more...]
Percona Server 5.1.53-11.7
+1 Vote Up -0Vote Down

Percona Server version 5.1.53-11.7 is now available for download.

The main purpose of this release is to update the current Percona stable release to the latest version of MySQL 5.1.

Functionality Added or Changed

  •  Percona Server 5.1.53-11.7 is now based on MySQL 5.1.53.
  •  New Features Added: None
  •  Other Changes: None

Bugs Fixed

  • Bug #643149 - Slow query log entries were not being done in the usual parsing format. (Alexey Kopytov)
  • Bug #677407 - The innodb.innodb_information_schema test could fail sporadically due to flawed logic in the INFORMATION_SCHEMA.INNODB_LOCKS caching mechanism. (Alexey Kopytov)

Release Notes for this and previous releases can be found in our

  [Read more...]
Percona Server now both SQL and NOSQL
+8 Vote Up -0Vote Down

Just yesterday we released Percona Server 5.1.52-12.3 which includes HandlerSocket. This is third-party plugin, developed Inada Naoki, DeNA Co., Ltd and explained in Yoshinori Matsunobu's blog post.

What is so special about it:

  • It provides NOSQL-like requests to data stored in XtraDB. So in the same time you can access your data in SQL and NOSQL ways. This is first open source solution which allows that.
  • It has persistent storage (XtraDB is persistent)
  • It handles really high load. In my tests using 2 dedicated web servers ( using perl clients) I reached 200,000 req/sec and the clients were real bottleneck, while Percona Server was busy only
  [Read more...]
Percona Training in London and Frankfurt
+1 Vote Up -0Vote Down

For those that missed it - last week we added training in Frankfurt and London to our website.  This includes our new Operations Training announced in September.

(While in Europe, we'd love to speak at your meetup group on Percona Server and/or MySQL Optimization.  If you're a meetup organizer in London or Paris, please feel free to get in touch.)


Entry posted by Morgan Tocker |

  [Read more...]
Percona Server 5.1.52-12.3
+2 Vote Up -1Vote Down

Percona Server version 5.1.52-12.3 is now available for download.

The main purpose of this release is to update the current Percona release candidate to the latest version of MySQL 5.1. The release also includes the HandlerSocket plugin, which provides NoSQL features in Percona Server.

Functionality Added or Changed

  [Read more...]
Percona XtraBackup 1.5-Beta
+2 Vote Up -1Vote Down

Percona XtraBackup 1.5-Beta is now available for download.

This release adds additional functionality to Percona XtraBackup 1.4, the current general availability version of XtraBackup.

This is a beta release.

Functionality Added or Changed

  • Support for MySQL 5.5 databases has been implemented. (Yasufumi Kinoshita)
  • XtraBackup can now be built from the MySQL 5.1.52, MySQL 5.5.7, or Percona Server 5.1.53-12 code bases (fixes bug #683507). (Alexey Kopytov)
  • The program is now distributed as three separate binaries: 
    • xtrabackup - for use with Percona Server with the built-in InnoDB plugin
    • xtrabackup_51 - for use with MySQL 5.0 & 5.1 with built-in InnoDB
    • xtrabackup_55 - for use with MySQL 5.5 (this binary is not provided for the FreeBSD
  [Read more...]
How well does your table fits in innodb buffer pool ?
+2 Vote Up -0Vote Down

Understanding how well your tables and indexes fit to buffer pool are often very helpful to understand why some queries are IO bound and others not - it may be because the tables and indexes they are accessing are not in cache, for example being washed away by other queries. MySQL Server does not provide any information of this type, Percona Server however adds number of tables to Information Schema which makes this information possible. It is just few queries away:

PLAIN TEXT SQL:
  • mysql> SELECT `schema` AS table_schema,innodb_sys_tables.name AS table_name,innodb_sys_indexes.name AS index_name,cnt,dirty,hashed,round(cnt*100/index_size,2) fit_pct   FROM (SELECT index_id,count(*)
  •   [Read more...]
    Thinking about running OPTIMIZE on your Innodb Table ? Stop!
    +4 Vote Up -0Vote Down

    Innodb/XtraDB tables do benefit from being reorganized often. You can get data physically laid out in primary key order as well as get better feel for primary key and index pages and so using less space,
    it is just OPTIMIZE TABLE might not be best way to do it.

    If you're running Innodb Plugin on Percona Server with XtraDB you get benefit of a great new feature - ability to build indexes by sort instead of via insertion. This process can be a lot faster, especially for large indexes which would get inserts in very random order, such as indexes on UUID column or something similar. It also produces a lot better fill factor. The problem is.... OPTIMIZE TABLE for Innodb tables does not get advantage of it for whatever reason.

    Lets take a look at little benchmark I done by running OPTIMIZE for a second time on a table


      [Read more...]
    Speaking on San Francisco Meetup 14-Dec : What’s new in XtraDB/InnoDB-plugin 5.1+
    +2 Vote Up -0Vote Down

    Erin and Mike, organizers of SF Meetup generously invited me to talk on coming SF Meetup on Dec-14 about new features in InnoDB in MySQL 5.1 and 5.5 and, what is pay attention to, when you upgrade from MySQL 5.0.
    Although I personally mostly in 5.1->5.5 upgrade area, Erin insured me that upgrade from MySQL 5.0 is still actually question for many users, so I accepted invitation. Event details are on Meetup.com page. So if you are up for free pizza, soda and do not mind to listen to me, welcome to join!


    Entry posted by Vadim | No comment

    Add to:


      [Read more...]
    Percona Server 5.1.52-rel11.6
    +4 Vote Up -1Vote Down

    Percona Server version 5.1.52-rel11.6 is now available for download.

    The main purpose of this release is to update the current Percona stable release to the latest version of MySQL 5.1.

    Functionality Added or Changed

    •  Percona Server 5.1.52-rel11.6 is now based on MySQL 5.1.52.
    •  New Features Added: None
    •  Other Changes: None

    Bugs Fixed

    • Bug #671764 - innochecksum wasn't distributed with RPM and .DEB packages. (Aleksandr Kuzminsky)
    • Bug #673426 - Use of some system variables as command-line options caused a crash or undefined behavior. (Oleg Tsarev)
    • Bug #673929 - Query cache misses were being reported for some queries when
      [Read more...]
    Moving from MyISAM to Innodb or XtraDB. Basics
    +4 Vote Up -0Vote Down

    I do not know if it is because we're hosting a free webinar on migrating MyISAM to Innodb or some other reason but recently I see a lot of questions about migration from MyISAM to Innodb.

    Webinar will cover the process in a lot more details though I would like to go over basics in advance. You can also check my old post on this topic about Moving MyISAM to Innodb as well as searching the blog - We've blogged so much on this topic.

    So what are the basics ?

    Regression Benchmarks - Make sure to run regression benchmarks in particular in terms of

      [Read more...]
    Percona XtraBackup 1.4
    +3 Vote Up -0Vote Down

    Percona XtraBackup 1.4 is now available for download.

    Version 1.4 fixes problems related to incremental backups. If you do incremental backups, it's strongly recommended that you upgrade to this release.

    Functionality Added or Changed

    • Incremental backups have changed and now allow the restoration of full backups containing certain rollback transactions that previously caused problems. Please see Preparing the Backups and the --apply-log-only option. (From innobackupex, the --redo-only option should be used). (Yasufumi Kinoshita)
      [Read more...]
    DBJ – MySQL Hotbackups with Xtrabackup
    +0 Vote Up -0Vote Down

    The open-source xtrabackup tool from Percona brings much needed hot backup functionality to MySQL deployments.  In this database journal article we discuss logical, cold, and hot backups, then explain how to use xtrabackup on your MyISAM, InnoDB, and XtraDB tables to create at-the-ready backups.  We then take you through the step-by-step process to restore them, and even the process of point-in-time recovery too.

    Database Journal – Hotbackups with Percona’s Xtrabackup

    Percona Server 5.1.51-rel11.5
    +1 Vote Up -0Vote Down

    Percona Community,

    Percona Server version 5.1.51-rel11.5 is now available for download.

    The main purpose of this release is to update the current Percona stable release to the latest version of MySQL 5.1.

    Functionality Added or Changed

    •  Percona Server 5.1.51-rel11.5 is now based on MySQL 5.1.51.
    •  New Features Added: None
    •  Other Changes: None

    Bugs Fixed

    •  Bug #661354 - Fixed a problem compiling query_cache_with comments for 5.1.51-rel11.5. (Oleg Tsarev)
    •  Bug #661844 - Fixed a problem with server variables failing test for 5.1.51-rel11.5. (Oleg Tsarev)

    The

      [Read more...]
    Percona Server with XtraDB Case Study, Behind the Scenes
    +5 Vote Up -2Vote Down

    We've published our first case study. The customer, ideeli, had a database that was struggling on standard MySQL and InnoDB. The big win was the upgrade to XtraDB. The business continued to grow quickly, and months later under much more traffic, the database is still outperforming their previous version.

    I thought I'd write a few notes that didn't seem appropriate to include in the case study, because this was a fun project that might be interesting to readers.

    As usual, it was all about diagnosing the problem correctly. I used a variety of tools to help with this, foremost among them "stalk" and "collect" from Aspersa. There were several problems, not just one, and they required

      [Read more...]
    Percona Server 5.1.50-rel12.1
    +6 Vote Up -2Vote Down

    Dear Community,

    Percona Server version 5.1.50-rel12.1 RC is now available for download.

    Functionality Added or Changed

    • Percona Server 5.1.50-rel12.1 is now based on MySQL 5.1.50.
    • New Features Added:
      • innodb_lru_dump_restore - Implemented automatic dumping of the buffer pool at specified intervals.
      • innodb_buffer_pool_shm - Implemented option ''innodb_buffer_pool_shm_checksum''; when enabled, shared memory buffer pool is checksum validated. This change also fixed these bugs: #643724, #649408, and #649393. (Yasufumi Kinoshita)
      [Read more...]
    Percona White Paper: Architecting SaaS Applications with XtraDB
    +2 Vote Up -1Vote Down

    Vadim and I have just published a new technical white paper. It shows how Percona Server with XtraDB can make large-scale multi-tenant databases easier to build with MySQL. Our experiences working with SaaS and shared-hosting companies influenced the features we included in Percona Server and XtraDB, and I think this is the best explanation of what levers are available and how to use them.

    Percona Server with XtraDB for Software-as-a-Service Application Databases is posted on the white-paper section of our website. No registration is required; it is just a PDF, freely downloadable with no marketing follow-up. Many thanks to Mark Callaghan and Dimitri Kravtchuk, who reviewed and gave

      [Read more...]
    Percona Server 5.1.50-rel11.4
    +1 Vote Up -1Vote Down

    Dear Community,

    Percona Server version 5.1.50-rel11.4 is now available for download.

    The changes in this release include:

    New features

    The primary purpose of this release is to update to the latest version of MySQL 5.1.

    • Percona Server 5.1.50-rel11.4 is now based on MySQL 5.1.50.

    Fixed bugs

    The binary packages are available on our website.

    Percona Server can be installed from either our 

      [Read more...]
    Percona Server 5.1.47-rel11.0
    +5 Vote Up -1Vote Down

    Dear Community,

    Percona Server version 5.1.47-rel11.0 is available for download now.

    The changes in this release include:

    New features

    • Percona Server is now based on MySQL 5.1.47, and XtraDB is now based on InnoDB plugin 1.0.8.
    • XtraDB now uses the fast recovery code released in InnoDB Plugin version 1.0.8, instead of Percona's earlier fast-recovery code.
    • Added the --percona_innodb_doublewrite_path option to place the double-write-buffer into its own file (issue #584299). The feature is sponsored by Large Social Network website.
    • Added the --suppress_log_warning_1592 option to disable
      [Read more...]
    Purge Thread Spiral of Death
    +5 Vote Up -0Vote Down

    I just wrote a large post on reasons for innodb main tablespace excessive growth and I thought it would make sense to explain briefly of why it is so frequently you have purge not being the problem at all and when out of no where you can see purge thread being unable to keep up and undo table space explodes and performance drops down. Here is what happens.

    When you have typical OLTP system with small transactions your UNDO space is small and it fits in buffer pool. In fact most of the changes do not need to go to the disk at all - the space for undo space is allocated, used and freed without ever needing to go to the disk.

    Now when you have spike in writes or long running transactions which increases your undo space size it may be evicted from

      [Read more...]
    FlashCache: tpcc workload
    +4 Vote Up -1Vote Down

    This is my last post in series on FlashCache testing when the cache is placed on Intel SSD card.

    This time I am using tpcc-like workload with 1000 Warehouses ( that gives 100GB of data) on Dell PowerEdge R900 with 32GB of RAM, 22GB allocated for buffer pool and I put 70GB on FlashCache partition ( just to simply test the case when data does not fit into cache partition).

    Please note in this configuration the benchmark is very write intensive, and it is not going be easy for FlashCache, as in background it has to write blocks to RAID anyway, and write rate in final place is limited by RAID. So all performance benefits will come from read hits

    The full report and results are available on benchmark Wiki

      [Read more...]
    The Doom of XtraDB and Percona Server?
    +7 Vote Up -5Vote Down

    In The Doom of Multiple Storage Engines, Peter talks about how the storage engine concept of MySQL is usually spoken of in positive terms, but there are many negatives.

    I have a hard time trying to figure out the deeper meaning behind Peter’s post, given that Percona writes a storage engine for MySQL, XtraDB. Does this mean that Percona will stop developing XtraDB? Does this mean that the Percona Server will diverge farther and farther away from MySQL so that they’re not compatible any more and migrating from MySQL to Percona Server is very difficult?

    Or maybe it’s just that Peter is saying one thing and doing the opposite; which just seems wrong because that would be blatant hypocrisy on Percona’s part.

    (This idea was a comment on

      [Read more...]
    XtraDB / InnoDB internals in drawing
    +12 Vote Up -1Vote Down

    I did some drawing exercise and put XtraDB / InnoDB internals in Visio diagram:

    The XtraDB differences and main parameters are marked out.

    PDF version is there http://www.percona.com/docs/wiki/percona-xtradb:internals:start.


    Entry posted by Vadim | 4 comments

    Add to:

      [Read more...]
    What’s different about XtraDB?
    +1 Vote Up -1Vote Down

    The video of my 5-minute Ignite talk on XtraDB is up on YouTube. Ignite talks have exactly 20 slides on auto-advance every 15 seconds. “Enlighten us, and make it fast!” It’s better than a lightning talk. I explained the difference between Percona XtraDB and other technologies such as standard MySQL, OurDelta, and MariaDB.

    Related posts:

  • Xtrabackup is for InnoDB tables too, not just XtraDB Just thoug
  • Recap of CPOSC 2009, plus slides Yesterday
  • Learn about mk-query-digest at PgEast 2010
  •   [Read more...]
    MySQL 5.5.4 in tpcc-like workload
    +4 Vote Up -0Vote Down

    MySQL-5.5.4 ® is the great release with performance improvements, let's see how it performs in
    tpcc-like workload.

    The full details are on Wiki page
    http://www.percona.com/docs/wiki/benchmark:mysql:554-tpcc:start

    I took MySQL-5.5.4 with InnoDB-1.1, tpcc-mysql benchmark with 200W ( about 18GB worth of data),
    InnoDB log files are 3.8GB size, and run with different buffer pools from 20GB to 6GB. The storage is FusionIO 320GB MLC card with XFS-nobarrier. .

    While the raw results are available on Wiki, there are graphical results.

    I intentionally put all line on the same graph to show trends.





      [Read more...]
    Great things afoot in MySQL 5.5
    +2 Vote Up -2Vote Down

    I haven’t been blogging much about the changes in MySQL for a while. But the MySQL and InnoDB engineers have been doing a ton of work over the last couple years, and now it’s seeing the light of day, so it’s time to offer words of congratulations and appreciation about that.

    I was holding my breath for a big-splash 5.5 GA announcement at last week’s conference, but I was wrong. Still, there’s a lot to talk about in 5.5, with a dozen or more substantial blog posts from the InnoDB and MySQL teams alone over the last week or so! Here are a few choice tidbits of the good, the bad, and the ugly.

    InnoDB is the default storage engine

    “No big deal,” I thought. “Serious users do this anyway.” But then Morgan

      [Read more...]
    451 CAOS Links 2010.04.13
    +0 Vote Up -0Vote Down

    600 new customers for SugarCRM. James Gosling leaves Oracle. And more.

    Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
    “Tracking the open source news wires, so you don’t have to.”

    # SugarCRM added nearly 600 customers in the first quarter of 2010.

    # James Gosling resigned from Oracle.

    # VMware’s SpringSource acquired Rabbit Technologies and its RabbitMQ messaging software.

    # EnterpriseDB hired Sun’s former MySQL VP Karen Tegan Padir as vice president of products and marketing.

    # Xen.org


      [Read more...]
    Should I buy a Fast SSD or more memory?
    +2 Vote Up -0Vote Down

    While a scale-out solution has traditionally been popular for MySQL, it's interesting to see what room we now have to scale up - cheap memory, fast storage, better power efficiency.  There certainly are a lot of options now - I've been meeting about a customer/week using Fusion-IO cards.  One interesting choice I've seen people make however, is buying an SSD when they still have a lot of pages read/second - I would have preferred to buy memory instead, and use the storage device for writes.

    Here's the benchmark I came up with to confirm if this is the case:

    • Percona-XtraDB-9.1 release
    • Sysbench OLTP workload with 80 million rows (about 18GB worth of data+indexes)
    • XFS Filesystem mounted with nobarrier option.
    • Tests run with:
      • RAID10 with BBU over 8 disks
      • Intel SSD X25-E 32GB
      • FusionIO 320GB MLC
      [Read more...]
    DBJ – Exotic Storage Engines for MySQL
    +0 Vote Up -0Vote Down

    In our March DBJ article we talked about some of the storage engines to choose from with MySQL.  With it’s plugin storage engine architecture, you have a range of options.  In our April article we continue to discuss a further selection of storage engines, and what features they offer to the DBA and database architect.

    Database Journal – Exotic Storage Engines

    How well do your tables fit in buffer pool
    +2 Vote Up -0Vote Down

    In XtraDB we have the table INNODB_BUFFER_POOL_PAGES_INDEX which shows which pages belong to which indexes in which tables. Using thing information and standard TABLES table we can see how well different tables fit in buffer pool.

    PLAIN TEXT SQL:
  • mysql> SELECT d.*,round(100*cnt*16384/(data_length+index_length),2) fit FROM (SELECT schema_name,table_name,count(*) cnt,sum(dirty),sum(hashed)  FROM INNODB_BUFFER_POOL_PAGES_INDEX GROUP BY schema_name,table_name ORDER BY cnt DESC LIMIT 20) d JOIN TABLES ON (TABLES.table_schema=d.schema_name AND TABLES.table_name=d.table_name);
  • +-------------+---------------------+---------+------------+-------------+--------+
  • | schema_name | table_name          | cnt   
  •   [Read more...]
    Previous 30 Newer Entries Showing entries 31 to 60 of 113 Next 30 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.