PremiseReference:Http://www.cnblogs.com/xiaoxiaoguixia/p/4032355.htmlDesign diagram:Divided into three parts:Zabbix-server zabbix*.tar.gz Source Package supportZabbix-web Lamp Environment SupportMySQL Zabbix MySQL database stores Zabbix's various
First, view the current database encodingShow variables like '%character% ';650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/80/3E/wKiom1c8A-7SxbjFAAAlDd_yQtY266.png "title=" 1.png " alt= "Wkiom1c8a-7sxbjfaaaldd_yqty266.png"/>You can see
MySQL version 5.6 Open Gtid mode, you must turn on the parameter log_slave_updates,Simply put, a binary log must be recorded on the slave. This, regardless of the cost of performance or storage, will undoubtedly increase correspondinglyThe MySQL 5.7
There are several ways to install the MySQL method, such as:
mysql installation method
1
yum/rpm Package installation
binary installation
decompression software,
four querying records The most common use of records in a data table in a MySQL database is a recorded query, and the records in the Operation data table are mostly recorded queries. FindThe syntax structure of the record is:SELECT select_expr [,
MySQL stored procedures and function stored proceduresDownloadDemoMysql> delimiter// --here//for modifying the default delimiter;mysql> CREATE PROCEDURE simpleproc (out param1 INT) begin-> SELECT COUNT (*) into param1 from T; End//query
There are two tables in the databaseT1 storing message information+-----------+------------------+------+-----+---------+----------------+|Field|Type| Null | Key | Default |Extra|+-----------+------------------+------+-----+---------+----------------
Application system is CentOS 6.x MySQL version 5.1The SELinux and iptables can be closed in advance.[Email protected] ~]# chkconfig iptables off[Email protected] ~]# chkconfig ip6tables off[[email protected] ~]# /etc/init.d/iptables Stop[[email
/* Index *//* Index design principles 1. Try to choose a uniqueness index of 2. Order by,group by,distinct for frequent needs, The field of the Union is set at index 3. Sets the index for a field that is commonly used as a query condition 4. Limit
This article mainly describes the CentOS 6.4 configuration Lnmp Server detailed steps, the need for friends can refer to the followingPrepare the article1, configure the firewall, open 80 ports, 3306 portsVi/etc/sysconfig/iptables-A input-m
Modifying a data table includes adding columns, deleting columns, adding constraints, deleting constraints, modifying column definitions, and modifying data table names, and the following two when we useBe cautious and try not to use it.Here is a
Creation, invocation, and syntax of stored procedures in MySQLThe MySQL stored procedure is a new feature that has been added since MySQL 5.0. The advantages of a stored procedure are a whole bunch. But the main thing is the execution efficiency and
The steps are as follows:1, the master-slave server for the following actions :1.1. Consistent version1.2. Initialize the table and start MySQL in the background1.3, change the root password2. Modify Master server Master:#vim/etc/my.cnf [mysqld]
Stitching FieldsThe data stored in a database table is generally not the format required by the application. We need data directly from 检索出转换、计算或格式化过 the database, rather than retrieving the data, and then reformatting it in the client application
When you start MySQL, you need to specify the configuration file for this instance:/bin/sh ${cmdpath}/mysqld_safe--defaults-file=/data/${port}/my.cnf 2>&1 >/dev/null &Path of the ${cmdpath}:mysql${port}: Port of this MySQL instanceWhen you close
Test environment: Windows7 64-bit Mysql.exe, Navicat Lite for MySQL, MySQL 5.0.18Structure of MySQL database:The database contains multiple tables (table), a table containing multiple attribute columns (column), a property column containing multiple
Database operation of separate additions and deletions, which query operations accounted for the system 90%, the optimization of the SQL statement is basically the optimization of query statements. Next, you'll learn the use of join, which includes:
Change the sales status of April 20 to the current time period to unsold (1), the sales time to null (0) UPDATE hy_car_detail hcd SET hcd.sales_date = ", Hcd.sales_status = ' 1 ' where HCD . car_id in (Select hc.car_id from Hy_car HC WHERE
Operating system cluster size is generally 4K, and InnoDB page size is generally 16K, then it is possible that 16K pages are not stored in a continuous cluster, so that the scanning software will not scan out such a page. To solve this problem, we
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