收藏一下
题目内容:
1. Explain MySQL architecture. – The front layer takes care of network connections and security authentications, the middle layer does the SQL query parsing, and then the query is handled off to the storage engine. A storage engine could be either a default one supplied with MySQL (MyISAM) or a commercial one supplied by a third-party vendor (ScaleDB, InnoDB, etc.)
2. Explain MySQL locks. – Table-level locks allow the user to lock the entire table, page-level locks allow locking of certain portions of the tables (those portions are referred to as tables), row-level locks are the most granular and allow locking of specific rows.
3. Explain multi-version concurrency control in MySQL. – Each row has two additional columns associated with it – creation time and deletion time, but instead of storing timestamps, MySQL stores version numbers.
4. What are MySQL transactions? – A set of instructions/queries that should be executed or rolled back as a single atomic unit.
5. What’s ACID? – Automicity – transactions are atomic and should be treated as one in case of rollback. Consistency – the database should be in consistent state between multiple states in transaction. Isolation – no other queries can access the data modified by a running transaction. Durability – system crashes should not lose the data.
6. Which storage engines support transactions in MySQL? – Berkeley DB and InnoDB.
7. How do you convert to a different table type? – ALTER TABLE customers TYPE = InnoDB
8. How do you index just the first four bytes of the column? – ALTER TABLE customers ADD INDEX (business_name(4))
9. What’s the difference between PRIMARY KEY and UNIQUE in MyISAM? – PRIMARY KEY cannot be null, so essentially PRIMARY KEY is equivalent to UNIQUE NOT NULL.
10. How do you prevent MySQL from caching a query? – SELECT SQL_NO_CACHE …
11. What’s the difference between query_cache_type 1 and 2? – The second one is on-demand and can be retrieved via SELECT SQL_CACHE … If you’re worried about the SQL portability to other servers, you can use SELECT /* SQL_CACHE */ id FROM … – MySQL will interpret the code inside comments, while other servers will ignore it.
题目内容:
1. Explain MySQL architecture. – The front layer takes care of network connections and security authentications, the middle layer does the SQL query parsing, and then the query is handled off to the storage engine. A storage engine could be either a default one supplied with MySQL (MyISAM) or a commercial one supplied by a third-party vendor (ScaleDB, InnoDB, etc.)
2. Explain MySQL locks. – Table-level locks allow the user to lock the entire table, page-level locks allow locking of certain portions of the tables (those portions are referred to as tables), row-level locks are the most granular and allow locking of specific rows.
3. Explain multi-version concurrency control in MySQL. – Each row has two additional columns associated with it – creation time and deletion time, but instead of storing timestamps, MySQL stores version numbers.
4. What are MySQL transactions? – A set of instructions/queries that should be executed or rolled back as a single atomic unit.
5. What’s ACID? – Automicity – transactions are atomic and should be treated as one in case of rollback. Consistency – the database should be in consistent state between multiple states in transaction. Isolation – no other queries can access the data modified by a running transaction. Durability – system crashes should not lose the data.
6. Which storage engines support transactions in MySQL? – Berkeley DB and InnoDB.
7. How do you convert to a different table type? – ALTER TABLE customers TYPE = InnoDB
8. How do you index just the first four bytes of the column? – ALTER TABLE customers ADD INDEX (business_name(4))
9. What’s the difference between PRIMARY KEY and UNIQUE in MyISAM? – PRIMARY KEY cannot be null, so essentially PRIMARY KEY is equivalent to UNIQUE NOT NULL.
10. How do you prevent MySQL from caching a query? – SELECT SQL_NO_CACHE …
11. What’s the difference between query_cache_type 1 and 2? – The second one is on-demand and can be retrieved via SELECT SQL_CACHE … If you’re worried about the SQL portability to other servers, you can use SELECT /* SQL_CACHE */ id FROM … – MySQL will interpret the code inside comments, while other servers will ignore it.
发表评论
-
linux清除mysql占用cache
2013-11-01 10:55 2001在linux内部将cache分为2种: 1、write/rea ... -
规范、经验
2013-11-04 17:23 557尽量不用NULL列 query cach ... -
mysql模拟队列
2013-05-14 13:42 1061-- 初始化数据 DROP TABLE IF EXIST ... -
高性能mysql[第3版]--笔记
2013-05-03 23:35 06.8 6.8.1 mysql构建消息队列 se ... -
生成随机字符串
2013-04-30 10:41 0DELIMITER $$ CREATE FUNCTIO ... -
复制笔记
2013-04-27 17:48 0http://dev.mysql.com/doc/refman ... -
[整理]mysql导入导出
2013-04-24 22:40 0方案一:拷贝物理文件(innodb, innodb_file_ ... -
【整理中】mysql字符集使用
2013-04-24 22:29 0show variables like 'characte ... -
MYSQL监控内容整理
2013-04-24 13:40 0内容 硬解析,软解析,等待事件,表空间,索引,触发器,alte ... -
无限级联分类查询
2013-04-24 09:36 0DROP TABLE IF EXISTS location ... -
mysqldbcompare --使用
2013-04-07 09:39 0http://dev.mysql.com/doc/workbe ... -
MYSQL 发送数据大小计算公式
2013-03-29 16:20 855引用:http://www.realzyy.com/?p=15 ... -
#mysql 笔记#索引长度限制
2013-03-18 12:11 826http://dev.mysql.com/doc/refman ... -
mysqldump简单使用
2013-01-21 15:27 0mysqldump -B或者--databases:备份指定数 ... -
linux经常登入登出mysql重复输入密码
2013-01-16 17:51 942经常登入、登出mysql,尤其是密码重新输入比较复杂时,使用& ... -
mysql存储过程实现行转列
2012-08-30 16:24 2111把表t_rows中的数据转换 ... -
mysql 判断字符串是否是数字
2012-07-12 10:21 2919查询表table_name中col_name(字符串类型)的值 ... -
[转载]drop 大表效率问题
2012-06-15 09:32 46http://www.mysqlops.com/2011/05 ... -
monyog安装文件
2012-03-26 16:29 1233monyog安装包,绿色版 -
linux sysbench+mysql
2012-02-16 17:25 0一、sysbench安装 tar -zxvf ...
相关推荐
MySQL相关的笔试题,能够帮助对mysql数据库的了解,能够更加清晰的认识数据库。
机测并精心整理筛选的33道MySQL笔试题(附带答案、表结构与数据),安装数据库后导入test.sql文件即可练习
MySQL数据库笔试试题及答案(全),单选题103题,多选题58题,填空题30题,编程题若干题
百度笔试题---数据库百度笔试题---数据库百度笔试题---数据库百度笔试题---数据库
2. 什么是存储引擎 3. myisam和innodb的区别 4. 备份的分类(6) 5. 冷备和热备的区别(8) 6. 冷备的分类(4) 7. 如何查看二进制
这是统计的最新的mysql笔试题,总共有四十几个问题,答案也在对应的问题下边,只要用心看完,相信你会有所提升。
自己整理的关于,面试时有关MySQL的笔试题,希望大家面试时能够用的到
mysql数据库笔试题一.pdfmysql数据库笔试题一.pdfmysql数据库笔试题一.pdfmysql数据库笔试题一.pdfmysql数据库笔试题一.pdfmysql数据库笔试题一.pdfmysql数据库笔试题一.pdfmysql数据库笔试题一.pdf
MySQL面试题、笔试题 MySQL面试题、笔试题 MySQL面试题、笔试题
这个是评自己多年工作经验总结出来的面试题 希望对大家有用 希望面试者相互多交流
PHP+MySQL笔试题,批注解说答案,针对性强,重点突出,新鲜出炉
2021年mysql数据库笔试题一.docx2021年mysql数据库笔试题一.docx2021年mysql数据库笔试题一.docx2021年mysql数据库笔试题一.docx2021年mysql数据库笔试题一.docx2021年mysql数据库笔试题一.docx2021年mysql数据库...
某IT公司初试时使用的MYSQL题目,比较简单。
(完整)mysql数据库笔试题(一).docx(完整)mysql数据库笔试题(一).docx(完整)mysql数据库笔试题(一).docx(完整)mysql数据库笔试题(一).docx(完整)mysql数据库笔试题(一).docx(完整)mysql数据库笔试题(一).docx(完整)...
mysql数据库笔试题一.docxmysql数据库笔试题一.docxmysql数据库笔试题一.docxmysql数据库笔试题一.docxmysql数据库笔试题一.docxmysql数据库笔试题一.docxmysql数据库笔试题一.docxmysql数据库笔试题一.docx
mysql数据库笔试题(一).pdfmysql数据库笔试题(一).pdfmysql数据库笔试题(一).pdfmysql数据库笔试题(一).pdfmysql数据库笔试题(一).pdfmysql数据库笔试题(一).pdfmysql数据库笔试题(一).pdfmysql数据库笔试题(一).pdf
MySQL笔试面试题大全,这是一个文档,成百到MySQL面试笔试可能遇到的问题
mysql数据库笔试题(一).doc
中等难度笔试题,包括select / insert / update / delete 语法应用 多表联合查询,排序、分组等功能运用 包括但不限于MySQL,也可推广至Oracle、DB2等常见关系型数据库 考验的包括基本的CRUD水平,以及边界情况的...