Automatically optimize all tables in a MySQL database
-
i need to optimize all tables in a MySQL database automatically. can you please help to make programe c#.net
-
i need to optimize all tables in a MySQL database automatically. can you please help to make programe c#.net
- What does optimize mean? What will you be doing with the tables?
- We got a database-forum
- Your question for help on C# is too broad; you make a C# app like all the others, and you can get help with specific questions. You'll have to do the writing yourself.
- Can you show us an example of a table before and after "optimization"?
Looking forward to your answers.
Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]
-
- What does optimize mean? What will you be doing with the tables?
- We got a database-forum
- Your question for help on C# is too broad; you make a C# app like all the others, and you can get help with specific questions. You'll have to do the writing yourself.
- Can you show us an example of a table before and after "optimization"?
Looking forward to your answers.
Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]
Hi, In our data base have more than 150 tables available. In every day some table have delete and update operation is going. While after the delete memory is stored in temp. When I tried to open schema, it’ll take some time. I need to make faster in my schema. What can I do? That’s only I selected optimize all table in mysql. Thanks, P.Alagiri
-
Hi, In our data base have more than 150 tables available. In every day some table have delete and update operation is going. While after the delete memory is stored in temp. When I tried to open schema, it’ll take some time. I need to make faster in my schema. What can I do? That’s only I selected optimize all table in mysql. Thanks, P.Alagiri
I suggest you start in the database-forum; to check whether your indexes are correct, whether you could benefit from partitioning the data, whether your table-structure is correct.. The usual things a DB-admin does when the db is too slow. C# has little to do with it.
Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]