Hi,
sorry for late response and thank you for clarification DrByte & I could not agree more with MC. Cold truth is that I have been sick for nearly 8 months and pile of work has to be done before winter. Also I work in this zen cart project as a part timer and 95% of the new shop is ready but my boss seems to have fun time kicking my ###### on less important things. It would be much wiser to upgrade but I have to keep up the old system running for few weeks still.
I did forget to mention that there is a simple category caching in place made by data-diggers. I did took of the Opcache from my.cnf and investigated whats causing the issue.
Seems myIsam table locks are the cause? :
Code:
| 4689 | Query | 274 | Sending data | select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name,
| 0.000 |
| 4692 | Query | 263 | Waiting for table level lock | update zen_products_description
set products_viewed = products_viewed+1
| 0.000 |
| 4694 | Query | 210 | Waiting for table level lock | select products_name
from zen_products_description
where produ | 0.000 |
| 4695 | Query | 203 | Waiting for table level lock | select products_name
from zen_products_description
where produ | 0.000 |
| 4696 | Query | 198 | Waiting for table level lock | select products_name
from zen_products_description
where produ | 0.000 |
| 4699 | Query | 163 | Waiting for table level lock | select products_name
from zen_products_description
where produ | 0.000 |
| 4700 | Query | 137 | Waiting for table level lock | select p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price | 0.000 |
| 4701 | Query | 126 | Waiting for table level lock | select products_name
from zen_products_description
where produ | 0.000 |
| 4704 | Query | 81 | Waiting for table level lock | select p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price | 0.000 |
| 4705 | Query | 63 | Waiting for table level lock | select p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price
Could I just convert products and categories to Innodb to get row level locking instead of table level locking? Now they are Isam.
Brgds,
Oops
Bookmarks