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 106 Next 30 Older Entries

Displaying posts with tag: xtradb (reset)

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...]
    InnoDB TABLE/INDEX stats
    +3 Vote Up -0Vote Down

    In Released and new coming features I did not mentioned two additional INFORMATION_SCHEMA tables available in XtraDB:
    It is

    • INNODB_TABLE_STATS
    • INNODB_INDEX_STATS

    These table show statistics about InnoDB tables ( taken from InnoDB data dictionary).

    INNODB_TABLE_STATS is

    • | table_name | table name in InnoDB internal style ('database/table') |
    • | rows | estimated number of all rows |
    • | clust_size | cluster index (table/primary key) size in number of pages|
    • | other_size | other index (non primary key) size in number of pages|
    • | modified | internal counter to judge whether statistics recalculation should be done |

    INNODB_INDEX_STATS is

    • |

      [Read more...]
    Percona-XtraDB-9.1: released and new coming features
    +5 Vote Up -1Vote Down

    Recently Alexandr announced new Percona-XtraDB-9.1 release, and now it is good time to summarize features we have and what is expected soon.

    This release contains long waited features from 5.0:

    • extended slow.log
    • USER/TABLE/INDEX/CLIENT_STATISTICS + THREAD_STATISTICS ( coming in release-10)

    Extended slow.log is now even more extended, there is additional information for each query:

    PLAIN TEXT CODE:
  • # Bytes_sent: 4973  Tmp_tables: 1  Tmp_disk_tables: 1  Tmp_table_sizes: 7808
  • That is you can see how many bytes was returned by query, was temporary table used,
    was it disk table or in-memory, and how big was temporary

      [Read more...]
    Maximal write througput in MySQL
    +3 Vote Up -1Vote Down

    I recently was asked what maximal amount transactions per second we can get using MySQL and XtraDB / InnoDB storage engine if we have high-end server. Good questions, though not easy to answer, as it depends on:

    - durability setting ( innodb_flush_log_at_trx_commit = 0 or 1 ) ?
    - do we use binary logs ( I used ROW based replication for 5.1)
    - do we have sync_binlog options.

    So why would not take these as variable parameters and run simple benchmark.
    I took sysbench update_key scenario ( update indexed field on simple table)
    and used Dell PowerEdge R900 with 16 cores, FusionIO as storage for table and RAID 10 with BBU as storage for innodb log files, innodb system table space and binary logs. And I used Percon-XtraDB-5.1.43-9.1 for benchmarks. All used



      [Read more...]
    XtraDB feature: save / restore buffer pool
    +6 Vote Up -1Vote Down

    We recently released XtraDB-9, and while we did not highlight it in announcement, the release-making feature is ability to save and restore InnoDB buffer pool.
    The idea is not new and was originally developed by Jeremy Cole (sorry, I do not have the link on hands) some time ago, and now we implemented it in XtraDB.

    Why would we need to save and restore content of buffer pool ?
    There are several reasons.
    First, it's not rate on modern servers to have 32GB+ of RAM, with allocated InnoDB buffer_pool 26GB or more. When you do restart of server, it may take long time to populate cache with useful data before you can bring it back to serve production load. It's not rare to see
    maintenance cycle takes two or more



      [Read more...]
    XtraDB storage engine release 1.0.6-9
    +7 Vote Up -1Vote Down

    Dear Community,

    As of today Release 9 of XtraDB storage engine is available.

    The release includes following new features:

    • The release is base on 1.0.6 version of InnoDB plugin.
    • MySQL 5.1.42 as a base release
    • Separate purge thread and LRU dump is implemented (this feature was actually added in Release 8, but somehow it was forgotten)
    • New patch innodb_relax_table_creation
    • Added extended statistics to slow log
    • Adjust defaults with performance intention
    • Added parameter to control checkpoint age
    • Added recovery statistics output when crash recovery (disabled by default)
    • Patch to dump and restore innodb_buffer_pool

    Fixed bugs:

      [Read more...]
    InnoDB, InnoDB-plugin vs XtraDB on fast storage
    +10 Vote Up -1Vote Down

    To continue fun with FusionIO cards, I wanted to check how MySQL / InnoDB performs here. For benchmark I took MySQL 5.1.42 with built-in InnoDB, InnoDB-plugin 1.0.6, and XtraDB 1.0.6-9 ( InnoDB with Percona patches).
    As benchmark engine I used tpcc-mysql with 1000 warehouses ( which gives around 90GB of data + indexes) on my workhourse Dell PowerEdge R900 ( details about box ).

    On storage configuration: FusionIO 160GB SLC and 320GB MLC cards are configured in software RAID0 to store InnoDB datafiles. For InnoDB logs and system tablespace I used partition on regular RAID10 with regular hard drives, here I followed Yoshinori Matsunobu's recommendations


      [Read more...]
    MariaDB 5.1.39 for Debian, Ubuntu, RHEL/CentOS
    +1 Vote Up -0Vote Down

    You can now yum (RPM) or apt-get (DEB) MariaDB 5.1.39, courtesy of OurDelta and in close cooperation with Monty Program Ab. Simply follow the info on the CentOS, Debian or Ubuntu pages.

    (note: give the mirrors some hours to sync up)

    Quick overview

    • See the Release Notes for relevant bugfixes.
    • Drop-in replacement for stock MySQL 5.0 or 5.1 (If you’re coming from stock MySQL, see the MariaDB extras/differences overview).
    • If you are upgrading from 5.0, please review the
      [Read more...]
    Previous 30 Newer Entries Showing entries 31 to 60 of 106 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.