数据库LAB2

最新推荐文章于 2024-10-20 17:13:34 发布
最新推荐文章于 2024-10-20 17:13:34 发布
阅读量508 收藏 2
点赞数
文章标签： mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/MysteriousL/article/details/115714072
版权
此内容展示了对多个数据库表的创建、插入数据、更新记录和查询操作，包括Branch、PrivateOwner、Client、Staff、PropertyForRent、Viewing和Registration等表。涉及外键约束、视图创建、数据修改以及事务处理等概念。
摘要由CSDN通过智能技术生成

在这里插入图片描述
在这里插入图片描述

show databases;
use dreamhome2;
show tables;

create database test;
create database test2;-- 这个是副本 

use test;

CREATE TABLE IF NOT EXISTS Branch (
   branchNo VARCHAR(4) NOT NULL,
	 street VARCHAR(40) NOT NULL,
	 city VARCHAR(20) NOT NULL,
	 postcode VARCHAR(10) NOT NULL,
	 PRIMARY KEY (branchNo)
);

-- drop table branch;

INSERT INTO Branch (branchNo, street, city, postcode)
VALUES ("B005", "22 Deer Rd", "London", "SW1 4EH"),
			 ("B007", "16 Argyll St", "Aberdeen", "AB2 3SU"),
			 ("B003", "163 Main St", "Glasgow", "G11 9QX"),
			 ("B004", "32 Manse Rd", "Bristol", "BS99 1NZ"),
			 ("B002", "56 Clover Dr", "London", "NW10 6EU");
             
             
             
CREATE TABLE IF NOT EXISTS PrivateOwner (
   ownerNo VARCHAR(4) NOT NULL,
	 fName VARCHAR(20) NOT NULL,
	 lName VARCHAR(20) NOT NULL,
	 address VARCHAR(40) NOT NULL,
	 telNo VARCHAR(20) NOT NULL,
	 eMail VARCHAR(40) NOT NULL,
	 password VARCHAR(20) NOT NULL,
	 PRIMARY KEY (ownerNo)
);

INSERT INTO PrivateOwner ()
VALUES ("CO46", "Joe", "Keogh", "2 Fergus Dr, Aberdeen AB2 7SX", "01224-861212", "jkeogh@lhh.com", "12345678" ),
			 ("CO87", "Carol", "Farrel", "6 Achray St, Glasgow G32 9DX", "0141-357-7419", "cfarrel@gmail.com", "12345678" ),
			 ("CO40", "Tina", "Murphy", "63 Well St, Glasgow G42", "0141-943-1728", "tinam@hotmail.com", "12345678" ),
			 ("CO93", "Tony", "Shaw", "12 Park Pl, Glasgow G4 0Qr", "0141-225-7025", "tony.shaw@ark.com", "12345678" );
             
             

CREATE TABLE IF NOT EXISTS Client (
   clientNo VARCHAR(4) NOT NULL,
	 fName VARCHAR(20) NOT NULL,
	 lName VARCHAR(20) NOT NULL,
	 telNo VARCHAR(20) NOT NULL,
	 prefType VARCHAR(10) NOT NULL,
	 maxRent INT UNSIGNED NOT NULL,
	 eMail VARCHAR(40) NOT NULL,
	 PRIMARY KEY (clientNo)
);

INSERT INTO Client (clientNo, fName, lName, telNo, prefType, maxRent, eMail)
VALUES ("CR76", "John", "Kay", "0207-774-5632", "Flat", 425, "john.kay@gmail.com" ),
			 ("CR56", "Aline", "Stewart", "0104-848-1825", "Flat", 350, "astewart@hotmail.com" ),
			 ("CR74", "Mike", "RitChie", "01475-392178", "House", 750, "mritchie01@yahoo.co.uk" ),
			 ("CR62", "Mary", "Tregear", "01224-196720", "Flat", 600, "maryt@hotmail.co.uk" );
         
select * from branch;
select * from privateowner;
select * from client;
             
             
-- 先创建三个主关系 ,后再创建staff？因为其外键是branch的主键

