The Curious Engineer

Percona

2006–2009

739 posts

2010–2013 →

2009 240

December 2009

  1. Percona is hiring a consultant
  2. Recovery Time for TokuDB
  3. What do we optimize with mk-query-digest ?
  4. Announcing TokuDB v3.0 Beta: ACID Transactions
  5. Battle around MySQL heats up
  6. There will be no separate Percona Performance Conference in April 2010
  7. Redis Benchmarks on FusionIO (Round 1)
  8. xtrabackup-1.0
  9. Why delayed flushing can result in less work
  10. FusionIO – time for benchmarks
  11. How many partitions can you have ?
  12. Effect of adaptive_flushing
  13. Sphinx 0.9.9 is finally here.
  14. Great work Innodb Team

November 2009

  1. More on table_cache
  2. MySQL Performance Blog was down today
  3. Paul McCullagh answers your questions about PBXT
  4. Rare evil MySQL Bug
  5. How innodb_open_files affects performance
  6. 5.0.87-build20 Percona binaries
  7. New TokuDB 2.2.0 feature: more query progress information
  8. table_cache negative scalability
  9. Chicago & Atlanta -last two training locations of the year
  10. Interviews for InfiniDB and TokuDB are next
  11. "Shard early, shard often"
  12. KAYAK chooses Tokutek for Fast and Flexible Indexing
  13. NDB API examples, the trivia to make ndbapi_scan works!
  14. Finding your MySQL High-Availability solution â€" Replication
  15. Would you like to ask a question about PBXT?
  16. Tokyo Tyrant -The Extras Part III : Write Bottleneck
  17. Tokyo Tyrant – The Extras Part II : The Performance Wall
  18. Web Site Update
  19. Tokyo Tyrant – The Extras Part I : Is it Durable?
  20. Air traffic queries in MyISAM and Tokutek (TokuDB)
  21. New developers training course is almost ready
  22. InnoDB: look after fragmentation
  23. Air traffic queries in InfiniDB: early alpha
  24. Speaking at the LA MySQL Meetup – 18th November

October 2009

  1. Announcing TokuDB 2.2.0
  2. New MariaDB release is out
  3. Giving a talk in Palo Alto, November 3rd
  4. State of the art: Galera – synchronous replication for InnoDB
  5. Air traffic queries in LucidDB
  6. XtraDB Amazon Image
  7. xtrabackup-0.9.5rc
  8. Percona Performance Conference 2010
  9. Captcha is replaced
  10. MySQL-Memcached or NOSQL Tokyo Tyrant – part 3
  11. Using Gearman for Nightly Build and Test
  12. Finding your MySQL High-Availability solution â€" The questions
  13. Training Updates
  14. How (not) to find unused indexes
  15. MySQL-Memcached or NOSQL Tokyo Tyrant – part 2
  16. MySQL-Memcached or NOSQL Tokyo Tyrant – part 1
  17. Tuning for heavy writing workloads
  18. Percona welcomes Devananda van der Veen
  19. Watch out for your CRON jobs
  20. XtraDB storage engine release 1.0.4-8
  21. 5.0.86-build19 Percona binaries
  22. Videos from the 2009 Percona Performance Conference now available on PerconaTV
  23. Finding your MySQL High-Availability solution – The definitions
  24. White Paper: Scaling High Performance MySQL Databases
  25. Percona welcomes Yves Trudeau and Fernando Ipar
  26. Analyzing air traffic performance with InfoBright and MonetDB
  27. EdUIConf 2009 recap
  28. TokuDB for MySQL Datasheet
  29. TokuDB for MySQL Performance Brief
  30. TokuDB for MySQL Pricing
  31. TokuDB for MySQL Evaluation Guide

September 2009

  1. Admin notice: comments again broken
  2. Quick comparison of MyISAM, Infobright, and MonetDB
  3. How the number of columns affects performance
  4. Why InnoDB index cardinality varies strangely
  5. InnoDB/XtraDB Training in New York City!
  6. Speaking at Highload.ru
  7. Guidance for MySQL Optimizer Developers
  8. Multi Column indexes vs Index Merge
  9. Attempting to Quantify Fragmentation Effects
  10. How to generate per-database traffic statistics using mk-query-digest
  11. Which adaptive should we use?
  12. SystemTap – DTrace for Linux ?
  13. Queries Active vs Transactions Active
  14. Statistics of InnoDB tables and indexes available in xtrabackup
  15. Cache Miss Rate as a function of Cache Size
  16. 3 ways MySQL uses indexes
  17. Sponsoring OpenSQL Camp 2009
  18. What to do with MySQL Full Text Search while migrating to Innodb ?
  19. Off to California!

