startup-bash-3.2$ Ps-ef|grep Post--View database status-bash-3.2$ Cat LogFile-bash-3.2$ ps-f-U postgresTo connect to a database: -bash-3.2$ Psql--Local connectionPsql (9.5.2)Type ' help ' for help.postgres=# \l..........postgres-# \password--Modify PG PasswordEnter New Password:Enter It again:C:\users\wangwc>psql-h 192.168.72.130-u postgres-d Oracle-Remote Connection
Postgresql Shared Memory Usage:
U Sage
A pproximate Shared Me
spring.datasource.minidle=1 spring.datasource.maxactive=20 # Configuration get connection Wait super
Time spring.datasource.maxwait=60000 # Configures the minimum lifetime of a connection in a pool, in milliseconds Spring.datasource.validationquery=select 1 from DUAL
Spring.datasource.testonborrow=false Spring.datasource.testonreturn=false Spring.datasource.testwhileidle=true
spring.datasource.minevictableidletimemillis=25200000 # How long does the configuration interval take to detect id
;1dbip=192.168.1.109dbport=3109dbuser= ' proxysql ' DBPASSWD= ' 123456 ' now= ' date + '%y%m%d%h%m ' dbname= "Sysbench" tblcnt=10 #表数量WARMUP =300 #预热时间 (seconds) during=1800 #持续时间 (seconds) R ows=10000000 #每个表中插入1KW行数据MAXREQ =1000000 #最大请求数为100W # When the duration or maximum number of requests is reached, the test on this round stops # Create a sysbench dedicated database echo ' now creat E db ' mysql-h$dbip-p$dbport-u$dbuser-p$dbpasswd-e ' Create Da
expression in oracle9i can be used in the following cases:DECODE and CaseIn all clauses except the GROUP by clause in SELECT1) using a single-column subquery in a CASE expressionExample: the Employee_id,last_name and location of an explicit employee. whichIf the employee department_id is the same as department_id with location_id 1800, the location is ' Canada ' and the rest is ' USA '.SELECT employee_id, last_name,(Case if department_id = (SELECT de
o'clock. In Druid, there is no problem that Oracle has too much memory in the lower Pscache, you can configure this value to be larger, for example , -
Propertyname= "Maxpoolpreparedstatementperconnectionsize"value= "-1" />
Propertyname= "Validationquery"value= "Select 1"/>
Propertyname= "Testwhileidle"value= "true"/>
Propertyname= "Testonborrow"value= "true"/>
Propertyname= "Testonreturn"value= "false"/>
turn on the removeabandoned feature
-s
To get back to the problem itself, first look at the MySQL parameter settings:
mysql> show variables like ‘%timeout%‘;
+-----------------------------+----------+
| Variable_name | Value |
+-----------------------------+----------+
| connect_timeout | 10 |
| interactive_timeout | 1800 |
| lock_wait_timeout | 31536000 |
| net_read_timeout | 3
\ ORADATA \ ORCTSTUEX \ POWERDES \ ORCTSTU01.DBF SQL>
2. Error in resize contraction:
To contract to 18 GB, run the following command to report an error:
SQL> alter database datafile '/home/oradata/powerdes/orctstu01.dbf' resize 1800 M;
Alter database datafile '/home/oradata/powerdes/orctstu01.dbf' resize 1800 M
*
ERROR at line 1:
ORA-03297: file contains used data beyondrequested RESIZE value
SQL>
Referen
. gcpisor and the maximum life time. Each php request has a certain probability of triggering the session detection mechanism. Session_setsavehandler can be used to redefine session behavior. There are two ways to implement redis storage session
Code Example 1:
The Code is as follows:
Ini_set ('session. gc_maxlifetime', 3600 );Ini_set ("session. save_handler", "redis ");Ini_set ("session. save_path", "tcp: // FIG: 6379? Auth = authpwd ");Session_start ();// $ _ SE
fuckshebao:function (Req,res,next) { //1800 per month for Social Security varday= (1800/ //15 Full Varfull_days=365*15;//retired at age 65 varold_days=365*35; vari=0;varp= 0;vartotal=0; //Time Flies while (iThe social security should not pay, oneself calculate a bill Nodejs code
create_more_administrative ments is begin add_more_administrative ments ('Media', 1800, 'editing', 99,1800); END;/BEGIN create_more_administrative ments; END; in this example 99 this record already exists in the table. If you insert the record again, the execution result will conflict with the following: the two insert statements are inserted only first, and the second one fails to be inserted. The execution result is as follows: SQL>/Add Dept: Media
Configure the php.ini file (for example, 500M files of the following size)Look for the following options and modify File_uploads = on; open File upload option upload_max_filesize = 500M; upload file limit If you want to upload larger files, only the above two are not enough, you must increase the server cache limit, the maximum execution time of the script is longer Post_max_size = 500M;p ost Upper max_execution_time = 1800; Maximum execution time of
"yes ".
LoginGraceTime 60 # If the client fails to log on within 60 seconds, the logon times out. sshd closes the connection.
KeyRegenerationInterval 1800 #1800 seconds (30 minutes), the server's key is automatically regenerated.
MaxStartups 3 # set the amount of unverified concurrency that occurs simultaneously, that is, there can be several
UseDNS no # Do not use the DNS query client.
PermitRootLogin no
EncryptionFirst, let's take a look at how to use this WEP Key to set up a wireless router. When configuring this part, it is best to use Wired connection to connect to the wireless router, because if you enter the wrong wireless key, you will not be able to use the correct key to connect to the wireless router.Use your Web browser to access the wireless router, and click the wireless parameter label. Enable Security Settings first, select WEP in the line marked with security type, and select he
');Ini_set (' Session.cookie_lifetime ', ' 1800 ');2. Set in php.iniSession.cookie_path =/Session.cookie_domain =. mydomain.comSession.cookie_lifetime = 18003. Call the function at the beginning of the PHP page (condition same as 1)Session_set_cookie_params (1800, '/', '. mydomain.com ');Experimental results:One650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/5C/9F/wKiom1UeTs-izDBxAALIDsdA6tc978.
problems are ruled out, I wrote a piece of test code, which quickly reproduced the problem.
The Code is as follows:
$ Y = "1800 ";$ X = array ();For ($ j = 0; $ j $ X [] = "{$ j }";}For ($ I = 0; I I If (in_array ($ y, $ x )){Continue;}}?>
Shell $ time/usr/local/php/bin/php test. php
Real 0m1. 132 s
User 0m1. 118 s
Sys 0m0. 015 s
Yes, we use string-type numbers. This is what we get from the cache! Therefore, this is specially converted to a st
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.