CREATE TABLE IF NOT EXISTS Staff (
    staffNo VARCHAR(4) NOT NULL,
	 fName VARCHAR(20) NOT NULL,
	 lName VARCHAR(20) NOT NULL,
	 position VARCHAR(20) NOT NULL, 
	 sex VARCHAR(1) NOT NULL, 
	 DOB DATE NOT NULL,
	 salary INT UNSIGNED,
     branchNo VARCHAR(4) NOT NULL,
	 PRIMARY KEY (staffNo),
     FOREIGN KEY(branchNo)
     REFERENCES Branch(branchNo)
     ON UPDATE CASCADE
     ON DELETE CASCADE
);

INSERT INTO Staff (staffNo, fName, lName, position, sex, DOB, salary, branchNo)
VALUES ("SL21", "John", "White", "Manager", "M", '1945-10-01', 30000, "B005"),
			 ("SG37", "Ann", "Beech", "Assistant", "F", '1960-11-10', 12000, "B003"),
			 ("SG14", "David", "Ford", "Supervisor", "M", '1958-03-24', 18000, "B003"),
			 ("SA9", "Mary", "Howe", "Assistant", "F", '1970-02-19', 9000, "B007"),
			 ("SG5", "Susan", "Brand", "Manager", "F", '1940-06-03', 24000, "B003"),
			 ("SL41", "Julie", "Lee", "Assistant", "F", '1965-06-13', 9000, "B005");

select * from Staff;
select * from branch;
-- 不确定！！！！！！！！！！！！！！！！！！！！！！！！！ 
CREATE TABLE IF NOT EXISTS PropertyForRent (
   propertyNo VARCHAR(4) NOT NULL,
	 street VARCHAR(40) NOT NULL,
	 city VARCHAR(20) NOT NULL,
	 postcode VARCHAR(10) NOT NULL,
	 type VARCHAR(10) NOT NULL,
	 rooms TINYINT UNSIGNED NOT NULL,
	 rent INT UNSIGNED NOT NULL,
	 ownerNo VARCHAR(4) NOT NULL,
	 staffNo VARCHAR(4),
	 branchNo VARCHAR(4) NOT NULL,
	 PRIMARY KEY (propertyNo),
     FOREIGN KEY(ownerNo) REFERENCES privateowner(ownerNo) ON UPDATE CASCADE ON DELETE CASCADE,
     foreign key(staffNo) references staff(staffNo) on update cascade on delete cascade,
     foreign key(branchNo) references branch(branchNo) on update cascade on delete cascade
);

INSERT INTO PropertyForRent (propertyNo, street, city, postcode, type, rooms, rent, ownerNo, staffNo, branchNo)
VALUES ("PA14", "16 Holhead", "Aberdeen", "AB7 5SU", "House", 6, 650, "CO46", "SA9", "B007"),
			 ("PL94", "6 Argyll St", "London", "NW2", "Flat", 4, 400, "CO87", "SL41", "B005"),
			 ("PG4", "6 Lawrence St", "Glasgow", "G11 9QX", "Flat", 3, 350, "CO40", NULL, "B003"),
			 ("PG36", "2 Manor Rd", "Glasgow", "G32 4QX", "Flat", 3, 375, "CO93", "SG37", "B003"),
			 ("PG21", "18 Dale Rd", "Glasgow", "G12", "House", 5, 600, "CO87", "SG37", "B003"),
			 ("PG16", "5 Navor Dr", "Glasgow", "G12 9AX", "Flat", 4, 450, "CO93", "SG14", "B003");

select * from propertyforrent;

-- drop table Viewing;

CREATE TABLE IF NOT EXISTS Viewing (
	 clientNo VARCHAR(4) NOT NULL,
	 propertyNo VARCHAR(4) NOT NULL,
	 viewDate DATE NOT NULL,
	 comment VARCHAR(40),
     primary key(clientNo,propertyNo,viewDate),
     foreign key(propertyNo) references propertyforrent(propertyNo) on update cascade on delete no action,
     foreign key(clientNo) references Client(ClientNo) on update cascade on delete no action
);

INSERT INTO Viewing (clientNo, propertyNo, viewDate, comment)
VALUES ("CR56", "PA14", '2013-03-24', "too small" ),
			 ("CR76", "PG4", '2013-04-20', "too remote" ),
			 ("CR56", "PG4", '2013-05-26', NULL ),
			 ("CR62", "PA14", '2013-05-14', "no dining room" ),
			 ("CR56", "PG36", '2013-04-28', NULL );

select * from Viewing;

-- drop table Registration; 

