Zabbix monitoring MySQL

1. On the MySQL side (Zabbix client) modifying parameters for monitoring MySQL[Email protected] ~]# VIM/ETC/MY.CNF[MySQL]Auto-rehashuser= User Namepassword= Password[Mysqladmin]user= User Namepassword= Password [[email protected] ~]#

Questions about MySQL wait_timeout parameter settings not in effect

About Wait_timeoutOnce went to online set wait_timeout when found changed does not take effect, as follows:Mysql> Show variables like ' wait_timeout ';+---------------+-------+| variable_name | Value |+---------------+-------+| Wait_timeout | 100 |+-

Spit Groove Dad's MySQL installation path selection

Generally after Windows installed MySQL we will choose the MSI installation mode, but install the latest version of MySQL (mysql-installer-community-5.7.11.0.msi) found that MySQL default is installed on the C drive, this absolutely can not endure,

Backup and Recovery for MySQL

Backup and recovery for MySQL:[Email protected] mysqldump]# mysqldump-uroot-p123qwe-h10.39.3.110 sales >/data0/mysqldump/sales_bak.sql[Email protected] mysqldump]# egrep-v "#|\*|--|^$"/data0/mysqldump/sales_bak.sql[Email protected] mysqldump]# mysql-

3 ways to divide MySQL tables

Source: http://blog.sina.com.cn/s/blog_640738130100tzeq.htmlWhen a piece of data reaches millions of, you spend more time searching for it, and if you have a joint query, I think it's possible to die there. The purpose of the sub-table is to reduce

Initializing the MySQL root password in a MAC environment

1. Turn off the MySQL service, turn on the system setup last MySQL, then turn off MySQL first2. Generate a file named Mysql-init, put in the file: a sentence, this sentence different version, the following: (not included in parentheses)Alter user '

MySQL Time function

1. MySQL adds a time interval for the date: Date_add ()Set @dt = Now ();Select Date_add (@dt, Interval 1 day); -Plus 1 daysSelect Date_add (@dt, interval 1 hour); -Plus 1 hoursSelect Date_add (@dt, interval 1 minute); -Plus 1 minutesSelect Date_add (

centos6.4 installation apache+mysql+php

First, install MySQLStart with the MySQL installation. Open HyperTerminal and enter:[email protected] ~]# yum install MySQL Mysql-serverThe installation is complete so that MySQL can start automatically with the system:[Email protected] ~]#

The perfect solution for MySQL Chinese garbled

problem Description: MySQL is displayed as garbled or "?" when inserting Chinese. No.Solution:Modifying the My.ini configuration of MySQL[Mysql]default_character_set=utf8[mysqld]character_set_server=utf8The following content is a Test record, can be

MySQL parameter tuning

We must tune it after we install MySQL, and if the configuration file does not do well, MySQL may occupy a largeMemory, and the performance of the server is greatly reduced, then how do we tune, tuning the common options and methods are, let's see

MySQL Setting connection wait time (wait_timeout)

Linux under MySQL Modify connection timeout  1, first into MySQL, see wait_timeout, interactive_timeout Whether this value is the default 8 hours (that is 28800)  [[email  Protected] ~]# mysql-u root-p enter password:  input Password Enter   Execute

Issues related to MySQL middleware atlas

Altas Introduction:Atlas is a MySQL protocol-based data mid-tier project developed and maintained by Qihoo, a web platform infrastructure team. It is based on MySQL's official launch of the Mysql-proxy 0.8.2 version, modified a large number of bugs,

Lamp part Fourth MySQL operation

1. Forget the root passwordEdit MySQL Master profile my.cnf in the [Mysqld] field to add parameters skip-grant, restart the database service, so that you can enter the database without authorization mysql-uroot, modify the corresponding user

MySQL Connection JDBC Query code

Packagecom.simope.test;ImportJava.sql.DriverManager;ImportJava.sql.ResultSet;Importjava.sql.SQLException;Importcom.mysql.jdbc.Connection;Importcom.mysql.jdbc.Statement; Public classConntomysql { Public Static FinalString url =

MySQL master-slave replication encounters an error handling method

MySQL in the master-slave replication often encountered errors caused by slave replication interrupt, this time the need for manual intervention to skip this error, in order to make the slave end of the replication, to continue;To skip the wrong way:

MySQL in layman's notes (stored procedure one)

1. Stored procedures and functions ....Stored procedures and functions are a collection of SQL statements that have been compiled and stored in a database, and calling stored procedures and functions can simplify much of the work of the application

Mysql-binlog Log Recovery Database

The Binlog log is used to record all statements that have updated data or that have potentially updated data. Statements are saved as "events," which describe data changes. When we fail the database for some reason, we can use the Binlog log to

Install and configure MYSQL 5.7.11 without installation: solve the problem that MYSQL cannot be started.

Install and configure MYSQL 5.7.11 without installation: solve the problem that MYSQL cannot be started. Download MySQL5.7.11 ZIP Archive on http://dev.mysql.com/downloads/mysql official site: Download 32-bit or 64-bit data from your

Execute the SQL script in the MySQL command line.

Execute the SQL script in the MySQL command line. This article mainly introducesMySQL Command LineThe following example shows how MySQL executes the script under the command line. Now let's start to introduce this process. 1. Write an SQL script and

MYSQL lock table Solution

MYSQL lock table Solution This article describes how to solve the MYSQL lock table problem. We will share this with you for your reference. The details are as follows: Many times! Lock the table accidentally! Here is the ultimate solution to the

Total Pages: 3233 1 .... 1638 1639 1640 1641 1642 .... 3233 Go to: GO

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.