August 2009

  1. Give me 8 hours, and I’ll help you build a better application
  2. Innodb performance gotcha w Larger queries.
  3. Looking at Redis
  4. A few administrative updates
  5. xtrabackup-0.9
  6. Sorting a Terabyte in 197 seconds
  7. XtraDB storage engine release 1.0.3-7
  8. A micro-benchmark of stored routines in MySQL
  9. XtraDB: The Top 10 enhancements
  10. Innodb plugin 1.0.4 released – great job Innobase
  11. 5.0.84-build18 Percona binaries
  12. Sphinx at MySQL Meetup at San Francisco
  13. NILFS – may be not yet
  14. Dissection of EC2 / EBS volume
  15. EC2/EBS single and RAID volumes IO benchmark
  16. Announcing TokuDB 2.1.0
  17. Why you don’t want to shard.
  18. Announcing Percona Training Workshops for InnoDB and XtraDB
  19. XtraDB has been commited to MariaDB
  20. Better Primary Keys, a Benefit to TokuDB’s Auto Increment Semantics

July 2009

  1. Copying InnoDB tables between servers
  2. Autoincrement Semantics
  3. 5.0.83-build17 Percona binaries
  4. Maatkit Now Supports Memcached
  5. Just how useful are binary logs for incremental backups?
  6. XtraDB storage engine release 1.0.3-6
  7. Recovery after DROP [ TABLE | DATABASE ]
  8. Crashes while using MyISAM with multiple key caches
  9. Percona BOFs at OSCON
  10. Percona talks at OSCON
  11. Performance improvements in Percona 5.0.83 and XtraDB
  12. Percona Welcomes Morgan Tocker and Matt Yonkovit
  13. Three key things to know about moving MySQL into the cloud.
  14. Improving InnoDB recovery time
  15. Is DRBD the right choice for me?
  16. OpenSQL Camp 2009
  17. Fractal Trees May Be Useful for Making Energy-Efficient Databases
  18. Just do the math!
  19. MySQL Scalability for Facebook Application Developers
  20. Onsite and Remote – getting best of both worlds
  21. Scaling w Flash Webinar Recording Available
  22. Gathering queries from a server with Maatkit and tcpdump
  23. xtrabackup-0.8

June 2009

  1. Few more ideas for InnoDB features
  2. check-unused-keys: A tool to interact with INDEX_STATISTICS
  3. Another look at improving TPC-H-like queries – Q17
  4. A Second Rule of Thumb for Choosing Column Order in Indexes
  5. Hosting the BOF at Velocity Conference
  6. Scaling IO Bound Workloads Webinar
  7. Announcing Percona.tv
  8. Slow DROP TABLE
  9. Testing FusionIO: strict_sync is too strict…
  10. Improving TPC-H-like queries – Q17
  11. How to pretty-print my.cnf with a one-liner
  12. The feature I love in TokuDB
  13. MySQL 5.1 Grammar Changes to Support Clustering Indexes
  14. 5.0.77 / 5.0.82 -build16 Percona binaries
  15. mysql-proxy, urgh performance and scalability ?
  16. Impossible – possible, moving InnoDB tables between servers
  17. Choosing Column Order in Indexes
  18. How clustering indexes sometimes help UPDATE and DELETE performance
  19. Long Index Keys
  20. Using netcat to copy MySQL Database

May 2009

  1. Clustering indexes vs. Covering indexes
  2. Introducing Multiple Clustering Indexes
  3. Publications Related to Fractal Tree Indexing
  4. Open Development vs Making a Big Splash
  5. Terminate MySQL Connections
  6. xtrabackup-0.7 (RC)
  7. Hint: throttling xtrabackup
  8. MySQL Pays attention to Bugs (Finally!)
  9. What time 18446744073709550.000 means
  10. Friday challenge: ibd recovery
  11. Covering Indexes: Orders-of-Magnitude Improvements
  12. Why MySQL’s binlog-do-db option is dangerous
  13. Global Transaction ID and other patches available!
  14. Open Database Alliance – allies welcome
  15. MySQL Meetups Sponsorship Available
  16. read_ahead (disabled) as steroid
  17. Friday challange: linking with GPL code
  18. Btw xtrabackup is not only backup..
  19. Getting annoyed with MyISAM multiple key caches.
  20. RAID vs SSD vs FusionIO
  21. 5.4 in-memory tpcc-like load
  22. Looking on 5.4 – IO bound benchmarks

