MySQL
There are three main methods for Mysql Data Synchronization:1. Use the MySQL database synchronization function2. Use the features of the MySQL database (the database has a fixed directory and is stored as a file) To synchronize the
MySQL cluster service configuration
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
1. IIS6 installation is normal2.A. Unzip the php-5.2.1-Win32 and copy all the DLL files in it and all the DLL files in the ext folder to \ windows \ system32B. Copy the php.exe‑php-win.exe and PHP. ini-Dist files in the C: \ PHP Directory to c: \
You can check it later.
I,MySQLGet current date and time
Now (): Obtain the current date + time (date + time) function:
Mysql> select now ();
+ --------------------- +
| Now () |
+ --------------------- +
| 10:26:23 |
+ ----------
Principle
Querycache (QC) is cache based on SQL statements. If an SQL query starts with select, the MySQL server will try to use QC for it. Each cache is saved using SQL text as the key. SQL text is not processed before QC is applied. That is to say,
PhpMyAdmin is never used, and navicat is also used on the local machine. phpMyAdmin is always slow. This is not the case. If there is no independent host, you have to use phpMyAdmin.
Step 1: Export SQL files from local data. I thought this was a
# Begin config info
# Descr: 4 gb ram, only InnoDB, acid, a small number of connections, large queue Load
# Type: System
# End config info
#
# This MySQL configuration file example is for 4G memory and is downloaded from www.bt285.cn Bt and
Lsof-I: 80. Check which programs are being executed on the port.
Start and Stop1. StartAfter MySQL is installed, run the following command to start MySql in the/etc/init. d directory.[Root @ test1 init. d] #/etc/init. d/MySQL start
2.
Http://dev.mysql.com/doc/refman/5.1/en/show-columns.htmlThe key field indicates whether the column is indexed:If key is empty, the column either is not indexed or is indexed only as a secondary column in a multiple-column, non-unique index.If key is
View the total number of nginx connections and connection status:
# Netstat-N | awk '/^ TCP/{++ s [$ NF]} end {for (a in S) print a, s [a]}'
Time_wait 17
Established 3254
Last_ack 236
Fin_wait_1 648
Fin_wait_2 581
Closing 7
Close_wait
1. phpMyAdminPhpMyAdmin is the most common MySQL maintenance tool. It is a MySQL management tool developed using PHP Based on the Web architecture on the website host. It supports Chinese characters and is very convenient to manage databases. It is
Mysql mysqldump only exports the table structure and does not export data
Copy codeThe Code is as follows: mysqldump -- opt-d database name-u root-p> xxx. SQL
Back up databaseCopy codeThe Code is as follows: # mysqldump Database Name> Database
Max_user_connections is the maximum number of MySQL user connections. The full-range statement indicates that the maximum number of connections of MySQL on the server is insufficient. Solution: Modify the value of the max_user_connections parameter
For mysql database operations in a good message book, refer to php beginners.
Copy codeThe Code is as follows: Class mysql {
Var $ querynum = 0;
Function connect ($ dbhost, $ dbuser, $ dbpw, $ dbname = '', $ dbcharset = ''){
If (! @ Mysql_connect ($
When migrating a database from MSSQL to MySQL, You need to insert 0 values in the auto-increment column of MySQL based on the requirements of business logic. In MSSQL, this is done as follows:Copy codeThe Code is as follows:String SQL; SQL = "set
The default encoding of MySQL is Latin1, which does not support Chinese characters. To support Chinese characters, you must change the default encoding of the database to gbk or utf8.1. You need to log in as the root user to view the database
Case DescriptionDuring the running of the scheduled script, it is found that when the SQL statement for backing up the table and the SQL statement for deleting some data in the table run simultaneously, mysql will detect the deadlock and print the
Mysql cannot be started because the hard disk is full.Log on to the system and check the cause.Delete the mysql Log file and restart mysql. the following error is found: Starting MySQL. Manager of pid-file quit without updating file. [FAILED]There
The MySQL administrator should know how to set the MySQL user account by specifying which users can connect to the server, where to connect, and what to do during connection. MySQL3.22.11 introduces two statements that are easier to perform this
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