PHP loader script with MariaDB - poor performance
- or -
Post a project like this- Posted:
- Proposals: 6
- Remote
- #2010444
- Expired
Description
customizable parameters such as record size, write I/O per seconds, number of commits
per write.
It starts regularly, but afterword (approx 4-600 physical write) it degradate in performance
becoming very slow, hence unusable for my scope. This application has been developed
as a benchmark, measuring its effect under datamirroring, DB replication and other stuff.
I tend to exclude any HW or OS performance, I install it on W2008 and Debian platforms
with same slow effects, Apache monitor doesn't reveal any degradation, OS performance
monitors measure approx 8-12% CPU time for PHP application or mysql process, so it's
presumably an application design limit or PHP/DB parameters that need to be reviewed.
Application can easily be tested from any site, either on Windows or Linux environment.
Budget estimation is required prior to assign the assignment.
Massimo R.
100% (8)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi
Looks to me you problem is with write locking manifesting itself falsely as poor disk i/o - the server will be timing out and reaching wait-lock-timeout threshold too quickly. Possibly the database schema needs optimized as well as your php code.
If you were able to send me a sql dump of your database and php code, I could send you a demonstration link on my server (Debian MariaDB 10.1) after it is optimized. -
Hello Massimo,
Please provide the database schema (the table definitions).
Regards,
John RMassimo R.14 May 2018Hello John,
DB is very simple, there isa single table with 3 fields : ID (INT-8, Timestamp VARCHAR-32, Datablock VARCHAR-1024). You can access the application and see the behaviour slowing down performance after few minutes. This is the address : http://80.211.130.114/benchmark/loadleveler.html -
i think , it may be occured from the poor code writings where php with connect mysql db. the reports and orther performance is poor. need the file of all the local server and do test. need the budget
Massimo R.14 May 2018Hi, thank you for answering my request. Guess you can figured out how it was implemented simply looking at it http://89.36.221.229/benchmark/loadleveler.html
You can access the application and see the behaviour slowing down performance after few minutes.Mustafiz C.14 May 2018so want php code now