MySQL - error at database
Given every 3 hours, I got a flood after the Load Averages 348.67 469.51 240.34 reached. Then MySQL crashes and stops working sites.
In order to recover, always give Rebuild RPM Database. But I can not do that forever.
I do not know what it is. It's the flood, or is there a problem with the MySQL server?
Please help me! What can I do?
(sorry for my bad english)
-
Hello :) I suggest reviewing the following thread for information on troubleshooting the server load: Troubleshooting High Loads on Linux Servers Thank you. 0 -
CPU memory (including swap) disk I/O ??? I have 4 cores from one Intel processor, XEON... memory 5150 MB, and 100 GB Disk..... 0 -
Nobudy can't help me ? 0 -
Upgrade to MySQL 5.6 ( If you're already upgraded to that, then rebuild it ) Home "Software "MySQL Upgrade 0 -
I give rebuild in every 3 hours, and it's still crashing MySQL is allready 5.6. 0 -
what do you have in your my.cnf ? Located /etc/my.cnf and what your ram and cpu specs 0 -
[quote="darrencain, post: 1696362">what do you have in your my.cnf ? Located /etc/my.cnf and what your ram and cpu specs
[QUOTE]/etc/my.cnf [mysqld] innodb_file_per_table=1 max_allowed_packet=268435456 default-storage-engine=MyISAM
[QUOTE]cat /proc/cpuinfo processor : 0 vendor_id : GenuineIntel cpu family : 6 model : 15 model name : Intel(R) Xeon(R) CPU L5335 @ 2.00GHz stepping : 11 cpu MHz : 1995.060 cache size : 4096 KB physical id : 0 siblings : 4 core id : 0 cpu cores : 4 apicid : 0 initial apicid : 0 fpu : yes fpu_exception : yes cpuid level : 10 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm constant_tsc arch_perfmon pebs bts rep_good aperfmperf pni dtes64 monitor ds_cpl vmx tm2 ssse3 cx16 xtpr pdcm dca lahf_lm dts tpr_shadow vnmi flexpriority bogomips : 3990.12 clflush size : 64 cache_alignment : 64 address sizes : 38 bits physical, 48 bits virtual power management: processor : 1 vendor_id : GenuineIntel cpu family : 6 model : 15 model name : Intel(R) Xeon(R) CPU L5335 @ 2.00GHz stepping : 11 cpu MHz : 1995.060 cache size : 4096 KB physical id : 0 siblings : 4 core id : 1 cpu cores : 4 apicid : 1 initial apicid : 1 fpu : yes fpu_exception : yes cpuid level : 10 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm constant_tsc arch_perfmon pebs bts rep_good aperfmperf pni dtes64 monitor ds_cpl vmx tm2 ssse3 cx16 xtpr pdcm dca lahf_lm dts tpr_shadow vnmi flexpriority bogomips : 3990.12 clflush size : 64 cache_alignment : 64 address sizes : 38 bits physical, 48 bits virtual power management: processor : 2 vendor_id : GenuineIntel cpu family : 6 model : 15 model name : Intel(R) Xeon(R) CPU L5335 @ 2.00GHz stepping : 11 cpu MHz : 1995.060 cache size : 4096 KB physical id : 0 siblings : 4 core id : 2 cpu cores : 4 apicid : 2 initial apicid : 2 fpu : yes fpu_exception : yes cpuid level : 10 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm constant_tsc arch_perfmon pebs bts rep_good aperfmperf pni dtes64 monitor ds_cpl vmx tm2 ssse3 cx16 xtpr pdcm dca lahf_lm dts tpr_shadow vnmi flexpriority bogomips : 3990.12 clflush size : 64 cache_alignment : 64 address sizes : 38 bits physical, 48 bits virtual power management: processor : 3 vendor_id : GenuineIntel cpu family : 6 model : 15 model name : Intel(R) Xeon(R) CPU L5335 @ 2.00GHz stepping : 11 cpu MHz : 1995.060 cache size : 4096 KB physical id : 0 siblings : 4 core id : 3 cpu cores : 4 apicid : 3 initial apicid : 3 fpu : yes fpu_exception : yes cpuid level : 10 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx lm constant_tsc arch_perfmon pebs bts rep_good aperfmperf pni dtes64 monitor ds_cpl vmx tm2 ssse3 cx16 xtpr pdcm dca lahf_lm dts tpr_shadow vnmi flexpriority bogomips : 3990.12 clflush size : 64 cache_alignment : 64 address sizes : 38 bits physical, 48 bits virtual power management:
cat /proc/meminfo |more MemTotal: 5242880 kB MemFree: 817288 kB Cached: 3747020 kB Active: 2421208 kB Inactive: 1867336 kB Active(anon): 358476 kB Inactive(anon): 183048 kB Active(file): 2062732 kB Inactive(file): 1684288 kB Unevictable: 0 kB Mlocked: 0 kB SwapTotal: 524288 kB SwapFree: 518620 kB Dirty: 0 kB Writeback: 0 kB AnonPages: 541524 kB Shmem: 5204 kB Slab: 136992 kB SReclaimable: 129496 kB SUnreclaim: 7496 kB [COLOR="silver">- - - Updated - - - This is the configuration of VPS0 -
Download this my.cnf and replace your current one. [Removed] You may need to tweak it, but see what that does. don't forget to restart mysql. Mod Note: Please post the full my.cnf file in code tags rather than linking to a third-party download. 0
Please sign in to leave a comment.
Comments
8 comments