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 'Zend_Db_Statement_Exception' with message 'SQLSTATE[HY000]: General error: 1114 The table 'catalog_product_index_price_bundle_sel_tmp' is full' in /home/staging2/public_html/newclubcolors/lib/Zend/Db/Statement/Pdo.php:234
I have checked lot of information on google but able to resolve this problem.
According to them, i have increased the values of mysql variables but still, i am getting table full error error
max_heap_table_size = 8096M:autoextend tmp_table_size = 4096M:autoextend innodb_data_file_path = ibdata1:4G:autoextend
Any help would be appreciated.