Table

• List database tables: show tables, \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

• Datatables
• TRUNCATE

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 (PARTITION BY RANGE), \dt, Hash table, CREATE TABLE, DROP TABLE, ALTER TABLE, SHOW TABLES, TRUNCATE
• 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, RDMS, TSDB, ScyllaDB, Very large database (VLDB)