Read the http://www.jb51.net/article/16244.htm first.
The framework is then explained Step-by-step.
The first is the download framework:
Official homepage:
http://cakephp.org/
Download
The following article mainly describes how to correct the installation of the RPM package, MySQL configuration and uninstall, the following details on the configuration of MySQL and uninstall MySQL (and PHP with the best combination) of the detailed
In our actual work, we tend to hear a lot about the reasons not to use MySQL database, of course, there are some of the MySQL (and the best combination of PHP) misunderstanding, I will talk about the 5 do not use MySQL (and PHP with the best
Copy Code code as follows:
REPAIR table ' table_name ' repair form
OPTIMIZE table ' table_name ' optimization tables
The REPAIR table is used to repair damaged tables.
The OPTIMIZE table is used to reclaim unused database space, and when
1. Table Damage Reason analysisThe following are common causes of MySQL table corruption:
1, the sudden loss of power to the server caused data file corruption.
2, forced shutdown, did not first shut down the MySQL service.
3. The mysqld process was
MySQL inserts when the record does not exist (insert if not exists)
In MySQL, inserting (insert) A record is very simple, but some special applications, before inserting the record, need to check whether this record already exists, only if the
Log in to MySQL to view the process information
Copy Code code as follows:
Show Processlist;
Found a large number of processes in the state for login
The original default when the MySQL startup is not using the
When the Mycheckpoint is installed, this secret is discovered when the user is given permission to do so:
Copy Code code as follows:
Mysql>
Mysql> GRANT all privileges in mycheckpoint.* to ' mycheckpoint_user ' @ ' localhost '
Introduction to MySQL
MySQL is an open source relational database management system (RDBMS), the MySQL database system uses the most commonly used database management language-Structured Query Language (SQL) for database management.
Stitching
Basic operations
View Database
show databases;
Specify character Set
create database day15
default character set UTF8
View Character Set
show CREATE database day15;
Delete
drop Database Day15
MySQL recently on Windows 2003 has many times the normal operation can not connect to the database failure, the phenomenon is unable to connect to the database, and can not stop MySQL or restart MySQL, restart the machine also has no effect, because
Use Python to parse Nginx access logs, split them according to the Nginx log format, and store them in the MySQL database.One, Nginx access log format is as follows:
Copy Code code as follows:
$remote _addr-$remote _user [$time _local]
An error like this cannot create a. frm file seems to imply incorrect permissions or other reasons for operating system files, but in reality, this MySQL error has been reported as a bug in MySQL itself and has been in the MySQL developer list for
MySQL's profiling feature should be used in MySQL version 5.0.37.
See if profile is open
Mysql> Show variables like '%profil% ';
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
Previously thought that from the top to the next unified use of UTF-8 on the rest of the peace of the day, but today in the crawl Sina Weibo data is still encountered the exception of characters.
The data captured by Sina Weibo throws an exception
The concept of null values is a common cause of confusion among novice sql, who often assume that null is the same thing as an empty string. That's not true! For example, the following statements are completely different:
Mysql> INSERT into
Problem: MySQL DNS anti-solution: Skip-name-resolveThe error log has a similar warning:
1.120119 16:26:04 [Warning] IP address ' 192.168.1.10 ' could the not to resolved:name or service not known2.120119 16:26:04 [Warning] IP address ' 192.168.1.14
1. To test triggers and stored procedures, first create a simple table:
Copy Code code as follows:
CREATE TABLE ' Airuser ' (
' UserId ' int (one) not NULL auto_increment,
' username ' varchar (128) Not NULL,
PRIMARY KEY ('
MySQL provides different storage engines for different functional requirements. The so-called storage engine is the specific implementation of the specific interface under MySQL.
Federated is one of the implementations specifically for remote
The InnoDB engine is different in statistics and MyISAM, and MyISAM has a built-in counter, so when you use the Select COUNT (*) from table, you can directly retrieve data from the counter. And InnoDB must be scanned all the time to get the total
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