Check and fix the mysql database table bitsCN.com
Check and fix mysql database tables
01
#! /Bin/sh
02
# Code by scpman
03
# Function: check and fix mysql database tables
04
# Add the script to the timer. when the script is executed, it will read
Mysql or query statement bitsCN.com
Mysql or query statement
To query a table that meets any condition, you can use union to implement or query the table.
idagegender120female221male322male
For example, in the person table, only women over 20
MySQL production database inserts the same record twice, but the primary key ID is different. the analysis process is bitsCN.com.
MySQL production database inserts the same record twice, but the primary key ID is different.
Laopan:
insert into
Modify database encoding command bitsCN.com
Change database encoding command
To modify the character set, run the mysql command.
Mysql> SET character_set_client = utf8; mysql> SET character_set_connection = utf8; use mysql> show variables like '
MYSQL5.5 table partition problem bitsCN.com
Partitions in MYSQL5.5 tables
1. The field attribute is timestamp, and an exception occurs during partitioning.
Constant, random or timezone-dependent expressions in (sub) partitioning function
How to restart mysql bitsCN.com
How to restart mysql
RedHat Linux (Fedora Core/Cent OS)
1. start:/etc/init. d/mysqld start
2. stop:/etc/init. d/mysqld stop
3. restart:/etc/init. d/mysqld restart
Debian/Ubuntu Linux
1. start:/etc/init.
MySQL: ERROR13 (HY000): Can bitsCN.com
MySQL: ERROR13 (HY000): Can't get stat of problem, but replace load data infile with load data local infile OK! Cause Analysis: From Mysql Chinese Manual: for security reasons, when reading text files on the
Mysql master-master replication architecture configuration bitsCN.com
The master-slave replication structure of MySQL is different from the master-slave replication structure. In the master-master replication structureIf the data stock on one server
Mysql synchronizes GLOBALsql_slave_skip_counter to explain bitsCN.com
As we all know, when an slave error occurs, you can skip the error through set global SQL _slave_skip_counter = N, but what does this N actually mean.
This statement skips the
Mysql backup script bitsCN.com
The mysql backup script is very general. don't laugh when you see it ..
#! /Usr/bin/perl-w
Use warnings;
Use strict;
Use DBI;
My $ backup_dir = "/root/perl/backup ";
My $ backup_log = "$ backup_dir/backup_log ";
My $
On WINDOWS host, mysql changes the ROOT password.
Change ROOT password1. net stop mysql // stop the MYSQ service2. CD to mysql bin directory mysqld-nt -- skip-grant-tables // start MYSQL3. DOS mysql // log on to the mysql database4. update user set
Further exploration of mysql backup and recovery bitsCN.com
1. my current backup solution is:A (master) -----> B (slave) for real-time synchronization, complete backup at every Sunday on B (slave), do from Monday to SaturdayIncremental Backup,
Mysql super authentic installation method bitsCN.com
To install mysql, follow these steps:
Note that, as shown in the figure, some options are different from the default ones. At the same time, if you re-install mysql, you should first back up the
Security risks caused by mysql 0 bitsCN.com
Menzhi007
I am very grateful for the clear explanation of the mysql comparison operation.
Http: // database/201003/45294 .html
When the where condition is executed in mysql, 0 can be used as a wildcard to
Frequently used mysql Performance Indicator bitsCN.com
Frequently used mysql Performance Indicator 1, obtain the total number of processes under a mysql User ps-ef | awk '{print $1}' | grep "mysql" | grep-v "grep" | WC-1 2, host performance status #
C # Do not delete bitsCN.com automatically when operating temporary tables in mysql
Use c # to call the mysql stored procedure and use a temporary table in the stored procedure. each time the first call is correct, an error is returned when the
Three batch-added performance analysis methods: bitsCN.com
I recently studied hibernate in depth. During batch operations, I found that the performance of hibernate batch operations is very low. so I want to find a method with high performance.
Fedora16mysql remote connection to Fedora
BitsCN.com
By default, mysql can only log on locally.
To connect remotely, create an account under root.
Format: grant all privileges on *. * to abc123 @ "#" identified by "password ";
'%' Indicates
Sun's smooth integration with MySQL serves the open-source community bitsCN.com. when Sun paid $1 billion to buy MySQL, the biggest problem was the obvious cultural conflict. Sun has been a closed source code software company for a long time, so
Is there a warning like this on your server? The information is as follows: from the official documentation, we know that mysql compiled and installed on linux has 100 connections by default, which is far from enough for website requirements. Mysql
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