Hi,
Thanks for the details. I can see that all datafiles are stored in different partitions. Are they using same file system?
innodb_data_file_path = /ssd/data/ibdata1:806578M; /mysql3/inno_db/data/ibdata2:390354M; /mysql4/inno_db/data/ibdata3:729522M; /mysql5/inno_db/data/ibdata4:370481M; /mysql5/inno_db/data/ibdata4:153M:autoextend
Also the size of ibdata4 file is,
-rw-rw---- 1 mysql mysql 388477485056 Mar 5 17:58 ibdata4
388477485056 = 379372544K = 370481M
Can you try to set below path and check if it works?
innodb_data_file_path = /ssd/data/ibdata1:806578M; /mysql3/inno_db/data/ibdata2:390354M; /mysql4/inno_db/data/ibdata3:729522M;/mysql5/inno_db/data/ibdata4:370481M:autoextend
OR
innodb_data_file_path = /ssd/data/ibdata1:806578M; /mysql3/inno_db/data/ibdata2:390354M; /mysql4/inno_db/data/ibdata3:729522M;/mysql5/inno_db/data/ibdata4:388477485056:autoextend
If you still see the issue then please provide /var/log/messages related to that disk. Waiting for your feedback.
Hi,
Thanks for the details. I can see that all datafiles are stored in different partitions. Are they using same file system?
innodb_ data_file_ path = /ssd/data/ ibdata1: 806578M; inno_db/ data/ibdata2: 390354M; inno_db/ data/ibdata3: 729522M; inno_db/ data/ibdata4: 370481M; inno_db/ data/ibdata4: 153M:autoextend
/mysql3/
/mysql4/
/mysql5/
/mysql5/
Also the size of ibdata4 file is,
-rw-rw---- 1 mysql mysql 388477485056 Mar 5 17:58 ibdata4
388477485056 = 379372544K = 370481M
Can you try to set below path and check if it works?
innodb_ data_file_ path = /ssd/data/ ibdata1: 806578M; /mysql3/ inno_db/ data/ibdata2: 390354M; /mysql4/ inno_db/ data/ibdata3: 729522M; /mysql5/ inno_db/ data/ibdata4: 370481M: autoextend
OR
innodb_ data_file_ path = /ssd/data/ ibdata1: 806578M; /mysql3/ inno_db/ data/ibdata2: 390354M; /mysql4/ inno_db/ data/ibdata3: 729522M; /mysql5/ inno_db/ data/ibdata4: 388477485056: autoextend
If you still see the issue then please provide /var/log/messages related to that disk. Waiting for your feedback.