> phpmysql 7.0.27
7.0.27 is the latest php version. What is your mysql version?
What performance problems are you trying to solve?
Slow queries? Turn on the slow query log and optimise the slow queries using Explain.
Memory overuse & swapping? Reconfig and/or add mem, let's see the mysql client results of ...
show variables;
show global status;
select engine,data,indexes,total
from (
select
ifnull(engine,'TOTALS') as engine,
concat(data,' GB') as data,
concat(indexes,' GB') as indexes,
concat(tot,' GB') as total,
if(engine is null,-1,tot) as ord
from (
select
engine,
round( sum(data_length)/1024/1024/1024, 1 ) as data,
round( sum(index_length)/1024/1024/1024, 1 ) as indexes,
round( sum(data_length+index_length)/1024/1024/1024, 1 ) as tot
from information_schema.tables
where engine is not null and engine not in('information_schema','performance_schema')
group by engine with rollup
) sums
) list
order by list.ord desc;
... and from the CentOS command terminal ...
free -m