mysql tuning script

2014-08-23 BaoxinjianI. Summary A script that is circulated online to query the efficiency of a single SQL query and export it as an HTML report, similar in function to Dbms_profilerQuery sql_id by session, only run script, export as HTML reportThe SQL script: Http://files.cnblogs.com/eastsea/sqlcheck.zipIi. cases-Using the

Today, developers continue to develop and deploy applications that use lamp (linux®, Apache, MySQL, and Php/perl) architectures. However, server administrators often have little control over the application itself, because the application is written by someone else. This article focuses on tuning the database layer to achieve maximum efficiency. About MySQL

MySql Performance Tuning (5) demonstration of using a proper lock mechanism for table locks, mysql Tuning MySql locks take the following forms: 1. Table-level locks; low overhead, fast locking; no deadlock; large lock granularity, the highest probability of lock conflict, th

MySql Performance Tuning (4) Quick table structure modification and mysql Tuning 1. Modify the varchar type To meet your needs, change varchar (6) To varchar (8). A better method is not to use altertable modify, but to use the following steps: A. Create A temporary table and set varchar to varchar (8) as fol

Cache Size| Query_cache_type | On | cache type, determines what queries are cached| Query_cache_wlock_invalidate | OFF | when other clients are writing to the MyISAM table If the query cache is returned , the cache result, or wait for the write operation to complete the reread table to get results+------------------------------+---------+Mysql> show global Status Like "qcache%";+-------------------------+-------+| va

. When the load increases on your server, use show processlist to view slow and problematic queries.86. All suspicious queries that are tested in the mirrored data generated in the development environment.MySQL backup process: 87. Back up from a level two replication server.88. Stop replication during a backup to avoid inconsistencies in data dependencies and foreign key constraints.89. Completely stop MySQL and back up from the database file.90. If y

show processlist to view slow and problematic queries.86. All suspicious queries that are tested in the mirrored data generated in the development environment.MySQL Backup process:87. Back up from a level two replication server.88. Stop replication during a backup to avoid inconsistencies in data dependencies and foreign key constraints.89. Completely stop MySQL and back up from the database file.90. If you are backing up using

We are in the design, often fine-tuning the color of the light and shade, or to some online color tool site to adjust the brightness accurately, but this is more troublesome, where the design of the talent network to find a very useful photoshop brightness adjustment script, The use of the time only to press the Photoshop shortcut keys can adjust the color of the bright and dark, saving a lot of design time

;>/opt/cron.log#记录执行时间Statime= ' Date +%y-%m-%d ' "%h:%m:%s 'echo "$statime" >>/opt/cron.log#任务计划开始时间, extraction hoursA= ' Cat/opt/cron.txt | grep dts_input.sh | awk ' {print $} '#传输完成时间, extraction hoursb= ' Tail-1/tmp/dts_message.log | awk ' {print $} ' | Cut-d ":"-F 1 'echo "Task Scheduler start time $ A" >>/opt/cron.logecho "Transfer complete Time $b" >>/opt/cron.log#判断传输完成时间是否大于等于任务计划时间If [$b-ge $a];then#增加1个小时C= '/usr/bin/expr $a + 1 '#修改任务计划文件/bin/sed-i "s/$a/$c/g"/opt/cron.txt#覆盖任务计划/us

, so adding sudo permissions does not have a security risk, and finally the official script can be modified:#!/bin/bash#youmustaddnagiospermissiontoiptablesin/etc /sudoersstate_ok=0state_warning=1state_criticalll=2state_unknown=3chains=$ (sudoiptables -nvL|grep ' Chain ' |awk ' {print$2} ') Forchain in $CHAINS ;doif[ "$CHAIN" != ' FORWARD ' ][ "$CHAIN" != ' OUTPUT ' ][$ (expr substr $CHAIN 14) != "Log_" ];then cnt=$ (expr$ (sudoiptables-s $CHAIN |wc-l

Oracle SQL Tuning Health Check ScriptWe focus on the performance of database system, the main task of database tuning is to optimize SQL. Good data architecture design, with application system middleware and writing a beautiful SQL, is the future of the system on-line no fatal performance problems of the strong guarantee.In the CBO era, a SQL execution plan was diverse. The factors that affect the execution

MySQL is a powerful open source database. With more and more database-driven applications, people have been pushing MySQL to its limits. Here are 101 tips for adjusting and optimizing MySQL installation. Some of the tricks are specific to the installation environment, but these ideas are generic. I've divided them into several categories to help you learn more ab

MySQL performance tuning and Architecture Design-Chapter 1 Performance Design-MySQL Replication and replication Optimization Chapter 1 scalability design-MySQL Replication Preface: MySQL Replication is a unique feature of MySQL. I

1. choose PerconaServer, MariaDB, MYSQL1, and Mysql storage engines. MySQL provides two storage engines: MyISAM and InnoDB, and MySQL4 and 5 use the default MyISAM storage engine. From MYSQL55, MySQL has changed the default storage engine from MyISAM to In MYSQL Enterprise common architecture and