CREATE TABLE IF NOT EXISTS Registration (
	 clientNo VARCHAR(4) NOT NULL,
	 branchNo VARCHAR(4) NOT NULL,
	 staffNo VARCHAR(4) NOT NULL,
	 dateJoined DATE NOT NULL,
     primary key(clientNo,branchNo,staffNo),
     foreign key(clientNo) references client(clientNo) on update cascade on delete no action,
     foreign key(branchNo) references branch(branchNo) on update cascade on delete no action,
     foreign key(staffNo) references staff(staffNo) on update cascade on delete no action
);

INSERT INTO Registration (clientNo, branchNo, staffNo, dateJoined)
VALUES ("CR76", "B005", "SL41", '2013-01-02' ),
			 ("CR56", "B003", "SG37", '2012-04-11' ),
			 ("CR74", "B003", "SG37", '2011-11-16' ),
			 ("CR62", "B007", "SA9", '2012-05-07' );

select * from registration;
-- 第三题的（a）和（b） 
select * from branch;
select * from staff;
delete from branch where branchNo='B003';
update branch set branchNo='B003' where branchNo='B010';

-- 第二问 
INSERT INTO branch(branchNo, street, city, postcode)
VALUES(NULL,"22 Deer Rd", "London", "SW1 4EH");

INSERT INTO staff(staffNo, fName, lName, position, sex, DOB, salary, branchNo)
VALUES("Li1", "John", "White", "Manager", "M", '1945-10-01', 30000, "B001");
-

-- 第四问 
alter table staff drop sex;
alter table staff add sex VARCHAR(20) NOT NULL;
-- 第五问(a)
SELECT  * FROM staff;
UPDATE staff SET salary = salary * 0.909090 where position = 'Manager';-- !!!!
 SET SQL_SAFE_UPDATES = 0;
 -- 第五问 (b)

 
 
 
 
 use test2;
 CREATE TABLE IF NOT EXISTS Branch (
   branchNo VARCHAR(4) NOT NULL,
	 street VARCHAR(40) NOT NULL,
	 city VARCHAR(20) NOT NULL,
	 postcode VARCHAR(10) NOT NULL,
	 PRIMARY KEY (branchNo)
);

-- drop table branch;

INSERT INTO Branch (branchNo, street, city, postcode)
VALUES ("B005", "22 Deer Rd", "London", "SW1 4EH"),
			 ("B007", "16 Argyll St", "Aberdeen", "AB2 3SU"),
			 ("B003", "163 Main St", "Glasgow", "G11 9QX"),
			 ("B004", "32 Manse Rd", "Bristol", "BS99 1NZ"),
			 ("B002", "56 Clover Dr", "London", "NW10 6EU");
             
             
             
CREATE TABLE IF NOT EXISTS PrivateOwner (
   ownerNo VARCHAR(4) NOT NULL,
	 fName VARCHAR(20) NOT NULL,
	 lName VARCHAR(20) NOT NULL,
	 address VARCHAR(40) NOT NULL,
	 telNo VARCHAR(20) NOT NULL,
	 eMail VARCHAR(40) NOT NULL,
	 password VARCHAR(20) NOT NULL,
	 PRIMARY KEY (ownerNo)
);

INSERT INTO PrivateOwner ()
VALUES ("CO46", "Joe", "Keogh", "2 Fergus Dr, Aberdeen AB2 7SX", "01224-861212", "jkeogh@lhh.com", "12345678" ),
			 ("CO87", "Carol", "Farrel", "6 Achray St, Glasgow G32 9DX", "0141-357-7419", "cfarrel@gmail.com", "12345678" ),
			 ("CO40", "Tina", "Murphy", "63 Well St, Glasgow G42", "0141-943-1728", "tinam@hotmail.com", "12345678" ),
			 ("CO93", "Tony", "Shaw", "12 Park Pl, Glasgow G4 0Qr", "0141-225-7025", "tony.shaw@ark.com", "12345678" );
             
             

CREATE TABLE IF NOT EXISTS Client (
   clientNo VARCHAR(4) NOT NULL,
	 fName VARCHAR(20) NOT NULL,
	 lName VARCHAR(20) NOT NULL,
	 telNo VARCHAR(20) NOT NULL,
	 prefType VARCHAR(10) NOT NULL,
	 maxRent INT UNSIGNED NOT NULL,
	 eMail VARCHAR(40) NOT NULL,
	 PRIMARY KEY (clientNo)
);

