The latest from the MySQL community

Rename table operations are common. When business situations and business requirements change, it becomes necessary to change the name of tables in MySQL databases. This article will explore various methods of renaming MySQL tables and essential related issues.

The post How to Change a Table Name in MySQL in Different Ways appeared first on Devart Blog.

Now that the call for participation is open, let me present the selection committee members that will read, evaluate, and rate your submissions.

Committee members are responsible for evaluating and scoring proposals.
They must also consider certain constraints, such as that the project must be open source, and that the session must be technical and in English. The best proposals will be selected for the devroom on Sunday afternoon.

Daniël van Eeden

Daniël van Eeden has been an active member of the MySQL community for many years. Besides contributing to MySQL, Wireshark, go-mysql, DBD::MySQL, and …

Even though I used a dedicated Kubernetes cluster to host my test database, I had this belief that by not explicitly allocating (or requesting, in Kubernetes vocabulary) CPU resources to my Percona XtraDB Cluster (PXC) pods or yet making just a small request, Kubernetes could be delaying access to the free CPU cycles available on […]

In this podcast, we’ll explore the issue of duplicate indexes in MySQL; including redundant index, foreign keys, left-prefixed secondary index /w primary key, and how to tackle the issue at…

The post Podcast: Duplicate Indexes in MySQL first appeared on Change Is Inevitable.

The latest update to MySQL Enterprise edition, version 9.1, introduces significant enhancements focused on replication monitoring. This update includes improvements to Group Replication Flow Control and the replication applier, providing users with better visibility and control over their replication performance, leading to potential long-term cost savings by ensuring efficient usage of their machine resources.

Different ways to get the status:

mysqlsh --login-path=icadmin -h$MYROUTER1 -- cluster status

mysqlsh --login-path=icadmin -h${HOSTNAME} --redirect-primary -- cluster status

mysqlsh icadmin:'P4ssw0rD'@db01:3306 -- cluster status --extended=0

mysqlsh icadmin@$MYROUTER1:3306 -- cluster status --extended=1

watch -n 5 “mysqlsh --login-path=icadmin -h$MYROUTER1 -- cluster status”

Set the Primary Instance (switching):

mysqlsh --login-path=icadmin -h${HOSTNAME} --redirect-primary -- cluster set_primary_instance "db01"

Obtaining MySQL InnoDB Cluster basics:

select cluster_id, cluster_name, description, cluster_type, primary_mode, clusterset_id from mysql_innodb_cluster_metadata.clusters;

Members of our cluster:

select * from performance_schema.replication_group_members order by MEMBER_ROLE;

Local & Remote Trans Q’s:

 …

For years, MySQL has been a cornerstone for businesses worldwide. Its ease of use and built-in data replication features have made it a perfect fit for creating high available databases. Moreover, it has made it possible to design and implement simple business continuity solutions based on live snapshots trough replication. As setups become more complex […]

BSE Limited (previously Bombay Stock Exchange) is Asia’s oldest stock exchange with a rich history of 150 years. It is the largest securities market with over 5,300 companies listed. BSE enables investors to trade equities, currencies, debt instruments, derivatives, and mutual funds. BSE Sensex represents 30 of India’s largest and most well-capitalized stocks and is […]

BSE leverages MySQL Enterprise Edition for processing 150 million trades and 5 billion orders per day.

So, we’ve heard that jemalloc is better than malloc for MySQL usage, and in fact, certain versions / forks of mysql already include this, eg. Percona Server (https://github.com/percona/jemalloc).

But, how can I install and configure my system to use it?

Here’s a quick push in the, hopefully, right direction.

First things first, what is “jemalloc” and how does it affect my system? I think it’s quite well explained here: https://www.percona.com/blog/impact-of-memory-allocators-on-mysql-performance/ albeit an old article.

The right place to get the latest …