…full-text search. Understand when to leverage MySQL features such as stored procedures, triggers and events. Operating and Troubleshooting for MySQL …, InnoDB hot backup). Setup and administer MySQL replication. Monitor MySQL servers in production. Discuss security issues with MySQL. Solve via …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…SHOW INNODB STATUS output and how to use this info to improve MySQL Performance. To start with basics SHOW …you can get an idea what might be hot spot in your workload. It however requires …builds for some pages to speed up row lookup replacing btree search with hash search. This section shows hash…
Post: MySQL Performance Forum: Hot Topics
August 18, 2006 By Leave a Comment
… MySQL Performance discussions as it names says. I spend planty of time replying questions and thought it would be good idea to provide weekly overviews of most interesting topic discussed. Here is the list for last week: Ways to perform full text search on Chinese texts with MySQL Replication of Summary tables only Overhead of…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… > expect it to beat MySQLi in speed. It is however bad idea to use > mysql_ functions directly as …get good > data clustering so table becomes hot very quickly due to data locality > once this user … the table) are potentially very valuable if searches are done against that information. On the other…
Post: To pack or not to pack - MyISAM Key compression
May 13, 2006 By 4 Comments
… not packed. Compressed blocks need to be treated differently. For uncompressed index blocks MySQL can do binary search inside the page – kind of… block this is not going to work and MySQL will need to scan keyblock from the start uncompressing keys to find matching key value… there are more reasons to have keys packed so cache hit is better. Especially if you can get hot indexes in memory…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… problem, hot backups are easy, though there are some important things which we have to consider… upgrading to Innodb. Features The MyISAM features which forbid moving to Innodb are typically Full Text Search … exercises not so common paths in the MySQL server – in particular Optimizer may have harder…
Post: Using flow control functions for performance monitoring queries
May 24, 2008 By 12 Comments
…CASE used in MySQL Queries as they are often abused used to create …to obfuscate some date 
In this query we’re looking at response time for different pages and we can find “search…hot pages, which will use content from the cache (or be served from the cache all together). Bots however tend to…
Post: RAID and Scale Out Discussions
June 12, 2007 By 3 Comments
…billion of forum posts we decided to go ahead with raw drives for search index because it is far …I remember uses decent servers with RAID for their MySQL installations. I surely agree with Jeremy on Commodity …internal storage option. Ie find me 12 or more hot swap SATA hard drives in the case in …
Post: HighLoad 2007 Review
October 6, 2007 By 1 Comment
…lot more details about their search process than Google would be willing to share. I specially mention Yandex…as the market is pretty hot. A lot of people I spoke to were approached about job …of tuning to very exciting yearly event. P.S My sessions from the conference uploaded to MySQL Presentations …