April 2009

  1. Call for opinions: Do we need MySQL 5.0 with MySQL 5.4 performance
  2. xtrabackup-0.6
  3. The Depth of a B-tree
  4. Detailed review of Tokutek storage engine
  5. XtraDB storage engine release 1.0.3-5
  6. The Percona Performance Presentations Are Online
  7. High Anxiety Whenever You’re Near
  8. Finding the Percona Performance Conference
  9. Meet the faces of Percona this week in Santa Clara
  10. Talking MySQL to Sphinx
  11. TokuDB Storage Engine for MySQL
  12. How to decrease InnoDB shutdown times
  13. Improving TPC-H-like Queries – Q2
  14. XtraDB storage engine release 1.0.3-4 codename Sakura
  15. xtrabackup-0.5, bugfixes, incremental backup introduction
  16. MySQL and IBM

March 2009

  1. My "hot" list for next InnoDB features
  2. xtrabackup-0.4, going beta, progress meter
  3. Adjusting Innodb for Memory resident workload
  4. 2009 Percona Performance Conference Schedule
  5. Sphinx Technologies launches Sphinx Support
  6. PROCEDURE ANALYSE
  7. Another ingenious piece of Sun Marketing
  8. MySQL random freezes could be the query cache
  9. MySQL insert performance with iiBench Python client
  10. Converting Character Sets
  11. Compression for InnoDB backup
  12. xtrabackup-0.3, binaries and stream backup
  13. Percona at PHP Quebec 09
  14. When would you use SAN with MySQL ?
  15. Percona Performance Conference CFP deadline extended
  16. Debian / Ubuntu Percona builds
  17. What does Using filesort mean in MySQL?
  18. Xtrabackup, doing once…
  19. Making replication a bit more reliable
  20. SSD, XFS, LVM, fsync, write cache, barrier and lost transactions
  21. XtraDB storage engine release 1.0.2-3 (Spring edition) codename Sapporo
  22. Understanding Performance Optimization Terminology
  23. KISS KISS KISS

February 2009

  1. Percona XtraBackup: Open Source Alternative for InnoDB Hot Backup call for ideas
  2. Percona is hiring performance experts
  3. How much memory can MySQL use in the worst case?
  4. Limiting InnoDB Data Dictionary
  5. Impact of logging on MySQL’s performance
  6. Beware of MySQL Data Truncation
  7. Disaster: LVM Performance in Snapshot Mode
  8. Announcing Percona Performance Conference 2009 on April 22 & 23
  9. Pretending to fix broken group commit
  10. Faster MySQL failover with SELECT mirroring

January 2009

  1. Funniest bug ever
  2. Linux schedulers in tpcc like benchmark
  3. iiBench with deletes
  4. The perils of InnoDB with Debian and startup scripts
  5. Another scalability fix in XtraDB
  6. iiBench Fractal Tree Results
  7. 5.0.75-build12 Percona binaries
  8. Optimizing repeated subexpressions in MySQL
  9. Beware: ext3 and sync-binlog do not play well together
  10. iiBench Contest Results
  11. Profiling MySQL stored routines
  12. Fix of InnoDB/XtraDB scalability of rollback segment
  13. Dropping unused indexes
  14. Some little known facts about Innodb Insert Buffer
  15. Percona welcomes Ryan Lowe and Vladimir Fedorkov
  16. Should you move from MyISAM to Innodb ?
  17. How Percona Develops Open-Source Software
  18. iiBench Contest Updates

2008 221

December 2008

  1. XtraDB storage engine release 1.0.2-2 (New Year edition)
  2. XtraDB/InnoDB CPU bound benchmarks on 24cores server
  3. 5.0.75-build11 percona binaries
  4. High-Performance Click Analysis with MySQL
  5. Goal driven performance optimization
  6. XtraDB in CPU-bound benchmark
  7. XtraDB benchmarks – 1.5X gain in IO-bound load
  8. Recovering CREATE TABLE statement from .frm file
  9. How much space does empty Innodb table take ?
  10. Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
  11. SHOW OPEN TABLES – what is in your table cache
  12. Looking for MySQL 4.0 Support post EOL ?
  13. MySQL QA Team Benchmarks for MySQL 5.1.30
  14. MySQL Binaries Percona build10
  15. 7 Reasons why MySQL Quality will never be the same
  16. MySQL 5.1 went to GA. Was it a good move ?
  17. Reading MySQL Enterprise future…
  18. Percona team at Turkey
  19. When to use Hardware upgrade instead of Software Optimization
  20. iiBench configuration
  21. iiBench Contest
  22. Tom Basil (formerly MySQL’s Director of Support) Joins Percona
  23. MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
  24. iiBench Contest – Who Can Insert 1B Rows into MYSQL the Fastest?
  25. Presentations from OpenSQLCamp Published

