| I noticed everyone keeps saying table looks, so im assuming its still running on MyISAM, which it shouldn't, it should run InnoDB, and judging by activity it should run XtraDB on percona (drop in replacement for MySQL). If its full text searches that you're worried about, sphinx is alwyas there to help with solving that problem with InnoDB. Row level locking is better than table locking. Increasing RAM won't be too costly too to help improve buffer pools and cache queries. |
DregondRahlMar 5, 2011 5:33 AM
More topics from this board
» new list option - "Maybe"dailydi - 33 minutes ago |
0 |
by dailydi
»»
33 minutes ago |
|
» Yearly Wrapped like MyDramaList ?ame - Sep 6 |
13 |
by ScaryOwl
»»
Yesterday, 10:47 AM |
|
» Abusing the Number of Shared Anime and Affinity to Uncover Private Listsvazae - Mar 7, 2021 |
6 |
by Serhiyko
»»
Oct 10, 7:01 AM |
|
» Separate rating lists by genre for more fair comparisons ( 1 2 )Mathi786 - Oct 7 |
94 |
by CC
»»
Oct 9, 8:42 PM |
|
» Can there be a different completed status for rewatching a show?Rally- - Oct 3 |
5 |
by Zekkenshin
»»
Oct 9, 12:07 AM |