FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour An option to optimize the mariadb/mysql tables
Posts: 1279
Joined: Mon Feb 06, 2006 04:28 PM
An option to optimize the mariadb/mysql tables
Posted: Tue May 24, 2022 03: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, el teclado y la IA!!"
Posts: 1276
Joined: Tue Dec 28, 2010 01:29 PM
Re: An option to optimize the mariadb/mysql tables
Posted: Tue May 24, 2022 03: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 25.12

Harbour/Hbmk2

Microsoft Visual C++

MySql 8.0

Antigravity

Posts: 1279
Joined: Mon Feb 06, 2006 04:28 PM
Re: An option to optimize the mariadb/mysql tables
Posted: Tue May 24, 2022 08: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, el teclado y la IA!!"
Posts: 1789
Joined: Tue Oct 11, 2005 05:01 PM
Re: An option to optimize the mariadb/mysql tables
Posted: Wed May 25, 2022 12:56 AM
Salu2

Carlos Vargas

Desde Managua, Nicaragua (CA)
Posts: 1772
Joined: Thu Sep 05, 2019 05:32 AM
Re: An option to optimize the mariadb/mysql tables
Posted: Wed May 25, 2022 05: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

Continue the discussion