MySQL practical tips by Experts - Part 1

Answers to common MySQL FAQs
Instructed by: Aws databaseguru | Subject: IT & Software, IT Certification

Description

This course focuses on practical tips for MySQL admins(DBAs) ,engineers and developers. It is designed by experts with 10+ years of MySQL/RDBMS experience. It is designed in question and answer mode to answer common FAQs. Mysqldump(backup) best practices , pt-kill to find long running queries , methods to execute scripts , password security , static/dynamic variables , Error log monitoring are some of the topics discussed. This is part 1 of the series.

Outcome

1. Start and stop MySQL
2. MySQL security
3. mysqldump best practices
4. Error log
5. Force Index Vs Use Index
6. Executing scripts
7. Connections usage in MySQL
8. Pt-kill to find long running queries

Take This Course

Course Info

• 13 Lectures
• 33 Minutes
• Language: English
• Subject: IT & Software, IT Certification
• Instructed by: Aws databaseguru
• Last updated on October 2017
• Platform: Udemy