All Questions
Tagged with indexing mysql-indexes
8 questions
1
vote
0
answers
417
views
Warning Memory size allocated for the temporary table is more than 20% of innodb_buffer_pool_size
I am using Magento 2.4.5 and getting 5 warning logs in system.log file while I run the command
php bin/magento indexer:reindex
Memory size allocated for the temporary table is more than 20% of ...
- 315
3
votes
2
answers
2k
views
Magento indexing causing website downtime
Magento is creating 700 + connections leading to database breakdown whenever cache is flushed or indexing is triggered. Production site remain down for 20 mins till all connections clears. All ...
- 31
0
votes
1
answer
407
views
ERROR The table 'catalog_product_index_price_bundle_sel_tmp' is full
There are 10k products, websites (over 50 ) and multiple store (i.e. over 100) in my web-store and I am getting following error during magento re-indexing process.
Next exception '...
- 2,891
1
vote
1
answer
161
views
Add index for import
To speed up the import process we added the index:
ALTER TABLE catalog_product_entity_varchar
ADD INDEX IDX_CATALOG_PRODUCT_ENTITY_VARCHAR_VALUE (value ASC);
After these changes the "search product" ...
- 6,134
1
vote
0
answers
125
views
Magento 1.9.0.1 - Category URL Rewrites - Cannot intitialize the indexer process [duplicate]
I finally got my local installation of Magento 1.9.0.1 with the sample data up and running - XAMPP 1.8.3 on Windows 7 (Apache 2.4, PHP 5.5.15). Everything was working fine with all the status warning ...
- 11
1
vote
1
answer
520
views
Combo Errors MySQL gone away & Product Price :Cannot initialize the indexer process
Indexing Stuck at Processing while Reindexing
And The exception.log shows Error as
General error: 2006 MySQL server has gone away
The Full Exception.log Contents are as follows :
2014-06-17T11:55:...
- 413
0
votes
5
answers
9k
views
Base table or view not found: 1146 Table 'cpaneluser_magento.catalog_category_flat' doesn't exist'
I am getting following error while trying to reindex catalog_category_flat (Category Flat Data). I did tried to repair the database with PHPMyAdmin and magento database repair tool but still not fix. ...
- 169
1
vote
1
answer
291
views
Catalog URL Rewrites Duplicate Index (HY002)
I've seen this problem all around the internet and have yet to find a reasonable solution yet. I've truncated the core_url_rewrite table, set my permissions properly, etc.
It seems there is an issue ...
- 871