Categories
DATABASE Service Software

[memo] Ubuntu forgot mysql root password

Categories
System/Linux/Unix*

[memo] Ubuntu LAMP setup / config / etc / network interface / eth0

Categories
DATABASE JOB

mysqldump 不鎖 table 備份 command , nolock , no lock

mysqldump -u -p -h host –lock-tables=false stat tbl_test | gzip -cf > 1.gz

Categories
DATABASE JOB

Protected: [LAB] Best practices guidelines for running MySQL databases on NetApp® storage , 測試結果

There is no excerpt because this is a protected post.

Categories
Network service System/Linux/Unix*

amazon aws ami LAMP / NGINX / PHP / memcache steps

// —– Using NGINX + PHP5-FPM sudo apt-get install nginx php5-fpm php5-mysql cd /etc/init.d/ sudo service apache2 stop sudo update-rc.d -f apache2 remove http://yoodey.com/how-install-configure-nginx-php-fpm-memcached-work-drupal-7-ubuntu-1010-maverick Install Memcached sudo apt-get install memcached libmemcached-dev php5-memcached php5-memcache // ==================== Getting a new virtual machine up and running from the default AMI is easy. Here’s my cookbook: Install basic services […]

Categories
DATABASE JOB

建 mysql partition table 遇到的問題

1. Out of resources when opening file 在 my.cnf 加 open-files-limit = 6000 2. Too many partitions were defined Ref. URL :  http://www.monster.com.tw/archives/2504

Categories
DATABASE JOB

Protected: [memo] mysql CPU / MEMORY / DISK / SERVER

There is no excerpt because this is a protected post.

Categories
DATABASE JOB

[memo] MySQL PROCEDURE ANALYSE / schema 分析

URL : http://dev.mysql.com/doc/refman/5.0/en/procedure-analyse.html  

Categories
DATABASE JOB

Protected: dbs222 mysql innodb Troubleshutting

There is no excerpt because this is a protected post.

Categories
DATABASE

mysql performance tunning – pdf

download: http://dn.monster.tw/my/docs/mysql/mysql_perf_tuning.pdf