article thumbnail

Using Jobs to Perform Schema Changes Against MySQL Databases on K8s

Percona

Copyright (c) 2009-2023 Percona LLC and/or its affiliates Copyright (c) 2000, 2023, Oracle and/or its affiliates. mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02 mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02 Your MySQL connection id is 256 Server version: 8.0.32-24.2

article thumbnail

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

Percona

WordPress also benefited from and popularized MySQL, introducing the LAMP stack – and open source – to an audience that might never have touched a database before or had any intro to open source. MySQL was founded in 1995 and went open source in 2000. MySQL was the database for phpWebLog, for example, way back in 2000.

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

Impact of Querying Table Information From information_schema

Percona

On MySQL and Percona Server for MySQL , there is a schema called information_schema (I_S) which provides information about database tables, views, indexes, and more. You can read some optimization examples in the official doc: [link]. Results for Percona Server for MySQL 8.0 While you are on 5.7, Try Percona Distribution for MySQL today!

Cache 104
article thumbnail

Purging Data When the Table Is Big and Has Children Tables

Percona

Check the database’s topology, whether one or more servers were replicating, if it was a Percona XtraDB Cluster , etc. The person who tried to run this in production did not do the following: Run some previous backups of the rows to delete. Check if the table had referential integrity, child tables. Check the size of the table.

Database 102
article thumbnail

Back-to-Basics Weekend Reading - Practical Applications of.

All Things Distributed

Werner Vogels weblog on building scalable and robust distributed systems. At the end of the 80s Ceri and Widom were researching the fundamentals of integrity constraints in databases. Widom, In 26th Very Large Data Bases Conference Proceedings, Cairo, September 2000, Pages 254-262. By Werner Vogels on 05 April 2013 08:30 AM.

article thumbnail

Percona’s MySQL Audit Log Plugin – An Enterprise Feature at a Community Price

Percona

The need to audit who is using a database and their activities is crucial in many environments. 22 Percona Server (GPL), Release '22', Revision '7e301439b65' Copyright (c) 2009-2022 Percona LLC and/or its affiliates Copyright (c) 2000, 2022, Oracle and/or its affiliates. Percona Server for MySQL is a drop-in replacement for MySQL.

article thumbnail

Back-to-Basics Weekend Reading - Epidemics - All Things Distributed

All Things Distributed

Werner Vogels weblog on building scalable and robust distributed systems. My paper to read this weekend was the Alan Demers seminal paper on epidemic techniques for database replication. reliable and scalable distributed systems. scalable distributed systems. Epidemic algorithms for replicated database maintenance.