we have high load and many times Internal Server Error what is best Config for my.cnf RAm 24 gig ssh hard for sql Total processors: 10 Processor #1 Vendor GenuineIntel Name Intel(R) Core(TM) i7 CPU 970 @ 3.20GHz Speed 1596.000 MHz Cache 12288 KB Processor #2 Vendor GenuineIntel Name Intel(R) Core(TM) i7 CPU 970 @ 3.20GHz Speed 1596.000 MHz Cache 12288 KB Processor #3 Vendor GenuineIntel Name Intel(R) Core(TM) i7 CPU 970 @ 3.20GHz Speed 1596.000 MHz Cache 12288 KB Processor #4 Vendor GenuineIntel Name Intel(R) Core(TM) i7 CPU 970 @ 3.20GHz Speed 1596.000 MHz Cache 12288 KB Processor #5 Vendor GenuineIntel Name Intel(R) Core(TM) i7 CPU 970 @ 3.20GHz Speed 1596.000 MHz Cache 12288 KB Processor #6 Vendor GenuineIntel Name Intel(R) Core(TM) i7 CPU 970 @ 3.20GHz Speed 3193.000 MHz Cache 12288 KB Processor #7 Vendor GenuineIntel Name Intel(R) Core(TM) i7 CPU 970 @ 3.20GHz Speed 1596.000 MHz Cache 12288 KB Processor #8 Vendor GenuineIntel Name Intel(R) Core(TM) i7 CPU 970 @ 3.20GHz Speed 3193.000 MHz Cache 12288 KB Processor #9 Vendor GenuineIntel Name Intel(R) Core(TM) i7 CPU 970 @ 3.20GHz Speed 3193.000 MHz Cache 12288 KB Processor #10 Vendor GenuineIntel Name Intel(R) Core(TM) i7 CPU 970 @ 3.20GHz Speed 1596.000 MHz Cache 12288 KB Processor #11 Vendor GenuineIntel Name Intel(R) Core(TM) i7 CPU 970 @ 3.20GHz Speed 3193.000 MHz Cache 12288 KB Processor #12 Vendor GenuineIntel Name Intel(R) Core(TM) i7 CPU 970 @ 3.20GHz Speed 1596.000 MHz Cache 12288 KB Code (markup):
Hi there, Nobody can offer suggestions, as each site is unique in how it interacts with the database server. All you have listed is the number of processors available and the total RAM. Here is a link to an old blog post I did about MySQL tuning, use those tools to tell you what to change in your configuration file. Regards, Chris
You would have to actually post your current sql status for usage, the cpu type doesnt tell us anything. The settings in my.cnf arent a guaranteed resolution either, if the tables are locking etc....
Try mysqltuner Nobody can really suggest you out of the box options, it depends on the type of database and traffic you have. It will advice you some options.
Memory Information Memory for crash kernel (0x0 to 0x0) notwithin permissible range Memory: 24688168k/25690112k available (2606k kernel code, 475980k reserved, 1662k data, 224k init)