分类：mysql

<img data-src='https://x1.77book.cn:2096/wp-content/uploads/2020/07/9f20e--1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img src="https://x1.77book.cn:2096/wp-content/uploads/2020/07/9f20e--1.png" />

mysql

MySQL集群(支持不同地区(不同ip段))高可用不是Keepalive 但类似

用过Keepalive的都知道,Keepalive只支持局域网,不支持外网,有没有一款支持外网的 Keepalive, 博主一直在思考这个问题,无意中发现了 mysql-router 这么一个软件, 下面就来研究一下这个…

2023年10月14日 0条评论 89次阅读 0人点赞阅读全文

<img data-src='https://x1.77book.cn:2096/wp-content/uploads/2020/07/9f20e--1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img src="https://x1.77book.cn:2096/wp-content/uploads/2020/07/9f20e--1.png" />

mysql

Mysql定时任务

开启事件调度器

2022年12月13日 0条评论 77次阅读 0人点赞阅读全文

<img data-src='https://x1.77book.cn:2096/wp-content/uploads/2020/07/9f20e--1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img src="https://x1.77book.cn:2096/wp-content/uploads/2020/07/9f20e--1.png" />

mysql

记一次consider increasing server sort buffer size的处理

SQLSTATE[HY001]: Memory allocation error: 1038 Out of sort memory, consider increasing server sort buffer size…

2022年2月24日 0条评论 184次阅读 0人点赞阅读全文

mysql

Mysql优化之innodb_buffer_pool_size篇

MyISAM：仅在内存中保存索引。 InnoDB：在内存中保存索引和数据。保存在内存的内容访问速度要比磁盘上的更快。对此（假设你的服务器仅仅运行 MySQL），公认的“经验法则”是设置为你的服务器物理内存的 80%。在保…

2022年1月25日 0条评论 102次阅读 0人点赞阅读全文

<img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img src="https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png" />

mysql

mysql 加上order by 查询变慢的解决/记一次find_in_set 查询变慢的解决

mysql在数据量较大的时候、使用order by查询结果集时速度很慢的原因排序字段加DESC后索引没有起作用（如何让索引起作用才是关键 ) mysql默认是用主键索引 , 但有时主键索引可能会比其他索引慢 …

2020年12月12日 0条评论 129次阅读 0人点赞阅读全文

<img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img src="https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png" />

mysql

mysql操作集合常用篇

增删改查如果存在则更新，不存在则插入新数据批量更新一个表库

2020年11月23日 0条评论 129次阅读 0人点赞阅读全文

<img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img src="https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png" />

mysql

mysql操作集合 binlog篇

binlog 复制实现级别 Statement Level、Row Level、Mixed Level 记一次-表结构损坏出现不停重启的现像当mysqld服务进程访问损坏的表时，数据库会直接崩溃退出。通过:show g…

2020年11月23日 0条评论 166次阅读 0人点赞阅读全文

<img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img src="https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png" />

mysql

mysql操作集合分区篇

创建分区

2020年11月23日 0条评论 177次阅读 0人点赞阅读全文

<img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img src="https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png" />

mysql

mysql操作集合内置函数

内置函数服务器字符集优化-慢查询密码丢失

2020年11月23日 0条评论 117次阅读 0人点赞阅读全文

<img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img data-src='https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png' class='lazyload' src='data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==' /><noscript><img src="https://x1.77book.cn:2096/wp-content/uploads/2019/09/下载-1.png" />

mysql

mysql操作集合连接篇

连接与查询登录创建一个储存过程, 入参

2020年11月23日 0条评论 113次阅读 1人点赞阅读全文

1
2
3
>
»