/db_1/rdbms/admin/" is the script directoryAfter running the script, enter perfstat_password, default_tablespace, temporary_tablespace
10. test whether a database snapshot is generated successfully.SQL> execute statspack. Snap
11. Generate a snapshotSQL> execute statspack. Snap
12. Take the statspack report for the time period between two snapshotsSQL> @/Oracle/product/10.2.0/db_1/rdbms/admin/spreport. SQLEnter the start point and end point for generating the statspack report. For example, a sna
In JS, code nesting and code callback are very common. They are not only difficult to write but are not harmful. It is a headache for me to wait for the codoon
function () { function () { function () { function () { //pass } } }}
This is a conventional nesting. If each function has a lot of logic processing, it will lead to a very long code, which is not only difficult to code, but also very painful to read, this is a good situation in JS,
tcp # http Layer 7 mode option httpchk # Heartbeat detection File server db1 10.1.6.203: 3306 weight 1 check port 9222 inter 12000 rise 3 fall 3 # server definition, check inter 12000 is the heartbeat detection frequency rise 3 is 3 times correctly think the server is available, fall 3 is 3 times failed think the server is unavailable, weight stands for weight server db2 10.1.6.205: 3306 weweigh T 1 check port 9222 inter 12000 rise 3 fall 3 listen haproxy_stats mode http bind 10.1.6.173: 8888 o
;haproxygrouphaproxy daemon#turnonstatsunixsocket statssocket/var/lib/haproxy/stats#---------------------------------------- -----------------------------#mainfrontendwhichproxystothebackends#- --------------------------------------------------------------------frontendmain*:80 #第一种方式 #bind*:80 #第二种方式 # bind*:8080 #只能用于frontend, listen;#maxconn can also be defined here or after listen, Defines the maximum number of concurrent connections for a single
I like it very much;
5. HAProxy supports virtual hosts.
The following describes how to use Haproxy as the Server Load balancer:Current Environment:
Ubuntu16.04 + Haproxy 192.168.93.21Centos6 + httpd 192.168.93.5Centos6 + httpd 192.168.93.7
Haproxy configuration file
Vi/etc/haproxy. using Global log/dev/log local0 log/dev/log local1 notice chroot/var/lib/haproxy stats socket/run/haproxy/admin. sock mode 660 level admin
Database home directory, default is '/data1/memcacheq '
-L
Log buffer size, default is 32KB
-C
How many seconds checkpoint once, 0 for disable, and default is 5 minutes
-T
How many seconds Memp_trickle once, 0 for disable, and default is seconds
-S
How many seconds queue stats dump once, 0 for disable, and defaul
([mydir ,'*. jpg ']); % extension n = length (DIRS); for I = 1: n if ~ DIRS (I ). isdir img = imread (strcat (mydir, DIRS (I ). name); img = im2bw (img); % binarization img = 1-img; % color Anti-transfer characters become Unicom domains, easy to remove noise for ii = region = [ii * 20 +,]; % divide a verification code into four 20*20 character pictures subimg = imcdrop (img, region); imlabel = bwlabel (subimg); % imshow (imlabel); if max (imlabel)> 1% indicates that there is noise, % max (imlab
/admin/spauto. SQL
14. Delete historical data
Select max (snap_id) from stats $ snapshot; -- deletes the corresponding data in the stats $ snapshot table. The corresponding data in other tables is also deleted.
Delete from stats $ snapshot where snap_id You can also run the sptrunc. SQL script to directly Delete the information of these statistical tables.
Note:
means to force the kill process.After the memcached is started, the data in the cache can be manipulated by the client, and we describe some common clients and how to use them.Telnet ClientThe Telnet client can use the command line to monitor how the memcached server stores data. For example, Memcached has a service address of 192.168.4.86:11211 and can telnet to the service port:Telnet 192.168.4.86 11211If the connection succeeds, you can use some of the following commands:
, Memcached is an LRU cache, and it cleans up extended data as long as it is pre-booked, but in fact, memcached does not delete any cached data but is no longer visible to the customer after it expires; Memcached also does not really clean up the cache by age, but only when the get command arrives, checking its duration;Memcached provides a handful of commands to accomplish server-side interactions, which are based on memcached protocol implementations.Storage class Commands: Set, add, replace,
Overwrite existing Key
Replace key 0 60 5
Append
Append data to existing key
Append key 0 60 15
Prepend
Prepend data to existing key
Prepend Key 0 60 15
incr
Increments numerical key value by given number
INCR MyKey 2
Decr
Decrements numerical key value by given number
DECR MyKey 5
Delete
Deletes an existing key
Delete MyKey
Flush_all
Invalidate sp
specific items immediately
Flush_all
Invalidate all items in n seconds
Flush_all 900
Stats
Prints General Statistics
Stats
Prints Memory Statistics
Stats Slabs
Prints Memory Statistics
Stats malloc
Print Higher level al
port 9222 Inter 12000 Rise 3 Fall 3 #服务器定义, check Inter 12000 is detecting heartbeat frequency rise 3 is 3 times correctly think the server is available , Fall 3 is 3 failures that the server is not available, weight represents the weight server DB2 10.1.6.205:3306 weight 1 Check port 9222 Inter 12000 rise 3 Fall 3 list En haproxy_stats MoDE http bind 10.1.6.173:8888 option httplog stats Refresh 5s stats u
Key
Replace key 0 60 5
Append
Append data to existing key
Append key 0 60 15
Prepend
Prepend data to existing key
Prepend Key 0 60 15
incr
Increments numerical key value by given number
INCR MyKey 2
Decr
Decrements numerical key value by given number
DECR MyKey 5
Delete
Deletes an existing key
Dele
/spcreate.sql--"/oracle/product/10.2.0/db_1/rdbms/admin/" as script directory
After you run the script, enter Perfstat_password, Default_tablespace, Temporary_tablespace
10, test whether successful, generate a snapshot of the database
Sql> Execute Statspack.snap
11. Regenerate into a snapshot
Sql> Execute Statspack.snap
12, take two snapshots between the time period of the Statspack report
Sql> @/oracle/product/10.2.0/db_1/rdbms/admin/spreport.sql
Enter the starting and ending points for generat
process, which should be less than the number of CPU cores. Daemon #进程后台运行, (recommended mode) Defaults mode HTTP #实例的默认运行模式 retries 3 #连接后端服务器的失败重试次数 timeout Connect 10s #连接服务器的最长等待时间 , the default unit is milliseconds, you can use other time units Timeout client 20s #连接客户端发送数据时最长等待时间, the default is milliseconds, you can use other time units timeout server 30s #服务器回应给客户端数据发送的最长等待时间, The unit is milliseconds, you can use other time units timeout Check 5s #对后端服务器的检查超时时间, the default unit is mil
Label:1.memcached InstallationYum Search memcached Yum install-y libevent memcached libmemcached Start:/etc/init.d/memcached start Viewing the Listening port: NETSTAT-LNP |grep Memcached|netstat-naput Ps-aux |grep memcached Define Startup parameters: Vim/etc/sysconfig/memcached -D: Start a daemon -P: Listening port -C: Maximum number of concurrent connections running M: Amount of memory allocated to memcached -L: Listening server IP address -P: Set the PID file to save memcached View memcached S
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.