MySQL files: bitsCN.com
MySQL files
Log files
The log file is in the data directory by default.
long_query_time=2log-slow-queries= log-error=log= C:/log.loglog-bin=
The mysql-bin.index File (binary log index) function is to record the
Master-data bitsCN.com
Master/slave database Manual synchronization of master-data
The master-data parameter is often used when a slave database is created, because it is a relatively useful parameter. the default value is 1. by default, the
MySQL learning footprint record 11 -- group data -- GROUPBY, HAVING bitsCN.com
MySQL learning footprint record 11 -- GROUP data -- group by, HAVING
1. create a GROUP
List all vend_id for comparison.
Mysql> SELECT vend_id FROM products; + ---------
Solve the length limit of mysqlsql bitsCN.com
Mysql SQL length limit
An error was found today:
Cocould not execute JDBC batch update
The final cause is that the SQL statement length is greater than 1 M, while mysql on my machine is set
NoSQL has been the only choice for data persistence in the past few years. Data workers only consider filtering these traditional databases, such as SQLServer, Oracle, or MySQL. You can even make some default options. for example, if you use. NET,
MySQL Query solution: bitsCN.com
MySQL Query solution
Mysql calculates the values of multiple fields
The original database is as follows. All fields are of the int type.
+----+---------+---------+| id | column1 | column2 |+----+---------+-------
Can 'tconnecttomysqlserver about linuxtcp connection optimization bitsCN.com
Can't connect to MySQL server for linux tcp connection optimization
Recently, two web machines are connected to mysql. sometimes, you Can't connect to MySQL server. view
MySQL obtains the system performance and status bitsCN.com.
MySQL obtains the system performance and status.
#! /Bin/ksh INTERVAL = 5 PREFIX = $ INTERVAL-sec-status touch/tmp/running RUNFILE =/tmp/running my-e 'show global variables '>
BitsCN.com
Minor issues when using Mysql command line tool to execute SQL scripts
The SQL script is executed according to the syntax.
Source create. SQL (full path of the create. SQL file)
What I entered on my computer is
1
Modify the MySQL time zone. the time_zone bitsCN.com parameter is involved.
Modify the MySQL time zone, involving the time_zone parameter
First, you need to view the current mysql time zone, with the time_zone parameter
[html]mysql> show
Two methods for adding a user to MySQL: bitsCN.com
Two methods for adding a user to MySQL
The following example shows how to use a MySQL client to install a new user. These examples assume that the permission has been installed by default. This
Mysql _ CASEWHEN string replacement processing bitsCN.com
Mysql _ case when for string replacement
Use case when for string replacement
03 mysql> select * from sales; 04 + ----- + ------------ + -------- + ------ + ------------ + 05 | num |
Notes about restoring mysql data
Notes on restoring mysql data
Many kids shoes have used the mysqldump and source functions when backing up and restoring the database. However, I feel that the operation is rather inconvenient. I cannot see all
Wheregroupby uses bitsCN.com together
Where group
Select column a, aggregate function from table name where filter condition group by column a having filter condition
The group by clause is also used together with the where clause. When combined,
MySQL best practices bitsCN.com
MySQL best practices
MYSQL best practices are described in the following two aspects:
1. table structure best practices
2. QUERY best practices
Table structure best practices:
1. the smaller the size, the better
Transaction isolation level and mysql-related settings bitsCN.com
Transaction isolation level and related settings in mysql
After entering the mysql management interface, you can execute the following SQL
[SQL] select @ tx_isolation; //
High availability of MySQLCluster bitsCN.com
High availability of MySQL Cluster-1
Mysql cluster can achieve a high reliability of 99.999. in this section, we mainly introduce some basic concepts:
Network Partitioning
In a mysql cluster, if a
MySqlTheservicecouldnotbestarted solves bitsCN.com
MySql The service cocould not be resolved by started
Install MySql
Because mySql database needs to be installed today, every time the software is installed, the database is always enough for 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