1Z0-888 Exam Question 96
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?
Can't start the server: Bind on TCP/IP port: Address already in use
What is the most likely cause of this error?
1Z0-888 Exam Question 97
Consider the index information for the dept_emp table in the employee's schema:

Which two conclusions can be made based on the output of the query?

Which two conclusions can be made based on the output of the query?
1Z0-888 Exam Question 98
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:
* The table data_currenthas 1,000,000 rows.
* The table data_reports has 1,500,000 rows.
* The table data_archivehas 4,500,000 rows.

You attempt to free space from ibdata1by taking a mysqldump of the data_archivetable 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?
You investigate and gather this information:

Three tables are stored in the InnoDB shared tablespace and the details are as follows:
* The table data_currenthas 1,000,000 rows.
* The table data_reports has 1,500,000 rows.
* The table data_archivehas 4,500,000 rows.

You attempt to free space from ibdata1by taking a mysqldump of the data_archivetable 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?
1Z0-888 Exam Question 99
You are using replication and the binary log files on your master server consume a lot of disk space. Which two steps should you perform to safely remove some of the older binary log files? (Choose two.)
1Z0-888 Exam Question 100
Which three allocate memory per thread in MySQL?