Dumpsbuddy logo
After rebooting the host, you attempt to start the mysqld service. You get the following error:
Can’t start the server: Bind on TCP/IP port: Address already in use
What is the most likely cause of this error?
A MySQL server was initialized with separate UNDO tablespaces. Users complain that when they roll back large transactions, the time to process the request takes too long. The DBA would like to move the MySQL InnoDB UNDO tablespace to a solid-state drive (SSD) for better performance. Is this possible and how?
Consider the join_buffer_size parameter in MySQL Server.
Which two statements are true about the join buffer? (Choose two.)
You will configure a MySQL Server to act as a replication master. Which two options must be configured correctly to allow this? (Choose two.)
You have installed MySQL Server for the first time on your system. However, the data directory along with the tables in the mysql system database are missing. Which step do you perform to create the contents of the data directory?
A single InnoDB table has been dropped by accident. You are unable to use an additional intermediate MySQL instance to restore the table. Which two backup methods can be used to restore the single table without stopping the MySQL instance? (Choose two.)
The ‘applicationdb’ is using InnoDB and consuming a large amount of file system space. You have a /backup partition available on NFS where backups are stored.
You investigate and gather this information:
Three tables are stored in the InnoDB shared tablespace and the details are as follows:
You attempt to free space from ibdata1 by taking a mysqldump of the data_archive table and storing it on your backup partition.
Unfortunately, this action does not free any actual disk space back to the file system and the server disk space is running out.
Which set of actions will allow you to free disk space back to the file system?
Enable compression on the table, causing InnoDB to release unused pages on disk to the file system:
Execute OPTIMIZE TABLE so that the InnoDB engine frees unused pages on disk back to the file system:
Set the server to use its own tablespace, and then alter the table so that data is moved from the shared tablespace to its own:
Take a backup, stop the server, remove the data files, and restore the backup:
Consider:
Which statement best describes the meaning of the value for the key_len column?
old_alter_table is disabled as shown.
mysql> SELECT @@old_alter_table;
Consider this statement on a RANGE-partitioned table:
mysql> ALTER TABLE orders DROP PARTITION p1, p3;
What is the outcome of executing this statement?
You are investigating the performance of the server and see this information:
Which action should be taken to remove the performance bottleneck described here?
You have just executed a manual backup by using this command:
mysqlbackup –u root –p –-socket=/tmp/my.sock –-backup-dir=/my/backup/ backup
The operation completed without error.
What is the state of this backup and operation required before it is ready to be restored?
You are using the Performance Schema to investigate replication on a slave which has a single master. The option slave-parallel-type is set to DATABASE.
Assume that all instruments and consumers are enabled and all threads are instrumented.
Which two facts can be concluded from the given output? (Choose two.)
MySQL is installed on a Linux server and has this configuration:
[mysqld]
user=mysql
datadir=/data/mysql/
As the ‘root’ user, you change the datadir location by executing:
shell> cp –R /var/lib/mysql /data/mysql/
shell> chown –R mysql /data/mysql
What is the purpose of changing ownership of datadir to the ‘mysql’ user?
TESTED 21 Nov 2024
