Personal schedule for Vadim Tkachenko
subscribe to Vadim Tkachenko's
Many people know Linux terminologies such as ext3, tmpfs, cfq io scheduler, OOM killer, etc. But many times it is not appropriately configured. In this session, the speaker will show Linux performance tuning and stabilization practices for MySQL, such as how to avoid OOM Killer, performance difference between I/O schedulers, tuning Linux kernel parameters, profiling with SystemTap, etc.
In this session, the speaker will explain some important but not well known indexing topics. Advanced topics such as indexes and lock contentions, how indexes impact MySQL optimizer will be covered. This session is the sequel to "Mastering the Art of Indexing" (http://www.mysqlconf.com/mysql2009/public/schedule/detail/6661), presented at the last MySQL Conference.
Galera is emerging synchronous multi-master replication method, providing tightly coupled InnoDB clustering solution.
Galera has nice features like:
* High Availability - no lost transactions
* Performance - scalability even with 100% write rate
* Transparency - direct MySQL connections
MySQL/Galera 0.7 is production-ready GA release
dim_STAT is a very powerful tool to monitor and analyze everything you need from your server. This presentation will cover MySQL oriented solutions integrated within dim_STAT.
This panel discussion, moderated by Sumeet Bansal, principal solutions architect for Fusion-io, the solid-state storage provider, will make clear to audience members the benefits of solid-state technologies, both from a performance standpoint and in relation to TCO. Q&A with the panel to follow. Participants include panelists from Answers.com, Cloudmark, Percona and Craigslist.org.
This session describes how to tune InnoDB based mainly on 'SHOW ENGINE INNODB STATUS' outputs.
The current version of InnoDB Plugin and XtraDB have various tunable options.
It will be cleared how the tuning options improves the performance for what condition.
The improvement is also demonstrated by the results of some benchmark workloads.
This session is about SSD deployment strategies for MySQL. For example, is it fine to store all files on SSD or is it faster to store some files (i.e. binary log files) on HDD? Is RAID 5 SSD fast enough? Do traditional H/W raid cards perform well for many(4-8) SSDs? Do MyISAM/InnoDB/other engines work well for SSD? I'll talk about these topics based on many kinds of recent benchmarking results.
It is still possible to bring back corrupted or unintentionally deleted InnoDB tables as long as data remain on medium.
During the session various recovery scenarios will be scrutinized.
The typical cases will be illustrated using InnoDB Recovery Tool.