article thumbnail

Powering the Web: Two Decades of Open Source Publishing With WordPress and MySQL

Percona

While not the first open source content management system (CMS), WordPress caught on like nothing before and helped spread open source to millions. It was simple, easy to deploy, and easy to use, and WordPress had the added benefit of being open source. MySQL was founded in 1995 and went open source in 2000.

article thumbnail

Update Percona Monitoring and Management Agent Settings for Already-Added Instances

Percona

Percona Monitoring and Management is a best-of-breed open source database monitoring solution. I hope you find the article useful and somewhat entertaining. Also, if you feel a PMM feature is missing, you can file an enhancement request in our bugtracker.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Why MySQL Could Be Slow With Large Tables

Percona

ProxySQL: It is a feature-rich open-source MySQL proxy solution, that allows query routing for the most common MySQL architectures (PXC/Galera, Replication, Group Replication, etc.). MyRocks: MyRocks is a storage engine developed by Facebook and made open source. 1 mysql mysql 592K Dec 30 02:48 tb1.ibd ibd -rw-r --.

article thumbnail

What is Non-Functional Testing? – All you need to know

Testlodge

It’s an open-source program with extensive documentation. Zed Attack Proxy (ZAP) – by OWASP is an open-source web scanner with a user-friendly GUI for beginners or a command-line option for more advanced users. Wfuzz – an open-source security tool that uses brute force to expose vulnerabilities.

Testing 74
article thumbnail

Best MySQL DigitalOcean Performance – ScaleGrid vs. DigitalOcean Managed Databases

Scalegrid

MySQL is the all-time number one open source database in the world, and a staple in RDBMS space. DigitalOcean is quickly building its reputation as the developers cloud by providing an affordable, flexible and easy to use cloud platform for developers to work with. DigitalOcean. MySQL Version. innodb_buffer_pool_size.

Database 217
article thumbnail

Impact of Querying Table Information From information_schema

Percona

you can also consider increasing table_open_cache to avoid table_misses or at least use some filters on the “WHERE” clause to avoid opening all.frm files and limit the query to a subset of the tables for a limited performance impact. While you are on 5.7, Try Percona Distribution for MySQL today!

Cache 98
article thumbnail

Purging Data When the Table Is Big and Has Children Tables

Percona

test -A -e "select count(1) from test.orders" + -+ | count(1) | + -+ | 10000 | + -+ Percona Distribution for MySQL is the most complete, stable, scalable, and secure open-source MySQL solution available, delivering enterprise-grade database environments for your most critical business applications… and it’s free to use!

Testing 96