MySQL performance

MySQL Performance Quiz

Questions:12
Attempts allowed:Unlimited
Available:Always
Pass rate:75 %
Backwards navigation:Allowed

Take this MySQL performance quiz.
MySQL Query and index optimization are the first and most important task of MySQL performance. Every task can be achieved by several different ways with various queries. However, by knowing the MySQL queries parts limits and drawbacks you can make your MySQL queries perform better.

Start quiz

Join Decomposition

Submitted by shareable on Mon, 11/14/2011 - 22:09
Multiple choice question

Join decomposition is a process of decomposing a join: running its single table queries parts and then composing the results at the application side. Can join decomposition give a significant performance boost or is it wasteful?

MySQL Packed Indexes

Submitted by shareable on Mon, 11/14/2011 - 18:14
Multiple choice question

What is true about MySQL Packed Indexes?

MySQL ENUM type

Submitted by shareable on Mon, 11/14/2011 - 18:09
Multiple choice question

What is true about MySQL ENUM?

MySQL Blob and Text types

Submitted by shareable on Mon, 11/14/2011 - 18:03
Multiple choice question

What is true about MySQL Blob and Text types?

MySQL Range Condition

Submitted by shareable on Mon, 11/14/2011 - 17:59
Multiple choice question

Range Condition makes MySQL ignore any further columns in the index.
Which from the following MySQL queries is considered a Range Condition in MySQL?

Using index scans for sorts

Submitted by shareable on Mon, 11/14/2011 - 17:49
Multiple choice question

Given a UNIQUE KEY: my_key (a_field, b_field, c_field). Which of the following queries will use the key in order to sort the results?

MySQL varchar amount of space

Submitted by shareable on Mon, 11/14/2011 - 16:56
Multiple choice question

Storing the value 'hello world' requires the same amount of space in a VARCHAR(11) and a VARCHAR(255) column. Is there any advantage to using the shorter column?

Optimize queries that refer to nullable columns

Submitted by shareable on Mon, 11/14/2011 - 16:46
True/false question

Is it True or False that it is harder for MySQL to optimize queries that refer to null-able columns.

Indexed column with function

Submitted by shareable on Thu, 11/10/2011 - 04:41
Multiple choice question

The following two queries produces the same results. The first uses LIKE and the second uses function LEFT. What is the best performing query, given that the column "title" is indexed?

Syndicate content