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

show innodb status (mysql)


µ±Ç°»îÔ¾µÄÊÂÎñ:
------------
TRANSACTIONS
------------
Trx id counter080157601
Purge done for trx's n:o <0 80154573 undo n:o <0 0
History list length 6
Total number of lock structs in row lock hash table 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 0 0, not started, process no 3396, OS thread id 1152440672
MySQL thread id 8080, query id 728900 localhost root
show innodb status
---TRANSACTION 0 80157600, ACTIVE 4 sec, process no 3396, OS thread id 1148250464, thread declared inside InnoDB 442
mysql tables in use 1, locked 0
MySQL thread id 8079, query id 728899 localhost root Sending data
select sql_calc_found_rows * from b limit 5
Trx read view will not see trx with id>= 0 80157601, sees <0 80157597
---TRANSACTION 0 80157599, ACTIVE 5 sec, process no 3396, OS thread id 1150142816 fetching rows, thread declared inside InnoDB 166
mysql tables in use 1, locked 0
MySQL thread id 8078, query id 728898 localhost root Sending data
select sql_calc_found_rows * from b limit 5
Trx read view will not see trx with id>= 0 80157600, sees <0 80157596
---TRANSACTION 0 80157598, ACTIVE 7 sec, process no 3396, OS thread id 1147980128 fetching rows, thread declared inside InnoDB 114
mysql tables in use 1, locked 0
MySQL thread id 8077, query id 728897 localhost root Sending data
select sql_calc_found_rows * from b limit 5
Trx read view will not see trx with id>= 0 80157599, sees <0 80157595
---TRANSACTION 0 80157597, ACTIVE 7 sec, process no 3396, OS thread id 1152305504 fetching rows, thread declared inside InnoDB 400
mysql tables in use 1, locked 0
MySQL thread id 8076, query id 728896 localhost root Sending data
select sql_calc_found_rows * from b limit 5
Trx read view will not see trx with id>= 0 80157598, sees <0 80157594
Èç¹ûÁ¬½ÓÊýÁ¿ºÜ´ó£¬InnoDBÖ»ÄÜ´òÓ¡³öÆäÖеÄÒ»²¿·Ö£¬ÒÔά³ÖÕû¸öÁбíµÄ³¤¶È¡£
Transaction idÊǵ±Ç°ÊÂÎñµÄ±êʶ·û¡£Purge done for trx's n:oÊÇ»ØÊÕ³ÌÐòÆô¶¯ÊÂÎñµÄÊýÁ¿¡£Èç¹û»ØÊÕ³ÌÐòûÓÐÔËÐÐÊÂÎñ£¬InnoD


Ïà¹ØÎĵµ£º

mysqlÖÐʱ¼ä²éѯº¯Êý£¨°üÀ¨Ê±¼ä´Á£©

ÕâЩº¯Êý¶¼ÊÇMySQL×Ô´øµÄ£¬¿ÉÒÔÖ±½ÓʹÓÃÔÚPHPдµÄMySQL²éѯÓï¾äÖÐŶ
1-CURDATE()»òCURRENT_DATE()ºÍCURTIME()»òCURRENT_TIME()
ÕâÁ½¸öº¯ÊýÊDZȽϳ£Óõ½µÄ£¬¹ËÃû˼Ò壬µÚÒ»¸ö·µ»Øµ±Ç°ÈÕÆÚ£¬µÚ¶þ¸ö·µ»Øµ±Ç°Ê±¼ä
¿ÉÒÔÔÚMySQL¿Í»§¶Ë»òÕßPHPÓï¾äÀïд"SELECT CURDATE(),CURTIME()"²é¿´Ïà¹ØÐÅÏ¢.
»¹ÓÐÒ»¸öºÜÖØÒªµÄº¯ ......

