Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

test load PHP, MySQL, Linux server

Posted on 2011-10-23
7
Medium Priority
?
385 Views
Last Modified: 2012-06-27
Hi,

I'm wondering which tools I can use to test load some PHP/MySQL programs running on a Linux system (Centos). Open sourced or paid ones. I have one site in particular (http://www.personals1001.com) and it seems to slow down with more than 20 members. Not all the time but sometimes. I'm thinking that I can do some call stack trace using Eclipse debugger but I use another IDE which uses a different debugger. I suppose I can set up another environment specifically for Eclipse though.

But are there some good tools I can use just to install on my Centos server and then see how many users this site can handle?

I'd like to load test other sites too that are hosted on shared hosting servers (if possible).

Thanks,
Victor
0
Comment
Question by:Victor Kimura
7 Comments
 
LVL 81

Assisted Solution

by:arnold
arnold earned 1332 total points
ID: 37014372
Add slow query check on the mysql server to make sure it is not the issue.
use phpmyadmin to see whether there are adjustments you can make to improve the performance of your mysql.

There are tools i.e.curl that lets you generate request to the PHP pages and such.

http://www.opensourcetesting.org/performance.php

Check the specs of your server and then compare that to the settings of apache/mysql to make sure you are not allocating more memory in the applications than your system has.
0
 
LVL 25

Accepted Solution

by:
madunix earned 668 total points
ID: 37014978
0
 
LVL 111

Expert Comment

by:Ray Paseur
ID: 37016712
Where is this hosted?  Is it on a shared server?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:Victor Kimura
ID: 37028803
It's on westhost. It's a business plan VPS but it's an older plan which they no longer have posted.
0
 

Author Comment

by:Victor Kimura
ID: 37028857
Hi arnold,

"...Check the specs of your server and then compare that to the settings of apache/mysql to make sure you are not allocating more memory in the applications than your system has..."

How do I do this? What am looking for? How do I check the specs? Commands?

Where do I check if I'm allocating more memory to the applications than my system has?

Thank you,
Victor
0
 
LVL 81

Assisted Solution

by:arnold
arnold earned 1332 total points
ID: 37029198
Can you install phpmyadmin on your system?  it is a web based tool to manage mysql and provides performance statistics and performance improving suggestion by using the output from show status among other parameters.
The settings for mysql dealing with temp db, etc. deals with how much resources mysql can use.  At times the configuration does not match actual use i.e. you think there will be 50 simulteneous connection but there are more, or the queries you have require more memory buffer than you allocated etc.

top -n
cat /proc/meminfo
0
 

Author Closing Comment

by:Victor Kimura
ID: 37051147
Okay, thank you. Will test out those commands.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article discusses how to implement server side field validation and display customized error messages to the client.
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question