Skip to main content

New answers tagged

0 votes

How can I change the default storage engine in phpmyadmin?

MyISAM is the default storage engine for WAMP/XAMP. So if you want to change default engine, just follow the instructions. Locate the MySQL configuration file my.ini. Find the default-storage-engine ...
Nayan Chandra Datta's user avatar
-1 votes

How to change default engine in WAMP to InnoDB

MyISAM is the default storage engine for WAMP. So if you want to change default engine, just follow the instructions. Locate the MySQL configuration file my.ini. Find the default-storage-engine ...
Nayan Chandra Datta's user avatar
0 votes

How innodb alter table inplace algorithm inner work?

This link explains in detail how the INPLACE changes works. I can't see a date on it so not sure how up-to-date it is, but it seems to be reasonably current: https://klouddb.io/understanding-how-...
Phil Sumner's user avatar
  • 1,897
0 votes

InnoDB Cluster ALTER large tables without causing lag

I would use pt-online-schema-change. The --max-flow-ctl is specific to PXC, but --max-lag works on any replication setup. Or don't use --max-lag either. One advantage of pt-osc is that the alter runs ...
Bill Karwin's user avatar
  • 15.2k
0 votes

Mysql/innodb deadlock on simple delete query

I've seen a similar issue, though my exact details are a bit different. Maybe this helps you narrow down a culprit for your exact issue. Try running an EXPLAIN on your query to figure out how the ...
Johannes Rudolph's user avatar
0 votes

What is causing my ERROR 2002 (HY000): Can't connect to local server through socket '/tmp/mysql.sock' (2)?

Have you tried running mysql.server start? I was having the same issue, and after three days of debugging, came across this post. They recommended running mysql.server start, and I don't know why, but ...
Krislunde's user avatar
0 votes
Accepted

Delay Async Replication Time ClusterSet

I assume you are using InnoDB ClusterSet. Currently, it's not supported to configure delayed replication in such architecture. You can configure it manually, however, you must understand the ...
Miguel Araújo's user avatar
0 votes

It's possible switchover a innodb cluster instance as primary?

First, MySQL 5.7 has been EOL since October 2023, so I highly recommend upgrading to 8.x. About your specific question: .setPrimaryInstance() is not supported on MySQL 5.7. That has been introduced in ...
Miguel Araújo's user avatar

Top 50 recent answers are included