CMS: Vivvo CMS v4.7
Required Very Experienced PHP Programmer to Work on the Site Code.
[!!] Temporary tables created on disk: 87% (93K on disk / 107K total)
Explanation: queries are creating large temporary tables written to disk (800MB per query). Without memory (RAM) disk for mysql /tmp, site is completely unresponsive even with SSD disks. Too many concurrent queries causes /tmp full and mysql crash.
Dear Sir ,
Lets check for the slow quires and buffer size also check for the spaces . Also why its happen with the help of logs.
Normally the quires are not optimized in this case
BR,
Mohsin
Hello !
There are some options to resolve a problem:
1) you need to modify queries so big temporary files will be not created.
2) you need to optimize queries to decrease size of temporary tables to minimum
Probably you need to change of structure of tables and same connected things
Anyway current way is incorrect.
I have experience in big DB data queries. My current project have table with more than 170.000.000 records. Queries work quickly and don't depend on table size
So i can have a look at to decide how it can be fixed
Please ignore a milestone
Hi, I saw your project and i am good in PHP and its all CMS and Frameworks development including the Responsive Bootstrap Designing.
I am working from last 5 Years within the same technology.
Thanks..!
Riya
hello,
i am rupali birwa from bhopal .
i m comfortable with your requirements .
and i worked on html, css, jquery, java script, my sql, bootstrap.
i work with my development team.
we develop and design all most 25 projects .
thank you
rupali birwa