INSERT INTO Client (clientNo, fName, lName, telNo, prefType, maxRent, eMail)
VALUES ("CR76", "John", "Kay", "0207-774-5632", "Flat", 425, "john.kay@gmail.com" ),
			 ("CR56", "Aline", "Stewart", "0104-848-1825", "Flat", 350, "astewart@hotmail.com" ),
			 ("CR74", "Mike", "RitChie", "01475-392178", "House", 750, "mritchie01@yahoo.co.uk" ),
			 ("CR62", "Mary", "Tregear", "01224-196720", "Flat", 600, "maryt@hotmail.co.uk" );
         
select * from branch;
select * from privateowner;
select * from client;
             
             
-- 先创建三个主关系 ,后再创建staff？因为其外键是branch的主键

CREATE TABLE IF NOT EXISTS Staff (
    staffNo VARCHAR(4) NOT NULL,
	 fName VARCHAR(20) NOT NULL,
	 lName VARCHAR(20) NOT NULL,
	 position VARCHAR(20) NOT NULL, 
	 sex VARCHAR(1) NOT NULL, 
	 DOB DATE NOT NULL,
	 salary INT UNSIGNED,
     branchNo VARCHAR(4) NOT NULL,
	 PRIMARY KEY (staffNo),
     FOREIGN KEY(branchNo)
     REFERENCES Branch(branchNo)
     ON UPDATE CASCADE
     ON DELETE CASCADE
);

INSERT INTO Staff (staffNo, fName, lName, position, sex, DOB, salary, branchNo)
VALUES ("SL21", "John", "White", "Manager", "M", '1945-10-01', 30000, "B005"),
			 ("SG37", "Ann", "Beech", "Assistant", "F", '1960-11-10', 12000, "B003"),
			 ("SG14", "David", "Ford", "Supervisor", "M", '1958-03-24', 18000, "B003"),
			 ("SA9", "Mary", "Howe", "Assistant", "F", '1970-02-19', 9000, "B007"),
			 ("SG5", "Susan", "Brand", "Manager", "F", '1940-06-03', 24000, "B003"),
			 ("SL41", "Julie", "Lee", "Assistant", "F", '1965-06-13', 9000, "B005");

select * from Staff;
select * from branch;
-- 不确定！！！！！！！！！！！！！！！！！！！！！！！！！ 
CREATE TABLE IF NOT EXISTS PropertyForRent (
   propertyNo VARCHAR(4) NOT NULL,
	 street VARCHAR(40) NOT NULL,
	 city VARCHAR(20) NOT NULL,
	 postcode VARCHAR(10) NOT NULL,
	 type VARCHAR(10) NOT NULL,
	 rooms TINYINT UNSIGNED NOT NULL,
	 rent INT UNSIGNED NOT NULL,
	 ownerNo VARCHAR(4) NOT NULL,
	 staffNo VARCHAR(4),
	 branchNo VARCHAR(4) NOT NULL,
	 PRIMARY KEY (propertyNo),
     FOREIGN KEY(ownerNo) REFERENCES privateowner(ownerNo) ON UPDATE CASCADE ON DELETE CASCADE,
     foreign key(staffNo) references staff(staffNo) on update cascade on delete cascade,
     foreign key(branchNo) references branch(branchNo) on update cascade on delete cascade
);

INSERT INTO PropertyForRent (propertyNo, street, city, postcode, type, rooms, rent, ownerNo, staffNo, branchNo)
VALUES ("PA14", "16 Holhead", "Aberdeen", "AB7 5SU", "House", 6, 650, "CO46", "SA9", "B007"),
			 ("PL94", "6 Argyll St", "London", "NW2", "Flat", 4, 400, "CO87", "SL41", "B005"),
			 ("PG4", "6 Lawrence St", "Glasgow", "G11 9QX", "Flat", 3, 350, "CO40", NULL, "B003"),
			 ("PG36", "2 Manor Rd", "Glasgow", "G32 4QX", "Flat", 3, 375, "CO93", "SG37", "B003"),
			 ("PG21", "18 Dale Rd", "Glasgow", "G12", "House", 5, 600, "CO87", "SG37", "B003"),
			 ("PG16", "5 Navor Dr", "Glasgow", "G12 9AX", "Flat", 4, 450, "CO93", "SG14", "B003");