November 2008

  1. Computing 95 percentile in MySQL
  2. MySQL for Hosting Providers – how do they manage ?
  3. Memcached Status
  4. Thanks Giving Challenge: How to detect replication context
  5. Using Multiple Key Caches for MyISAM Scalability
  6. How Percona does a MySQL Performance Audit
  7. Using INFORMATION_SCHEMA instead of shell scripting
  8. How to Calculate a Good InnoDB log file size
  9. The patches are going to Launchpad
  10. Percona build7 with latest patches
  11. Adaptive checkpointing
  12. New SpecJAppServer results at MySQL and Sun.
  13. Scaling to 256-way the Sun way
  14. More patches
  15. Thoughs on Innodb Incremental Backups
  16. Drilling down to the source of the problem
  17. New Presentations published (Meetup and Highload)
  18. Poor man’s query logging
  19. Living with backups
  20. Election night
  21. MySQL, AIX5L and malloc()
  22. OpenSQLCamp is comming close
  23. Yasufumi Kinoshita joins Percona

October 2008

  1. A quest for the full InnoDB status
  2. How expensive is a WHERE clause in MySQL?
  3. Speaking on MySQL SF Meetup (Nov 3)
  4. Mirrored Binlogs patch
  5. JOIN Performance & Charsets
  6. Improved InnoDB rw_lock patch
  7. Percona’s patches spread to a wider audience
  8. Announce: Front End Performance Optimization
  9. Three ways to know when a MySQL slave is about to start lagging
  10. Percona welcomes Ewen Fortune and Piotr Biel

September 2008

  1. Why audit logging with triggers in MySQL is bad for replication
  2. What is stored InnoDB buffer pool
  3. Four ways to optimize paginated displays
  4. Fight MySQL Replication Lag
  5. Finding what Created_tmp_disk_tables with log_slow_filter
  6. Speaking on HighLoad++, Moscow, Russia
  7. A common problem when optimizing COUNT()
  8. When is it a time to upgrade memory ?
  9. Unused indexes by single query
  10. Google’s user_statistics V2 port and changes
  11. What Bugs makes you to recomend upgrade most frequently ?
  12. AUTO_INCREMENT and MERGE TABLES
  13. Can you Trust CHECK TABLE ?
  14. The performance effects of new patches
  15. Development plans
  16. New patches, new builds
  17. How quickly you should expect to see bugs fixed
  18. ANALYZE: MyISAM vs Innodb
  19. Beware of running ANALYZE in Production
  20. How network can impact MySQL Operations ?

August 2008

  1. How to track down the source of Aborted_connects
  2. MySQL End Of Life (EOL) Policy
  3. Multiple column index vs multiple indexes
  4. How to find wrong indexing with glance view
  5. Rendundant Array of Inexpensive Servers
  6. Worse than DDOS
  7. The ultimate tool for generating optimal my.cnf files for MySQL
  8. Beware of MyISAM Key Cache mutex contention
  9. Wonderfull World of MySQL Storage Engines slides are now published
  10. Picking datatype for STATUS fields
  11. New MySQL Community release – Great job MySQL !
  12. Predicting Performance improvements from memory increase
  13. Will Percona Support Drizzle ?
  14. 128GB or RAM finally got cheap
  15. To find the bottleneck, stop guessing and start measuring
  16. Userstats patches with information schema support
  17. Troubleshooting Relay Log Corruption in MySQL
  18. Recovery beyond data restore
  19. How adding another table to JOIN can improve performance ?
  20. Percona turns two today !
  21. Percona RPMS for RedHat 5 / CentOS 5 x86_64

July 2008

  1. Quick tip: how to convert tables to InnoDB
  2. Report from OSCON 2008
  3. The #1 mistake hosting providers make for MySQL servers
  4. Daniel Nichter and Percona join forces on Maatkit
  5. Percona builds with patches
  6. Sphinx 0.9.8 is released just in time for OSCON 2008
  7. Missing Data – rows used to generate result set
  8. MySQL 5.1 is to reach GA state – all to arms !
  9. Percona builds with Percona patchsets
  10. How to Outrun the Lions
  11. LVM Configuration mistake to Avoid
  12. Logging your MySQL command line client sessions
  13. Velocity Presentation Slides Published
  14. How SHOW SLAVE STATUS relates to CHANGE MASTER TO
  15. Speaking on OSCON 2008
  16. Recovering Innodb table Corruption
  17. How to load large files safely into InnoDB with LOAD DATA INFILE
  18. Should we proclaim MySQL Community Edition Dead ?

June 2008

  1. MySQL 5.1 Stability
  2. Resyncing table on MySQL Slave
  3. Web Site Optimization: FrontEnd and BackEnd
  4. Percona is looking for a Perl and Python expert
  5. Neat Tricks for the MySQL Command-line Pager
  6. Will Falcon fly?
  7. Lighttpd as reverse proxy
  8. Speaking on Velocity and Book Signing
  9. Estimating Undo Space needed for LVM Snapshot
  10. How would you compress your MySQL Backup
  11. Confusing MySQL Replication Error Message
  12. How much overhead DRDB could cause ?
  13. Tools to use for MySQL Performance Review
  14. Is DNS the Achilles heel in your MySQL installation?

