Mysql slimming method bitsCN.com
Mysql slimming method
Note:
1. stop the database service before performing the operation and copy the mqslq5 folder for backup;
2. install the database connection tool navicate on the computer where the database is
Start the MYSQL server in linux and configure the self-starting command bitsCN.com
Start the MYSQL server in linux and configure the self-starting command
/Usr/local/mysql/bin/mysqld_safe -- user = mysql &
Note: MYSQL installation directory
SuseLinux10MySql randomly starts bitsCN.com
Suse Linux 10 MySql random start
Mysql has been installed in SUSE 10, but the path is not in/usr/local
Run service mysql start to start www.bitsCN.com.
There is a mysql file under/etc/init. d /.
How to modify the maximum number of mysql concurrent connections (connections) bitsCN.com
How to modify the maximum number of mysql concurrent connections
The maximum number of MySQL connections does not matter with MySQL. it mainly depends on the
MySQL database combines individual fields of multiple records into one record, bitsCN.com
MySQL database combines individual fields of multiple records into one record
MySQL database merges individual fields of multiple records into one
How to operate mysql in python and common problems in python
BitsCN.com
Install the mysql module
sudo easy_install mysql-pythonConnect to database
1 #!/usr/bin/env python2 #coding=utf-83 import MySQLdb4 conn =
MySQL foreign key constraints
BitsCN.com
MySQL foreign key constraints
If the primary keyword of Table A is A field in Table B, this field is called the foreign key of Table B. Table A is called the primary table and table B is called the slave
Use BINLOG to find the SQL statement bitsCN.com of the specified date
Use BINLOG to find the SQL statement of the specified date
On the 95 database server, find the postid = 1652971 of posts. post_thread and run the SQL statement that modified the
Mysql stress test shell script bitsCN.com
Mysql stress test shell script
Mysql comes with the stress testing tool mysqlslap, so we don't have to write a program to test the Mysql read pressure. The stress test shell script is as follows:
MySQL Query analysis and optimization bitsCN.com
MySQL Query analysis and optimization
Show www.bitsCN.com
Show status -- Display status information (extended show status like 'XXX ')
Show variables -- Display System variables (extended show
Mysql5.5 set up master-slave replication (setupmaster-slavereplication) bitsCN.com
Mysql5.5 set up master-slave replication)
1. notes:
(1) the master/slave server versions must be consistent.
(2) to change the root password, do not use the initial
Optimize mysql nested query and table query bitsCN.com
Optimize mysql nested queries and table queries
Poor optimization of nested queries
As mentioned above, join table queries are more effective than nested queries without special considerations.
MySQL command line to enable slow. log failed to solve bitsCN.com
An error occurred while enabling slow. log on the MySQL command line.
You need to check slow. log, but I found that slow. log has not been written for a long time.
Check the server
When the text field is updated, rowsiz1_large reports bitsCN.com
Cause:Group buying Development report indicates an error occurred during the update.
The update SQL statement is as follows:
UPDATE table_name d SET
"MySQL" timestamp conversion bitsCN.com
1 NOW () // Current Time 2 SYSDATE () // Current Time 3 CURRENT_TIMESTAMP 4 returns the current date and time in 'yyyy-MM-DD HH: MM: SS' or YYYYMMDDHHMMSS format, it depends on whether the function is used in
Mysql syntax leftjoin, rightjoin, innerjoin bitsCN.com
Mysql syntax: left join, right join, inner join
Test table user:
Test table password table pwd:
1. create a user table:
1
Create table 'user '(
2
'Id' int (11) not null
When the text field is updated, rowsiz1_large reports bitsCN.com
The Row size too large error is reported when the text field is updated.
Cause:
Group buying Development report indicates an error occurred during the update.
Www.bitsCN.com
The
Note bitsCN.com when backing up a mysql database
Pay attention to the cold backup of mysql database
Cold backup means that when the database is shut down normally, it will provide us with a complete database. Cold backup is a way to copy key files
MYSQL -- Transaction processing bitsCN.com
MYSQL -- Transaction processing
Transaction processing is widely used in various management systems. for example, in the personnel management system, many synchronous database operations require
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