Mahesh Patil

Bangalore

Age: 30

Test Engineer, Interested in Database and MySQL, Testing concepts.. etc

Jul
7
answered Good software to monitor disk io, memory and cpu use?
Jun
13
comment Where I can find a MySQL Enterprise Monitor and Agent version 2.3 for Redhat/CentOS?
You have to login to edelivery.oracle.com after login select Database as "MySQL" and in list you will find out "Agent" and "Service Manager" binaries. Now the version is 3.X
Jun
13
comment MySQL Community Server Limitations
Another advantage of MySQL Enterprise edition over Community edition is it provides the MySQL Thread Pool. The Thread Pool provides a highly scalable, queue-based thread-handling model designed to reduce overhead in managing client connections and statement execution threads.
Jun
13
comment Mysql Optimization issues
Recently I have watched a webinar from Percona they have mentioned about MONyog you can watch it as well may be it can be worthy tool for you percona.com/resources/mysql-webinars/monitoring-mysql-monyog
Jun
13
comment MySQL my.cnf File Optimization help
Since you are using MyISAM table you can try optimizing them using myisam utilities mentioned here dev.mysql.com/doc/refman/5.0/en/myisam-optimization.html and dev.mysql.com/doc/refman/5.5/en/optimizing-myisam.html
Jun
13
comment MySQL replication of single DB to same server
You can try using mysqlsandbox.net which allows replication setup on the same host. Once you have tried test setup you can replicate the same on production environment.
Jun
13
answered What is difference between INDEX and VIEW in MySQL
Jun
13
answered How can I list the schemas on my server?
Jun
9
answered MariaDB vs MySQL documentation
Jun
7
awarded Yearling
Jun
6
comment How to restore innodb tables without ibdata1 and *.ibd files
The Percona Data Recovery Tool for InnoDB is a free toolkit for recovering lost or corrupted data from InnoDB tables. For more details you can refer percona.com/software/mysql-innodb-data-recovery-tools
May
22
comment Sync two MySQL databases in two different locations
You can refer existing answer posted here in StackOverflow stackoverflow.com/questions/52583/…
May
22
answered Why would innoDB lock tables
May
22
answered MySQL 5.6 replications stop without any error
May
22
comment MySQL transactions and the USE `database name` statement
Use database isn't transactionable, only transnational statements are SELECTs, UPDATEs and DELETEs.
May
22
answered Whats the difference between information_schema.user_privileges and mysql.user?
May
12
answered Create read only user without being root
May
8
answered Lost connection to mysql?
May
8
answered Host is not allowed to connect to MySQL
Apr
23
answered How to Identify the user who issued MySQL Shutdown command
1 2 3 4 5