Featured

MySQL 5.7
Support

Percona Server for MySQL
Learn More

Compare Percona to Leading Database Solutions

Start

Percona Products

Percona Services

Use Cases

Percona Resources

Software
Downloads

All of Percona’s open source software products, in one place, to download as much or as little as you need.

View Downloads

Valkey Contribution

Learn More

Product Documentation

View Documentation

Resource Hub

A single source for all resources

Webinars

Presentations

Datasheets

Ebooks

Downloads

Solution Briefs

Case Studies

Percona Videos

White Papers

Documentation

View All Resources

Why Percona for MongoDB?

Learn More

Why Percona for PostgreSQL?

Learn More

Percona Blog

Percona Blog

Our popular knowledge center for all Percona products and all related topics.

View The Blog

Community

Percona Community Hub

A place to stay in touch with the open-source community

Forums

Community Blog

PMM Contributions

Explore The Community

Events

Percona Events Hub

See all of Percona’s upcoming events and view materials like webinars and forums from past events

Percona.connect events

Upcoming Events

View Our Events

About

About Percona

Percona is an open source database software, support, and services company that helps make databases and applications run better.

Learn More

Percona in the News

See Percona’s recent news coverage, press releases and industry recognition for our open source software and support.

News coverage
Press Releases

Our Customers

Learn More

Our Partners

Learn More

Careers

Learn More

Contact Us

Let's Talk

Jeremy Cole on MySQL Replication

by | May 27, 2006 | Insight for DBAs

Jeremy Cole recently posted very nice post about MySQL Replication Performance. There are however few points I should comment on. Jeremy Speaks about MyISAM and Innodb in the same terms, in fact they are quite different for Replication. As you probably know MyISAM...

Group commit and XA

by | May 19, 2006 | Insight for DBAs

Returning to post Group commit and real fsync I made several experiments: I ran sysbench update_key benchmarks without —log-bin, with —log-bin, and with —log-bin and —innodb-support-xa=0 (default value is 1). Results (in transactions / sec)...

Mess with innodb_thread_concurrency

by | May 12, 2006 | Insight for DBAs

In MySQL 5.0.19 the meaning of innodb_thread_concurrency variable was changed (yeah, again). Now innodb_thread_concurrency=0 means unlimitied count of concurrent threads inside InnoDB. It’s logical, but there was long way. In MySQL versions below 5.0.8 for...

Innodb Fuzzy checkpointing woes

by | May 10, 2006 | Insight for DBAs

As you might know Innodb storage engines uses Fuzzy Checkpointing technique as part of it recovery strategy.  It is very nice approach which means database never needs to “stall” to perform total modified pages flush but instead flushing of dirty pages...

My Innodb Feature wishes

by | May 4, 2006 | Insight for Developers

At Users Conference Heikki did good presentation about Innodb planned features. I did not see some of big and tiny wishes listed so I was making notes. Here is what I’d like to see Packed indexes. In many cases then difference in Performace with MyISAM and...

Group commit and real fsync

by | May 3, 2006 | Insight for DBAs

During the recent months I’ve seen few cases of customers upgrading to MySQL 5.0 and having serious performance slow downs, up to 10 times in certain cases. What was the most surprising for them is the problem was hardware and even OS specific – it could...