Ò»¶Î×Ô¶¯±¸·ÝµÄMYSQL±¸·ÝµÄ½Å±¾

     ×î½ü¹«Ë¾×¼±¸Ê¹ÓÃÏîÄ¿¹ÜÀíµÄÍøÕ¾DotProject£¬¹«Ë¾ËäÈ»²»´ó£¬µ«ÊÇÇ£Éæµ½µÄÒµÎñÒ²ÊǺܸ´Ôӵģ¬ËùÒÔÐèÒª¶¨Ê±È¥±£´æÊý¾Ý¿âµÄÐÅÏ¢ÒÔ·ÀÖ¹Êý¾Ý¿â±ÀÀ£»òÕßÆäËûµÄÔ­ÒòÔì³ÉµÄÊý¾ÝËðʧ£¬ÕâÑù¾ÍÐèÒª½øÐÐÊý¾Ý¿âµÄ±¸·Ý¡£
     DotProjectʹÓõÄÊÇMysqlÊý¾Ý¿â£¬±¸·ÝMysqlÊý¾Ý¿âµÄÒ»¸ö±È½ÏºÃµÄ·½·¨¾ÍÊÇ ......

Mysql´æ´¢¹ý³Ì£¨ËÄ£©——Òì³£´¦Àí

ÓÐʱºò£¬²»Ï£Íû´æ´¢¹ý³ÌÅ׳ö´íÎóÖÐÖ¹Ö´ÐУ¬¶øÊÇÏ£Íû·µ»ØÒ»¸ö´íÎóÂë¡£
Mysql
Ö§³ÖÒì³£´¦Àí£¬Í¨¹ý¶¨Òå
CONTINUE/EXIT
Òì³£´¦ÀíµÄ
HANDLER
À´²¶»ñ
SQLWARNING/NOT FOUND/SQLEXCEPTION
£¨¾¯¸æ
/
ÎÞÊý¾Ý
/
ÆäËûÒì³££©¡£ÆäÖУ¬
FOR
ºóÃæ¿ÉÒÔ¸ÄΪ
SQLWARNING,
NOT FOUND, SQLEXCEPTION
À´Ö¸Ê¾ËùÓÐÒì³£¶¼´¦Àí£¬Ïൠ......

mysql hibernateÖ÷¼üÅäÖÃ

  ÔÚ½üÆÚµÄÏîĿά»¤¹¤×÷ÖУ¬Ê±³£³öÏÖÖ÷¼üÖظ´µÄÒì³£¡£¾­¹ýһϵÁÐ×ÊÁϵIJéѯ֮ºó£¬·¢ÏÖʱhibernateÓ³ÉäÎļþÅäÖÃÎÊÌâ¡£
  mysqlÌṩÖ÷¼ü“×Ô¶¯ÔöÁ¿”µÄÅäÖã¬Ö¸¶¨¸ÃÀàÐ͵ÄÖ÷¼ü£¬mysqlÄܹ»×Ô¶¯¼ÓÒ»¡£
  ÔÚhibernateÓ³ÉäÎļþÖУ¬¹ØÓÚÖ÷¼üµÄÅäÖò»ÄÜÊÇ
<generator class="increment"&g ......

Apache::DBIÓëMYsqlµÄ³ÖÐøÁ¬½ÓÌ«¶àµÄÎÊÌâ

ÎÒ¾­¹ýÕ⼸ÌìÑо¿·¢ÏÖmod_perlÌṩµÄ³ÖÐøÁ¬½Ó²¢²»ÖÇÄÜ£¨Ò²ÐíÊÇÎÒ»¹Ã»ÓÐÕÒµ½¸ü
ºÃµÄ½â¾ö·½°¸£©£¬Èç¹û½Å±¾ÖеIJÎÊýºÍ³õʼ»¯µÄ²ÎÊý²»Ò»Ñù£¬ÔÚÄÚ´æÖлá³öÏÖÁ½¸ö
¾ä±ú¡£
Apache::DBI->connect_on_init("DBI:mysql:mysql:localhost","root","root",
{
PrintError => 1,
RaiseError => 0,
AutoCommit => ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