Buy Percona ServicesBuy Now!
  January, 2011
   Baron Schwartz, Vadim Tkachenko

Configuring Percona Server with XtraDB for Fast Restarts

InnoDB requires a long time to restart on servers with large amounts of memory. It can take many hours to warm InnoDB up enough to serve queries quickly. The database's "working set" of data is not in memory after a restart, so queries must perform random disk I/O to read pages, and are thus too slow for production use. Percona Server with XtraDB greatly lowers database warmup time by quickly restoring the buffer pool to its state before shutdown. This enables higher uptime, and removes the need for elaborate methods of warming up servers. It reduces the cost of a server restart, permitting MySQL to scale to much larger hardware and to be used more flexibly. Percona Server's fast restart capabilities provide significant operational and cost advantages in scenarios such as cloud computing, high availability, dynamic scaling, and restores from backups.

Baron Schwartz
Vice President of Consulting
CEO - VividCortex

Vadim Tkachenko
CTO
Vadim Tkachenko co-founded Percona in 2006 and serves as its Chief Technology Officer. Vadim leads Percona Labs, which focuses on technology research and performance evaluations of Percona’s and third-party products. Percona Labs designs no-gimmick tests of hardware, filesystems, storage engines, and databases that surpass the standard performance and functionality scenario benchmarks. Vadim’s expertise in LAMP performance and multi-threaded programming help optimize MySQL and InnoDB internals to take full advantage of modern hardware. Oracle Corporation and its predecessors have incorporated Vadim’s source code patches into the mainstream MySQL and InnoDB products. He also co-authored the book High Performance MySQL: Optimization, Backups, and Replication 3rd Edition. Previously, he founded a web development company in his native Ukraine and spent two years in the High Performance Group within the official MySQL support team. Vadim received a BS in Economics and an MS in computer science from the National Technical University of Ukraine. He now lives in California with his wife and two children.

Our MySQL white papers are free. They are released under the Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 license.

Visit Percona Store


General Inquiries

For general inquiries, please send us your question and someone will contact you.