Shulou(Shulou.com)06/01 Report--

1. Start MySQL service

2. Check whether the port is running

3. Set password or change password for MySQL.

4. Log in to MySQL database.

5. View the character set of the current database

6. View current database version

7. View currently logged in users.

8. Create the database oldboy of GBK character set and view the complete statement of the established library

9. Create user oldboy to manage database oldboy

10. See what permissions created user oldboy has

11. See which users are currently in the database

12. Enter the oldboy database

13. Create an innodb GBK table test with fields id int(4) and namevarchar(16)

14. View SQL statements that create table structures and table structures

15. Insert a piece of data "1,oldboy"

16. Then insert 2 rows of data "2, old boy" and "3,oldboyedu" in batches.

17. Search for records named oldboy

18. Change the name oldboy with data id equal to 1 to oldgirl

19. Insert age field before field name, type tinyint(2)

20. Complete backup of oldboy database without exiting database

21. Delete all data from the test table and view

22. Delete the test and oldboy databases and view

23. Restore deleted data without exiting database

24. Change GBK character set of library table to UTF8.

Set the id column to the primary key and create a normal index on the Name field.

26. Insert the cell phone number field (shouji) after the field name, type char(11).

27. Insert 2 records in all fields (self-set data)

28. Create a normal index for the first 8 characters on the phone field.

29. View information such as the index created and the index type.

30. Remove the index of the Name, shouji column.

31. Union index the first 6 characters of the Name column and the first 8 characters of the Phone column.

32. Query records with cell phone numbers starting with 135 and names oldboy (insert in advance).

33. Query the execution plan of the above statement (whether to use union index, etc.).

Change the engine of the test table to MyISAM.

35. Withdraw select permission from oldboy user.

36. Delete the oldboy user.

37. Delete the oldboy database.

38. Close the database using mysqladmin.

39. MySQL password lost, please retrieve?

(2) MySQL operation and maintenance basics interview questions

(Requirements: 4 people in a group, one person asks questions, one person answers, others add, try to describe all orally in their own language)

Question 001: Please explain the concept and main characteristics of relational database.

Question 002: What are the typical products, characteristics and application scenarios of relational databases?

Question 003: Please explain the concept and main characteristics of non-relational database.

Question 004: What are the typical products, characteristics and application scenarios of non-relational databases?

Question 005: Please describe the SQL statement classification and corresponding representative keywords in detail.

Question 006: Describe the difference between char(4) and varchar(4).

Question 007: how to create a utf8 character set database oldboy?

Question 008: How to authorize oldboy users to access the database from 172.16.1.0/24.

Question 009: What is MySQL multi-instance and how to configure MySQL multi-instance?

Question 010: How to strengthen MySQL security, please give feasible specific measures?

Question 011: MySQL root password forgotten how to retrieve?

Question 012: What is the difference between delete and truncate?

Question 13: How to solve MySQL Sleep thread overload?

Question 014: What does the sort_buffer_size parameter do? How do online modifications take effect?

Question 015: How to clean MySQL binlog correctly online?

Question 016: What are Binlog's work patterns? What are the characteristics and how do companies choose?

Question 017: Mistake execution of a drop library SQL statement, how to complete recovery?

Question 018: mysqldump backup uses-A -B parameters. How to restore single table?

Question 019: Describe MySQL master-slave replication principle and complete steps for configuring master-slave.

Question 020: How to open the binlog function of the slave library?

Question 021: How does MySQL achieve two-way master-slave replication and explain the application scenario?

Question 022: How does MySQL achieve cascade synchronization and explain the application scenario?

Question 023: How to solve MySQL master-slave replication failure?

Question 024: How to monitor whether master-slave replication fails?

Question 025: How does MySQL database achieve read-write separation?

Interview question 026: How to manually recover from the downtime of one master and many slaves in production?

Interview Question 027: How to manually recover from the downtime of the main database?

Question 028: What database failures have you encountered in your work? Please describe 2 examples.

Question 029: What are the reasons for MySQL replication delays? How?

Question 030: Give a feasible backup solution for large-scale MySQL cluster architecture in enterprise production?

Question 031: What is a database transaction and what are its characteristics? How do companies choose?

Question 032: Please explain the concept of full preparation, additional preparation, cold preparation, hot preparation and practical experience of enterprises?

Question 033: How to optimize MySQL SQL statements?

Question 034: How to design backup solution for enterprise production MySQL cluster architecture?

Interview Question 035: Development has a bunch of data sent to dba execution, DBA execution need to pay attention to what?

Question 036: How to adjust the character set of MySQL database in production line.

Question 037: Please describe the principle of Chinese data garbled in MySQL. How to prevent garbled data?

Interview Question 038: How to optimize enterprise production MySQL (please describe it from multiple angles)?

Interview Question 039: What are MySQL high availability solutions, their respective characteristics, how do enterprises choose?

Interview question 040: How to backup and restore in batches (dictation script implementation process)?

Question 041: How to change the engine of database tables in batches?

Question 042: How to change the database character set in batches?

Interview question 043: website open slow, please give the troubleshooting method, if the database slow cause,

How to investigate and solve, please analyze and give examples?

Question 044: How does xtranbackup backup, incremental backup and restore work?

Question 045: How to recover dropped data by xtranbackup?

Question 046: How to check the consistency of master-slave data

Question 047: How to monitor MySQL's addition, deletion and revision times?

Question 048: MySQL index types and working principles.

Question 049: Please describe the locking mechanism of MySQL's different engines.

Question 050: Please describe the four transaction isolation levels supported by InnoDB and their characteristics.

Question 051: How to customize scripts to start MySQL(say key commands)

Question 052: How to customize scripts to smoothly close MySQL(say key commands)

Interview Question 053: MySQL Mha High Availability Software Detailed Working Principle

Question 054: How does your company achieve database read-write separation?

Question 055: Please describe MySQL architecture knowledge briefly.

Question 056: Please briefly describe the internal structure principle of InnoDB engine?

================================================================

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.