MySQL Forums
Forum List  »  Performance

Re: mysql TABLE tuning and performance
Posted by: Rick James
Date: March 29, 2009 10:35PM

Deleting will become an issue...
http://forums.mysql.com/read.php?20,253717 (Very slow DELETE, UPDATE, INSERT on a new server)
http://forums.mysql.com/read.php?115,251243 (Performing multiple updates and selects)
http://forums.mysql.com/read.php?22,246868 (mysql very slow after million insert/delete)
http://forums.mysql.com/read.php?26,247225 (Statement/row questions)

Summary tables -- to may the reports fast...
http://forums.mysql.com/read.php?125,252723 (Database Design for huge set of data)
http://forums.mysql.com/read.php?10,252593 (Counters)
http://forums.mysql.com/read.php?125,245133 (Design approach for summary table by 3 items)

In Data Warehousing, one should "Normalize" out common strings and put them into "dimension tables" rather than have them bulking up the "fact table".

Indexes... It is very hard to see the indexes from what you provided, please
SHOW CREATE TABLE tbl\G
and surround it with [ code ] and [ / code ]

We can chat some more after you have a chance to glance over that stuff.

Options: ReplyQuote


Subject
Views
Written By
Posted
3900
March 29, 2009 08:47AM
Re: mysql TABLE tuning and performance
1913
March 29, 2009 10:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.