Hi,
I have a VPS Web server (Apache 2.4/PHP 7.x + Varnish 4.1) running with
MySQL 5.6. I have 20 Gb of RAM. I serve Wordpress sites mainly all using
innodb.
So I´m thinking of ways of improving MySQL performance and of course
for that, you need to measure.
Currently I´m checking, there are no
Dear all,
Not sure if this the right mailing list address for asking this.
Server running Centos and MySQL.
Client is a windows xp machine.
I have setup a SSH tunnel with putty and run mysql administrator. It
works fine with the root account.
With a non-root account I get
t
Dear all,
I'm a newbie in MySQL so bare my questions.
I have run mysqltuner.pl and It says I have fragmentation in my
tables. Searching around I found this script which reports the
fragmentation in my tables:
#!/bin/sh
echo -n "MySQL username: " ; read username
Dear all,
I have a pretty simple setup. A LAMP server in production and a
failover LAMP server in case the main server is down.
I have been searching around to find out a clear answer of how to
proceed when you need to promote a MySQL 5.5 slave server when the
master (also 5.5) has cra
