0
votes
1answer
36 views

MySQL: How turning off the logging affect the performance?

OS: RHEL5 DB: MySQL 5.1.73 community edition DB size: ~1GB I have setup a testing environment and turned off all logging - general logs, binary logs, slow query logs etc. I am using Oracle ...
1
vote
1answer
114 views

InnoDB engine is not loading after tuning parameters

After installing MySQL-5.1.73, I placed default my-huge.cnf into /etc/my.cnf and started the mysql service. It was running without any issue. Now, I tunned some parameters in /etc/my.cnf file. Below ...
0
votes
1answer
34 views

MySQL: How to find MySQL 5.1 (with built-in InnoDB) or MySQL 5.1 (with InnoDB-plugin)?

My DB server has MySQL 5.1.58-community-log and I am planning to upgrade it to MySQL 5.6 with specific purpose of improving my system performance and removing the bottleneck issue. So, I have gone ...
0
votes
1answer
153 views

MySQL: Different thread states in Query execution

My MySQL 5.1 bases Intranet system is facing very bad performance during high load. When observe through MonYog, I found below thread states: We can simply understand the different thread state by ...
0
votes
0answers
15 views

MySQL: How logging is useful in performance improvement

My application is facing performance hit. Its a MySQL-5.1.55 version. I am using Windows 2008 dedicated server with 8 GB for the database. There is only one database in this whole system. Till now, I ...
0
votes
0answers
146 views

MySQL: How to get locked tables list at a time

Is there any way or any query exist in mysql which list down all the locked tables at a time. I have dedicated Windows 2008 DB server with 8GB memory. In my MySQL5.1 based application, suddenly we get ...
0
votes
0answers
153 views

MySQl: slow query is not using index in joining

Below is the configuration of my DB server: Apache version : Apache/2.2.22 (Win32) mod_ssl/2.2.22 OpenSSL/0.9.8 PHP version : 5.3.13 MySQL version : mysqlnd 5.1.11 Windows Server 2008 Standard ...