May 2008

  1. Should you name indexes while doing ALTER TABLE ?
  2. Can MySQL temporary tables be made safe for statement-based replication?
  3. INFORMATION_SCHEMA tables in the InnoDB pluggable storage engine
  4. Using flow control functions for performance monitoring queries
  5. Apache PHP MySQL and Runaway Scripts
  6. Dangerous command
  7. Wanted: Better memory profiling for MySQL
  8. Concurrent inserts on MyISAM and the binary log
  9. MySQL Is back to Open Source Camp ?
  10. MySQL Performance Engineer opening
  11. Quickly preloading Innodb tables in the buffer pool
  12. Learning about MySQL Table Fragmentation
  13. T2000 CPU Performance – Watch out
  14. Can having information public hurt consulting business ?
  15. Percona Team presentations from MySQL Users Conference 2008 published

April 2008

  1. The MySQL optimizer, the OS cache, and sequential versus random I/O
  2. MySQL Replication vs DRBD Battles
  3. How multiple disks can benefit for single client workload ?
  4. Is disk Everything for MySQL Performance ?
  5. MySQL Architecture meeting at Google
  6. MySQL extensions for hosting
  7. Efficient Boolean value storage for Innodb Tables
  8. Conference for MySQL Users
  9. Real-Life Use Case for "Barracuda" InnoDB File Format
  10. Testing InnoDB "Barracuda" format with compression
  11. How to estimate query completion time in MySQL
  12. MySQL and plugin binaries
  13. Updated msl (microslow) patch, installation walk-through!
  14. Idea: Couple of more string types
  15. All thouse new MySQL Storage Engines
  16. A note about Pythian
  17. Future InnoDB File Formats
  18. Interested to learn about New Innodb Plugin Performance ?
  19. Partially OpenSourced
  20. MySQL Optimizer team comments on TPC-H Results
  21. MySQL Community Dinner
  22. Meet MySQL Performance Blog guys on MySQL Users Conference
  23. TPC-H Run on MySQL 5.1 and 6.0
  24. State of MySQL Market and will Replication live ?
  25. How fast can MySQL Process Data
  26. MySQL should have dynamic durability settings
  27. Should you have your swap file enabled while running MySQL ?
  28. Kickfire Kickfire Kickfire
  29. Multi-Column IN clause – Unexpected MySQL Issue
  30. Hacking for Faster Insertions: Is this really how you want to spend your time?
  31. Andrew Aksyonoff does Sphinx Talk in Moscow
  32. Stored Function to generate Sequences
  33. MySQL Performance on Memory Appliance

March 2008

  1. Using MMM to ALTER huge tables
  2. Welcome to the team, Baron
  3. MySQL and Sun – Oportunity for smaller companies ?
  4. MySQL Public Worklog and Community Focus
  5. MySQL 6.0 vs 5.1 in TPC-H queries
  6. MySQL File System Fragmentation Benchmarks
  7. How many people will leave MySQL now ?
  8. Big Iron for tests anyone ?
  9. MySQL Query Cache WhiteSpace and comments
  10. The tool I’ve been waiting for years
  11. Working with many files and file system fragmentation
  12. Researching your MySQL table sizes
  13. MySQL Error Message Nonsenses
  14. Sharding and Time Base Partitioning
  15. Economics of Performance Optimization
  16. Tradeoff: Insertions versus Point Queries
  17. Speeding up GROUP BY if you want aproximate results
  18. Sphinx 0.9.8 reaches RC stage, Docs updated
  19. Evaluating IO subsystem performance for MySQL Needs
  20. RAID System performance surprises
  21. Tradeoffs: Updates versus Range Queries

February 2008

  1. A piece of Sun/MySQL Marketing
  2. MySQL Performance Blog now uses Sphinx for Site Search
  3. Back to USA
  4. How to check MySQL Config files
  5. How Fast Can Updates Run?
  6. MySQL Full Text Search in Action
  7. MySQL 6.0 Subquery optimizations are published.
  8. Updates & Discipline
  9. Finding the largest tables on MySQL Server
  10. Speaking on MySQL Users Conference 2008
  11. Performance gotcha of MySQL memory tables

January 2008

  1. How MySQL Query Cache works with Transactions
  2. Monty unviels Maria and starts Blogging
  3. No more MySQL Crash Safe Replication in 5.0 ?
  4. Enum Fields VS Varchar VS Int + Joined table: What is Faster?
  5. Range Queries: Is the Bottleneck Seeks or Bandwidth?
  6. What should we say about Sun buying MySQL ?
  7. The Trouble with Point Queries
  8. MySQL Blob Compression performance benefits
  9. PHP vs. BIGINT vs. float conversion caveat
  10. CentOS Comes with free build of MySQL Enterprise ?

