Answer: |
here is a query that will ondelay? 33596980 | ozonelab | localhost | ozonelab_imp | Query | 9958 | Waiting for table metadata lock | ALTER TABLE `tov` ADD `pr ice_sale` DOUBLE(16,2) NOT NULL DEFAULT `0` AFTER `price2` | | 33640051 | ozonelab_imp | localhost | ozonelab_imp | Query | 7242 | Waiting for table metadata lock | select count(fld_key3) c f rom tov where tov.price>0 and fld_key2=67535316 | | 33675635 | ozonelab_imp | localhost | ozonelab_imp | Query | 4930 | Waiting for table metadata lock | select concat(`/catalog/`, replace(site_grp.url `.html`, \"),`/`,grp.url,`/`,sgrp.url,`/`,tov.url`. | | 33678928 | ozonelab_imp | localhost | ozonelab_imp | Query | 4717 | Waiting for table metadata lock | select count(fld_key3) c f rom tov where tov.price>0 and fld_key2=44315924 | | 33679962 | ozonelab_imp | localhost | ozonelab_imp | Query | 4655 | Waiting for table metadata lock | select concat(`/catalog/`, replace(site_grp.url `.html`, \"),`/`,grp.url,`/`,sgrp.url,`/`,tov.url`. | | 33684708 | ozonelab_imp | localhost | ozonelab_imp | Query | 4363 | Waiting for table metadata lock | select concat(`/catalog/`, replace(site_grp.url `.html`, \"),`/`,grp.url,`/`,sgrp.url,`/`,tov.url`. | | 33685913 | ozonelab_imp | localhost | ozonelab_imp | Query | 4290 | Waiting for table metadata lock | select concat(`/catalog/`, replace(site_grp.url `.html`, \"),`/`,grp.url,`/`,sgrp.url,`/`,tov.url`. | | 33688308 | ozonelab_imp | localhost | ozonelab_imp | Query | 4130 | Waiting for table metadata lock | select concat(`/catalog/`, replace(site_grp.url `.html`, \"),`/`,grp.url,`/`,sgrp.url,`/`,tov.url`. | | 33705762 | ozonelab_imp | localhost | ozonelab_imp | Query | 2982 | Waiting for table metadata lock | select good, tov.count res t, recycle.price, recycle.count, recycle.name, (select image from note_tov | | 33708976 | ozonelab_imp | localhost | ozonelab_imp | Query | 2732 | Waiting for table metadata lock | select good, tov.count res t, recycle.price, recycle.count, recycle.name, (select image from note_tov | | 33712486 | ozonelab_imp | localhost | ozonelab_imp | Query | 2452 | Waiting for table metadata lock | select concat(`/catalog/`, replace(site_grp.url `.html`, \"),`/`,grp.url,`/`,sgrp.url,`/`,tov.url`. | | 33712631 | ozonelab_imp | localhost | ozonelab_imp | Query | 2444 | Waiting for table metadata lock | select concat(`/catalog/`, replace(site_grp.url `.html`, \"),`/`,grp.url,`/`,sgrp.url,`/`,tov.url`. | | 33715009 | ozonelab_imp | localhost | ozonelab_imp | Query | 2270 | Waiting for table metadata lock | select concat(`/catalog/`, replace(site_grp.url `.html`, \"),`/`,grp.url,`/`,sgrp.url,`/`,tov.url`. | | 33715118 | ozonelab_imp | localhost | ozonelab_imp | Query | 2263 | Waiting for table metadata lock | select concat(`/catalog/`, replace(site_grp.url `.html`, \"),`/`,grp.url,`/`,sgrp.url,`/`,tov.url`. | | 33715143 | DELAYED | localhost | eximstats | Delayed insert | 42 | Waiting for INSERT | | | 33717341 | ozonelab_imp | localhost | ozonelab_imp | Query | 2119 | Waiting for table metadata lock | select concat(`/catalog/`, replace(site_grp.url `.html`, \"),`/`,grp.url,`/`,sgrp.url,`/`,tov.url`. | | 33717533 | ozonelab_imp | localhost | ozonelab_imp | Query | 2105 | Waiting for table metadata lock | select concat(`/catalog/`, replace(site_grp.url `.html`, \"),`/`,grp.url,`/`,sgrp.url,`/`,tov.url`. | | 33736013 | ozonelab_imp | localhost | ozonelab_imp | Query | 811 | Waiting for table metadata lock | select concat(`/catalog/`, replace(site_grp.url `.html`, \"),`/`,grp.url,`/`,sgrp.url,`/`,tov.url`. | | 33748194 | eurolub_tk1 | localhost | eurolub_tk1 | Sleep | 10 |