随笔分类 -  Database

[转载] 使用MySQL Proxy解决MySQL主从同步延迟
摘要：原文地址：http://koda.iteye.com/blog/682547MySQL的主从同步机制非常方便的解决了高并发读的应用需求，给Web方面开发带来了极大的便利。但这种方式有个比较大的缺陷在于MySQL的同步机制是依赖Slave主动向Master发请求来获取数据的，而且由于服务器负载、网络拥... 阅读全文
posted @ 2015-10-21 14:37 DavidHHuan 阅读(192) 评论(0) 推荐(0) 编辑
[Ubuntu] Access denied for user ‘debian-sys-maint’@'localhost’ (using password: YES)
摘要：I have reinstalled my system to Ubuntu 12.04, after installed mysql, i found that there is an error when start mysql:Accessdeniedforuser‘debian-sys-maint’@'localhost’(usingpassword:YES)After searching the reason via google, i at last found the reason, here is it:That’sbecausedebianhasamysqlaccou 阅读全文
posted @ 2012-05-19 10:34 DavidHHuan 阅读(2302) 评论(0) 推荐(0) 编辑
[MySQL] #1153 - Got a packet bigger than 'max_allowed_packet' bytes
摘要：When I runed a 32M database file in phpmyadmin, I got this error in the screen.[代码]There is a good way to fix this problem. Open the my.cnf file in the mysql install path. (Because I install the lampp... 阅读全文
posted @ 2010-08-19 15:43 DavidHHuan 阅读(867) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示