- Published on
Sorry folks, this article was based on flawed benchmark results, I will soon
post [an update](/blog/2009/03/31/improve-mysql-insert-performance/)!
Transactions
All Posts
- programming (27)
- ubuntu (21)
- linux (15)
- performance (15)
- bash (13)
- mysql (13)
- ide (12)
- nodejs (11)
- apache (10)
- pear (10)
- javascript (10)
- ssh (9)
- database (9)
- security (8)
- crontab (7)
- cakephp (7)
- io (6)
- pecl (5)
- eclipse (5)
- git (5)
- transloadit (5)
- htaccess (4)
- squid (4)
- vim (4)
- cs (4)
- virtualbox (4)
- github (4)
- campfire (4)
- ci (4)
- osx (4)
- vhost (3)
- caching (3)
- array (3)
- hierarchy (3)
- recursion (3)
- tree (3)
- svn (3)
- memcache (3)
- virtualization (3)
- sql (3)
- benchmark (3)
- innodb (3)
- nginx (3)
- ruby (3)
- nas (3)
- sabnzbd (3)
- synology (3)
- regex (2)
- memcached (2)
- devshm (2)
- ram (2)
- tmpfs (2)
- backup (2)
- font (2)
- imagemagick (2)
- imagick (2)
- sid (2)
- windows (2)
- netbeans (2)
- daemon (2)
- bulk (2)
transactions (2)
- api (2)
- python (2)
- conference (2)
- versioncontrol (2)
- html (2)
- redis (2)
- network (2)
- shell (2)
- dpc (2)
- dropbox (2)
- coffeescript (2)
- npm (2)
- testing (2)
- solo (2)
- vagrant (2)
- go (2)
- golang (2)
- uploading (2)
- reliability (2)
- macos (2)
- apple (2)
- typescript (2)
- ai (2)
- mod_rewrite (1)
- seo (1)
- url (1)
- cat (1)
- comments (1)
- config (1)
- editor (1)
- mc (1)
- pico (1)
- open_basedir (1)
- safemode (1)
- mod_expires (1)
- pxe (1)
- sata (1)
- umask (1)
- cli (1)
- libssh2 (1)
- router (1)
- firewall (1)
- iptables (1)
- dd (1)
- iso (1)
- rsync (1)
- synchronization (1)
- display (1)
- dpi (1)
- gnome (1)
- delimiter (1)
- compiz (1)
- ghostscript (1)
- pdf (1)
- postscript (1)
- tiff (1)
- sddl (1)
- vbscript (1)
- parsing (1)
- vmware (1)
- xen (1)
- lamp (1)
- apt (1)
- aptfile (1)
- dpkg (1)
- dry (1)
- mvc (1)
- feedburner (1)
- rss (1)
- cvs (1)
- documentation (1)
- phd (1)
- chart (1)
- google (1)
- flash (1)
- flv (1)
- video (1)
- desktop (1)
- incolsolata (1)
- monospaced (1)
- sysadmin (1)
- terminal (1)
- java (1)
- tinyurl (1)
- youtube (1)
- berlin (1)
- event (1)
- notes (1)
- php53 (1)
- flush (1)
- netcat (1)
- phpjs (1)
- system_daemon (1)
- trac (1)
- generators (1)
- kvzhtml (1)
- kvzlib (1)
- karmic (1)
- upstart (1)
- rest (1)
- password (1)
- analyze (1)
- firebug (1)
- http (1)
- tools (1)
- tshark (1)
- wireshark (1)
- dpc10 (1)
- startup (1)
- haproxy (1)
- logging (1)
- rsyslogd (1)
- syslog (1)
- gems (1)
- mongrel (1)
- ror (1)
- sqlite (1)
- thin (1)
- screen (1)
- tmux (1)
- indentation (1)
- spaces (1)
- tabs (1)
- whitespace (1)
- debugging (1)
- server (1)
- tail (1)
- wtf (1)
- multibyte (1)
- utf8 (1)
- casperjs (1)
- homebrew (1)
- hubot (1)
- cronlock (1)
- timkay (1)
- mount (1)
- productivity (1)
- soundex (1)
- dns (1)
- nameserver (1)
- papertrail (1)
- redundancy (1)
- spof (1)
- migration (1)
- replication (1)
- grammar (1)
- markdown (1)
- spelling (1)
- wget (1)
- coding-style (1)
- operators (1)
- streams (1)
- capistrano (1)
- deploy (1)
- boot (1)
- grub (1)
- kernel (1)
- apps (1)
- arduino (1)
- automation (1)
- fxos (1)
- mobile (1)
- raspberrypi (1)
- amazon (1)
- aws (1)
- encoding (1)
- jenkins (1)
- travis (1)
- heartbleed (1)
- openssl (1)
- ssl (1)
- stunnel (1)
- hours (1)
- timelog (1)
- timetracking (1)
- track (1)
- tooling (1)
- backpressure (1)
- circuitbreaker (1)
- flowcontrol (1)
- tus (1)
- english (1)
- language (1)
- buildtools (1)
- browsersync (1)
- jekyll (1)
- staticsites (1)
- webdev (1)
- webpack (1)
- questions (1)
- review (1)
- writing (1)
- different (1)
- think (1)
- cursor (1)
- Published on
Sometimes MySQL needs to work hard. I've been working on an import script that fires a lot of INSERTs. Normally our database server handles 1,000 inserts / sec. That wasn't enough. So I went looking for methods to improve the speed of MySQL inserts and was finally able to increase this number to 28,000 inserts per second. Checkout my late night benchmarking adventures.