Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: percona

How can I make an Async Slave track all of the nodes in a Percona XtraDB Cluster?

By adminPosted on February 2, 2023

Question : I’m seeing a lot of tutorials that claim I have to pick just one of the nodes in […]

Mysql error : Slave SQL Could not execute …on table

By adminPosted on February 1, 2023

Question : Im running a percona cluster of 3 nodes. Yesterday I needed to throw some more memory in them, […]

Flush Host Connection Blocked, but some connections allowed

By adminPosted on January 20, 2023

Question : We are running Percona MySQL 5.6.30. We’ve had an issue where a PHP script on a different host […]

MySQL8: xtrabackup Invalid stream argument: tar

By adminPosted on January 18, 2023

Question : I am using xtrabackup to take full backup and send it to another host as .tar file using […]

truncate table in mysql 8.0 is slower than older version

By adminPosted on January 16, 2023

Question : I have few hundreds of tests which use mysql. I was using Mysql 5.7 (percona) and I changed […]

Using CONVERT TO CHARACTER SET for changing only collation?

By adminPosted on January 11, 2023

Question : I think the answer to this is an obvious yes, but I’m having trouble finding confirmation on it. […]

Can’t restore master/slave replication from Percona backup (slave server)

By adminPosted on January 8, 2023

Question : A slave is restored from a master backup created with Percona xtrabackup On the master binlog is set […]

Does Percona Xtrabackup support RedHat release 4

By adminPosted on January 6, 2023

Question : I downloaded Percona’s Xtrabackup rpm file for RedHAT. I attempted to install but hit into an error. The […]

Difference between FIND_IN_SET and LIKE

By adminPosted on January 5, 2023

Question : Is there a difference in behavior or performance in choosing FIND_IN_SET over LIKE for a operation that looks […]

xtrabackup prepare – after dump or before restore?

By adminPosted on December 20, 2022

Question : i have doubts about xtrabackup –apply-log. is there any difference when use it? should it be done right […]

  • 1
  • 2
  • 3
  • …
  • 23

Recent Posts

  • Restored database copy larger than original
  • SQL Server Failed Login – SQL Server login (not windows) – Random times
  • Steps or evaluation order of the SQL statement
  • Can I kill these MSCRM related SQL processes?
  • Postgres to Postgres DBLink with AWS/RDS
  • What are the pros and cons of having more data-bearing members in a MongoDB replica set? [closed]
  • Transaction log backup after full backup is too big
  • Strange behavior with Quotename and substring [closed]
  • MySQL slow select from a view
  • CREATE INDEX vs ALTER TABLE ADD INDEX – MySQLism, or SQL Standard?
  • How to run my query on a one-to-many relation to run efficiently
  • Can I get SSMS to show me the Actual query costs in the Execution plan pane?
  • What are the best Database Analytics Companies for analyzing several 1000s or Mio. of products,sum them together and analyze them for statistics?
  • How to list the permissions on User-Defined Table Types?
  • Do I need an auto-generated ID in addition to a unique field?
  • Why should foreign keys be implemented in my relational database? [duplicate]
  • Difference between changed compatibility level database and new database
  • Does a query with a primary key and foreign keys run faster than a query with just primary keys?
  • What is the limit on the number of INSERT statements you can paste into SSMS and run?
  • String or separate Table

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding