Personal schedule for Zardosht Kasheff
subscribe to Zardosht Kasheff's
In this session, recent query acceleration trends in data warehouse workloads including column stores, disk filtering, hardware acceleration, SSD, MPP and SQL coprocessors will be compared. We’ll describe in detail Kickfire’s dataflow hardware acceleration and provide real-world examples from our enterprise customers.
Learn how Infobright's columnar analytic database delivers very fast query response against large volumes of data without indexes, data partitioning or other DBA effort. Includes case studies on the leading mobile analytics company who saw query response time reduced from many minutes to just seconds and a large energy company who had data compression of 98% and implemented a data mart in weeks.
Location: Ballroom EFGH
Audience level: Novice
Monty, the co-founder of MySQL and now project lead of MariaDB, discusses what MariaDB is all about. He'll also present an overview of the future of this community developed branch of the MySQL database.
Location: Ballroom D
Audience level: Novice
This talk is for developers or administrators who need to make their queries faster.
Disks are often credited with being the biggest performance bottleneck to any database system. This session introduces you to Linux diagnostic tools, hardware purchasing options, and how you should be thinking about IO.
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.
InfiniDB is a scalable, column-oriented database purpose-built for data warehousing and analytical workloads. Session attendees will learn how to leverage InfiniDB to build a future-proof information management infrastructure that can continually scale to meet evolving user, data and performance needs.
There are many examples and posts on how to use partitioning in MySQL, but little information on when to use it and how to apply it to typical business problems. This talk focusses on when to use partitioning, what type to use, and what are the best practices in using the different types of MySQL partitioning.