/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
-- "/oracle/product/10.2.0/db_1/rdbms/admin/" is the script directoryAfter running the script, enter perfstat_password, default_tablespace, temporary_tablespace10. test whether a database snapshot is generated successfully.SQL> execute statspack. snap11. Generate a snapshotSQL> execute statspack. snap12. 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 re
+value+flags default is 48-H Display HelpOperation Memcached
Command
Description
Example
Get
Reads a value
Get MyKey
Set
Set a key unconditionally
Set MyKey 0 60 5
Add
ADD a new key
Add Newkey 0 60 5
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
Invalidate 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 all
ACCEPTIptables-a input-p udp-s 192.168.1.111-dpost 11211-j ACCEPT Install. then start memcached-d start
Command
Description
Example
Get
Reads a value
Get mykey
Set
Set a key unconditionally
Set mykey 0 60 5
Add
Add a new key
Add newkey 0 60 5
Replace
Overwrite existing key
Replace key 0 60 5
Append
Append data to existing key
Append key 0 60 15
Prepend
Prepend
provides data preprocessing and visualization functions for the classification, such as checking the redundancy and standardization of variables. The dist () in the base package and the Daisy () function in the cluster package provide a distance calculation function, and the proxy package provides more distance measures, including the distance between matrices. The Simba package handles both the existing and missing data, including the similarity matrix and the reshape.2) hypothesis test (hypot
= "access_combined_wcookie"
1. log requests whose source type is access_combined_wcookie and whose IP address is 10.2.1.44
-- 81
Sourcetype = "access_combined_wcookie" 10.2.1.44
2. Search for 63 requests for "purchase"
Sourcetype = "access_combined_wcookie" 10.2.1.44 purchase
3. Further search for purchase requests whose HTTP return code is not 200
Sourcetype = "access_combined_wcookie" 10.2.1.44 purchase not 200
4. Further search for requests that are not 404 error
Sourcetype = "access_combine
other Slab
After knowing this, we can understand why memcached has lost cache data when the total memory is not fully occupied.
-P
Connection: Telnet 127.0.0.1 11211.
Stats \ r \ nHere we can see the number of times memcache is obtained, the current number of connections, the number of writes, the hit rate, and so on;
PID: process IDUptime: total running time, in secondsTime: Current TimeVersion: Version Number......Curr_items: Number of keyva
----> customize a response header. You can view the HTTP packet to know that the request is responded by the group of backend servers. Cookie webserver insert nocache option httpchk server S1 172.16.0.99 cookie S1 check port 80 weight 1 server B1 127.0.0.1: 8080 backup stats enable --------> stats hide-version stats uri/haproxy?
Add
Add a new key
Add newkey 0 60 5
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
I
Memcached status analysis, memcached status
1. memcache status stats description:
Pid memcache server process ID uptime server has run seconds time server current unix timestamp version memcache version pointer_size pointer size of the current operating system (32-bit systems are generally 32bit) cumulative user time of the rusage_user process the cumulative system time of the rusage_system process the number of items currently stored on the curr_item
/spcreate. SQL -- "/oracle/product/10.2.0/db_1/rdbms/admin/" is the script directoryAfter running the script, enter perfstat_password, default_tablespace, temporary_tablespace10. test whether a database snapshot is generated successfully.SQL> execute statspack. snap11. Generate a snapshotSQL> execute statspack. snap12. 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 th
1. Memcached Stats command: The Memcached Stats command is used to return statistics such as PID ( process number ), version number, number of connections, and so on. Grammar:StatsOutput Information Description:PID: memcache server process IDUptime: Number of seconds the server has been runningTime: Server current Unix timestampVersion:memcache versionsPointer_size: Operating system pointer sizeRusage_u
Disable the Flush_all command
-O
Specify comma-delimited options, typically used for extended or experimental properties
Stop memcached
You can query the process number of the memcached by using the following command from Linux:grep memcachedThen kill the memcached service process:pid>-9 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 h
Knowledge to be mastered:1. Functions2. File processing3, the use of tag4, the decoupling of the programDemand:1: Query2: Add3: Delete4: Modify5: ExitHaproxy.conf Configuration file Contents: 1 Global 2 log 127.0.0.1 local2 3 daemon 4 maxconn 5 log 127.0.0.1 local2 info 6 DEFA Ults 7 Log Global 8 mode HTTP 9 Timeout connect 5000ms10 Timeout client 50000ms11 Timeout server 50000ms12 option Dontlognull13 Listen stats:888815
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.