Tag Archives: MySQL

Description: As we know, we can’t create a function-based index on MySQL, not like PostgreSQL (https://www.postgresql.org/docs/current/indexes-expressional.html). Usually, we should avoid using functions in the where …

  Recently, i used a user-defined variable to store some values, and it showed an unexpected result. I updated rows using ‘where a in (@var)’, but this query …

  Sometimes when we get ERROR messages such as the communication failure, MySQL server not responds your requests, or we want to know what the …

  Have you tried connecting to your MySQL server only to get the annoying error, “too many connections” ? This means that the number of …

  Sometimes when we want to insert rows into a table which contains duplicate keys, then we consider using ‘replace into’ or ‘insert into … …

  Previously i just shared the full backup script. Now we will take incremental backups using last_checkpoints. Basically, what this script will do is that …

  Below is the simple script for taking non-blocking Mysql physical backup using percona xtrabackup toolkit. This backup is encrypted using AES256 algorithm. [crayon-6744215807ff0588254709/]   –extra-lsndir:  save …

Before installing MySQL instance, we must evaluate the CPU, Memory, Disk IO performance, Disk size, network of the server, also the maximal QPS(Query Per Second), concurrent …

  Percona XtraDB Cluster is a active/active database clustering solution for MySQL. It ensures high availability, prevents downtime and data loss, and provides linear scalability …

  Percona Xtrabackup is  open source  backup solution for Percona & mysql server. It will not block the database or very minimal lock while performing …