Portal Home > Knowledgebase > Articles Database > my .cnf settings

my .cnf settings

Posted by no one, 08-18-2011, 06:19 AM

Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance MySQL started within last 24 hours - recommendations may be inaccurate Reduce your overall MySQL memory footprint for system stability Enable the slow query log to troubleshoot bad queries Increasing the query_cache size over 128M may reduce performance Adjust your join queries to always utilize indexes Increase table_cache gradually to avoid file descriptor limits Variables to adjust: *** MySQL's maximum memory usage is dangerously high *** *** Add RAM before increasing MySQL buffer variables *** query_cache_size (> 384M) [see warning above] join_buffer_size (> 1.0M, or always use indexes with joins) what is your advice to my server Total processors: 8 Processor #1 VendorGenuineIntel NameIntel(R) Xeon(R) CPU E5620 @ 2.40GHz Speed2401.000 MHz Cache12288 KB Mem: 12289856 100 site

---

Posted by no one, 08-20-2011, 11:04 AM

up up up up up

---

Add to Favourites    Print this Article

ResellerZoom offers just one dedicated IP? (Views: 755)

Which services can be disabled and which are essential? (Views: 780)

reseller (Views: 762)

Not receiving email after exim4 restart (Views: 755)

urgent problem i need help (Views: 778)