Mysql tmp dir ibtmp1 full my hard disk

Inaendelea Ilichapishwa Miaka 4 iliyopita Kulipwa wakati wa kujifungua
Inaendelea Kulipwa wakati wa kujifungua

I've a problem with Mysql tmp dir,

after few hour the tmp dir table full my hard disk, i've limited the dir to 50gb (in mysql config) but when i try to save a product on my ecommerce ( magento 2 ) get this error in the log:

[login to view URL]: Impossibile salvare la riserva di magazzino. Si prega di riprovare. {"exception":"[object] (Magento\\Framework\\Exception\\CouldNotSaveException(code: 0): Impossibile salvare la riserva di magazzino. Si prega di riprovare. at at /home/raizer96/public_html/vendor/magento/module-catalog-inventory/Model/Stock/[login to view URL], Magento\\Framework\\Exception\\LocalizedException(code: 0): SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/#[login to view URL]' (Errcode: 122 - Internal (unspecified) error in handler), query was: CREATE TEMPORARY TABLE IF NOT EXISTS `catalog_product_index_price_temp` LIKE `catalog_product_index_price_tmp` at /home/raizer96/public_html/vendor/magento/module-catalog/Model/Indexer/Product/Price/Action/[login to view URL], Zend_Db_Statement_Exception(code: 0): SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/#[login to view URL]' (Errcode: 122 - Internal (unspecified) error in handler), query was: CREATE TEMPORARY TABLE IF NOT EXISTS `catalog_product_index_price_temp` LIKE `catalog_product_index_price_tmp` at /home/raizer96/public_html/vendor/magento/zendframework1/library/Zend/Db/Statement/[login to view URL], PDOException(code: HY000): SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/#[login to view URL]' (Errcode: 122 - Internal (unspecified) error in handler) at /home/raizer96/public_html/vendor/magento/zendframework1/library/Zend/Db/Statement/[login to view URL])"} []

if i restart mysql service all return ok for few hour

Linux Magento MySQL PHP Zend

Kitambulisho cha Mradi: #19793144

Kuhusu mradi

3 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

3 wafanyakazi huru wanazabuni wastani wa €31 kwa kazi hii

ambientinfotech

Hello, I have read your job details carefully and I can do your work if you will provide me more details of the project. I will definitely give you a better solution to your problem. Thanks Ambient Infotech

€50 EUR kwa siku 1
(Maoni 345)
7.6
Hostingshades

Hello, I'll check and resolve your issue. Please initiate a chat session so we can discuss more about it. Thank you.

€20 EUR kwa siku 1
(Maoni 137)
5.9