在Ubuntu上优化MariaDB查询速度,可以采取以下措施:
/etc/mysql/mariadb.conf.d/50-server.cnf
或 /etc/my.cnf
)innodb_buffer_pool_size = 4G
query_cache_size = 64M
max_connections = 500
tmp_table_size = 256M
max_heap_table_size = 256M
innodb_log_file_size = 256M
innodb_flush_log_at_trx_commit = 2
ulimit -n 65535
vm.swappiness = 10
vm.vfs_cache_pressure = 50
CREATE INDEX idx_column_name ON table_name(column_name);
EXPLAIN SELECT * FROM table_name WHERE condition;
OPTIMIZE TABLE table_name;
通过上述措施,可以显著提高MariaDB在Ubuntu上的查询速度。记得在每次更改配置后重启MariaDB服务以使更改生效。