I'm doing a massive insert to a virtual table in mysql my application falls down because of problems on the server so t 1: it is the connection time 2: memory in the cache
is a dedicated server of 1 tera and 8 gb in ram so I want to increase the performance of my BD for more and more that I'm looking for not achieving how to change the configuration but if I have to update it I need to update
The first thing you must do is enter Phpmyadmin, if it is your case and you have it installed and you go to the option "Show MYSQL Execution Time Information" and show the variables of the system, it should be in the front principal. something like this:
> wget mysqltuner.pl
> chmod 755 mysqltuner.pl
> perl mysqltuner.pl
You can also use this script that they recommend:
to see the analysis of your database which will give you some suggestions to modify your engine.
Greetings.