标签：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定时任务

开启事件调度器

2022年12月13日 0条评论 78次阅读 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占用CPU超过100%解决过程

可以看到服务器负载很高，，mysql CPU使用已达到接近200%（因为是四核，所以会有超过100%的情况）。二、在服务器上执行mysql -u root -p之后，输入show full processlist; 可…

2022年3月18日 0条评论 100次阅读 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条评论 185次阅读 0人点赞阅读全文

mysql

Mysql优化之innodb_buffer_pool_size篇

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

2022年1月25日 0条评论 103次阅读 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条评论 130次阅读 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条评论 167次阅读 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条评论 178次阅读 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条评论 118次阅读 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条评论 114次阅读 1人点赞阅读全文

<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操作集合 json篇

一维数组查询方式: 二维数组查询方式: 查询json 搜索和修改JSON值

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

1
2
3
>
»