Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÁеÄ×î´óÔÊÐí³¤¶ÈÒÀÀµÓÚÔÚ¿Í»§/·þÎñÆ÷ЭÒéÖпÉÅäÖõÄ×î´ó°üµÄ´óСºÍ¿ÉÓÃÄÚ´æÊý¡£
¡¡¡ ......

ʹÓÃHibernate+MySql+native SQLµÄBUG,ÒÔ¼°½â¾ö°ì·¨

±¾À´ÊÇmssql+hibernate+native SQL Ó¦ÓõĺܺÍг
µ«Êǵ½Á˰Ñmssql»»³Émysql£¬¾Í³öÁË´í(ͬÑùµÄÊý¾Ý½á¹¹ºÍÊý¾Ý)¡£
²éѯ·½·¨ÊÇ£º
String sql =
"select id XXX_ID from t_tab";
List<Map> list = session.createSQLQuery(sql)
.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP)
.list();
´í ......

mysql ÌáÉýÃüÖÐÂÊ

Query Cache ÔÚÌá¸ßÊý¾Ý¿âÐÔÄÜ·½Ãæ¾ßÓзdz£ÖØÒªµÄ×÷Óá£
ÆäÉ趨Ҳ·Ç³£¼òµ¥£¬½öÐèÒªÔÚÅäÖÃÎļþдÈëÁ½ÐУº query_cache_type ºÍ query_cache _size£¬¶øÇÒ MySQL µÄ query cache ·Ç³£¿ì£¡¶øÇÒÒ»µ©ÃüÖУ¬¾ÍÖ±½Ó·¢Ë͸ø¿Í»§¶Ë£¬½ÚÔ¼´óÁ¿µÄ CPU ʱ¼ä¡£
µ±È»£¬·Ç SELECT Óï¾ä¶Ô»º³åÊÇÓÐÓ°ÏìµÄ£¬ËüÃÇ¿ÉÄÜʹ»º³åÖеÄÊý¾Ý¹ýÆÚ¡£Ò»¸ö ......

MySQLѧϰ2

  Á˽âÁËһЩ×î»ù±¾µÄ²Ù×÷ÃüÁîºó£¬ÎÒÃÇÔÙÀ´Ñ§Ï°ÈçºÎ´´½¨Ò»¸öÊý¾Ý¿âºÍÊý¾Ý¿â±í¡£
1¡¢Ê¹ÓÃSHOWÓï¾äÕÒ³öÔÚ·þÎñÆ÷Éϵ±Ç°´æÔÚʲôÊý¾Ý¿â£º
mysql> SHOW DATABASES;
+----------+
| Database |
+----------+
| mysql   |
| test    |
+----------+
3 rows in set (0.00 sec) ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