An option to optimize the mariadb/mysql tables

An option to optimize the mariadb/mysql tables

Postby jose_murugosa » Tue May 24, 2022 3:11 pm

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
Saludos/Regards,
José Murugosa
"Los errores en programación, siempre están entre la silla y el teclado y la IA!!"
User avatar
jose_murugosa
 
Posts: 1180
Joined: Mon Feb 06, 2006 4:28 pm
Location: Uruguay

Re: An option to optimize the mariadb/mysql tables

Postby Compuin » Tue May 24, 2022 3:31 pm

jose_murugosa wrote: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.
FWH 20.12
Hbmk2 32/64 Bits (Build 19.29.30133)
Microsoft Visual C 32 Bits
MySql 8.0.24 32/64 Bits
VS Code
Compuin
 
Posts: 1214
Joined: Tue Dec 28, 2010 1:29 pm
Location: Quebec, Canada

Re: An option to optimize the mariadb/mysql tables

Postby jose_murugosa » Tue May 24, 2022 8:00 pm

Muchas Gracias por contestar.

Thank you very much for answering.

Lo consideraré.
Saludos/Regards,
José Murugosa
"Los errores en programación, siempre están entre la silla y el teclado y la IA!!"
User avatar
jose_murugosa
 
Posts: 1180
Joined: Mon Feb 06, 2006 4:28 pm
Location: Uruguay

Re: An option to optimize the mariadb/mysql tables

Postby carlos vargas » Wed May 25, 2022 12:56 am

Salu2
Carlos Vargas
Desde Managua, Nicaragua (CA)
User avatar
carlos vargas
 
Posts: 1720
Joined: Tue Oct 11, 2005 5:01 pm
Location: Nicaragua

Re: An option to optimize the mariadb/mysql tables

Postby Jimmy » Wed May 25, 2022 5:48 am

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 :idea:
greeting,
Jimmy
User avatar
Jimmy
 
Posts: 1732
Joined: Thu Sep 05, 2019 5:32 am
Location: Hamburg, Germany


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 81 guests