ÐÞ¸ÄmysqÁ¬½ÓÊýºÍÆô¶¯mysql·þÎñ
my.cnf »òÕßÊÇ my.ini
ÔÚ[MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)d]ÅäÖöÎÌí¼Ó£º
max_connections = 1000
±£´æ£¬ÖØÆôMySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)·þÎñ¡£
È»ºóÓÃÃüÁ
MySQL(ºÍPHP´îÅäÖ®×î¼Ñ×éºÏ)admin -uroot -p variables
ÊäÈërootÊý¾Ý¿âÕ˺ŵÄÃÜÂëºó¿É¿´µ½
| max_connections | 1000 |
Æô¶¯mysql·þÎñ
RedHat Linux (Fedora Core/Cent OS)
1.Æô¶¯£º/etc/init.d/mysqld start
2.Í£Ö¹£º/etc/init.d/mysqld stop
3.ÖØÆô£º/etc/init.d/mysqld restart
Debian / Ubuntu Linux
1.Æô¶¯£º/etc/init.d/mysql start
2.Í£Ö¹£º/etc/init.d/mysql stop
3.ÖØÆô£º/etc/init.d/mysql restart
Windows
1.µã»÷“¿ªÊ¼”->“ÔËÐД£¨¿ì½Ý¼üWin+R£©
2.Æô¶¯£ºÊäÈë net stop mysql
3.Í£Ö¹£ºÊäÈë net start mysql
Ìáʾ
Redhat Linux Ò²Ö§³Öservice command£¬
Æô¶¯£º# service mysqld start
Í£Ö¹£º# service mysqld stop
ÖØÆô£º# service mysqld restart
Windowsϲ»ÄÜÖ±½ÓÖØÆô(restart)£¬Ö»ÄÜÏÈÍ£Ö¹£¬ÔÙÆô¶¯¡£
Ïà¹ØÎĵµ£º
[root@pku-fan MySQL]# cat limbs.sql
CREATE DATABASE cookbook;
USE cookbook;
DROP TABLE IF EXISTS limbs;
CREATE TABLE limbs
(
thing VARCHAR(20), # what the thing is
legs INT, ......
netbeans6.7ÖÐÏòmysql5ÖвåÈëÖÐÎÄÊý¾ÝʱÏÔʾ”data too long for column“µÄÎÊÌâ¡£
ÎÒµÄmysqlÖÐ×Ö·ûµÄÉèÖÃʱutf-8£¬²¢ÇÒÔÚ¿ØÖÆÌ¨ÖпÉÒÔ²åÈëÖÐÎÄÊý¾Ý²¢ÏÔʾ£¬µ«ÔÚnetbeansÖвåÈëÊý¾Ýʱȴ×ÜÊÇÏÔʾ”data too long for column“¡£»ù±¾¿ÉÒÔÅжÏÊÇÓÉÓÚnetbeansºÍmysqlÖ®¼äµÄÊý¾Ý½»»»³öÁ ......
¼ÙÉèÓбí tb1
ID £ü name£ü
----+--------+
1 £ü2toon£ü
2 £ü1*xyz£ü
Óï¾ä1£º
select * from tb1 where ID='2toon' or name ='2toon';
mysql·þÎñÆ÷ÔÚijģʽÏ£¬¿ÉÒÔÖ´ÐÐÕâÌõ¾ä£¬¾Í³É¹¦·µ»ØÁ½Ìõ¼Ç¼£¬ÔÒòÔÚÓÚ ID=‘2toon’ ¼ÓÁ˵¥ÒýºÅ£¬mysql½âÊÍΪ ID=2.
Óï¾ä2
select * fro ......
¡¡Õâ´ÎÊÇFotolog
µÄ¾Ñ飬´«ËµÖбÈFlickr¸ü´óµÄÍøÕ¾
£¬FotologÔÚ21̨·þÎñ
Æ÷Éϲ¿ÊðÁË51¸ömemcachedʵÀý£¬×ܼÆÓÐ254G»º´æ¿Õ¼ä
¿ÉÓ㬻º´æÁ˶à´ï175GµÄÄÚÈÝ£¬Õâ¸öÊýÁ¿±ÈºÜ¶àÍøÕ¾µÄÊý¾Ý¿â¶¼Òª´óµÄ¶à£¬ÔÎÄÊÇA Bunch of Great Strategies for Using Memcached and MySQL Better Together
£¬ÎÒÕâÀﻹÊÇÑ¡ÔñÐԵķÒëÒÔ¼°°´ÕÕ ......
ÔËÐл·¾³£ºwindows xp sp2
IIS v5.1
PHP 5.3.1-Win32-VC9-x86
Mysql 5.0
°²×°²½Ö裺
°²×°IIS5.1
ÔÚ ......