linux performance tuning books

15 useful MySQL/MariaDB performance tuning and Optimization Techniques MySQL is a powerful open-source Relational Database Management System (RDBMS ). It was released in 1995 (20 years ago ). It uses Structured Query Language (SQL), which may be the most popular choice in database content management. The latest MySQL version is 5.6.25, which was released on July 25, May 29, 2015. An interesting fact about M

and optimized the performance of Hadoop clusters deployed in virtualization and Physical Mode on the same scale. The experiment shows that the virtualized Hadoop cluster can well support the production environment.Performance Comparison between a virtualized environment and a physical environment Figure 1 shows the deployment style of the Performance Tuning Test

Tags:/etc/serve linux show via experience performance help insertionMySQL restricts the size of packets accepted by the server according to the configuration file.Sometimes large inserts and updates are limited by the Max_allowed_packet parameter, resulting in failure.View current configurationShow VARIABLES like '%max_allowed_packet% ';The results shown are:+--------------------+---------+| variable_name |

, the most important of which is how long the thread has been running. Consider this factor to allow each thread to get the chance to run. So, regardless of how low the priority of the thread is set, they always get the chance to run.In addition, the weight of the thread priority set on the different OS is different. On Unix-based systems, the execution time of a thread is a factor in the current priority of the dominant thread, which means that the thread priority set is rarely "referenced". On

order to better match the permission record in the Mysql.user (some are defined by hostname).If the MySQL server has a DNS server set up and the client IP does not have a corresponding hostname on the DNS, then this process is slow and causes the connection to wait.After adding skip-name-resolve, I skipped a process.If the table scan rate exceeds 4000, indicating that too many table scans have been performed, it is likely that the index has not been built, and that increasing the read_buffer_si

://www.iptables.org/Netfilter/iptables Project2.11 http://www.linuxfromscratch.orgLFS (Linux from scratch) project2.12 http://www.uclibc.orgUclibc (C library for developing embedded Linux systems) Homepage2.13 http://www.LinuxVirtualServer.orgChapter ‑ Linux virtual server project2.14 http://linux-ha.orgHigh-availabili

Linux statistics/monitoring tools SAR Details: To determine a system bottleneck, sometimes it takes several SAR command options to combine, 怀疑CPU存在瓶颈，可用 sar -u 和 sar -q deng 等来查看 怀疑内存存在瓶颈，可用 sar -B、sar -r 和 sar -W 等来查看 怀疑I/O存在瓶颈，可用 sar -b、sar -u 和 sar -d 等来查看View the overall condition of the machine using the command DSTAT-TCDLNMP Https://github.com/dagwieers/dstatTop threads that consume the most CPU resources: ps -eL -o pid,%cpu,lwp|grep -i 12

, insufficient use of resources or the structure of the program is unreasonable.For Java applications, the method of looking for performance bottlenecks is typically to analyze resource consumption first, and then combine some Java tools to query for code that causes excessive resource consumption in the program. CPU Consumption AnalysisContext SwitchesEach CPU can execute only one thread at a time,andLinux uses preemptive scheduling, that is, each th

Tags: size arrangement SDN Technology share ext ODBC. NET Analysis tool downPostgreSQL Hardware Performance Tuning Translated from the article "PostgreSQL Hardware performance Tuning" PostgreSQL is an object-relational database developed by developers all over the world on the Internet. She is an open so

Reference: 1190000000666603 http://blog.csdn.net/zhoudaxia/article/details/23853609 #使用cpython PyPy for improved performance http://www.ibm.com/developerworks/cn/linux/l-cn-python-optim/ Optimization of the algorithm time complexityThe time complexity of the algorithm has the greatest impact on the execution efficiency of the program, and in Python it is possible to optimize the time complexity by se

Brother Bird's Linux Private cuisine (third edition) Basic Learning Chapter Linux command line and Shell script programming Daquan High-performance Linux server Building combat Proficient in regular expressions Battle Nginx (Technical Volume system volume) HTTP TCP/IP Detailed Volume One Teach you

1, Tomcat's external tuningJava Virtual Machine (JVM) performance optimization allows you to set the size of the virtual machine using memory,-xmsThe size of these two values is generally set as needed. The size of the initialization heap performs the size of the memory that the virtual machine requests to the system at startup. Generally speaking, this parameter is not important. However, some applications in a large load of the case will be a sharp

add the following line to the boot auto mount in the/etc/fstab file: /dev/sdb1/ssd ext3 defaults00 Now we move MySQL to the new diskFirst stop the MySQL service: #service mysqld stop I suggest you?? Stop Apache/nginx at the same time to prevent any attempts to write to the database: #service httpd stop #service nginx stop Now copy the entire MySQL directory into the new partition: #cp/var/lib/mysql/ssd/-Rp This may take some time, depe

recommended to copy the library file tcnative-1.dll to the bin directory of Tomcat. In linux, you can directly decompress and install the tomcat_native.tar.gz file under the bindirectory. Before compiling, make sure that the APR library has been installed.How can I determine whether the APR library is enabled for Tomcat? The method is to view the Tomcat startup log:If APR is not enabled, the startup log generally contains the following:Org. Apache. C

Tuning mysql Network Performance Debugging Tool article bitsCN.com this article is an article about Linux system network performance management skills, this section describes how to use route, netstat, and tcpdump network management testing tools and their functions. Route When configuring the network, you must specify

Debugging Tool for tuning mysql Network Performance: This article describes the network performance management skills of Linux systems, this section describes how to use route, netstat, and tcpdump network management testing tools and their functions. Route When configuring the network, you must specify the path throu

efficient results. Http://bbs.linuxtone.org/thread-5152-1-1.html3. Operating System-level optimizationA> A 64-bit system can allocate more memory and service tuning to a single process, disable unnecessary services, modify file descriptor restrictions, and reserve more resources for MySQL;B> File System Optimization: XFS is recommended for a separate file system for the data warehouse, which is generally more efficient and reliable.C> enable the noat

Linux tuning:The purpose of tuning is to make the system more efficient and to maximize the balance of system resource usage.Resources:http://os.51cto.com/art/201303/385726.htm (Tuning those things)http://www.111cn.net/sys/linux/58433.htm (io/System/Memory performance

currently doing performance analysis of things, not how to contact perf, find a few articles combed a bit, according to the form of problems recorded here. easy to see for yourself. What is perf? Linux Performance Tuning tool, 32 cores above the tool, software performance

) Programming Essence: Writing high-quality C-language code Deep anatomy of the C language "C and Pointers" "C Expert Programming" V. C + + Series "C + + Primer" is currently looking at start time 20170307 "C + + programming language" "Effective C + +" "More effective C + +" 99 common programming errors in the C + + language "Meditation on C + +" C + + Programming anatomy-issues, scenarios, and Design guidelines Liu Weipeng translation