Performance Tuning

Pagecache

https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Linux/5/html/Tuning_and_Optimizing_Red_Hat_Enterprise_Linux_for_Oracle_9i_and_10g_Databases/sect-Oracle_9i_and_10g_Tuning_Guide-Memory_Usage_and_Page_Cache-Tuning_the_Page_Cache.html

Database Tuning


https://www.google.ca/search?q=pagecache+and+database&ie=utf-8&oe=utf-8&gws_rd=cr&ei=PsjLVJK2KIufyQTh74HIDQ#q=linux+pagecache+and+database

Slow Query Due to fragmentation

http://www.psce.com/blog/2012/07/09/data-fragmentation-problem-in-mysql-myisam/

No comments: