Dba: How to add index to a big table with 60M records without downtime?

Channel:
Peter Schneider
Subscribers:
4,130
Published on ● Video Link: https://www.youtube.com/watch?v=jSzB8BloUCI


Category:
Guide
Duration: 3:09
3 views
0

How to add index to a big table with 60M records without downtime?
I hope you found a solution that worked for you :)
The Content (except music & images) is licensed under (https://meta.stackexchange.com/help/licensing)CC BY-SA
Thanks to all those great people for their contributions!

(dba.stackexchange.com/users/284171/rohan)Rohan
(dba.stackexchange.com/users/877/rolandomysqldba)RolandoMySQLDBA
A special thanks goes out to the (https://dba.stackexchange.com/questions/334094/how-to-add-index-to-a-big-table-with-60m-records-without-downtime)Stackexchange community

I wish you all a wonderful day! Stay safe :)

online-operations percona-tools mysql-5.7 mysql amazon-rds



Other Videos By Peter Schneider


2023-12-20Mathematica: Wrong solution in a geometry problem
2023-12-20Salesforce: How to enable the FormulaEvalInApex and ApexZipSupport Feature in the Created Scratch...
2023-12-20Drupal: Drush 12 Installation in Hosting Environments
2023-12-20Drupal: Some results in a view appear twice or more
2023-12-20Drupal: Some results in a view appear twice or more
2023-12-20Bitcoin: When was the first OP_RETURN output in a coinbase?
2023-12-20Electronics: How do you identify the value of a resistor?
2023-12-20Codereview: Comparison of two excel files ignoring line order
2023-12-20Apple: The SSD not showing up correctly in diskutil in recovery
2023-12-20Ethereum: How can we assign bytes to uint256 variables in solidity?
2023-12-20Dba: How to add index to a big table with 60M records without downtime?
2023-12-20Dba: T-SQL round current time down to the last 15 minute period
2023-12-20Tex: Expanding a l3 variable to split it
2023-12-20Mathematica: Solving Laplace Transform IVP
2023-12-20Unix: How to proberly deal with quotes in filenames when using variables/arrays including the fil...
2023-12-20Can pointers with different provenance be equal?
2023-12-20Wordpress: Ajax call to a function in another module returns a 400 (Bad Request) error
2023-12-20Merge two results from CTE's as separate columns
2023-12-20Can you convert std::vector to std::array at compile-time without making the vector twice?
2023-12-19Getopt::Long: Detect if no Options Passed
2023-12-19Setup with promtail + loki + grafana is not showing any log data


Tags:
online-operations
percona-tools
mysql-5.7
mysql
amazon-rds