2007 173

December 2007

  1. What is the longest part of Innodb Recovery Process ?
  2. Large result sets vs. compression protocol
  3. MVCC: Transaction IDs, Log Sequence numbers and Snapshots
  4. Fixing Column Encoding Mess in MySQL
  5. Slides from Egypt talks
  6. Back from company meeting in Hurghada, Egypt
  7. Be careful rotating MySQL logs

November 2007

  1. Packing for company meeting in Egypt
  2. Data Recovery Toolkit for InnoDB Version 0.1 Released
  3. Slides from Zurich talk are now posted
  4. Pitfall of proxying HTTP requests through Lighttpd
  5. Giving a talk in Zurich
  6. MySQL: Data Storage or Data Processing
  7. Ways to Crash or Overload MySQL
  8. Innodb Undelete and Sphinx Support
  9. How we work on High Performance MySQL Second Edition
  10. Filtered MySQL Replication
  11. Heikki Tuuri answers to Innodb questions, Part II
  12. Nginx Powers Hulu.com ?
  13. The new cool MySQL patch has landed! Check your queries performance!

October 2007

  1. Yet another presentation submission
  2. Hacking to make ALTER TABLE online for certain changes
  3. Heikki Tuuri Innodb answers – Part I
  4. MySQL Support or Support for MySQL ? MySQL Trademark Policies
  5. MySQL Performance Blog gets new server.
  6. MySQL Users Conference Presentation Proposals
  7. Progress with ClickAider project
  8. Making bugs public – good job MySQL
  9. What would you like to hear about on MySQL Users Conference 2008 ?
  10. Traffic Tricks by Hosting Providers.
  11. MySQL Performance – eliminating ORDER BY function
  12. MySQL Northern European Customer Conference
  13. Be Careful when Joining on CONCAT
  14. Managing Slave Lag with MySQL Replication
  15. MyISAM Scalability and Innodb, Falcon Benchmarks
  16. Add an option to Fail on Innodb Initialize failure, Please ?
  17. HighLoad 2007 Review
  18. UNION vs UNION ALL Performance
  19. What did we want Interns to do
  20. MySQL Quality of old and new features

September 2007

  1. Heikki Tuuri to answer your in depth Innodb questions
  2. Using VIEW to reduce number of tables used
  3. Innodb usability and ease of use.
  4. InnoDB auto-inc scalability fixed
  5. MySQL Master Class after HighLoad.RU
  6. Possible optimization for sort_merge and UNION ORDER BY LIMIT
  7. Using GROUP BY WITH ROLLUP for Reporting Performance Optimization
  8. MySQL: What read_buffer_size Value is Optimal?
  9. Going to MySQL Developers conference in Heidelberg
  10. Enabling/Disabling query log without server restart in MySQL 5.0
  11. InnoDB in self-compiled MySQL 5.1
  12. Query Profiling with MySQL: Bypassing caches
  13. Read Buffers, mmap, malloc and MySQL Performance
  14. VOIP Advice requested
  15. Withdrawal of Memory allocation in Stored Function
  16. What would make MySQL Multiple Queries Usable ?
  17. Speaking on HighLoad Conference, Moscow, Russia
  18. Looking for High Performance MySQL Interns
  19. Site was down today, support and web hosting.

August 2007

  1. Working on "High Performance MySQL, Second Edition", how you can help?
  2. Guess what?! Microsecond slow query timing finally available in MySQL!
  3. To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
  4. Do you always need index on WHERE column ?
  5. Redundant index is not always bad
  6. Memory allocation in Stored Function
  7. How fast can you sort data with MySQL ?
  8. Should MySQL Extend GROUP BY Syntax ?
  9. How much overhead is caused by on disk temporary tables
  10. Yahoo Search Suggestions for MySQL
  11. MySQL Community Needs
  12. MySQL VIEW as Performance Troublemaker
  13. FaceBook Search, Search for social networks
  14. SpyLOG Was sold the other day, time to look back
  15. MySQL Community contrubutions
  16. New MySQL Community Release Policies published
  17. Query_cache and column level privileges
  18. Landscape of Transactional Storage Engines for MySQL

