Thank you Mr. Visvanath Ratnaweera for your support. One main mistake i made was my mysql collation was default instead of utf8mb4_unicode_ci.I changed that.
Second thing needs to care is ulimit in ubuntu os it was 1024 by default.
Second thing needs to care is ulimit in ubuntu os it was 1024 by default.
Third changed mpm_prefork to mpm_event.
I conducted quiz upto 1200 peak.It was fine ..The Highest usage of available connection was only 15-20 up to 900 users, but all of a sudden the highest db usage goes up to 302 for above 1000 users.But i did't face any issue as it uses only 50%of ram. Is that a real scenario happening or some configuration mistakes .Now I enabled memcached in php lets see how the performance goes.
I conducted quiz upto 1200 peak.It was fine ..The Highest usage of available connection was only 15-20 up to 900 users, but all of a sudden the highest db usage goes up to 302 for above 1000 users.But i did't face any issue as it uses only 50%of ram. Is that a real scenario happening or some configuration mistakes .Now I enabled memcached in php lets see how the performance goes.