, our test destination/ Global/oradata is built on one of the LUNs, uses 8 disks, and Raid10,stripe (that is, Ncol) is set to 4 with Veritas Volum Manager.
bonnie++-d/global/oradata-s 8192-m d2new-u Oracle
Using uid:1001, gid:101.
Writing with PUTC () ... done
Writing Intelligently...done
Rewriting...done
Reading with getc () ... done
Reading Intelligently...done
Start ' Em...done...done...done ...
Create files in sequential order...done.
Stat files in sequential order...done.
Delete
Label:Build table Insert test dataA> CREATE TABLE test (id int, num int);Query OK, 0 rows affected (0.53 sec) a> INSERT into test values ();Query OK, 1 row affected (0.01 sec) a> INSERT into test values (2,2);Query OK, 1 row Affected (0.00 sec) a> INSERT into test values (3,3);Query OK, 1 row affected (0.01 sec) A> sel
column level.
Host permission table: Use the database permission table to control database-level operation permissions on a given host. This permission table is not affected by the GRANT and REVOKE statements.
Case analysis:
1. create and authorize a user (root user)
[Root @ mysrv ~] # Mysql-u root-poracle
Mysql> select version () \ g
+ ------------------------------------------- +
| Version () |
+ ------------------------------------------- +
| 5.6.25-enterprise-defined cial-advanced-lo
system:
Server # netserverStarting netserver at port 12865Starting netserver at hostname 0.0.0.0 port 12865 and family AF_UNSPEC
The netperf tool may require multiple sampling. most basic tests are a standard throughput test. in the following example, a 30-second TCP throughput sample is executed from the client in a LAN environment:
The output shows that the network throughput is about 89 mbps. The server (192.168.1.215) and client are in the same LAN. This is very good for 100 mbps networks.
tested 691180 data records reserve sufficient memory space for each insert of a large amount of data. For the deque storage allocation assumption, observe the memory allocation graph and the previous graph in this test. We need to further quantify this test.
How can we improve the performance of memory allocation?
The following figure shows that the capacity increases as data increases:
When adding data, the efficiency of adding the capacity is basically the same in the execution of ve
Label:Database version:[Email protected]mysqltest ~]# mysql-u root-p123456Welcome to the MySQL Monitor. Commands End With; or \g.Your MySQL Connection ID is 389805Server version:5.1.73-community MySQL Community Server (GPL)Copyright (c) and/or, Oracle, its affiliates. All rights reserved.Oracle is a registered trademark of the Oracle Corporation and/or itsAffiliates. Other names trademarks of their respectiveOwners.Type ' help ', ' or ' \h ' for help. Type ' \c ' to clear the current input state
Tags: random 5.4 Good handle OBA Rev calculation option occupiedMySQL performance index calculation and optimization method1 QPS calculation (number of queries per second)For MyISAM engine-based DB Mysql> show global status like ' questions '; +---------------+------------+ | variable_name | Value | +---------------+------------+ | Questions | 2805815665 | +---------------+------------+ 1 row in Set (0.00 sec) mysql> show global status like '
Tags: 646Day02The MySQL key value (key) # #设置在字段上, which constrains how to assign a value to a field. Normal indexUnique Indexes UniquePrimary KEY Primary KeyFOREIGN key foreign keyFull-Text Index fulltext +++++++++++++++++++++++++++++++++++1.1 Use of index for normal indexes1.1.1 What is an index?Equivalent to "book catalogue"Advantages and disadvantages of 1.1.2 indexesPros: Speed up your query historyCons: Accounting for physical storage space, slowing down write speed (insert update delete)
{Code ...} there are two arrays above, now, you need to know which of the preceding statements are repeated. For example, if the key in the array permission is MainIndextestb, and the key in the menu is MainIndextest, the second statement is repeated. For example, in the array permission key is Ma...
A:array(4) { ["Api/Index/index"] => string(3) "226" ["Main/Index/index"] => string(3) "227" ["Main/Index/main"] => string(3) "228" ["/Main/Index/test"] => string(3) "229"}B:array(22) { ["/Main/
workstations and a high-load server (such as file or web server. the netperf tool runs in client/server mode.
To complete a basic controllable throughput test, the netperf server must first run on the server-side system:
Server # netserverStarting netserver at port 12865Starting netserver at hostname 0.0.0.0 port 12865 and family AF_UNSPEC
The netperf tool may require multiple sampling. most basic tests are a standard throughput test. in the following example, a 30-second TCP throughput sample
Tags: mysql four kinds of transaction isolation mechanismThe MySQL standard defines 4 isolation levels that define which changes within and outside a transaction are visible and which are not.Low isolation levels generally support higher concurrency and lower system overhead.Isolation levels from low to High: READ UNCOMMITTED First: READ UNCOMMITTED (read UNCOMMITTED content)At this isolation level, all transactions can see the execution results of other uncommitted (commit) transactions.This is
, documents5. benefits and disadvantages of File compression
Vi. Others
1. Send mail (jmail; ms smtp)
Use Microsoft SMTP to send emails(1) install Microsoft SMTP service(2) Set Microsoft SMTP service(3). Code:Mail_smtp.aspSub Sendmail (fromwho, towho, subject, body)Dim mymailSet mymail = server. Createobject ("cdonts. newmail ")Mymail. From = fromwhoMymail. To = towhoMymail. Subject = subjectMymail. Bo
Vim/Vi practical skills (version 2) and vim Practical SkillsVim/Vi Practical Skills
1. Import files
: R [file name] # import to the currently edited File
For example, r/etc/inittab
The upper part of the file is the/etc/services file, and the lower part is the/etc/inittab file.
2. Run the command [do not exit vi]
:! [Command]
:! Ls-l/home/hadoop
Extended-import the command execution result to the currently edited file!
: R! Date
3. Define shortcuts
: Map [shortcut key] [trigger command]
E.
feed and carriage return is equivalent to [^ \ n \ r]
The same letter is case-insensitive.Hexadecimal and octal characters
It is also feasible to use hexadecimal or octal characters in regular expressions. The matching characters are the characters corresponding to the converted decimal value in ASCII.
Var reAt =/\ x40/; // The hexadecimal character \ x40 (64) corresponds to the character "@" var reA =/\ 0101 /; // octal character \ 0101 (65) corresponds to the character ""Duplicate match
Taki
SMTP server for some free public mailboxes does not allow this service, please select another SMTP.Vii. establishing a stored procedure for sending messages--Send mail template stored procedureCreate PROCEDURE [dbo]. [MyMail]@mailto varchar (max),@mailsubject nvarchar (255),@mailbody nvarchar (max)AsBEGINSet @mailbody =replace (replace (@mailbody, ' +n ' EXEC Msdb.dbo.sp_send_dbmail@profile_name = ' Worklogmail ',@recipients = @mailto,@subject = @mai
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.