Original article link
In Linux, core files are not generated by default. You must open them with ulimit-C unlimited.
Overview
System performance has always been a topic of interest. How to achieve the most effective performance tuning through
1 Virtual Machine hard drive should not be set to the default 8g as big as possible
2. It is not difficult to install oracle. Is not familiar with Linux Command operations
3. When installing the Linux system, remember to set the resolution
Guidance:
X $ the table name is too hard to remember. record it for future reference.
[K] ernel Layer
[2]-phase commit
[G] lobal [T] ransaction [e] ntry
X $ k2gte-current 2 PC TX
X $ k2gte2-current 2 PC TX
[C] ache Layer
[B] uffer Management
Buffer [
Overview
Software design is the most important part of converting requirements into software systems. The advantages and disadvantages of system design fundamentally determine the quality of software systems.
This article mainly describes five core
Background:
Recently, some web-related work has discovered the Performance Testing Tool webbench, which is very easy to use. However, the use process was not satisfactory, so the idea of improvement came into being.
Webbench is based on the GPL
9i data dictionary user view.
645. user_all_tables
Description of the table available to the user.
646. user_arguments
Lists the parameters in a user-accessible object.
647. user_associations
User-Defined statistics on the objects owned by the
Q: Why is the "Service unavailable" prompt sometimes displayed on my website, which can be accessed after several refresh times.
A: This is because your website has exceeded the system resource limit, mainly because the traffic is too large or the
Introduction to three MPM types
Apache 2.x supports plug-in parallel processing modules, called multipleRoad Processing Module(MPM ). When compiling Apache, You must select or select only one MPM. For Unix-like systems, there are several
UlimitThe resources used to start a shell process are shell built-in commands.
Function Description:Controls shell program resources.
Note:Ulimit is a built-in shell command that can be used to control shell execution program resources.
Syntax
Enable the FTP (vsftpd) service in Linux1. check whether it is installed # rpm-qa | grep vsftpd 2. new Installation # rpm-ivh vsftpd-2.0.1-5.i386.rpm 3. start/stop/restart # service vsftpd start # service vsftpd stop # service vsftpd restart 4. main
Database users should not be locked
1) view the default number of database locks[SQL]
SQL>SetLinesize 2000
SQL>Select*FromDba_profilesWhereResource_nameLike 'Failed _ LOGIN_ATTEMPTS %';
PROFILE RESOURCE_NAME RESOURCE LIMIT
--------------------
During project development today, we found that there are too many database connections and many timeout connections exist in Oracle. As a result, the new client cannot connect to the database. Therefore, the oracle connection attribute is forcibly
Oracle 11g password expired lock reported ORA-28000 the account is locked, 11gora-28000
I. Reasons for triggering this error and Related Factors
This is because "PASSWORD_LIFE_TIME = 180 days" is set in the default profile in oracle11g by
Password verification during Oracle user Creation
We need to perform some performance tests in the test environment today. In order not to affect the original data, we need to create a temporary schema. However, the following error is reported
ORACLE System Table Overview, oracle Overview
Oracle System Table Overview
The following is a comprehensive introduction to Oracle system tables: the data dictionary dict always belongs to the Oracle user sys.
1. User:
Select username from
Oracle limits the number of connections and PROFILE of a user
Today, a colleague called to limit the number of connections of a user, which can be achieved through the Oracle PROFILE file.
1. View resource_limit parameters: SQL> show parameter
Linux Process understanding and practice (1) Basic concepts and programming Overview (fork, vfork, cow)Process and program what is a program? A program is a set of commands to complete a specific task. What is a process? [1] from the user's
Create and set a MySQL user through the command line in Linux
Q: I want to create a new user account on the MySQL server and grant it appropriate permissions and resource restrictions. How can I create and set a MySQL user through command line?
To
Nginx: TooManyOpenFiles solution Summary
During Nginx high-pressure testing, sometimes a WEB logs throws Too program Open Files, which is generally optimized from the following three aspects:
1. nginx. conf parameter planning and setting
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.