An option to optimize the mariadb/mysql tables

[jose_murugosa]

Quisiera agregar si es posible, una opción que permita optimizar las tablas mariadb/mysql de un cliente que tiene tablas sumamente grandes de vez en cuando, ¿Cuál sería la forma más segura y sencilla de optimizarlas?


I would like to add, if possible, an option to optimize the mariadb/mysql tables of a client that has extremely large tables from time to time, what would be the safest and easiest way to optimize them?

Gracias desde ya
thanks since now

[Compuin]

Quisiera agregar si es posible, una opción que permita optimizar las tablas mariadb/mysql de un cliente que tiene tablas sumamente grandes de vez en cuando, ¿Cuál sería la forma más segura y sencilla de optimizarlas?


I would like to add, if possible, an option to optimize the mariadb/mysql tables of a client that has extremely large tables from time to time, what would be the safest and easiest way to optimize them?

Gracias desde ya
thanks since now

Hola Jose,

Utilizar indices si no los tiene.

[jose_murugosa]

Muchas Gracias por contestar.

Thank you very much for answering.

Lo consideraré.

[carlos vargas]

https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html

[Jimmy]

hi,

when you talk about "Optimize" than i have to ask how have you "Config" MariaDb/MySQL

under PostgreSQL i have "postgresql.conf" to change Default Settings and "optimize" SQL Server
for PostgreSQL there is a Website (have to search Link) where you can enter your Server Data ( Cores, RAM etc.) for your Environment you want to use it (WEB,"Desktop", Large Files ...)

is there a Website for MariaDB / MySQL to get these Information