ERROR 1114 (HY000) The table '' is full
客戶的5.1的mysql遷移到5.7,tb_mk_revisit_id是innodb表
$mysql -u root -p webparty < /data2/woqu/tbover6.sql
Enter password:
ERROR 1114 (HY000) at line 24612: The table 'tb_mk_revisit_d' is full
看是否每個innodb表單獨表空間,問題的原因就是innodb_data_home_dir設定到根目錄了,並且共享表空間很大了,30G,然後檔案系統滿了。就醬紫。。。。後來改回來了,
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29990276/viewspace-2216992/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ERROR 1114 (HY000): The table 'test1' is full 的解決Error
- alter table engine=memory ERROR 1114Error
- ERROR 1168 (HY000): Unable to open underlying table which isError
- MySQL ERROR 1031 (HY000) at line 33: Table storage engine forMySqlError
- ERROR 1786 (HY000): Statement violates GTID consistency: CREATE TABLE ... SELECTError
- ERROR 1206 (HY000): The total number of locks exceeds the lock table sizeError
- 【MySQL】ERROR 1005 (HY000): Can't create table' (errno: 150)MySqlError
- ERROR 1548 (HY000): Cannot load from mysql.proc. The table is probably corruptedErrorMySql
- ERROR 1005 (HY000): Can't create table 'starive.SC' (errno: 150)"Error
- 收集full table / index scan sqlIndexSQL
- The LRU Algorithm and Full Table Scans (81)Go
- ERROR 1005 (HY000): Can't create table'matrix.system_log' (errno: 150)Error
- Tuning Oracle Full-table ScansOracle
- ERROR 1010 (HY000): Error dropping databaseErrorDatabase
- ERROR 1524 (HY000): Plugin is not loadedErrorPlugin
- ERROR 2026 (HY000): SSL connection error: unknown error numberError
- SNMP TABLE ERROR : Requested table is empty or does not existError
- MySQL "ERROR 1010(HY000):Error dropping database(canMySqlErrorDatabase
- ORA-20010: INTERNAL ERROR: dumped min/max is null for table EXP.SYS_EXPORT_FULL_01ErrorNullExport
- MYSQL ERROR 2003 (HY000) CanMySqlError
- ERROR 1290 (HY000): The MySQL server is running withErrorMySqlServer
- ERROR 1290 (HY000) 解決辦法Error
- ERROR 1010 (HY000) mysql 5.5.19ErrorMySql
- MySQL 8.0.25 Bug 報"MY-013132 The table ...is full"MySql
- HPUX Error 23 File table overflowUXError
- 【MySQL】ERROR 1878 (HY000): Temporary file write failure.MySqlErrorAI
- Error!: SQLSTATE[HY000] [2002] Connection refusedErrorSQL
- kernel: ip_conntrack: table full, dropping packet.
- Oracle Exadata的TABLE ACCESS STORAGE FULL執行計劃Oracle
- 解決ERROR 1030 (HY000): Got error 168 from storage engine apparmorErrorGoAPP
- Mysql連線錯誤ERROR 2003 (HY000)MySqlError
- ERROR 1135 (HY000): Can't create a new threadErrorthread
- 【Mysql】ERROR 1872 (HY000): Slave failed to initialize relay log infoMySqlErrorAI
- ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL,ErrorFunctionNoneSQL
- 【TUNE_ORACLE】列出走了TABLE ACCESS FULL的SQL參考OracleSQL
- mysql 記憶體表The table 'pvlogs' is full問題處理MySql記憶體
- 【MySQL】5.6.x InnoDB Error Table mysql.innodb_table_stats not foundMySqlError
- [ERROR] Can't open the mysql.plugin tableErrorMySqlPlugin