conditions, filtering conditions, aggregate queries, and sorting fields as index candidate fields.
C. Combine frequently-used fields to form a composite index. The field order of the composite index is the same as that of the primary key. You also need to put the most commonly used fields in front, put the fields with low repetition rate in front.
D. Do not add too many indexes to a table because the index affects the insert and update speeds.
Indexing is not only a matter of consideration when
Hardware preparation environment:
Hard drive: 16 SAS 15 k raid 5 with 512 MCache
CPU: AMD 4-core two
Memory: 16 GB
Software environment:
Operating System: RedHat AS4.6 2.6.9-67. ELsmp
Mysql: 5.0.
Performance Tuning based on different scenarios is as follows:
Scenario:
Write operations (insert, query, and delete) are intensive, and the data capacity far exceeds the memory size (minimum is more than GB, or ev
Article Source: http://hi.baidu.com/top2top/blog/item/0bea951600a16050f2de322b.html apache2.0 prefork and worker module Performance Tuning
The performance improvement of Apache 2.0 is the most attractive. On UNIX systems that support POSIX Threads, Apache can use different MPM to run in a mix of multi-process and multi-thread modes to enhance the scalabi
MySQL performance tuning and Architecture Design-Chapter 1 Data splitting of scalability design and mysql Optimization
Chapter 1 Data splitting for scalable design
Preface The expansion implemented through the MySQL Replication function is always limited by the size of the database. Once the database is too large, especially when writing too frequently, it is difficult to support it by a host, we are still
TraceView and androidtraceview of Android Performance Tuning Tool
Since the 16 Performance Optimization series Videos released by Google in January, many excellent articles on the optimization series have been found in major communities during this time. I have analyzed the causes of performance, shared how to optimize
There are fewer tutorials on iOS performance tuning, and the decision to write an iOS performance Tuning series focuses on several aspects of memory leaks, performance optimization, traffic, and power analysis.Xcode has provided a very powerful
, you can copy the collection into an array.Pay attention to redraw and re-typesetting, batch modify style, operate DOM tree offline, cache and reduce access to layout information.Use absolute coordinates in animations, using drag-and-drop proxies.Minimize the number of event handles using event-managed technology.Algorithm and process optimizationThe performance characteristics of the for,while,do-while cycle are similar, and no one is faster or slow
default.Copying files between OSS, currently only supports copying object and does not support copying multipart.General recommendationsJobs * Parallel and CPU cores are 1:1,2:1, but not too bigToo many concurrent numbers will directly fill the network card, the CPU will be crowded. It is recommended to observe the environment CPU, network, process/thread condition while concurrencyReferenceOssutil Large File Breakpoint continuationPlease add a link to the original link descriptionThis article
1. JPS (Java Virtual machine Process Status Tool)JPS is primarily used to output process state information running in the JVM-Q does not output the class name, jar name, and parameters passed in the Main method-m output parameters that pass in the Main method-L OUTPUT The full name of the main class or Jar-V Output parameters for incoming JVM2. JstackJstack is used primarily to view thread stack information within a Java processThe command line parameter options are described below:-L long listi
Performance optimizations for CSS:
Related tuning of Style tags
How to use special CSS styles
CSS abbreviation (color, up or down merge, etc.)
CSS declarations (the class on the page should be unique globally, and locating a node with a unique class name is often quicker than combining positioning.) separation of styles from elements, both independently maintained )
CSS selectors (the ID select
AIX
Performance Tuning-Memory and CPU
Sar-P all CPU usage
Sar-A File AccessThe number of fast reads (B) by the Directory Access daemon when the dirblk/s locates the fileIget/s I node to find the number of times the system process is calledLookuppn/s Directory: the number of times the process finds the V node and obtains the path name.
Activity of SAR-B buffer, including transmission, access, and hit rateNu
for new TCP connections, which defaults to 0, which means shutdown; Net.ipv4.tcp_tw_recycle = 1 indicates a fast recovery of time-wait sockets in a TCP connection, and the default is 0, which means close; NET.IPV4.TCP_FIN_TIMEOUT=30 modifies the default timeout time for the system . If the above configuration tuning performance is not ideal, you can continue to modify the configuration:Vi/etc/sysctl.co
Linux system Performance Tuning related commands summary:1. PS: See which processes are currently running in the systemCommon commands are PS aux | Grep-i MySQLHttp://www.cnblogs.com/peida/archive/2012/12/19/2824418.html2. Top: Dynamic display of the CPU, memory usage, and load of each programHttp://www.cnblogs.com/ggjucheng/archive/2012/01/08/2316399.html3. Overall load of IO, process IO load, load from a
Tags: mysql, mariadbEvery day seems very busy, in fact, found themselves still very lazy, read a lot of books, not a good read. Recently, not so much work, decided to finish reading a few books, and continue to keep on updating. I hope I can persist in the end! The later content is all about MySQL management (performance tuning, high availability and monitoring), mariadb and MySQL, and your own experiments.
MySQL Management: Performance tuning, high availability and monitoring mini-bookmysql5.5.x Main Improvements1. Use InnoDB storage engine by default2. Make full use of CPU multi-core processing capability3, improve the number of brush write dirty pages and merge the number of inserts, improve I/O4, let Innodb_buffer_pool buffer pool of heat data to survive longer, pollution problems5, InnoDB Data recovery ti
so that you can mark the snapshot information set at important times. A baseline is defined between a pair of snapshots, and the snapshot is identified by their snapshot sequence number. eachThe baseline has only a couple of snapshots. A typical performance tuning practice starts with collecting baseline collections of metrics, making changes, and then capturing another set of baselines. You can compare th
Source Address: https://msandbu.wordpress.com/2014/10/31/netscaler-and-real-performance-tuning/The author is obviously not a native English speaker, so some places I look at is also more laborious, but very grateful to the original author.========= translated content started =========Yesterday I had a meeting with Citrix User group in Norway on NetScaler and performance
powerful visualization tools, Jconsole and JVISUALVM. The latter, called Oracle's main-driven multiple-in-one fault-handling tool, has been separated from the JDK as an Open-source project that can be independently developed. Introduction to Performance tuning
Most people will use some virtual machine parameters or commands (such as configuration heap memory size, configure garbage collector, etc.) to do s
structures, the more tables, need to allocate more memory, a version set to 16MB(3) Innodb_log_buffer_size: The buffer used by the transaction log.7.3 Query cache is used in different environments: its function is to cache SELECT statements and result sets. The query cache will never return stale data, and any related entries in the query cache will be erased when the data is modified.If there are many write operations in the environment, it is not appropriate to open query_cache_type, and if r
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.