17 posts tagged myisam
Subscribe-
Concurrent inserts on MyISAM and the binary log
http://www.mysqlperformanceblog.com/ 2008/ 05/ 14/ concurrent-insert-select-myis…Recently I had an interesting surprise with concurrent inserts into a MyISAM table. The inserts were not happening concurrently with SELECT statements; they were blocking and the process list was filling up with queries in Locked status.
-
MySQL Performance on Memory Appliance
http://www.mysqlperformanceblog.com/ 2008/ 03/ 31/ mysql-performance-on-memory-a…Recently I have had a chance to check out MySQL Performance on "Memory Appliance" by Violin Memory which can be used as extremely high speed storage system. I helped Violin Memory to optimize MySQL for customer workload and Violin memory and also had a chance to do some benchmarks on my own.
-
MySQL File System Fragmentation Benchmarks
http://www.mysqlperformanceblog.com/ 2008/ 03/ 21/ mysql-file-system-fragmentati…Few days ago I wrote about testing writing to many files and seeing how this affects sequential read performance. I was very interested to see how it shows itself with real tables so I've got the script and ran tests for MyISAM and Innodb tables on ext3 filesystem.
-
MySQL Backup and Recovery Methodologies
http://www.yinfor.com/ blog/ archives/ 2008/ 02/ mysql_backup_and_recovery_meth.…MySQL is very popular. Many open source or free software use MySQL as their main database engine. To make our data safe, please remember to backup your data regularly. There are two methodologies you can use to back up MySQL databases without spending money.
-
Repaire corrupted MyISAM tables
http://www.yinfor.com/ blog/ archives/ 2008/ 02/ repaire_corrupted_myisam_table.…To repare the corrupted MyISAM tables, just cd to the directory that holds the MyISAM datafiles, then run this: $ myisamchk -r -q table_name If it doesn't work, try this command, $ myisamchk --safe-recover table_name The above two commands can fix most of the problems of MyISAM tables.
-
Maria (aka MyISAM++)
http://blogs.sun.com/ theaquarium/ entry/ maria_aka_myisam_debutsMonty has started blogging and has announced the Early Release of the sources and Specs for Maria (aka MyISAM++). Also check out comments from Guiseppe (the Data Charmer) and from the Performance blog. Maria and Falcon are the two newest Storage Engines in MySQL.
-
Maria (aka MyISAM++)
http://blogs.sun.com/ theaquarium/ entry/ maria_aka_myisam_debutsMonty has started blogging and has announced the Early Release of the sources and Specs for Maria (aka MyISAM++). Also check out comments from Guiseppe (the Data Charmer) and from the Performance blog. Maria and Falcon are the two newest Storage Engines in MySQL.
-
MyISAM to InnoDB Conversion: Converting almost a billion records
http://mysqldatabaseadministration.blogspot.com/ 2008/ 01/ myisam-to-innodb-conv…So my challenge last week was to convert almost a billion records in 37 databases and 74 tables. Oh, and I wanted to do it only during the night (between 12:30AM and 6AM) and in the least number of nights. This was not my first massive MyISAM to InnoDB migration, nonetheless, I still manged to learn a few things.
-
Enum Fields VS Varchar VS Int + Joined table: What is Faster?
http://www.mysqlperformanceblog.com/ 2008/ 01/ 24/ enum-fields-vs-varchar-vs-int…Really often in customers' application we can see a huge tables with varchar/char fields, with small sets of possible values. These are "state", "gender", "status", "weapon_type", etc, etc. Frequently we suggest to change such fields to use ENUM column type, but is it really necessary (from performance standpoint)?
-
DB Upgrade
http://www.zackire.com/ db-upgrade.htmDB Upgrade January 10th, 2008 Filed under Uncategorized ———————————- !! You can choose to ignore this !! ———————————- This is an AUTOBOT vs DECEPTORCON WAR. Server Upgrades in Process. Stage 1 ****** Hacking into your Computer > AUTO IDIOT INSTALLED Stage 2 ****** DRAINING YOUR MONEY > All your advertising money have been siphoned off.
Mentions by Day
Posts tagged myisam per day for the past 30 days.
