timelog

display query results over a specified timeLog type for MySQL service:Error log: Default enabled, logged service error messages during startup and runBINLG log: Default is not enabled, after logging client Connection server, execute the SQL command other than the querySlow query log: SQL command to display query results over a specified time after logging client connections is not enabled by defaultQuery log: All SQL commands that are executed after

First, log cuttingPrinciple:1, CP a slow log backup2, clear the principle of slow log3, write a script, every day, so OKSecond, find the slow log in the log1, do a log cutting (slow log file is small)2. Find a slow log at a timeLog Time format: # time:161102 3:50:14Filter with grep: Grep-a15 "time:161102 3:50:14" Mysql_slow_query.logSlow log format:# time:161102 3:50:14# [email protected]: xxx[xxx] @ [xx.xx.xx.xx] id:4211754# query_time:18.014797 lock

($module),Mcrypt_rand); Mcrypt_generic_init ($module,$key,$iv); $encrypted=$iv. Mcrypt_generic ($module,$data); Mcrypt_generic_deinit ($module); Mcrypt_module_close ($module); return MD5($data).‘ _‘.Base64_encode($encrypted); } Public Static functionDecrypt$data,$key){ $_data=Explode(‘_‘,$data, 2); if(Count($_data) ){ return false; } $data=Base64_decode($_data[1]); $module=mcrypt_module_open (' des ', ', MCRYPT_MODE_CBC, '); $key=substr(MD5($key), 0,mcrypt_enc_get_key

, each time the need to retrieve the two ends of the userid is poor, and then use these two userid to make the choice of the third query is the data we want. These three searches we only need to read about 10 page to solve the problem. This approach looks like a hassle, but it's the only solution when the amount of data in the table reaches billions of dollars. Select a log for a period of timeLog table is our most common table, how to design is of

. In place. Out Dum. Out-nodisp-place_only-init_t 5-exit_t 0.005-alpha_t 0.9412-inner_num 2> place_log.out 2> place_log.errVPR net. In arch. in place. In route. Out-nodisp-route_only-route_chan_width 15-pres_fac_mult 2-acc_fac 1-Route 4-initial_pres_fac 8> route_log.out 2> routeVPR net. In arch. In place. Out Dum. Out-nodisp-place_only-init_t 5-exit_t 0.005-alpha_t 0.9412-inner_num 2> place_log.out 2> place_log.errVPR net. In arch. in place. In route. Out-nodisp-route_only-route_chan_width 15-pr

:##DHCPServerConfigurationfile.#see/usr/share/doc/dhcp*/dhcpd.conf.sample#see'man5dhcpd.conf'# Copy related scripts as promptedcp/usr/share/doc/dhcp-4.1.1/dhcpd.conf.sample/etc/dhcp/dhcpd.conf# Copy a scriptvim/etc/dhcp/decpd.conf# Open the configuration file as follows: The Information allocated to the client starting with option, and the operating characteristics of ducp defined by non-optionoptiondomain-name"magedu.com";# Configure a domain nameoptiondomain-name-servers8.8.8.8;# Configure the

maximum length of the string.When dealing with character arrays, don't forget to add '/0 ' or 0 at the end.11. Use the three mesh operatorint max (int a,int b){return a>b?a:b;}12. Convert multiplication to addition to reduce timeLog (A*b) =log (a) +log (b);Convert multiplication to division to prevent overflowA/(b*c) =a/b/c;13, sorting requirements are not high can be used in C + + STL template function sort (), Stable_sort ()int a[n]={...};Sort (a,a

the * @param String $skey Decrypt key106 * @return String107 */108 Public Static functionDecode$string= ",$skey= ' cxphp ')109 { the $STRARR=Str_split(Str_replace(Array(' o0o0o ', ' o000o ', ' oo00o '),Array(' = ', ' + ', '/'),$string), 2);111 $strCount=Count($STRARR); the foreach(Str_split($skey) as $key=$value) {113 $key$strCountisset($STRARR[$key]) $STRARR[$key][1] = = =$value$STRARR[$key] =$STRARR[$key][0]; the } the return B

] o.s.web.context.contextloader : Root webapplicationcontext:initialization Completed in 1358 Ms2014-03-05 10:57:51.698 INFO 45469---[ost-startstop-1] O.s.b.c.e.servletregistrationbean : Mapping servlet: ' Dispatcherservlet ' to [/]2014-03-05 10:57:51.702 INFO 45469---[ost-startstop-1] o.s.b.c.embedded.filterregistrationbean : Mapping filter: ' Hiddenhttpmethodfilter ' to: [/*]The content includes:Date and timeLog level: ERROR, WA

automatically disconnect if not connected)The wait_timeout default is 28,800 seconds, 8 hours, and the connection is disconnected.Net_read_timeout Network Read timeout timeNet_write_timeout Network Write timeout timeLog level for InnoDB:How the cached data in the Innodb_flush_log_at_trx_commit:innodb log is written to the hard disk.0 The least secure, every second to write data to the hard disk, power outages or database corruption data will be lost.

dbname cursor FORSelect name from master.dbo.sysdatabasesOpen dbnameFETCH NEXT from dbname to @nameWhile @ @fetch_status = 0BeginSet @cmd = ' Select b.databse_id, Db=dbname (b.database_id), p.object_id, p.index_id, Buffer_count=count (*) from ' + @name + '. Sys.allocation_units A, '+ @name + '. Sys.dm_os_buffer_descriptions b, ' + @name + '. Sys.partitions pwhere a.allocation_unit_id=b.allocation_unit_idand a.container_id=p.hobt_idand b.database_id=db_id ("' + @name + ')Group by b.database_id,

-scripts/ifcfg-eth0Device=eth0Type=ethernetOnboot=yesNm_controlled=noBootproto=staticipaddr=192.168.1.10netmask=255.255.255.02)/etc/init.d/network Restart | Service Network Restart | Reboot2. Install the DHCP package1) rpm-ivh/mnt/packages/portreserve-0.0.4-9.el6.x86_64.rpm2) rpm-ivh/mnt/packages/dhcp-4.1.1-49.p1.el6.centos.x86_64.rpmConfiguration1) cp/usr/share/doc/dhcp-4.1.1/dhcpd.conf.sample/etc/dhcp/dhcpd.conf//Copy DHCP configuration file template2)/etc/dhcp/dhcpd.conf:% g/^#/d//delete all