Table

• List database tables: show table, \dt *.*
• Delete rows of a table

• External table
• Foreign table
• Table Partitioning

Related terms

• MariaDB: MyISAM, InnoDB
• DESCRIBE TABLE_NAME
• ALTER TABLE_NAME
• iptables
• AWS Database Migration Service (DMS)
• GRANT SELECT ON ALL TABLES IN SCHEMA public TO xxx;
• GRANT SELECT ON mytable TO xxx

2020-05-05 5:56:00 139949468755712 [ERROR] mysqld: Table './xxxxx/searchindex' is marked as crashed and should be repaired

Activities

1. Read InnoDB Recovery Modes https://mariadb.com/kb/en/innodb-recovery-modes/

See also

• Table, foreign table, external table, show table, Delete rows of a table, Table Partitioning, \dt
• Databases: Database management, SQL, NoSQL, Wide column, PostgreSQL, MariaDB, MySQL, Derby DB, MongoDB, Cassandra, SQLite, HSQL2, H2, RocksDB, Microsoft SQL Server, DB2, Oracle Database, Memcached, Berkeley DB, Collation, SingleStore, Amazon Aurora, Graph database, Amazon DynamoDB, PrestoDB, Cache hit ratio, ACID, WAL, ARIES, DBMS, OLTP, OLAP, Database Schema, CockroachDB, Tables, Views, Apache Druid