…lot of customers who do click analysis, site analytics, search engine marketing, online advertising, user … of repairing huge MyISAM tables and taking downtime, I would not use MyISAM for anything but read-… some of the tactics I’ve used to successfully scale large click-processing and other types …
Post: Working with large data sets in MySQL
July 5, 2007 By 12 Comments
… database is already loaded. So operating wit such large databases you need to be patient and learn…or bringing the site down. If you have tiny 1GB table you pretty much can use trial and… BTREE (even MyISAM which builds “normal” indexes by sort builds primary key and unique indexes using keycache) If…
Post: Performance impact of complex queries
January 17, 2007 By 11 Comments
…Performance by complex queries on large data sets(ie some large aggregate queries) and batch jobs…can affect web site performance dramatically. Sometimes instead of using slave you may use database version …to the master using mysqldump, or even careful file transfer if you’re using MyISAM tables. …
Comment: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… of only three ways to get a consistent backup of myisam suitable for a replication seed. Maybe one of the guys… tables option (this is an outage) 3) if you’re using LVM, FLUSH TABLES WITH READLOCK … snap … RELEASE LOCK (this is…. We run a site with a large number of myisam tables that we’re seriously considering moving to innodb; myisam has a lot of…
Comment: Using MyISAM in production
June 20, 2006 By 35 Comments
… while searching through performance forum on MySQL site It is a great blog with lot …using MyISAM tables. Here is some background on our environment: H/W: Dell 2.4GH 2CPU servers with 3 internal disks using… grows in size doing nothing resulting in large number of db connections Once MySQL unfreezes,…
Comment: Should you move from MyISAM to Innodb ?
February 1, 2010 By 53 Comments
…using InnoDB? We use an internal process based on mysqldump and innodb file-per table. Our “Database File-Per-Table Archives” web site…rows. Some applications use MyISAM with …large InnoDB tables is not an issue, My suggestion to use all the tools and techniques available to you, icrease the use…
Comment: Thoughts on MySQL Replication
July 9, 2006 By 18 Comments
… one major site which uses DRDB (with Postgres) and they seem to like it. It seems that it can only be used for… be able to do it). Another point…. yes large transactions (on MyISAM) will use locks longer but this can be faster than doing…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…myisam_recoverblogpercona.commanual myisam_recover_optionsblogpercona.commanual myisam_recover_optionsblogpercona.commanual myisam_repair_threadsblogpercona.commanual myisam_sort_buffer_sizeblogpercona.commanual myisam_stats_methodblogpercona.commanual myisam_use…
Post: Is it query which needs to be optimized ?
March 6, 2007 By 9 Comments
… people think counting is fast, some have heard MyISAM is instant with COUNT(*) without reading enough …some sort of profile browsing at social networking site – SELECT COUNT(*) FROM profiles where STATE_ID=…M’. If number of rows is not too large using covering index ie (STATE_ID,CITY_ID,GENDER)…
Post: Converting Character Sets
March 17, 2009 By 16 Comments
…” results in a plethora of sites, each with a slightly different… ->Â Â `c1` text NOT NULL -> ) ENGINE=MyISAM DEFAULT CHARSET=latin1; Query OK, … process is inherently unsuitable for large databases because it requires multiple… perhaps maatkit, if it proves useful enough) once it is feature complete….
