The MySQL Benchmark and Testing Project

Peter Zaitsev

Description

12003-04-10 | The MySQL Benchmark and Testing Project | © MySQL AB 2003 | www.mysql.com

The MySQL Benchmark
and Testing Project
Peter Zaitsev,
MySQL AB
MySQL User Conference 2003
2003-04-10
© MySQL AB 200312003-04-10 | The MySQL Benchmark and Testing Project | © MySQL AB 2003 | www.mysql.com
About Speaker
Peter Zaitsev, Benchmark Project Coordinator
• 4 Years of mission critical MySQL experience.
• CoFounder of Mytrix/SpyLOG web project,
– One of the largest MySQL users in Russia
– Over 1Tb of data, over 100,000,000,000 rows
• Joined MySQL in April 2002
• Wears many hats, involved in
– Support,
– D evelopment,
– Consulting,
– Certification12003-04-10 | The MySQL Benchmark and Testing Project | © MySQL AB 2003 | www.mysql.com
Project Team
• Peter Zaitsev
• Alexey Kishkin (Walrus)
• Alexey Stroganov (Ranger)
• Rest of MySQL team
• External contributors12003-04-10 | The MySQL Benchmark and Testing Project | © MySQL AB 2003 | www.mysql.com
Alexey Kishkin (Walrus)
• sql-bench suite development
• Crash-Me tool development
• Quality Assurance tools development
• D atabase Expert
• D ocumentation development12003-04-10 | The MySQL Benchmark and Testing Project | © MySQL AB 2003 | www.mysql.com
Alexey Stroganov (Ranger)
• Benchmark project web pages development
• Multi User tests development (AS3AP)
• Porting OSD L suite to MySQL
• D BI/D BD Maintenance
• D ata Generation scripts developer12003-04-10 | The MySQL Benchmark and Testing Project | © MySQL AB 2003 | www ...

Sujets

• Linternaute.com
• Arms
• Testudo
• Rows
• Couverture de code
• MyISAM

Informations

• Publié par: Zunik
• Nombre de lectures: 113
• Langue: English

Extrait

2003-04-10 | The MySQL Benchmark and Testing Project | © MySQL AB 2003 | www.mysql.com    The MySQL Benchmark and Testing Project Peter Zaitsev, MySQL AB MySQL User Conference 2003 2003-04-10 © MySQL AB 2003 1

2003-04-10 | The MySQL Benchmark and Testing Project | © MySQL AB 2003 | www.mysql.com About Speaker Peter Zaitsev, Benchmark Project Coordinator • • • •  4 Years of mission critical MySQL experience.  CoFounder of Mytrix/SpyLOG web project, – One of the largest MySQL users in Russia – Over 1Tb of data, over 100,000,000,000 rows  Joined MySQL in April 2002  Wears many hats, involved in – Support, – Development, – Consulting, – Certification 1

• • • • • P vestiaZ rete 2003-04-10 | The MySQL Benchmark and Testing Project | © MySQL AB 2003 | www.mysql.com Project Team lA )surlaW( nikhsiK yexe regnaR( vonagortS yexelA ) maet LQSyM fo tseR  srotubirtnoc lanretxE  1

• • • • • 2003-04-10 | The MySQL Benchmark and Testing Project | © MySQL AB 2003 | www.mysql.com Alexey Kishkin (Walrus) tnempoleved etius hcneb-lqs arCtnempoleved loot eM-hs  sloot ecnarussA ytilauQtnempoleved pxE esabataDtre leved noitatnemucoDtnempo 1

• • • • • 2003-04-10 | The MySQL Benchmark and Testing Project | © MySQL AB 2003 | www.mysql.com Alexey Stroganov (Ranger) leved segap bew tcejorp kramhcneBtnempo )PA3SA( tnempoleved stset resU itluM LQSyM ot etius LDSO gnitroP M DBD/IBDecnanetnia repoleved stpircs noitareneG ataD 1

• • • • • • 2003-04-10 | The MySQL Benchmark and Testing Project | © MySQL AB 2003 | www.mysql.com Informal Members: MySQL Team & External contributors orPsecivreS lanoissef abdeeFkc esaC tseTsaedI  doCsnoitubirtnoc e t rof erawdrah fo snoitubirtnoCstse sevlesmeht yb stset eht gninnuR You are welcome to Join ! 1

• • • • • • 2003-04-10 | The MySQL Benchmark and Testing Project | © MySQL AB 2003 | www.mysql.com 1 Goals of the Project Tools for fair comparison of different databases –  performance, features, stability Tools to help database selection and optimization to match customer load Provide tools for generic system performance comparison. – To help kernel and system software developers Spotting bottlenecks databases might have Eliminating bottlenecks in MySQL server Quality Assurance for MySQL Server, release testing.

• • • • • • 2003-04-10 | The MySQL Benchmark and Testing Project | © MySQL AB 2003 | www.mysql.com We can't totally deny Bias but we try to keep it down  ecruos nepo era  stset ruO sesac tset dradnats yrtsudni esu osla eW noitarugifnoc tluafed ni sesabatad kramhcneb eW b nac stset os ylraelc noitarugifnoc yficeps eWdetaeper e cilbup meht peek dna snoissucsid rof nepo er'eW ramhcneb nwo ruoy nur ot eerf er'uoY.meht hsilbup dna sk 1

• • • • 2003-04-10 | The MySQL Benchmark and Testing Project | © MySQL AB 2003 | www.mysql.com Goals of MySQL product development ofrePecnamr ibatSytilibaileR/ytil E( ytilibasU)ecneinevnoC / esU fo esa eFseruta We target the two top items with our project. 1

• • 2003-04-10 | The MySQL Benchmark and Testing Project | © MySQL AB 2003 | www.mysql.com Project Role in MySQL product development Performance – No performance bugs with new changes – New features are fast enough – Optimizations made really improve things ytilibatSStability – No bugs are added during code improvement – New code is properly tested – Release successfully handles stress load 1

• • • • • • 2003-04-10 | The MySQL Benchmark and Testing Project | © MySQL AB 2003 | www.mysql.com Performance Regression performance testing by sql-bench suite. Adding test cases for new features Stress testing Finding bottlenecks Search for possible optimizations Research the best options for different load types 1