July 2007

  1. More Gotchas with MySQL 5.0
  2. MySQL 5.0 Community Edition Regression
  3. MySQL on OSCON
  4. MySQL and PostgreSQL SpecJAppServer benchmark results
  5. What exactly is read_rnd_buffer_size
  6. Sphinx: Going Beyond full text search
  7. Microslow patch for 5.1.20
  8. How Innodb flushes data to the disk ?
  9. Innodb Recovery – Is large buffer pool always better ?
  10. Silicon Valley Onsite consulting anyone ?
  11. ClickAider – Track Adsense Clicks and much more
  12. MySQL net_write_timeout vs wait_timeout and protocol notes
  13. PHP Large result sets and summary tables.
  14. Working with large data sets in MySQL
  15. Top 5 MySQL wishes – what is next ?
  16. Speaking on OSCON 2007
  17. Implementing efficient counters with MySQL

June 2007

  1. Top 5 Wishes for MySQL
  2. Can Innodb Read-Ahead reduce read performance ?
  3. Does Slow query log logs all slow queries ?
  4. Using CHAR keys for joins, how much is the overhead ?
  5. MySQL 5.1 Command line client improvements
  6. Innodb Second Start prevention bug ?
  7. Commodity Hardware, Commodity Software and Commodity People
  8. RAID and Scale Out Discussions
  9. MySQL Stored Procedures: Explanation and Best Practices
  10. MySQL 4 to MySQL 5 Upgrade performance regressions
  11. Microslow patch for 5.0.37

May 2007

  1. MySQL Slow query log in the table
  2. MySQL – to use or not to use
  3. Predicting How Long Data Load Would Take
  4. Innodb Recovery Update – The tricks what failed.
  5. MySQL Geek Job Openings
  6. Wishes for mysqldump
  7. Innodb crash recovery update
  8. Magic Innodb Recovery self healing
  9. MySQL Installation and upgrade scripts.
  10. Planet MySQL AdSense Advertisement
  11. MySQL Storage Engines – PBXT
  12. Merge Tables Gotcha
  13. How to estimate time it takes Innodb to Recover ?
  14. MySQL Users Conference – Innodb
  15. Linux failing to boot screen on the plane
  16. Countless storage engines
  17. UC2007 Presentation and Notes

April 2007

  1. Back from RIT2007
  2. How simple answer are you looking for ?
  3. COUNT(*) vs COUNT(col)
  4. PBXT benchmarks
  5. Master-Master or Master with Many Slaves
  6. Using delayed JOIN to optimize count(*) and LIMIT queries
  7. MySQL Master-Master replication manager released

March 2007

  1. Speaking on RIT-2007, Moscow, Russia
  2. MySQL Replication and Slow Queries
  3. Integers in PHP, running with scissors, and portability
  4. PHP Sessions – Files vs Database Based
  5. Only Design What You Can Implement
  6. MySQL Large Query Cache Size Problems
  7. Onsite consulting in Sillicon Valley anyone ?
  8. MySQL Releases first real Community Release
  9. MySQL MyISAM Active Active Clustering – looking for trouble ?
  10. MySQL Query Cache and prepared statements – support comming ?
  11. Box for some tests anyone ?
  12. Mail clients and Databases
  13. Figuring out what limits MySQL Replication
  14. Is it query which needs to be optimized ?
  15. Power of MySQL Storage Engines

February 2007

  1. System size and Performance Optimization
  2. Pitfalls of converting to InnoDB
  3. MySQL Consulting – Being on your own
  4. MySQL Error control changes
  5. Using index for ORDER BY vs restricting number of rows.
  6. Beware: key_buffer_size larger than 4G does not work
  7. Getting use of Slave in MySQL Replication
  8. Content delivery system design mistakes
  9. Debugging Sleeping Connections with MySQL
  10. Why do you need many apache children ?

January 2007

  1. Getting MySQL to use full key length
  2. Linux IO Schedulers and MySQL
  3. Making MySQL Replication Parallel
  4. TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
  5. MySQL Binaries availability
  6. INSERT ON DUPLICATE KEY UPDATE and REPLACE INTO
  7. Performance impact of complex queries
  8. Speaking at MySQL Users Conference 2007
  9. Some of our articles are translated to Russian
  10. Binaries of MySQL 5.0.33 Community release for AMD64 / EM64T
  11. Falcon Storage Engine Design Review
  12. Looking for someone with Chinese knowledge
  13. Getting real life query speeds with MySQL
  14. MySQL automatic data truncation can backfire
  15. MySQL sources from development tree
  16. Sphinx Developer joins our team
  17. InnoDB vs MyISAM vs Falcon benchmarks – part 1
  18. InnoDB benchmarks
  19. MySQL/Innodb scalability tests after fix

2006 105

December 2006

  1. Where to get recent MySQL version ?
  2. MySQL Session variables and Hints
  3. Are you designing IO bound or CPU bound application ?
  4. Innodb locking and Foreign Keys
  5. Using LoadAvg for Performance Optimization
  6. COUNT(*) for Innodb Tables

