09 2015 档案

MySQL不能启动 Can't start server : Bind on unix socke
摘要：MySQL服务器突然不能启动，查看最后的启动日志如下： 080825 09:38:04 mysqld started080825 9:38:04 [ERROR] Can't start server : Bind onunixsocket: Permission denied080825 9:38... 阅读全文
posted @ 2015-09-29 11:06 zping 阅读(1850) 评论(0) 推荐(0)
Worst Performing Queries
摘要：WITH TMP AS( SELECT TOP 100 CAST(SUM(s.total_elapsed_time) / 1000000.0 AS DECIMAL(10, 2)) AS [Total Elapsed Time in S], SUM(s.execution_count) AS [T... 阅读全文
posted @ 2015-09-24 14:48 zping 阅读(315) 评论(0) 推荐(0)
Mysql5.6主从复制
摘要：搭建（192.168.1.10 -> 192.168.1.20） 1 master 上执行 阻塞 DMLflush tables with read lock; 记录 File 和 Positionshow master status; mysqldump -u root -p --all-data 阅读全文
posted @ 2015-09-15 16:09 zping 阅读(430) 评论(0) 推荐(0)
linux 安装 mysql-5.6.26
摘要：linux安装mysql-5.6.26 查看工具：winscp 下载地址 http://mirrors.sohu.com/mysql/MySQL-5.6/ 文件： mysql-5.6.26-linux-glibc2.5-x86_64.tar.gz 解压 tar -xzf mysql-5.6.26-l 阅读全文
posted @ 2015-09-14 17:17 zping 阅读(2617) 评论(0) 推荐(0)
SQL Server 2012 AlwaysON 同步延迟时间
摘要：SELECT availability_mode_desc , role_desc , replica_server_name , last_redone_time , GETDATE() now , DATEDIFF(ms, ... 阅读全文
posted @ 2015-09-06 16:23 zping 阅读(2353) 评论(0) 推荐(0)