2015-03-04 05:49:06 60863 [ERROR] InnoDB: Linux Native AIO not supported. You can either move tmpdir to a file system that supports native AIO or you can set innodb_use_native_aio to FALSE to avoid this message.
2015-03-04 05:49:06 60863 [ERROR] InnoDB: Linux Native AIO check on tmpdir returned error[22]
you should not put tmpdir into memfs to avoid this error.
"Made a typo and got the server online with this statement:
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"
Here, I can see ibdata4 twice, was it intentionally set? you mean with this, you were able to start server?
Can you please provide my.cnf and what is the current page size you are using for InnoDB? (by default, it is 16K)
Hi,
First error in log,
2015-03-04 05:49:06 60863 [ERROR] InnoDB: Linux Native AIO not supported. You can either move tmpdir to a file system that supports native AIO or you can set innodb_ use_native_ aio to FALSE to avoid this message.
2015-03-04 05:49:06 60863 [ERROR] InnoDB: Linux Native AIO check on tmpdir returned error[22]
you should not put tmpdir into memfs to avoid this error.
"Made a typo and got the server online with this statement: 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 "
innodb_
Here, I can see ibdata4 twice, was it intentionally set? you mean with this, you were able to start server?
Can you please provide my.cnf and what is the current page size you are using for InnoDB? (by default, it is 16K)