select * from propertyforrent;

-- drop table Viewing;

CREATE TABLE IF NOT EXISTS Viewing (
	 clientNo VARCHAR(4) NOT NULL,
	 propertyNo VARCHAR(4) NOT NULL,
	 viewDate DATE NOT NULL,
	 comment VARCHAR(40),
     primary key(clientNo,propertyNo,viewDate),
     foreign key(propertyNo) references propertyforrent(propertyNo) on update cascade on delete no action,
     foreign key(clientNo) references Client(ClientNo) on update cascade on delete no action
);

INSERT INTO Viewing (clientNo, propertyNo, viewDate, comment)
VALUES ("CR56", "PA14", '2013-03-24', "too small" ),
			 ("CR76", "PG4", '2013-04-20', "too remote" ),
			 ("CR56", "PG4", '2013-05-26', NULL ),
			 ("CR62", "PA14", '2013-05-14', "no dining room" ),
			 ("CR56", "PG36", '2013-04-28', NULL );

select * from Viewing;

-- drop table Registration; 

CREATE TABLE IF NOT EXISTS Registration (
	 clientNo VARCHAR(4) NOT NULL,
	 branchNo VARCHAR(4) NOT NULL,
	 staffNo VARCHAR(4) NOT NULL,
	 dateJoined DATE NOT NULL,
     primary key(clientNo,branchNo,staffNo),
     foreign key(clientNo) references client(clientNo) on update cascade on delete no action,
     foreign key(branchNo) references branch(branchNo) on update cascade on delete no action,
     foreign key(staffNo) references staff(staffNo) on update cascade on delete no action
);

INSERT INTO Registration (clientNo, branchNo, staffNo, dateJoined)
VALUES ("CR76", "B005", "SL41", '2013-01-02' ),
			 ("CR56", "B003", "SG37", '2012-04-11' ),
			 ("CR74", "B003", "SG37", '2011-11-16' ),
			 ("CR62", "B007", "SA9", '2012-05-07' );

 select * from staff;
 update staff set position='Supervisor', salary=1.05*salary where fName='Julie' and lName='Lee';
 
 select * from propertyforrent;
