show variables

We can use show variables like character to view character encoding in mysql. modify the configuration method in my. ini. Let's take a look at it. Recently, in the mysql database used by the project team, garbled data is inserted. We have summarized

1. mysql encoding: mysqlgt; showvariableslike 1. mysql encoding: mysqlgt; show variables like I. mysql Encoding Mysql> show variables like 'collation _ % ';+ ---------------------- + ------------------- +| Variable_name | Value |+ --------------

MySQLSQL profiling (SQLprofile) Analyzing SQL Execution overhead is an important means to optimize SQL. In MySQL databases, you can configure the profiling parameter to enable SQL profiling. This parameter can be set at the global and session level.

In mysql, SHOWSTATUS is our best friend. It allows us to quickly view the running status and optimize the database in a timely manner. Below I have summarized some usage. In mysql, show status is our best friend. It allows us to quickly view the

This article mainly introduces the MySQL performance analysis tool profile tutorial, this article describes how to use MySQLprofile, does not involve specific sample analysis, if you need it, you can refer to the analysis of SQL execution overhead,

MySQL System variables are actually some system parameters used to initialize or set the occupation of system resources by the database, and the storage location of files. These systems MySQL system variables are actually some system parameters used

This article is the 13th chapter of the Integration Services series, please refer to the original text for details. Brief introductionIn the previous article we combined the previous learning of bubbling, logging, and parent-child mode to

Configure slow queryThe default my. cnf file is in the/etc/directory.Vim/etc/my. cnf# Slow_querySlow_query_log = 1 # enable slow querySlow_query_log_file =/var/lib/mysql/mysql-slow.log # set the slow query pathLong_query_time = 0.01 # set the slow

Recommended settings: For a single running web server, we recommend that you add: Skip-locking Skip-name-resolve Skip-networking Use "localhost" when connecting to the database in PHP. In this way, the mysql client library will overwrite and try to

MySQL Slow Query Log (Slow Query Log), mysqlslow Like most relational databases, log files are an important part of MySQL databases. MySQL has several different log files, such as error log files, binary logs, common logs, and slow query logs. These

Parameter configuration for MySQL Performance Optimization 1. Purpose: Modify the MySQL System Parameters Based on the current status of the server to reasonably utilize the existing resources of the server and improve the MySQL performance. 2.

Differences between mysql status and variables First, you can use the following two commands to view the corresponding mysql system parameters.Show status like '% abc % ';Show variables like '% abc % '; However, many people do not understand the

Status = Show status like '% ' [example: Show status like ' Com_select ']variables = Show variables like '% ' [example: show variables like ' query_cache_size ']1. Number of MySQL queries (taken from show status return information)Com_select;

Http://dev.mysql.com/doc/refman/5.6/en/memory-use.htmlThe following list indicates some of the ways that the mysqld server uses memory. Where applicable, the name of the system variable relevant to the memory use is given: All threads share the

The slow query log is used to optimize the query statement, the following are several parameters, 5.5 can be later to the subtle (MS)Mysql> Show variables like '%slow% ';+---------------------------+-------------------------------+| variable_name |

First, the MySQL database master-slave replication principle process:MySQL's master-slave replication is an asynchronous replication process where data is copied from one MySQL database (master) to another MySQL database (slave), and the process of

MySQL for Linux database installation processL installation Version: Mysql-advanced-5.6.12-linux-glibc2.5-x86_64.tar.gz, this version is a green version, just need to extract it to the relevant directory.PS: This installation method is not a common

Http://blog.csdn.net/hzcyclone/archive/2010/08/18/5821370.aspxThe MySQL configuration file is/etc/my.cnf, which is configured by modifying it to configure MySQL./etc/my.cnf from the following files:If your memory is ≤64m, copy/usr/share/doc/mysql/my-

InnoDB has multiple blocks of memory that you can think of as a large pool of memory that is responsible for the following tasks: Maintains multiple internal data structures that all processes/threads need access to. Cache the data on

Please see the original: http://www.ucai.cn/blogdetail/7036?mid=1&f=5Can be run online to see the effect Oh!This article is based on the gifted network course collation, web-oriented developers, content to practical, professional DBA can bypass.If