CentOS下MySQL最大串連數設定 1040 too many connectionCentOS下MySQL最大串連數設定 1040 too many connection當最大串連數比較小時,可能會出現“1040 too many connection”錯誤。可以通過修改設定檔來修改最大串連數,但我連設定檔在哪都不知道,應該怎麼辦呢?首先需要重啟mysql服務,執行命令:service mysql restart也有可能是:service mysqld
MySQL剛安裝完只認得的主機是:localhost和127.0.0.1MySQL剛安裝完只認得的主機是:localhost和127.0.0.1,如果你要讓你機上的IP可以正常登入有兩種辦法: 一是對你的IP 172.16.1.10 進行授權 grant privileges on dbname.* to "user "@ "172.16.1.10 "
調整Oracle sga的大小導致 ORA-00851和ORA-00844錯誤今天調整了下Oracle sga的大小,結果重啟資料庫的時候報如下錯誤。 SQL>alter system set sga_max_size=1024M scope=spfile; SQL> shutdown immediate SQL> startup ORA-00844: Parameter not taking MEMORY_TARGET into
【翻譯自mos文章】對dba_users視圖中,account_status列的解釋,dbausers對dba_users視圖中,account_status列的解釋參考原文:How to Interpret the ACCOUNT_STATUS Column in DBA_USERS (Doc ID 260111.1)適用於:Oracle Server - Enterprise Edition - Version 9.2.0.1 to 11.2.0.3 [Release 9.2 to 11.2
Oracle TIMESTAMP的處理,oracletimestamppublic class Test {private static final SimpleDateFormat FORMAT = new SimpleDateFormat("yyyy-MM-dd HH:mm:dd");public static void main(String[] args) throws SQLException {oracle.sql.TIMESTAMP temp = new
【翻譯自mos文章】SYS_OP_C2C 導致的全表掃描(fts)/全索引掃描,sys_op_c2cftsSYS_OP_C2C 導致的全表掃描(fts)/全索引掃描參考原文:SYS_OP_C2C Causing Full Table/Index Scans (Doc ID 732666.1)適用於:Oracle Database - Enterprise Edition - Version 10.1.0.2 to 12.1.0.1 [Release 10.1 to
Chapter 1 Securing Your Server and Network(1):選擇SQL Server運行帳號,chaptersecuring原文出處:http://blog.csdn.net/dba_huangzj/article/details/37924127 ,專題目錄:http://blog.csdn.net/dba_huangzj/article/details/37906349