1

PHP/MySQL Performance Testing with Just PHP

view story
linux-howto

http://serverfault.com – I'm trying to diagnose a server where the website is loading very slowly, but unfortunately my client has only provided me with FTP access. I've got FTP access so I can upload PHP scripts, but can't set up any other server side tools. I have access to phpMyAdmin, but not direct access to the MySQL server. It is also unfortunately a Windows server (and we've been a Linux shop for over a decade now). So, if I wan to evaluate MySQL & disk speed performance through PHP on a generic server, what is the best way to do this? There are already tools like: https://github.com/raphaelm/php-benchm (HowTos)

xskl's picture
Submitted by xskl on 09/08/2012

Stories similar to PHP/MySQL Performance Testing with Just PHP

Allow Your Applications To Access The XAMPP MySQL Server Directly If you want to have a full featured "LAMP" server with one step you can use "XAMPP", it's easy and fast but you can't access its MySQL database server using the regular "mysql" client (/usr/bin/mysql), you have to use its own client (/opt/lampp/bin/mysql) to do that.

Hello Friends, Access Your MySQL Server Remotely Over SSH | SSH Tunnel Everybody wants to secure their server and also wants to access application from remotely. So if you have MYSQL server, But bydefault its only opened for local machine for the security reasons. And if you want to access your database server or database [...]

Does anyone know how to change the LAN IP of your server and maintain connection to MySQL server.

I have phpmyadmin installed and when I changed the LAN IP I lost the ability to log in.

I recieved and error with: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I have a MySQL based website that also became unavailable when I try to acce

So I'm running crunchbang linux and installed mysql-server using the following terminal command:

sudo apt-get install mysql-server

Setup runs without problems, but when trying to access mysql I get "Error 1045 Access denied". The tutorial I used stated that during setup of mysql-server I'd be asked to set a password, but this step never happened.

We have a problem accessing an HTTPS site, it only happens to only one HTTPS site other corporate HTTPS sites are accessible behind the ubuntu server with ip 10.0.0.98 /29.

My MySQL server has broken down, and I can't figure out why. Trying to do a yum reinstall I get this: Error: mysql-server conflicts with mysql-server

I figure that's because the server already had the mysql server, and when I ran the upgrade, everything got messed up.

I'm unable to access MySQL, so I can't even do a mysqldump. How can I reinstall without compromising my existing databases?

I have 2 servers, both running Ubuntu server 11.10. The first server runs Apache and PHP and it connects to a Mysql database on the second server.

The problem is slow mysql response on the second server.mysql logs does not show any errros other than: 120526 12:56:27 [Note] Plugin 'FEDERATED' is disabled.

I am having problems connecting to remote mysql server. I am running two ec2 instances, one has mysql server configured and the other is from where I need to connect to.

Things I have done...

1. I have modified /etc/my.conf to comment out skip-networking and added bind-address to point to mysql server ip. 2. I made sure port 3306 is open for listening. 3.

Using OpenVPN to access MySQL 10 weeks 2 days ago

I have a server setup with Ubuntu Server 12.04 LTS and I use Windows 7 desktop to access a MySQL database for a CAD program I also have a Windows 7 laptop with similar setup. I would like to be able to access the MySQL database when outside my network, either using wifi or internet through my phone using easytether.