This paper introduces the tuning method of MySQL, including slow log query analysis and explain query analysis SQL execution plan1. mysql optimization1, slow log query analysisYou first need to make some settings for the slow log, as follows:SHOW
Configuring SSHWith the network SSH service is open by default, you can test with the client, if not open using the following command: [[Email protected] ~] # /etc/init.d/sshd Restart stopping sshd: [ OK ] activating sshd:
CentOS Study Notes-SSH, centos-sshConfigure SSH
If the network SSH service is enabled by default, you can test it on the client. If not, run the following command:
[Root @ www ~] #/Etc/init. d/sshd restart stopping sshd: [OK] Activating sshd: [OK] #
We often see a large set of small variables to prevent compile from being optimized to register variables. Do not pollute...
The pdflush kernel thread pool is a process context work environment created by Linux to write back file system data. Its
Explanation of the content of Vmstat resultsVmstatprocs-----------Memory-------------Swap-------io------System-------CPU------R b swpd free buff cache si so bi bo in CS us sy ID WA St2 0 88 199564 134860 1175252 0 0 0 352 9323 10496 8 6 85 0
by Falcon of tinylab.org2015/04/18ReasonSource code analysis is a topic that programmers can not leave.Whether it is research open source projects, or usually do all kinds of transplant, development, can not avoid the deep interpretation of the
The is grey of the Earth, the land of the constantly unpleasant smell. A storm is coming.
This is the second day of the interview back, as usual, sleep to 11 natural awake, I do not know this is called happiness or tragedy, my sleep quality is very
In Linux systems, we often use the free command to view the state of the system's memory usage. On a RHEL6 system, the display of the free command is probably a state:[[email protected] ~]# free total used free shared
400. V $ pq_sysstat
Lists the statistics of the parallel query system.
401. V $ pq_tqstat
Contains statistics on parallel execution operations to help determine imbalance in a query.
402. V $ Process
Contains information about the active process.
403
Leverage a simplified user interface
With the redesigned, Easy-to-use Reader 8 interface, you can view information more accurately and efficiently. Select reading mode to allow more content to fit into the screen, select the double mode to see the
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.