Preparation package:
Httpd-2.2.6.tar.gz mysql-5.0.41.tar.gz php-5.2.6.tar.gz libxml2-2.6.30.tar.gz before installation is best to shut down the firewall, wait for the environment after installation and then unified configuration firewall (Service
Switch from csdn -- http://topic.csdn.net/u/20070418/16/b7ad36d1-d011-45a4-b4e5-d796d65feedd.html
MySQL sets the encoding method
MySQL can insert English fields into the database. When I enter Chinese characters, the field data truncation: data
If phpMyAdmin is enabled, change the root password in the permission, and then open phpMyAdmin. "phpMyAdmin tries to connect to the MySQL server, but the server rejects the connection. Check the host, user name, and password in config. Inc. php and
Solve the problem of slow MySQL LoginSymptom:The system is normal and the local login speed is fast. There is no problem with the query and other operations. No error message is reported in the log. However, remote login is abnormal and slow, and
From: http://www.cnblogs.com/donknap/archive/2010/01/27/1657373.html
To optimize MySql in high concurrency, it is necessary to understand the lock table mechanism when MySQL queries an update.
I. Overview
MySQL has three levels of locks: Page,
1. Assume that your table contains columns A, B, and C and you want to import the data to the table in your database. The corresponding fields are col1, col2, and col3.
2. Add a column to your table and use the Excel Formula to automatically
First, I want to say one sentence:
I despise people who are engaged in it in China. They are completely speechless and solve this problem almost exactly the same. They are copied. What's more, an error is thrown: Access denied for user 'root' @
Master-slave MySQL master-slave Database Configuration
1./etc/My. CNF master database configuration
# Generally, it already exists.Server-id = 1# Databases to be copiedBINLOG-do-DB = search# Databases that do not require
Initial installation method:
1. Download MySQL 5.0 from the official website.
2. Modify the firewall settings and add a new port to allow exceptions. The port name is MySQL and the opened port is TCP 3306.
In this case, you should click
I. Startup Mode
1. Start with service: Service mysqld start
2. Use the mysqld script to start:/etc/init. d/MySQL start
3. Start with safe_mysqld: safe_mysqld &
Ii. Stop
1. Start with service: Service mysqld stop
2. Use the mysqld script to
1. Connect to MySQL
Format: mysql-H host address-u user name-P User Password
Ii. Change the password
Format: mysqladmin-u username-P old Password New Password
3. Add new users.
(Note: Unlike the above, the following commands in the MySQL
Access the MySQL database using JythonPreparationsDownloadHttp://jaist.dl.sourceforge.net/sourceforge/zxjdbc/zxJDBC-2.1.tar.gzHttp://jaist.dl.sourceforge.net/sourceforge/jython/jython_installer-2.2.1.jarHttp://mmmysql.sourceforge.net/dist/mm.mysql-2.
1. IndexingIn addition to the ordered search mentioned above, the database can greatly improve the query efficiency by using various fast locating technologies. In particular, when the data volume is very large and the query involves multiple tables,
Transaction processing support has been the wish of most MySQL developers for a long time. With the release of MySQL 4.0, this wish was finally realized. Shortly after MySQL 4.0, PHP 5.x with a new MySQL plug-in was also released. This new plug-in,
A friend asked me, "Hi, I want to ask what urgent measures do you take when the single-host load is too high? "
I asked him if he was a MySQL db server?
He said yes.
I give him the following suggestions:
1. Check whether the mysqld process causes
Encoding is a basic issue that is easily overlooked by everyone. before writing code, you should consider it a lot and it will be less troublesome in the future.
PHP has developed a lot, And now pear is very easy to use. There are related classes to
// Display the slow Query Count
Show status like 'slow _ queries ';
① How to locate slow queries
Building a large table (4 million)-> building a stored procedure
By default, MySQL considers 10 seconds as a slow query.
L modify the slow query of
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