35 reputation
8
bio website linkedin.com/profile/…
location Hyderabad, India
age 24
visits member for 1 year, 5 months
seen Sep 22 '13 at 14:43

Wokring as MySQL DBA at IPsoft. Handling 300+ MySQL servers with different Replication Topologies (Master-Master, Master-Slave), Rolling Partitions, Performance Tuning, Query Optimization, MEM(MySQL Enterprise Monitor) tool setup and maintenance.


Sep
19
awarded  Tumbleweed
Sep
12
awarded  Commentator
Sep
12
answered MySQL gives me:“Can't open and lock privilege tables: Table 'host' is read only”
Sep
12
answered bulk_insert_buffer_size and InnoDB
Sep
12
comment Create user for alternate port
Can you please post the error via SMF.
Sep
12
asked MySQL connection lock during backup(mysqldump)
Aug
9
comment Backup / Export data from MySQL 5.5 attachments table keeps failing!
Can you increase the innodb_buffer_pool_size= 8G or more and try it. Also please do share the command and options you using to take dump.
Aug
9
comment Backup / Export data from MySQL 5.5 attachments table keeps failing!
What is the data size of table you taking as dump and what is the available memory to the MySQL?.
Apr
29
awarded  Supporter
Apr
29
comment Optimizing Query
Thanks a lot druzin....
Apr
29
accepted Optimizing Query
Apr
29
asked Optimizing Query
Jan
5
comment mysqlbackup mysql enterprise utility issue
Ok thanks for clarifying.....all I was thinking is that I'm not using right commands....
Jan
5
comment mysqlbackup mysql enterprise utility issue
My concern is after a successful restore into datadir.....user:group is root:root so does the privileges with 644 instead of 660 for frm ibd myd files. Is it that usually happens with mysqlbackup or do I need to use any options for it.
Jan
4
asked mysqlbackup mysql enterprise utility issue
Dec
20
awarded  Scholar
Dec
20
accepted MySQL Start/Stop
Dec
20
answered Best Way to Partition By City / State in MySQL 5.5
Dec
19
answered mysql index on derived table
Dec
17
comment How to solve MySQL “The table is full” error 1114 with Amazon RDS?
what is the storage engine?? If InnoDB check innodb_data_file_path variable once. and look is it auto extend and innodb file per table is on or off.....