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

mysql 5.1 configure ±àÒë²ÎÊýÏê½â

-static  13%
   --with-client-ldflags=-all-static
  
--with-mysqld-ldflags=-all-static
¾²Ì¬Á´½ÓÌá¸ß13%ÐÔÄÜ
Unix Socket  7.5%
--with-unix-socket path=/usr/local/mysql/tmp/mysql.sock
ʹÓÃunixÌ×½Ó×ÖÁ´½ÓÌá¸ß7.5%ÐÔÄÜ£¬ËùÒÔÔÚwindowsÏÂmysqlÐÔÄܿ϶¨²»ÈçunixÏÂÃæ
--enable-assembler
The --enable-assembler options of configure allows for
compiling in x86 (and sparc) versions of common
string
operations, which should result in more
performance.
»ã±àx86µÄÆÕͨ²Ù×÷·û£¬¿ÉÒÔÌá¸ßÐÔÄÜ
--with-extra-charsets
=complex×Ö·ûÖ§³Ö
--enable-thread-safe-client
#Compile the client with
threads. Ò²¾ÍÊÇÈÿͻ§¶ËÖ§³ÖÏ̵߳ÄÒâ˼
--with-big-tables
There is a limit of 232
(~4.295E+09) rows in a MyISAM
table. If you build MySQL
with the --with-big-tables
option, the
row limitation is increased to (232
)2
(1.844E+19) rows
--with-ssl
--with-embedded-server
   #±àÒë³Éembedded MySQL library (libmysqld.a
),
--enable-local-infile
#ÈÃmysqlÖ§³Ö´Ó±¾µØÎļþ µ¼ÈëÊý¾Ý¿â
load data local infile '/usr/test' into table test fields terminated by ' ';
ERROR 1148 (42000): The used command is
not allowed with this
MySQL version£©
--with-plugins=innobase
´æ´¢ÒýÇæ
Mysql5.1¿ªÊ¼£¬±àÒëÌí¼Óinnodb²å¼þ¾Í´Ó--with-innodb ¸Ä³ÉÁË --with-plugins=innobase
--with-plugins=PLUGIN[[[,PLUGIN..]]]
                                                    Plugins to include in
mysqld. (default
is
: none)
                                                 


Ïà¹ØÎĵµ£º

mysqlºÍsqlserverÖв鿴µ±Ç°¿âÖÐËùÓбíºÍ×Ö¶ÎÐÅÏ¢

>>mysql:
1¡¢²é¿´ËùÓбíÃû£º
show tables [from db_name];
2¡¢²é¿´×Ö¶ÎÐÅÏ¢
SHOW FULL COLUMNS from db_name.table_name
»ñÈ¡ÒÔÏÂÐÅÏ¢
Field £º×Ö¶ÎÃû
Type£º×Ö¶ÎÀàÐÍ
Collation£º×Ö·û¼¯ £¨mysql 5.0ÒÔÉÏÓУ©
Null £ºÊÇ·ñ¿ÉÒÔΪNULL
Key£ºË÷Òý£¨PRI,unique,index)
Default£ºÈ±Ê¡Öµ
Extra£º¶îÍ⣨ÊÇ·ñ aut ......

mysql forige key


Love in coding...
    Free and Susan
[Òý]MySQL INNODBÀàÐͱíµÄÍâ¼ü¹ØÁªÉèÖÃ

Here is a simple example that relates parent and child tables through a single-column foreign key:
CREATE TABLE parent (id INT NOT NULL,
          ......

PHPÍæ×ªMySQLÖ®Íâ¼üÔ¼Êø ÄÏÈý·½

ÔÚ±¾ÎÄÖУ¬ÎÒÃǽ«Ñ§Ï°ÈçºÎͨ¹ýPHP 5µÄÒ»¸ö»ù±¾³éÏóÀàʹÓÃÍâ¼üÔ¼ÊøÀ´¸üÐÂÁ½¸öInnoDB±íµÄÊý¾Ý¡£ ÎÒÃǽ«Í¨¹ý¾ßÌåʾÀýÀ´ËµÃ÷ÈçºÎͨ¹ý·þÎñÆ÷¶Ë½Å±¾ÓïÑÔÀ´Ê¹ÓÃÍâ¼üÔ¼Êø¡£
¡¡¡¡Ò»¡¢ÀûÓÃÍâ¼üÔ¼Êø¸üÐÂMySQLÖеÄÊý¾Ý
¡¡¡¡ÏÖÔÚ£¬×îÁ÷ÐеĿªÔ´¹ØÏµÐÍÊý¾Ý¿â¹ÜÀíϵͳ·ÇMySQLĪÊô£¬¶øMySQLÓÖÖ§³Ö¶à¸ö´æ´¢ÒýÇæ£¬ÆäÖÐĬÈϵÄÒ²ÊÇËٶȽϿìµÄ´ ......

MySQL Cluster Multi Computer Configuration


For our four-node, four-host MySQL Cluster, it is necessary to
write four configuration files, one per node host.

Each data node or SQL node requires a
my.cnf
file that provides two pieces of
information: a connectstring
that tells
......

Initial Startup of MySQL Cluster


Starting the cluster is not very difficult after it has been configured. Each cluster node process must be started separately, and on the host where it resides. The management node should be started first, followed by the data nodes, and then finally by any SQL nodes:
On the management host, issu ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