Tamamlanmış

Mysql tmp dir ibtmp1 full my hard disk

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

Beceriler: Linux, Magento, MySQL, PHP, Zend

Daha fazlasını gör: project assembly fix hard disk, hard disk drive firmware search engine, source code hard disk encryption, mysql ibtmp1 size, what is /var/lib/mysql/ibtmp1, innodb_temp_data_file_path, ibtmp1 mysql, innodb_temp_data_file_path = ibtmp1:12m:autoextend:max:5g, mysql tmpdir, mysql clear temp files, how to clean or resize the ibtmp1 file in mysql, transfer files hard disk disk, program count files hard disk, monitor hard disk size zenoss, hitachi hard disk firmware, saving wmv hard disk, hard disk firmware, external hard disk price sri lanka colombo, can save wmv hard disk, hard disk serial number assembly language

İşveren Hakkında:
( 0 değerlendirme ) grosseto, Italy

Proje NO: #19793144

Seçilen:

infihost

Hi, I will audit complete configuration of the server and will fix mysql issue. I will delete unused files from the server and free disk space on the server. I do have more than 9 years of expertise in web hosting, Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% EUR
(123 Değerlendirme)
5.8

Bu iş için 5 freelancer ortalamada €30 teklif veriyor

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(248 Değerlendirme)
7.0
kuldeepvk

Hi, I will fix this [login to view URL] discuss. I have more than 14 years of expertise in server side work. Thank you

€23 EUR in 0 gün içinde
(308 Değerlendirme)
6.9
Hostingshades

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% EUR
(90 Değerlendirme)
5.2
evonsystems7

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do th Daha Fazla

€27 EUR in 7 gün içinde
(1 Yorum)
0.0