열린 작업방

http://www.howtogeek.com/howto/linux/using-a-mysql-performance-tuning-analyzer-script/ http://free4u.dnip.net/weblog/node/2305 http://www.howtogeek.com/howto/programming/speed-up-your-web-site-with-mysql-query-caching/

mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client 원인: php API client version과 실제 DB version과의 차이 때문. 대부분 php API version이 3.xx 일때 발생 password()의 암호화 hash의 길이가 3.x버전이후에서 길어짐에 따라 발생. 해결방법: 1. SET PASSWORD FOR peter@localhost = OLD_PASSWORD('something') 2. win계열의 경우 my.ini에서 old_password=1 3. linux계열의 경우 1번과 같이 하던가 php재설치 http://fo..

Getting data out of MySQL by Russell J.T. Dyer Basic elements Selectivity and order Some flags Conclusion About the author The simplest way to retrieve data from MySQL is to use the SELECT statement. Since the SELECT statement is an essential SQL statement, it has many options available with it. It's not necessary to know or use them all—you could execute very basic SELECT statements if that sat..

아..제목그대로 루트 패스워드가 도저히 생각이 안납니다..-_-;; 막상 적어논것두 없구..ㅠㅠ 절망 하다 찾아낸 팁입니다... [root@develop mysql]# bin/mysqld -uroot --skip-grant-tables --skip-locking 050810 11:42:36 InnoDB: Started; log sequence number 0 43634 bin/mysqld: ready for connections. Version: '4.1.1-alpha-standard' socket: '/tmp/mysql.sock' port: 3306 위의 옵션을 주면 패스워드가 없이 접근이 가능합니다. 접근후 update문을 써서 패스워드를 다시 설정하시고, mysql데몬을 다시 실행해 주시면 됩니다...

파일을 참조하세요.^^*

파일을 참조하세요.^^*

파일을 참조하세요..^^*

Oracle sql tunning 관련 문서

By Russell Dyer A utility like mysqldump is very useful for backing up MySQL data and table schema. However, backups are usually made only once a day or at some other regular interval. If data is lost on your system several hours after the last backup is completed, you may not be able to recover it. There are a few methods by which you can continuously protect data. One method that you can use t..

Getting started with MySQL by Russell J.T. Dyer Over the past few years, MySQL has become one of the most popular database systems. The company which develops the software, MySQL AB of Sweden, is experiencing about 35,000 downloads a day and estimates over 5 million installations worldwide. Since MySQL can be selected from installation as part of Red Hat? Enterprise Linux? and Fedora Core, I won..