mysql Êý¾Ý¿â´óС
information_schema¿âÖаüº¬Á˶ÔÕû¸öÊý¾Ý¿âµÄºÜ¶àͳ¼ÆÐÅÏ¢£¬¿ÉÒÔͨ¹ý²é¿´ËüÃÇ£¬À´µÃµ½Êý¾Ý¿âÏà¹ØµÄÐÅÏ¢¡£
mysql> use information_schema;
Database changed
mysql> select count(1) as tables, concat(round(sum(table_rows)/1000000,2),'M') as rows, concat(round(sum(data_length)/(1024*1024*1024),2),'G') as data, concat(round(sum(index_length)/(1024*1024*1024),2),'G') as idx, concat(round(sum(data_length+index_length)/(1024*1024*1024),2),'G') as total_size,round(sum(index_length)/sum(data_length),2) as idxfrac from tables;
+--------+--------+--------+-------+------------+---------+
| tables | rows | data | idx | total_size | idxfrac |
+--------+--------+--------+-------+------------+---------+
| 719 | 96.41M | 30.17G | 9.63G | 39.80G | 0.32 |
+--------+--------+--------+-------+------------+---------+
1 row in set (1 min 9.64 sec)
Ïà¹ØÎĵµ£º
mysql> flush privileges;ʲôÒâ˼£¿
mysql> update mysql.user set password=PASSWORD('ÐÂÃÜÂë') where User='root';
mysql> flush privileges;
mysql> quit
´ð:
mysql ÐÂÉèÖÃÓû§»ò¸ü¸ÄÃÜÂëºóÐèÓÃflush privilegesË¢ÐÂMySQLµÄϵͳȨÏÞÏà¹Ø±í£¬·ñÔò»á³öÏ־ܾø·ÃÎÊ£¬»¹ÓÐÒ»ÖÖ·½· ......
ʾÀýÑÝʾÁËÓÃC#²Ù×÷MySQLµÄ·½·¨£¬ÌṩÁËÈý¸ö¿ÉÖØÓõÄÀàMySqlDBUtil,MySqlPageUtil,Page¡£
±¾Ê¾ÀýÓÉ C#²Ù×÷AccessÊý¾Ý¿âµÄ¼òµ¥Àý×Ó£¨http://www.albertsong.com/read-56.html£©Ð޸ĶøÀ´¡£
1.Ê×ÏÈÏÂÔØMySQLÊý¾Ý¿âµÄ.NETÇý¶¯
http://dev.mysql.com/get/Downloads/Connector-Net/mysql-connector-net-5.0.8.1-noinstall.zip/ ......
linux°²×°mysql.txt
2009-03-22 10:45
¡¡Ò»¡¢ÒýÑÔ
¡¡¡¡ÏëʹÓÃLinuxÒѾºÜ³¤Ê±¼äÁË£¬ÓÉÓÚûÓÐÓ²ÐÔÈÎÎñһֱҲûÓÐϵͳѧϰ£¬½üÈÕÓÉÓÚ¹¤×÷ÐèÒª±ØÐëʹÓÃLinuxϵÄMySQL¡£±¾ÒÔΪÓÐWindowsÏÂʹÓÃSQL ServerµÄ¾Ñ飬¾õµÃÔÚLinuxϰ²×°MySqlÓ¦¸ÃÊÇÒ×Èç·´ÕÆµÄÊ£¬¿ÉÔÚÕæÕý°²×°ºÍʹÓÃMySQLʱ×ßÁ˺ܶàÍä·£¬Óö¼ûºÜ¶àÎÊÌ⣬±Ï¾¹Linux ......
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:jee="http://www.springframework.org/schema/jee"
&nbs ......