Tags: Access record win log file data file Profile Check MDF BSPOne: How the data is stored: 1. Data files:. mdf or. ndf 2. log file:. ldf Two: The work steps of the transaction log: 1. Data modification is emitted by the application (cached in buffer) 2. The data page is in the buffer buffer, or read into the buffers cache and modify 3. Modify the transaction log that is recorded on disk 4. The checkpoint is written to the database Three: Manual Performance
Server high performance program disk I/O
Linux IoSystem Architecture
I.Device--------Factors Affecting disk Performance
The speed of the hard disk affects the overall performance of the hard disk. Generally, the higher the speed, the better the performance.
Hard
tutorial, which is basically very old. When we use Ubuntu, we usually use the software package manager of the system to install the software, and seldom compile and install the software by ourselves. However, we recommend that you use an earlier version for independent/usr,/opt,/usr/local, instead of re-compiling the software when reinstalling the system. However, for most common users, this suggestion is usually meaningless.5./var: System Log Record
Anywhere (v6)139/tcp ALLOW Anywhere (v6)445/tcp ALLOW Anywhere (v6)8080/tcp ALLOW Anywhere (v6)3306 ALLOW Anywhere (v6)Devadm @ devserver :~ $
3) Local Connection to configure the user and user database
Devadm @ devserver :~ $ Mysql-h 127.0.0.1-u root-pEnter password:Welcome to the MySQL monitor. Commands end with; or \ g.Your MySQL connection id is 43Server version: 5.1.58-1Ubuntu1 (Ubuntu)
For systems running on-line, current database performance monitoring typically monitors the following points:(1) Whether there is obstruction (Blocking);(2) whether there is waiting (waiting), blocking is the lock (locks) waiting;(3) Whether the running time is too long (long running);(4) Whether there is a deadlock (Deadlock);Sys.dm_exec_query_stats and so on, and so on some statistical information, usually not as the real-time alarm content, but in
on the size of the data.resolves a memory fragmentation problem , but creates a waste of memory ( such as 100bytes of data to be stored in a block of )tuning : adjusting the block size of a group based on data sizedata deletion aspects of MemcachedU Memcached does not really delete data , does not monitor expired data , but checks for expiration at get , This technique is called lazy ( lazy )U LRU overwrites the least recently used dataMemcached 's
services in Ubuntu require memory, CPU, and disk space. disabling or deleting unnecessary services can improve the overall system performance and reduce the attack surface. Run the following command to check which services are running in the current system:
Sudo initctl list | grep running
You can use the following command to disable services that are not needed:
Sudo update-rc.d-f service name remove
installation, the installation steps are as follows:TAR-XZVF rpc.rstatd-4.0.1.tar.gzCD RPC.RSTATD-4.0.1/./configure-Configuration Actionsmake-to compileMake install-start InstallationRpc.rstatd-starting the RSTATD process"Rpcinfo-p" command to see if the current system has started the RSTATD daemonAppears as followsProgram Version Protocol port100000 2 TCP 111 Portmapper100000 2 UDP 111 Portmapper100024 1 UDP 669 status100024 1 TCP 672 status100001 5 UDP 718 RSTATD100001 3 UDP 718 RSTATD100001
Performance testing, we have two parts of the attention point1 service itself: Concurrency response time QPS2 Server Resource Usage: CPU memory I/O disk, etc.JMeter Plugins plug-in can realize the "two" monitoring, the specific operation steps are as follows (the main record of my practice process):Description: My jmeter version is 2.13Download Plugin1 visit URL http://jmeter-plugins.org/downloads/all/, dow
, non-blocking IO. Stability is strong, but the overhead of the context switch grows rapidly with HTTP request increments. 2> a kernel-level thread that handles a single connection, non-blocking IO, multi-process multithreaded hybrid approach. The problem with Context switch still exists.In theory, more concurrent connections can be supported. 3> a process handles multiple connections, non-blocking IO. (Epoll, Kqueue) lighttpd, Nginx. Strong concurrency perf
test Environment: Ubuntu 14.04 with i5-3230mTomcat 8.0.5 with 64bit jre1.7.0_55PHP 5.5.8 with Zend Opcache V7.0.3-dev test Script: Displays the current server time Java tomcat:t.jsp PHP CLI server:t.php TASKSET-PC 1 ' pgrep java ' binds Java processes to CPU1Taskset-p ' pgrep Java ' to view CPU usage after binding Taskset-c 1 php-s 127.0.0.1:8081-t/png/www/bind PHP process to CPU1 and startTaskset-p ' pg
--------------------------------------------------------------------------------------Note: ServerAgent boot to rely on JDK Oh, JDK installation process slightly ( install a Linux version of the JDK, first of all, to view the Linux operating system information to facilitate the download of the appropriate JDK version )installation configuration JDK environment variables encountered problems: With the vi edit configuration file/etc profile, save always prompt is rejected, and then use sudo vi pro
On ubuntu 15.04 server, how does one configure SNMPv3?
SNMP is an internet standard protocol that can be used to manage devices on an IP network ". Generally, devices that support SNMP include routers, switches, servers, workstations, printers, modems, and more devices. It is most commonly used in the network management system to monitor devices connected to the
minimal Ubuntu server as the basis for this article. I run all the commands under root, so make sure you're using the root account: sudo suInstalling MariaDB as a replacement for MySQLI installed MariaDB instead of MySQL. MariaDB is the MySQL branch version maintained by the author of MySQL Monty Widenius. MariaDB is compatible with MySQL and adds functionality to improve
There are many methods for setting up a vpn server on ubuntu with a single NIC, including PPTP, L2TP/IPSec, and OpenVPN. Among the three methods, the latter two have better security, but the configuration is troublesome. OpenVPN is deployed on Windows/Mac...
There are many methods for setting up a vpn server on ubuntu
operations of the Web server.
(2) nginx Signal Control
Nginx uses signals to control nginx stop and smooth restart. The main semaphores include:
Term, int
Quick Shutdown
Quit
Graceful shutdown: closes the process after the request ends.
Hup
Configuration reload, start the new worker processesA new configuration gracefully shutdown the old worker ProcessesChange the configuration file, repeat the configuration fil
GitLab Server tutorial in Ubuntu 16.04, 16.04 gitlab
I. Members of the "git" Family
First, I solve a problem that is easy to confuse, and I often confuse it:
Git is a version control system, a command, and a tool.
Gitlib is a development library used to implement git functions.
Github is an online code hosting repository based on git. It contains a website interface that is open to the Internet.
Gitlab is
Microsoft has just announced a public preview of the next generation of SQL Server, and Canonical has officially announced that this preview is available for Ubuntu systems. Whether used internally or in the cloud, SQL Server on Ubuntu provides developers and organizations with a more liberal choice. The development la
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.