4058867 | ozonelab_imp | localhost | ozonelab_imp | Execute | 9736 | Copying to tmp table | select count(tov.fld_key2) count sgrp.n e sgrp.fld_key2 from site_grp, link_grp, grp, sgrp, tov <|p> 4130302 | ozonelab | localhost | ozonelab_imp | Query | 5655 | Copying to tmp table | select count(tov.fld_key2) count sgrp.na sgrp.fld_key2 from site_grp, link_grp, grp, sgrp, tov <|p> 4139670 | ozonelab | localhost | ozonelab_imp | Query | 5212 | Waiting for table metadata lock | ALTER TABLE `ozonelab_imp`.`tov` ADD INDE `tov_name` (`name`(100))COMMENT \" <|p> 4146590 | ozonelab | localhost | ozonelab_imp | Query | 4867 | Waiting for table metadata lock | ALTER TABLE `ozonelab_imp`.`tov` ADD INDE `tov_name` (`name`(50))COMMENT `tov_name` <|p> 4167248 | ozonelab | localhost | ozonelab_imp | Query | 3761 | Waiting for table metadata lock | select count(tov.fld_key2) count sgrp.na sgrp.fld_key2 from site_grp, link_grp, grp, sgrp, tov w <|p> 4169239 | ozonelab | localhost | ozonelab_imp | Query | 3662 | Waiting for table metadata lock | select tov.fld_key2 count from site_grp nk_grp, grp, sgrp, tov where link_grp.site_grp=site_grp.i <|p> 4177057 | ozonelab | localhost | ozonelab_imp | Query | 3309 | Waiting for table metadata lock | SELECT * FROM `tov` IMIT 0, 25 <|p> You need to optimize the DB queries. They create load on the server. |