MySQL

Mysql database IntroductionMySQL is a real multi-user, multi-thread SQL database server. SQL (Structured Query Language) is the most popular and standard in the world.Database language. MySQL is implemented in a Client/Server structure. It is

Author: hoowa This script uses Perl to generate excel xls files. Depending on some modules, you can use it in linux to generate xls files. The command line + parameter is used. Very convenient.#! /Usr/bin/perl #====================================#

Menzhi007 I am very grateful for the clear explanation of the mysql comparison operation. Http://www.bkjia.com/database/201003/45294.html When the where condition is executed in mysql, 0 can be used as a wildcard to query the indexed data. Mysql>

It is said that this is a master-optimized mysql for your reference. The number of connections: max_connections = 1500 can be changed based on the server performance. # Set-variable = connect_timeout = 5 # Set-variable = wait_timeout = 5 We

When MySQL is used as a site, unknown errors may occur. How can this problem be recorded? The solution is as follows:Class. method   // Create an error log Function error (){ + "); $ Time = date ("Y-m-d H: I: s "); $ Msg = "{VisitedTime: $

In Soundbreak, we play live audio and video continuously 24 hours a day, so we cannot make a convincing test of the new replication feature of MySQL. Through tests, we found that this feature can be used to maintain data synchronization with the

By default, mysqld shields the host after 10 connection errors. You can adjust the value by starting the server as follows: If the following error occurs, mysqld has received many connection requests from the host "host_name", but the host is

(1) Connection The connection usually comes from the Web server. The following lists some connection-related parameters and how to set them. 1. max_connections This is the maximum number of connections allowed by the Web server. Remember to use the

Whether in a small free database space or a large e-commerce website, it is necessary to reasonably design the table structure and make full use of the space. This requires us to fully understand the common MySQL Data Types in the database system.

Foreign key: Data consistency and integrity are maintained to control data stored in the foreign key table. Associate two tables. The foreign key can only reference the values of columns in the External table! For example: A and B Table a

The most basic is mysql's mysqlslowdump Easy to use:   Mysqldumpslow-s c-t 20 host-slow.log   Parameters: 1.-s, sorting, c, t, l, r, and ac, at, al, and ar are sorted by query times, time, lock time, and returned records respectively. Adding a is

This is a class library written in VB.net to connect to MySql. You can use this class library to directly operate MySql databases. Before using this class library, you must installOdbc mysql 3.51:

1. MySQL logical backup backs up the database into a file, which facilitates viewing and editing. In MySQLk, use mysqldump to complete logical backup;1. Back up the specified database or tables in the database;Mysqldump [options] db_name [tables]2.

I. Introduction==========This document describes how to install and configure a MySQL cluster based on two servers. MySQL can continue to run when any server encounters a problem or goes down. Note!Although this is a MySQL cluster based on two

1. Modify the mysql Log PathVim/etc/my. cnfLog-bin = mysql-binTo:Log-bin =/$ PATH/mysql-binAfter modification, save and exit.Modify the mysql-bin.index file to modify the path to an existing log.The default value is./mysql-bin .....Change to/$

  Mysqldump Back up the entire database Mysqldump-u root-ppassword databasename> data. SQL // Enter the root password. Back up one or more tables Mysqldump-u root-p databasename table1name table2name> data. SQL // Enter the root password.

Mysql> select now (); select now ()-10;+ --------------------- +| Now () |+ --------------------- +| 21:07:20 |+ --------------------- +1 row in set (0.00 sec) + ----------------------- +| Now ()-10 |+ ----------------------- +| 1, 20090925210710.00

I have studied the high availability of databases and need to use Database Synchronization and backup. Below are some of my studies on MySQL HA.     According to the HA solution provided in MySQL 5.0 Reference Manual, it mainly consists of the

The first method, of course, is to increase your wait-timeout value. This parameter is in my. cnf (my. ini), my database load is slightly larger, so the value I set is 10 (The unit of this value is seconds, this means that when a database connection

MySQL database optimization allows for fast paging Analysis of tens of millions of data records.The data table collect (id, title, info, vtype) has these four fields, where title is fixed length, info is text, id is gradual, vtype is tinyint, and