configuration
so do the following edit my.cnf: [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/English bind-address = xxx.xxx.xxx.xxx # skip-networking after edit hit service mysqld restart after
database
前demo有介紹利用SqlDataSoure和手動撰寫ADO.NET的方式大量新增資料的方法，雖然已經有效的改善了寫入的速度，但在發現了SqlBulkCopy以後，發現它更是威力強大，現在就來介紹SqlBulkCopy的猛。 3 SHARES FacebookGoogle+TwitterMore ★注意事項：本文是延續將資料大量寫入資料庫時的優化寫法的更優化如果對於文中有不清楚之意，可利用本文最下方相關的文章進入觀看資料大量寫入資料庫時的優化寫法一文 ▲說明都在程式註解中啦 //一開始我們先產生一個DataTable來裝我們要寫入的資料 DataTable dt = new DataTable(); dt.Columns.Add("id", typeof(int)); dt.Columns.Add("name", typeof(string)); //因為SqlBulkCopy的猛就是大量的一次寫入，所以我們也來跑10萬筆吧 int i; for (i = 0; i < 100000; i++)
configuration
Oracle 11g 啟用 Archive Log Mode 我從Oracle下載Pre-Built Developer VMs，內建11gR2的Database，但是並沒有啟用Archive Log Mode SQL> archive log list; Database log mode No Archive Mode Automatic archival Disabled Archive destination Oldest online log sequence 389 Current log sequence 391 關閉DB，重啟到mount階段 SQL> startup mount SQL> alter database archivelog （alter
database
https://docs.oracle.com/cd/B28359_01/server.111/b28310/diag001.htm#ADMIN11257 Alert Log The alert log is an XML file that is a chronological log of database messages and errors. It is stored in the ADR and includes messages about the following: * Critical errors (incidents) * Administrative operations, such
configuration
by Eric Jenkinson on April 8, 2010 Categories: Backup and Recovery Tagged: archive log, redo log Note: It is recommended to perform a backup of the database (after a shutdown normal or immediate) prior to changing the archive status of a database. If you would like to perform these tasks
blog
When I try to play wordpress 3.3.1 blog with ckeditor-for-wordpress.3.6.2.5 plugin ,they requirement depends package version as below. MySQL-5.0.95 PHP-5.2.4 But my Linux version CentOS 3.9 that was too old and cann't on-line insall such as packages.