liferay 7 database configuration

server|sqlserver| Data | database Preparation of database log tables Prepare one of these tables in the database, Mail_web_log: Build script: CREATE TABLE [dbo]. [Mail_web_log] ( [NId] [INT] IDENTITY (1, 1) not NULL, [Dtdate] [DateTime] Not NULL, [Sthread] [varchar] (m) COLLATE chinese_prc_ci_as not NULL, [Slevel] [varchar] (m) COLLATE chinese_prc_ci_as not NULL

Tags: database style Microsoft ya Black justifyIX. Database cluster deployment, configuration (i) Adding Failover Clustering Features 1. Open the PowerShell command modifier on SQL01,SQL02, and execute the following command to add the failover function.Add-windowsfeature-source Z:\sources\sxs net-framework-features,net-framework-core,failover-cluste

Tags: successful version download experience exchange experience Image title amp load1. First download yii-advanced-app-2.0.6.tgz 2. Unzip to the D:\WAMP\WWW\YII2 directory and cut all files in the directory advanced to D:\wamp\www\yii2 3. Open cmd, switch to current directory 4. Run the Init.bat file and prompt for the installation version 5. Enter Yes, then install 6. You can now open your browser: Enter http://localhost:8080/yii2/ 7. Click fr

Tags: app docker node database master-slave read config Isod how to PrimaryFirst, the specific operation method1. Start two MONGO containersDocker run--name mongo1-p 21117:27017-d MONGO--noprealloc--smallfiles--replset rs1docker run--name mongo2-p 22117: 27017-d MONGO--noprealloc--smallfiles--replset rs12. Viewing a running containerDocker PS | grep MONGO3. View Mongo1, Mongo2 container IPDocker Inspect Mongo1 | grep IPA4. Use the native (host) MONGO

operation. The default value is 2097144 (2m), and I change it to 16777208 (16m).(7), Table_cache:The number of tables opened for all threads. Increasing this value can increase the number of file descriptors required by the mysqld. MySQL requires 2 file descriptors for each unique open table. The default value is 64, I change it to 512.(8), Thread_cache_size:The number of threads that can be reused for saving in. If there is, a new thread is obtained

# Check the MySQL server system process ~ Ps-aux|grep mysqlmysql 1103 0.0 0.3 492648 51780 ? SSL 14:04 0:21/usr/sbin/mysqldsharon 15918 0.0 0.0 15940 968 pts/4 s+ 21:36 0:00 grep--color=auto mysql# check MySQL server footprint Port ~ Netstat-nlt|grep 3306tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN # check MySQL server status by Start command ~ sudo/etc/init.d/mysql statuscopyright (c), Oracle and/or its affil Iates. All rights reserved