First at all, maybe this is not the correct thread, this
@george1421 said in Bottleneck on DATABASE:
First let me say that FOG isn’t designed for this large of an installation. But I’m sure there are things we can do to optimized the installation. The first step is to get the database running well. Then we can look into other tweaks to help productivity.
Yes I know, but it’s a good project that fits on our needs.
My database analisys reveals than there are too many table locks that fall in poor performance. With this test, changing myISAM by InnoDB change the table locks by row locks, first problem seems solved, and currently have ,on the first moment, a workload average 7 (200 points lesser) with client checkins about 45min 1hour. now we can add cache and memory temporary tables, that can help to get the best database performance.
The change has been do it, now we are on “Test mode” and it feels like a great hint, all the help to increase performance on the installation are wellcome, and feel free to request me information, im glad to help.
By the other way, now you can get information about the convenience about change the database engine to get more performance, I’ll report all information than you request to me and I can.
The change than i made was the ALTER TABLES, no php code was touched.