3
votes
3answers
4k views

How to check throughput (query per second) of a database?

I have PostgreSQL dbms. I want to check live throughput of the DBMS. I want to build a graph of throughput which will be updated every 10 seconds. How do I do that? Any suggestion for MySQL will ...
0
votes
2answers
145 views

MySQL sudden throughput increase

What could be the cause of a sudden increase in MySQL throughput (from an average of 1.5M/s to 7.5M/s). The system is running WordPress on a trafficked site (2M monthly pageviews). The throughput is ...
1
vote
5answers
1k views

DMZ configuration and firewall throughput

I've been asked to look into placing a firewall between a webserver (Debian/Apache/PHP) in the DMZ and a backend MySQL database to achieve "isolation". Right now, iptables is running on the MySQL ...