update propertyforrent set rent=rent*1.02 where city='Glasgow';
MysteriousL
关注
HIT哈工大软件构造实验lab2
06-17
哈工大软件构造实验Lab2知识点总结 本文档总结了哈工大软件构造实验Lab2的知识点，涵盖了抽象数据类型（Abstract Data Type，ADT）、面向对象编程（Object-Oriented Programming，OOP）等方面的内容。 一、实验...
lab-14:数据库规范化
04-13
在本实验“lab-14:数据库规范化”中，我们将深入探讨这一主题，通过一系列查询来实践和理解规范化的过程。 首先，我们要了解数据库规范化的几个主要阶段，它们包括第一范式（1NF）、第二范式（2NF）、第三范式（3NF...
数据库上机LAB5
肥仔的博客
04-21 827
主要考察了视图及相关操作，索引，批处理和变量，控制流。下面是题目及我的代码： 前提： 表结构为 customer(cid,gender,city) food(cid,name,city,price) neworder(oid,cid,fid,quantity) TASK1: –1. 建立购买过重庆或四川食物的顾客视图Shu-view（包含Customer中CID，City） create vie...
数据库实践LAB大纲 01 管理
JamSlade的博客
02-08 557
创建数据库。
MIT 6.830数据库系统 -- lab five
cggghh的博客
05-19 47
本文链接：https://blog.csdn.net/m0_53157173/article/details/131962742
MIT6.830 数据库lab1 总结
wwxy1995的博客
04-24 600
该Lab是用Java实现的一个简单的数据库，主要帮助学生理解数据库的基本原理。 Lab1主要实现数据表结构的存储（使用分页BufferPool存储），以及顺序扫描，这个大体相当于从零面向过程的C语言教程https://cstack.github.io/db_tutorial/的前六章。 对BufferPool的实现没有使用LRU等淘汰优化策略。 Lab1已经给出基本框架，要求学生根据Get和Set方法，思考出对应的成员数据，以及实现相关方法。 该实验中体现了Java的编程特点...
PHP5中PDO的简单使用
weixin_33815613的博客
08-12 134
作者：heiyeluren <http://blog.csdn.net/heiyeshuwu>时间：2006-10-29关键字：PHP PHP5 PDO 数据库抽象类 PDO(PHP Data Object) 是PHP 5新出来的东西，在PHP 6都要出来的时候，PHP 6只默认使用PDO来处理数据库，将把所有的数据库扩展移到了PECL，那么默认就是没有了我们喜爱的php_mysq...
HIT/RUC-rucbase-lab 数据库实验答案
m0_74049435的博客
11-24 786
两个学校差别几乎没有，改改就能用，但是和CMU就差的比较多了。
ECNU数据库作业——Lab8
ysji's blog
01-18 406
ECNU数据库作业——Lab8
ECNU数据库作业——Lab2
ysji's blog
01-18 456
【代码】ECNU数据库作业——Lab2。
lab-2_tpch_数据库_tpch建表_
10-02
标题"lab-2_tpch_数据库_tpch建表_"指的是一个关于TPCH数据库构建的实验项目，其中"lab-2"可能代表系列实验中的第二部分，而"tpch数据库"和"tpch建表"是关键词，意味着我们将探讨如何根据TPCH标准建立数据库和表格。...
数据库系统lab5.zip
08-20
项目工程资源经过严格测试可直接...2. 部分字体及插图等来自网络，若是侵权请联系删除，本人不对所涉及的版权问题或内容负法律责任。收取的费用仅用于整理和收集资料耗费时间的酬劳 3. 积分资源不提供使用问题指导/解答
Lab5.数据库和映射1
08-04
Lab5.数据库和映射1 本实验旨在练习在Message Broker中如何使用ESQL和map访问数据库。通过本实验，您将能够编写ESQL访问数据库，使用关系数据库selects、IF-ELSE逻辑、ESQL过程、XPATH连接方法创建映射。 实验目的...
#MySQL `SELECT` 语句执行流程详解
最新发布
h123372868的博客
10-20 503
MySQL 的 `SELECT` 语句执行流程是一个复杂而高效的过程。它涉及多个组件的协作：连接器负责连接管理，解析器和预处理器确保语句合法，优化器生成最优执行计划，而执行器和存储引擎则负责实际的数据检索工作。理解这一流程可以帮助我们更好地优化查询，提升数据库性能。
MySQL 指定字段排序
学习,分享一直在路上
10-17 573
的主要优势在于其灵活性。无论是根据业务需求还是用户的偏好，都可以轻松实现自定义排序。例如，电商平台中的产品分类或评论排序，均可以使用此方法。是 MySQL 中一种灵活而强大的排序手段，能够满足复杂的排序需求。
【MySQL】事务
weixin_66672501的博客
10-18 1024
mysql是一个网络服务，这意味着在同一时刻可能有多个用户在并发访问或者操作这个数据库中的某些数据，如果不对这些操作进行控制的话有可能会造成并发访问导致数据不一致的问题，进而导致错误发生，因此针对这种并发访问的情况，数据库要通过事务等制来保证操作的正确性。
MySQL表的操作
2302_81707171的博客
10-14 903
MySQL表的操作
【原创】java+springboot+mysql校园留言墙管理系统设计与实现
计算机软件编程，包含Java、Php、Python、前后端、数据库等实战项目
10-15 1021
使用java+springboot+mysql开发的留言墙管理系统网站，系统包含管理员、用户角色，功能如下：管理员：登录后台；用户管理（冻结解禁）；留言管理；公告管理；关于我们；个人信息、密码修改。用户：注册、登录系统；首页，查看所有留言，发布留言，可以回复其他人的留言，可以按内容搜索留言；查看公告；用户还具备个人中心功能，可以管理自己的留言，可以修改个人信息，上传头像，可以修改密码。系统界面美观大方，功能及其丰富，使用了springboot、bootstrap、jquery、ajax等技术栈。
MySQL之Buffer Pool缓冲池详解
XT4625的专栏
10-15 823
Innodb 存储引擎设计了一个缓冲池（，来提高数据库的读写性能。Buffer Pool 以页为单位缓冲数据，可以通过参数调整缓冲池的大小，默认是 128 M。Innodb 通过三种链表来管理缓页：Free List （空闲页链表），管理空闲页；Flush List （脏页链表），管理脏页；LRU List，管理脏页+干净页，将最近且经常查询的数据缓存在其中，而不常查询的数据就淘汰出去。；
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值