Whenever I alter a mysql table like add a new field it gets really slow and
all other processes lag.
Is there a memory variable I can adjust for this?
--
View this message in context:
http://www.nabble.com/MySQL-slow-when-altering-tables.-tf4119161.html#a11714643
Sent from the MySQL - General ma
Hi I need some optimization help.
I currently have this query "SELECT COUNT(*) as count,sum(p.amt) as
total,p.batch,m.username,m.id,p.method,DATE_FORMAT(p.occur, '%M %d, %Y') as
dateBought FROM pay p LEFT JOIN members m ON m.id=p.mid WHERE
p.method!='none' AND p.method!='' GROUP BY p.batch ORDE
Hi I need some optimization help.
I currently have this query "SELECT COUNT(*) as count,sum(p.amt) as
total,p.batch,m.username,m.id,p.method,DATE_FORMAT(p.occur, '%M %d, %Y') as
dateBought FROM pay p LEFT JOIN members m ON m.id=p.mid WHERE
p.method!='none' AND p.method!='' GROUP BY p.batch ORDE
Hi I need some optimization help.
I currently have this query "SELECT COUNT(*) as count,sum(p.amt) as
total,p.batch,m.username,m.id,p.method,DATE_FORMAT(p.occur, '%M %d, %Y') as
dateBought FROM pay p LEFT JOIN members m ON m.id=p.mid WHERE
p.method!='none' AND p.method!='' GROUP BY p.batch ORDE
