I have a laravel application which must insert/update
thousands of records per second in a for loop
. my problem is that my Database insert/update
rate is 100-150 writes per second . I have increased the amount of RAM dedicated to my database but got no luck.
is there any way to increase the write rate for mysql to thousands of records per second ? please provide me configurations.
My storage engine is InnoDB