Mahesh Patil

Bangalore

Age: 31

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

Nov
19
comment Optimize this query
Actually this query is a view definition , so thought of optimizing it without loosing any column for retrieval
Nov
18
comment Optimize this query
Added please check above
Nov
18
revised Optimize this query
added one more table definition
Nov
17
revised Optimize this query
added 1019 characters in body
Nov
17
asked Optimize this query
Nov
14
comment MySQL - OPTIMIZE TABLE for partitions
Actually our application executes lot of DML statements and once a week we purge the data so we need to shrink ".ibd" file size. I think it's good practice to do OPTIMIZE once in 15 days. MySQL v5.5.30 and InnoDB I prefer first option anyway but if I can do OPTIMIZE at paritition level will it reduce overhead on server locking, speed etc.. ?
Nov
13
asked MySQL - OPTIMIZE TABLE for partitions
Nov
13
awarded Scholar
Nov
13
accepted MySQL - Old ibdata file shall I delete safely
Nov
12
awarded Curious
Nov
11
asked MySQL - Old ibdata file shall I delete safely
Oct
22
asked MySQLfabric -- Manage setup problem
Oct
13
asked MySQL Fabric Error- No module named mysql.fabric.services
Oct
13
asked MySQL Fabric Error- No module named mysql.fabric.services
Oct
6
awarded mysql
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
Sep
24
awarded Autobiographer
1 2 3 4 5