<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Sandescholar的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/Sandescholar</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; Sandescholar]]></copyright><item><title><![CDATA[MySQL 核心技术_存储引擎]]></title><link>https://blog.youkuaiyun.com/Sandescholar/article/details/103823443</link><guid>https://blog.youkuaiyun.com/Sandescholar/article/details/103823443</guid><author>Sandescholar</author><pubDate>Fri, 10 Jan 2020 09:02:56 +0800</pubDate><description><![CDATA[存储引擎
1. 存储引擎介绍
相当于Linux 文件系统.组织存储表数据.
2. 存储引擎的种类
show engines;
InnoDB
MyISAM
CSV
Memory
其他的存储引擎:
MariaDB : InnoDB,TokuDB ,Myrocks
percona : xtradb ,TokuDB ,Myrocks
TokuDB ,Myrocks : 比较适合于在写入操作较多的场景,数据...]]></description><category></category></item><item><title><![CDATA[MySQL 核心技术_06索引及执行计划]]></title><link>https://blog.youkuaiyun.com/Sandescholar/article/details/103815130</link><guid>https://blog.youkuaiyun.com/Sandescholar/article/details/103815130</guid><author>Sandescholar</author><pubDate>Fri, 03 Jan 2020 16:56:35 +0800</pubDate><description><![CDATA[1. 索引及执行计划


1.1 介绍
索引：相当于一本书中的目录,优化查询.


1.2 MySQL索引的类型(算法)
BTREE (Banlance Tree) ******
HASH
FULLTEXT
RTREE
GIS


1.3 索引算法的演变


 1.3.1 BTREE算法 由来
BTREE讲究的是查找数据的平衡,让我们的查询可以快速锁定范围


 1.3.2 BTREE 的增强之路...]]></description><category></category></item><item><title><![CDATA[MySQL 基础入门_05SQL补充及Information_schema]]></title><link>https://blog.youkuaiyun.com/Sandescholar/article/details/103787903</link><guid>https://blog.youkuaiyun.com/Sandescholar/article/details/103787903</guid><author>Sandescholar</author><pubDate>Fri, 03 Jan 2020 09:38:13 +0800</pubDate><description><![CDATA[1. show 语句的列表介绍 ******
查看所有的库
show databases;
– 查看当前库下的所有表
show tables;
show tables from world;
– 查看当前并发会话信息
show processlist;
show  full processlist;
– 查看数据库支持的权限
show privileges;
– 查看数据库参数信息
show va...]]></description><category></category></item><item><title><![CDATA[MySQL 基础入门_04SQL基础]]></title><link>https://blog.youkuaiyun.com/Sandescholar/article/details/103761541</link><guid>https://blog.youkuaiyun.com/Sandescholar/article/details/103761541</guid><author>Sandescholar</author><pubDate>Tue, 31 Dec 2019 19:16:32 +0800</pubDate><description><![CDATA[1. SQL介绍

1.1 SQL的定义
结构化查询语言，全称是Structured Query Language
1.2 SQL标准
SQL89 SQL92 SQL99 SQL03 SQL05
1.3 SQL_MODE
除数为零
日期
mysql&gt; select @@sql_mode;
1.4 SQL 类型
DDL : 数据定义语言 : 库名,库属性,表名,表属性,列(列名,列属性)
DC...]]></description><category></category></item><item><title><![CDATA[MySQL 基础入门_03基础管理]]></title><link>https://blog.youkuaiyun.com/Sandescholar/article/details/103738843</link><guid>https://blog.youkuaiyun.com/Sandescholar/article/details/103738843</guid><author>Sandescholar</author><pubDate>Fri, 27 Dec 2019 21:48:20 +0800</pubDate><description><![CDATA[1. 用户管理

1.1 作用 登录 管理对象
1.2 长成什么样?
用户名@‘白名单’
1.2.1 用户名: 不要太长 , 和业务有关
emp_user01
grant all on . to wordpress@’%’ identified ‘123’;
1.2.2 白名单?
user@‘10.0.0.56’
user@’%’
user@‘10.0.0.%’ 255.255.255.0 24位...]]></description><category></category></item><item><title><![CDATA[MySQL 基础入门_02体系结构]]></title><link>https://blog.youkuaiyun.com/Sandescholar/article/details/103719935</link><guid>https://blog.youkuaiyun.com/Sandescholar/article/details/103719935</guid><author>Sandescholar</author><pubDate>Thu, 26 Dec 2019 22:59:08 +0800</pubDate><description><![CDATA[1. MySQL的工作模型 C/S : 客户端/服务端模型
1.1 服务端程序 mysqld
1.2 客户端程序 mysql mysqldump mysqladmin …
1.3 连接协议(Linux)
网络套接字: TCP/IP网络连接串 ----&gt; mysql -uroot -p123 -h10.0.0.51 -P3306
本地套接字: socket本地连接串 ----&gt; mysq...]]></description><category></category></item><item><title><![CDATA[MySQL 基础入门_01安装部署]]></title><link>https://blog.youkuaiyun.com/Sandescholar/article/details/103717870</link><guid>https://blog.youkuaiyun.com/Sandescholar/article/details/103717870</guid><author>Sandescholar</author><pubDate>Thu, 26 Dec 2019 17:34:10 +0800</pubDate><description><![CDATA[1. 产品介绍

1.1什么是数据?
人类认为的数据: 抽象出来的,图片,视频,文字,表格,数字.
计算机: 2进制,16机制.
1.2 DBMS 数据库管理系统
RDBMS: 关系型数据库管理系统
特点: 二维表结构,提供很丰富的查询功能.高一致性.性能相比较差.
NoSQL: 特点: 无结构化存储数据,性能较高
NewSQL: PinCAP TiDB Aliyun PolarDB + OB T...]]></description><category></category></item><item><title><![CDATA[Linux_查看系统信息的命令]]></title><link>https://blog.youkuaiyun.com/Sandescholar/article/details/102966868</link><guid>https://blog.youkuaiyun.com/Sandescholar/article/details/102966868</guid><author>Sandescholar</author><pubDate>Fri, 08 Nov 2019 09:27:11 +0800</pubDate><description><![CDATA[Linux系统:
常用查看系统信息的命令


]]></description><category></category></item><item><title><![CDATA[Linux_根目录/下各目录的作用]]></title><link>https://blog.youkuaiyun.com/Sandescholar/article/details/102966773</link><guid>https://blog.youkuaiyun.com/Sandescholar/article/details/102966773</guid><author>Sandescholar</author><pubDate>Fri, 08 Nov 2019 09:19:40 +0800</pubDate><description><![CDATA[Linux系统:
熟记根目录/下各目录的作用


]]></description><category></category></item></channel></rss>