Using --preserve-triggers on pt-online-schema-change results in this error message:
Percona-XtraDB-Cluster prohibits use of LOCK TABLE/FLUSH...
No content found
Show More
Please log in to your account to view your subscribed posts.
| Directory | Topics | Posts | Last Post | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Topics about Open Source Databases and related software.
Topics: 5,523
Posts: 18,693
|
5,523 | 18,693 | |||||||||||||
|
Sub-Forums:
| |||||||||||||||
|
Employment topics on MySQL, OpenStack and open source-related topics (only)
Topics: 5
Posts: 2
Last Post:
Seeking a Senior DBA!
|
5 | 2 |
|
||||||||||||
|
Sub-Forums:
| |||||||||||||||
|
This is an open forum for MySQL meetup groups around the world. Ask, answer & share ideas with each other as well as with different MySQL meetup groups. Organizers can also request their own group subcategory to manage.
Topics: 0
Posts: 0
|
0 | 0 | |||||||||||||
-
-
The other day, i use pt-online-schema-change to add a column and index to a table,the table is about 1 Minion rows and the .ibd file size is about 5G...08-18-2017, 10:54 AM
-
Right after a restart TRUNCATEs are super quick, but when the buffer pool is getting filled (but not full) TRUNCATEs take 1-2 seconds halting all queries...08-18-2017, 05:07 AM