Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

MySQL¼¯ÈºÊµ¼ùÏê½âϵÁÐÖ®¶þ£ºÈçºÎ°²×°Management Node

±ÊÕߣ¨mqboss£©½üÆÚÔÚ×öMySQL¼¯ÈºµÄ¼¼Êõµ÷ÑУ¬»áÂ½Ðø°Ñ×Ô¼ºµÄÐĵÃÌå»áд³öÀ´ºÍ´ó¼Ò·ÖÏí£¬Çë´ó¼Ò¼ÌÐø¹Ø×¢¡£
1.´Ómysq¹Ù·½ÍøÕ¾ÏÂÔØ°²×°Îļþmysql-cluster-gpl-7.0.9-solaris10-sparc-64bit.tar.gz£¬²¢Í¨¹ýFTPÉÏ´«µ½Solaris·þÎñÆ÷ÉÏ£»
2.Ìí¼ÓÓû§×émysqlºÍÓû§mysql(×¢£ºmysqlÓû§ÊôÓÚmysqlÓû§×é)
shell> groupadd mysql
shell> useradd -g mysql mysql
3.½øÈëmysql-cluster-gpl-7.0.9-solaris10-sparc-64bit.tar.gzÎļþËùÔÚµÄĿ¼£¬½âѹËõ¸ÃÎļþ£º
µÃµ½Îļþ¼Ðmysql-cluster-gpl-7.0.9-solaris10-sparc-64bit£¬ÎªÁË·½±ãÆð¼û£¬°Ñ¸ÃÎļþÃûÖØÃüÃûΪmysql-cluster-7.0.9£»
´Ë´¦¼Ù¶¨¸ÃÎļþ¼ÐÔÚĿ¼/var/tmpÏ£¬ÒÀ´ÎÖ´ÐÐÒÔÏÂÃüÁ
shell> cd /var/tmp
shell> cd mysql-cluster-7.0.9
shell> cp bin/ndb_mgm* /usr/local/bin
Ä¿µÄÊǰÑndb_mgmºÍndb_mgmd¿½±´µ½/usr/local/binĿ¼ÏÂ
´Ëºó£¬¿ÉÒÔ·ÅÐĵİÑmysql-cluster-7.0.9Îļþ¼Ðɾ³ý
4.½øÈë/usr/local/binĿ¼Ï£¬²¢ÊÚÓèndb_mgmºÍndb_mgmd¿ÉÖ´ÐÐȨÏÞ£¬¾ßÌåÈçÏ£º
shell> cd /usr/local/bin
shell> chmod +x ndb_mgm*
×÷Õß¼ò½é£º mqboss ÊÇ×÷Õß±ÊÃû£¬Ôø¾ÍÖ°ÓÚÆÕÌìºÍÖÐÐË£¬ÏÖÔÚÒ»ÍâÆó¹¤×÷£¬Ò»Ö±´ÓÊÂͨÐÅÈí¼þµÄ²âÊÔ¡¢¿ª·¢ÓëÉè¼Æ¹¤×÷£¬×¨×¢ÓÚJAVA, J2EE, WEB, DBµÈÁìÓòµÄÀíÂÛÑо¿¡¢²âÊÔ¡¢¿ª·¢ÓëÉè¼Æ


Ïà¹ØÎĵµ£º

MySQLÓÐËÄÖÖBLOBÀàÐÍ:


MySQLÓÐËÄÖÖBLOBÀàÐÍ:
¡¡¡¡·tinyblob:½ö255¸ö×Ö·û
¡¡¡¡·blob:×î´óÏÞÖÆµ½65K×Ö½Ú
¡¡¡¡·mediumblob:ÏÞÖÆµ½16M×Ö½Ú
¡¡¡¡·longblob:¿É´ï4GB
¡¡¡¡ÔÚÿ¸öMySQLµÄÎĵµ(´ÓMySQL4.0¿ªÊ¼)µÄ½éÉÜÖÐ,Ò»¸ölongblobÁеÄ×î´óÔÊÐí³¤¶ÈÒÀÀµÓÚÔÚ¿Í»§/·þÎñÆ÷ЭÒéÖпÉÅäÖõÄ×î´ó°üµÄ´óСºÍ¿ÉÓÃÄÚ´æÊý¡£
¡¡¡ ......

Oracle,MySQL,MSSQL ServerºÍAccessÊý¾Ý¿âµÄͳ¼Æº¯Êý

Oracle,MySQL,MSSQL ServerºÍAccessÊý¾Ý¿âµÄͳ¼Æº¯Êý
ÎÒÃÇÔÚ±à³ÌÖг£ÓõÄͳ¼Æº¯ÊýÓмÆÊý,ÇóºÍ,Çó×î´óÖµ,Çó×îСֵ,Ç󯽾ù,·½²îºÍ±ê×¼²î.
·½²î(Variance)
·½²îÊDZê׼ƫ²îµÄƽ·½¡£×éÖеÄÖµ£¬ÓëËüÃÇÆ½¾ùÖµÖ®¼äÆ«Àë³Ì¶ÈµÄ¶ÈÁ¿¡£
±ê׼ƫ²î(Standard Deviation)
Ò»¸ö²ÎÊý£¬Ö¸³öÒ»ÖÖ·½Ê½£¬Ò»¸ö¸ÅÂʺ¯ÊýÒÔÕâÖÖ·½Ê½·Ö²¼ÔÚÆ½¾ùÖµ¸ ......

mysql ¹²ÏíËø ÅÅËûËø ·À²åÈëËø

ÊÔÑé1
ÊÂÎñ1£º
#!/usr/bin/python
import time
import MySQLdb;
conn = MySQLdb.connect(host="localhost",port=3306,user="root",passwd="asdf",db="test",unix_socket="/data/mysql_3306/mysql.sock")
cursor = conn.cursor()
cursor.execute("select * from test")
while str!="1":
    str = r ......

UbuntuÏÂMySQL·þÎñ¹ÜÀí

²âÊÔ»·¾³£ºUbuntu 9.10 + MySQL 5.1.37-1ubuntu5
Ubuntu ÔÚÆô¶¯¹ÜÀí init.d
ÀïÃæ¹ØÓÚ MySQL µÄÃüÁîÓУº
/etc/init.d/mysql start|stop|restart|reload|force-reload|status
ÀýÈçÖØÆôMySQL·þÎñ£ºsudo /etc/init.d/mysql restart
......

mysql ѧϰ

truncate table Çå¿Õ±í£¬ºÍdeleteÏàËÆ£¬µ«ÊÇÔÚ±í·Ç³£´óµÄʱºò£¬ËüÊÇÖð²½Êͷŵġ£
insert Èç¹ûÔÚ²åÈëʱ£¬Ä³¸ö×ֶδæÔÚ£¬ÎÒÏë¸üпÉÒÔͨ¹ý insert into tablename values() on duplicate key update id=id+1;
insert into tablename values(default) ĬÈÏ×ÔÔö³¤
select last_insert_id() È¡×îºó²åÈëÒ»Ìõ¡£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