November 2006

  1. Interesting MySQL and PostgreSQL Benchmarks
  2. BoardReader – Forum Search Engine
  3. Trailing spaces in MySQL
  4. Covering index and prefix indexes
  5. Opening Tables scalability
  6. Feature Idea: Finding columns which query needs to access
  7. Rebuilding MySQL Binary
  8. Bug fix of InnoDB scalability problem
  9. Trying Archive Storage Engine
  10. Are PHP persistent connections evil ?
  11. When EXPLAIN can be misleading
  12. Undo area size restriction needed for Innodb
  13. Back from OpenSource Database Conference

October 2006

  1. Using Sphinx as MySQL data retrieval accelerator
  2. Wishes for new "Pure PHP" MySQL driver
  3. Speaking on OpenSource Database Conference, Frankfurt
  4. Should MySQL and Web Server share the same box ?
  5. Small things are better
  6. MySQL Optimizer and Innodb Primary Key
  7. Long PRIMARY KEY for Innodb tables
  8. Backport of micro-time patch to mysql 4.1

September 2006

  1. APC or Memcached
  2. Life Beyond MySQL
  3. Test Drive of Solid
  4. EuroOSCON 2006 – High Performance FullText Search
  5. Database Performance Optimization in Web Applications
  6. Alternatives of PHP ?
  7. Why Index could refuse to work ?
  8. Internals of InnoDB mutexes
  9. Wrong GROUP BY makes your queries fragile
  10. Joining Peter for MySQL Consulting
  11. Even minor upgrades are not always safe
  12. GROUP_CONCAT useful GROUP BY extension

August 2006

  1. Derived Tables and Views Performance
  2. MySQL wins C’T Database Contest
  3. Watch out for Marketing benchmarks
  4. Using LVM for MySQL Backup and Replication Setup
  5. MySQL Performance Forum: Hot Topics
  6. SysBench – benchmark tool
  7. Duplicate indexes and redundant indexes
  8. UNION and Double IN methods for Query Optimization
  9. Database problems in MySQL/PHP Applications
  10. MySQL Server Upgrade
  11. MySQL Performance Forums
  12. Using UNION to implement loose index scan in MySQL
  13. Cache Performance Comparison
  14. Caching techinques
  15. SELECT LOCK IN SHARE MODE and SELECT FOR UPDATE
  16. Innodb Double Write
  17. MySQL Prepared Statements

July 2006

  1. Leaving MySQL, MySQL Consulting
  2. MySQL Crash Recovery
  3. Returning to InnoDB scalability
  4. MySQL Query Cache
  5. Extended EXPLAIN
  6. MySQL EXPLAIN limits and errors.
  7. Stack trace for x86_64 boxes
  8. SHOW INNODB STATUS walk-through
  9. eWeek tests OpenSource stacks and .NET
  10. How much memory Innodb locks really take ?
  11. INSERT INTO … SELECT Performance with Innodb tables.
  12. Thoughts on MySQL Replication
  13. Sysbench evaluation of iSCSI performance
  14. Choosing proper innodb_log_file_size

June 2006

  1. How reliable RAID really is
  2. What MySQL buffer cache hit rate should you target
  3. Handling big result sets
  4. Full text search for all MySQL Storage Engines
  5. MySQL Sizing questions
  6. Using MyISAM in production
  7. FreeBSD tests
  8. MyISAM concurrent insert
  9. Quick look at Ubuntu 6.06
  10. Why MySQL Could Be Slow With Large Tables
  11. MySQL Server Variables – SQL layer or Storage Engine specific.
  12. Intel Woodcrest vs AMD Opteron for MySQL
  13. Are larger buffers always better ?
  14. How InnoDB Thread Concurrency Works
  15. InnoDB page size
  16. Indexes in MySQL

May 2006

  1. InnoDB memory usage
  2. Join performance of MyISAM and Innodb
  3. MySQL INSERT ON DUPLICATE KEY UPDATE and counters
  4. MySQL SpecJAppServer2004 results
  5. Jeremy Cole on MySQL Replication
  6. MyISAM mmap feature (5.1)
  7. How Web Services world affect LAMP Stack
  8. Speedup your LAMP stack with LigHTTPD
  9. Group commit and XA
  10. MySQL Server Memory Usage
  11. Optimizing MySQL on Source Code Level
  12. To pack or not to pack – MyISAM Key compression
  13. Mess with innodb_thread_concurrency
  14. Operation Systems do not provide good IO interface for Database Servers
  15. Innodb Fuzzy checkpointing woes
  16. Descending indexing and loose index scan
  17. My Innodb Feature wishes
  18. Group commit and real fsync
  19. Site goes lives

2010–2013 →