Posts Tagged ‘mysql’

傻瓜式搭建Nginx+PHP+Mysql服务器

This item was filled under [ Linux, Web Server ]

1.下载 一键安装包LNMP
wget http://licess.googlecode.com/files/LNMP.zip
2. 64位机器
yum -y install libjpeg-devel
Read the full story »

Continue reading...

Tagged with: [ , , ]

使用Google的TCMalloc库,提高MySQL的性能

This item was filled under [ Linux ]

TCMalloc(Thread-Caching Malloc)是google开发的开源工具──“google-perftools”中的成员。与标准的glibc库的malloc相比,TCMalloc在内存的分配上效率和速度要高得多,可以在很大程度上提高MySQL服务器在高并发情况下的性能,降低系统负载。
  TCMalloc的实现原理和测试报告请见一篇文章:《TCMalloc:线程缓存的Malloc》
  为MySQL添加TCMalloc库的安装步骤(Linux环境):
  1、64位操作系统请先安装libunwind库,32位操作系统不要安装。libunwind库为基于64位CPU和操作系统的程序提供了基本的堆栈辗转开解功能,其中包括用于输出堆栈跟踪的API、用于以编程方式辗转开解堆栈的API以及支持C++异常处理机制的API。
Read the full story »

Continue reading...

Tagged with: [ , ]

彻底解决 mysql ERROR 2002 (HY000)

This item was filled under [ Linux ]

 
[mysql]ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
 
rm -fr /var/lib/mysql/* 
Read the full story »

Continue reading...

Tagged with: [ ]

Linux服务器常用命令

This item was filled under [ Linux ]

Linux服务器常用命令
数据库:
导入.sql文件命令(例如/home/admin/3ebooks.sql)
  mysql -hlocalhost -uroot -p
Read the full story »

Continue reading...

Tagged with: [ , , ]

Mysql 实现自动备份

This item was filled under [ Linux ]

论坛页面文件在/var/apache/htdocs目录下,备份文件存放在/home/backup目录下
shell#vi /home/backup.sh
#!/bin/sh
cd /home/backup
Read the full story »

Continue reading...

Tagged with: [ ]
Page 1 of 212