Search found 8 matches

by tejas5555
2018/04/03 06:09:32
Forum: CentOS 5 - Software Support
Topic: High load due to MYSQL ON 8core cpu server
Replies: 0
Views: 5261

High load due to MYSQL ON 8core cpu server

Dear all, I have a8 core CPU server with memory of 32GB. Then to mysql results into heavy load, sometimes even 50 with idealtime=0. Please find the output of mysqltuner. >> MySQLTuner 1.7.8 - Major Hayden <major@mhtx.net> >> Bug reports, feature requests, and downloads at http://mysqltuner.com/ >> R...
by tejas5555
2018/04/03 05:57:51
Forum: CentOS 5 - Software Support
Topic: Unable to start MYSQL service
Replies: 9
Views: 5412

Re: Unable to start MYSQL service

innodb_force_recovery = 1

It is the exact line which is there in /etc/my.cnf.
by tejas5555
2018/03/23 04:46:51
Forum: CentOS 6 - General Support
Topic: High load due to MYSQL
Replies: 2
Views: 812

Re: High load due to MYSQL

Thanks for your help. It was the faulty disk which is located in our DC. Anyway will align hardware team for the replacement
by tejas5555
2018/03/22 08:54:38
Forum: CentOS 6 - General Support
Topic: High load due to MYSQL
Replies: 2
Views: 812

High load due to MYSQL

Dear all, In my server , CPU is continuously under heavy load due to mysql. Also ideal time is 0. Please find the output of mysqltuner.pl script. Any help to reduce load is appreciated. -bash-4.1# ./mysqltuner.pl >> MySQLTuner 1.7.7 - Major Hayden <major@mhtx.net> >> Bug reports, feature requests, a...
by tejas5555
2018/02/28 05:10:38
Forum: CentOS 5 - Software Support
Topic: Unable to start MYSQL service
Replies: 9
Views: 5412

Re: Unable to start MYSQL service

MYSQL Log:- ;InnoDB: End of page dump 180228 10:28:06 InnoDB: Page checksum 1575996416, prior-to-4.0.14-form checksum 1371122432 InnoDB: stored checksum 0, prior-to-4.0.14-form stored checksum 0 InnoDB: Page lsn 0 0, low 4 bytes of lsn at page end 0 InnoDB: Page number (if stored to page already) 0,...
by tejas5555
2018/02/27 09:12:08
Forum: CentOS 5 - Software Support
Topic: Unable to start MYSQL service
Replies: 9
Views: 5412

Re: Unable to start MYSQL service

Hi Devourer,
Database is not starting even after using innodb_recovery to level 5. Any other solutions?
by tejas5555
2018/02/26 06:10:21
Forum: CentOS 5 - Software Support
Topic: Unable to start MYSQL service
Replies: 9
Views: 5412

Re: Unable to start MYSQL service

No, Lots of space is left in the disk.
df -lh

Filesystem Size Used Avail Use% Mounted on
/dev/hda1 66G 5.6G 57G 9% /
/dev/hda2 16G 4.2G 11G 29% /var
tmpfs 2.0G 0 2.0G 0% /dev/shm
by tejas5555
2018/02/23 11:45:18
Forum: CentOS 5 - Software Support
Topic: Unable to start MYSQL service
Replies: 9
Views: 5412

Unable to start MYSQL service

Dear all, I am unable to start MYSQL service in my CENTOS 5.11 server . Please find the attached logs for your reference. Your help will be appreciated. vi /var/log/mysqld.log 180223 16:46:02 mysqld started InnoDB: The log sequence number in ibdata files does not match InnoDB: the log sequence numbe...

Go to advanced search