MySQL¼¯Èº
1£¬½«6.0°æ±¾µÄmysql¼¯ÈºÈí¼þÉÏ´«µ½Linux»òÊÇSolarisÉÏ£¬½âѹ
1>£¬ÎªÁË·½±ãµ÷Óý«Æä¸ÄÃûΪmysql£¬²¢ÇÒ·ÅÓÚ/usr/local/ÏÂ
2>£¬´´½¨Á¬½ÓÎļþ£¬½øÈë/usr/local/ÏÂ
ln -s ..../mysql mysql
2£¬´´½¨×飬Ìí¼ÓÓû§
groupadd mysql
useradd -g mysql mysql
3£¬È¨ÏÞµÄÐÞ¸Ä
cd /usr/local/mysql
chown -Rhf mysql .
chgrp -Rhf mysql .
Ö´Ðнű¾£¬´´½¨Êý¾Ý¿â
scritps/mysql_install_db --user=mysql &
chown -Rhf root .
chown -Rhf mysql .
chown -R mysql data
chgrp -R mysql .
cp support-file/mysql.server /etc/rc.d/ini.d/mysqld
chmod +x /etc/rc.d/init.d/mysqld
<chkconfig - add mysqld>
ÑéÖ¤Æô¶¯Êý¾Ý¿â
Æô¶¯Ê§°Ü¿ÉÒÔ³¢ÊÔ£º
/etc/rc.d/init.d/mysqld stop/start
service mysqld restart
Èç¹û»¹ÊÇʧ°Ü
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
bin/mysqld_safe --user=mysql &
ÑéÖ¤³É¹¦ºó£¬Í£Ö¹mysql£¬Í£Ö¹½ø³Ì
ps -ef | grep mysql<ndb>
kill -9 ½ø³Ì±êºÅ
4£¬´´½¨ÅäÖÃÎļþ
vi my.cnf
[mysqld]
default-storage-engine=ndbcluster
ndbcluster
ndb-connectstring=10.85.0.90,10.85.0.80
[ndbd]
connect-string=10.85.0.90,10.85.0.80
[ndb_mgm]
connect-string=10.85.0.90,10.85.0.80
[ndb_mgmd]
config-file=/usr/local/mysql/config.ini
[mysql_cluster]
ndb-connectstring=10.85.0.90,10.85.0.80
5£¬´´½¨Æô¶¯Îļþ
vi config.ini
[ndbd default]
NoOfReplicas= 2
MaxNoOfConcurrentOperations= 10000
DataMemory= 80M
IndexMemory= 24M
TimeBetweenWatchDogCheck= 30000
DataDir= /var/lib/mysql-cluster
MaxNoOfOrderedIndexes= 512
StartPartialTimeout=100
StartPartitionedTimeout=100
ArbitrationTimeout=5000
TransactionDeadlockDetectionTimeout=5000
HeartbeatIntervalDbDb=5000
StopOnError=0
[ndb_mgmd default]
DataDir= /var/lib/mysql-cluster
[ndb_mgmd]
Id=1
HostName= 10.85.0.90
[ndb_mgmd]
Id=2
Ho
Ïà¹ØÎĵµ£º
Ò»,½ñÌì¸ø´ó¼Ò½²Ò»ÏÂ,×öÁôÑÔµÄÒ»ÖÖ×·¼ÓµÄ·½Ê½Ö÷ÒªÈç¹ûµ±Ç°ÓÐÁôÑÔ,¾Í¸üе±Ç°µÄÁôÑÔÒÔ×·¼ÓµÄ·½Ê½,Èç¹ûûÄÜÁôÑԾͽ«ÈëÒ»ÌõеÄ
mysql:insert into `table` (field) values ('$value') on duplicate key update `field`=concat('value',ifnull(`field`,''));
¾ßÌå±¾ÌõSQLµÄÓ÷¨,Çë²é¿´ÊÖ²á
¶þ,½²Ò»ÏÂͳ¼ÆµÄÓ÷¨,Ö÷Òª½éÉÜÈçº ......
USE dxdb;
DELIMITER //
#»ñÈ¡Á÷Ë®ºÅ
DROP PROCEDURE IF EXISTS get_sid;
CREATE PROCEDURE get_sid(para_domain VARCHAR(20), out para_sid BIGINT UNSIGNED)
BEGIN
START TRANSACTION;
UPDATE t_sid SET sID=sID+1 WHERE cDomain=para_domain;
SELECT sID INTO para_sid from t_sid WHERE cDomain=para_domain;
......
mysqlÖÐINSTRº¯ÊýµÄÓ÷¨
INSTR(×Ö¶ÎÃû, ×Ö·û´®)
Õâ¸öº¯Êý·µ»Ø×Ö·û´®ÔÚijһ¸ö×ֶεÄÄÚÈÝÖеÄλÖÃ, ûÓÐÕÒµ½×Ö·û´®·µ»Ø0£¬·ñÔò·µ»ØÎ»Ö㨴Ó1¿ªÊ¼£©
SELECT * from tblTopic ORDER BY INSTR( topicTitle, 'ha' ) > 0 DESC
SELECT INSTR( topicTitle, 'ha' ) from tblTopic
mysqlÖÐʹÓÃinstrÅäºÏINÅÅÐò
½«instr½á¹û×÷Î ......
1£º ASCII(str) ¡¡·µ»Ø×Ö·û´®strµÄµÚÒ»¸ö×Ö·ûµÄASCIIÖµ(strÊǿմ®Ê±·µ»Ø0) mysql> select ASCII('2'); ¡¡¡¡-> 50 mysql> select ASCII(2); ¡¡¡¡-> 50 mysql> select ASCII('dete'); ¡¡¡¡-> 100
2£ºORD(str) ¡¡Èç¹û×Ö·û´®str¾äÊ×Êǵ¥×Ö½Ú·µ»ØÓëASCII()º¯Êý·µ»ØµÄÏàֵͬ¡£¡¡Èç¹ûÊÇÒ»¸ö¶à×Ö½Ú×Ö·û,ÒÔ¸ñʽ·µ ......
#ÐÂÔöÒ»¸ö×ֶΣ¬Ä¬ÈÏֵΪ0£¬·Ç¿Õ£¬×Ô¶¯Ôö³¤£¬Ö÷¼ü
alter table tabelname add new_field_name field_type default 0 not null auto_increment ,add primary key (new_field_name);
#Ôö¼ÓÒ»¸öÐÂ×Ö¶Î
alter table tableName add new_field_name field_type;
alter table tableNam ......