By plogi in mysql questions
See the following example:
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| iff |
| mysql |
| test |
| tt |
| tt3 |
+--------------------+
6 rows in set (0.02 sec)
mysql> show global variables like 'datadir';
+---------------+----------------------------------------+
| Variable_name | Value |
+---------------+----------------------------------------+
| datadir | c:\mysql-noinstall-5.0.51b-win32\data\ |
+---------------+----------------------------------------+
1 row in set (0.00 sec)
mysql> show table status from tt3;
+------------+--------+---------+------------+--------+- .
| Name | Engine | Version | Row_format | Rows | A .
+------------+--------+---------+------------+--------+--- .
| e1tst | MyISAM | 10 | Fixed | 100000 | .
| e2tst | MyISAM | 10 | Dynamic | 10 | .
| egen | MyISAM | 10 | Fixed | 10 | .
| r_date_dim | MyISAM | 10 | Dynamic | 1000 | .
| rgen | MyISAM | 10 | Fixed | 10 | .
+------------+--------+---------+------------+--------+---- .
5 rows in set (0.06 sec)
What is the absolute path of e1tst.frm?
a) c:\mysql-noinstall-5.0.51b-win32\data\mysql\tt3\e1tst.frm
b) c:\mysql-noinstall-5.0.51b-win32\data\tt3\e1tst.frm
c) c:\mysql-noinstall-5.0.51b-win32\data\e1tst.frm
d) c:\data\databases\tt3\e1tst.frm
[ MySQL Architecture (10%) - How MySQL uses Disk Space ]
Tags: learning, mysql, question
By plogi in mysql questions
See the following example:
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| iff |
| mysql |
| test |
| tt |
| tt3 |
+--------------------+
6 rows in set (0.02 sec)
mysql> show global variables like 'datadir';
+---------------+----------------------------------------+
| Variable_name | Value |
+---------------+----------------------------------------+
| datadir | c:\mysql-noinstall-5.0.51b-win32\data\ |
+---------------+----------------------------------------+
1 row in set (0.00 sec)
What’s the path of the tt3 db-directory?
a) c:\data\
b) c:\mysql-noinstall-5.0.51b-win32\data
c) c:\mysql-noinstall-5.0.51b-win32\data\mysql\tt3
d) c:\mysql-noinstall-5.0.51b-win32\data\tt3
[ MySQL Architecture (10%) - How MySQL uses Disk Space ]
Tags: learning, mysql, question
By plogi in general
Hello again!
The next few questions are about MySql’s structure on disk:
- Where to find databases
- Where to find tables
- Where to find logs
You’ll need that knowledge for example to implement backups, data transfer and debugging.
By plogi in general
Hello!
If you attempt to pass the MySql certification tests, then check the link below!
http://www.mysql.com/certification/candguide.html
In my experience you get the practical knowledge needed for the tests quite quickly by just using MySql every day. For the theoretical background however you need to study.
I got my certifications about a hundred years ago. In preparation I visited a course. At the course I actually got vouchers for the tests and the study guide. Shortly after that I passed the certificaton tests.
So, if you are serious about MySql certifications, get the study guide. A MySql course will help you save you time on perparations. And maybe even testing your knowledge with the questions on this page will help you on the way…
By plogi in mysql questions
a) locklist
b) dbheap
c) util_heap_sz
d) innodb_buffer_pool_size
e) innodb_log_buffer_size
f) key_buffer_size
g) query_cache_size
[ MySQL Architecture (10%) - How MySQL Uses Memory ]
Tags: learning, mysql, question
By plogi in mysql questions
a) bulk_insert_buffer_size 8388608
b) innodb_buffer_pool_size 8388608
c) innodb_log_buffer_size 1048576
d) join_buffer_size 131072
e) key_buffer_size 8388600
f) myisam_sort_buffer_size 8388608
g) read_buffer_size 131072
h) read_rnd_buffer_size 262144
i) sort_buffer_size 2097144
[ MySQL Architecture (10%) - How MySQL Uses Memory ]
Tags: learning, mysql, question
By plogi in general
Hi!
Now with the last two questions we entered the field of database administration. Before that everything was mostly development related. We’ll have a look at how MySql is using memory. The links below will give some background information:
http://dev.mysql.com/doc/refman/5.0/en/memory-use.html
http://http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html
By plogi in mysql questions
a) bulk_insert_buffer_size 8388608
b) innodb_buffer_pool_size 8388608
c) innodb_log_buffer_size 1048576
d) join_buffer_size 131072
e) key_buffer_size 8388600
f) myisam_sort_buffer_size 8388608
g) read_buffer_size 131072
h) read_rnd_buffer_size 262144
i) sort_buffer_size 2097144
[ MySQL Architecture (10%) - How MySQL Uses Memory ]
Tags: learning, mysql, question
By plogi in mysql questions
(Find all correct answers)
a) innodb_buffer_pool_size 8388608
b) innodb_log_buffer_size 1048576
c) join_buffer_size 131072
d) key_buffer_size 8388600
e) read_buffer_size 131072
f) sort_buffer_size 2097144
[ MySQL Architecture (10%) - How MySQL Uses Memory ]
Tags: learning, mysql, question
By plogi in mysql questions
(Find all correct answers)
a) If only one storage engine is used then
backup and recovery are easier to implement.
b) Joins between different storage engines
can cause unexpected problems.
c) Each table engine has its own memory-buffers...
Using many different engines may waste memory
d) All engines have the same features...
No need using more than one!
[ Basic Optimizations (10%) - Choosing Appropriate Storage Engines ]
Tags: learning, mysql, question