First of all, my server's hardware and forum situation,
Cpu:2 Quad Core Intel Xeon 2.00GHz
Memory: 4GB DDR
Hard drive: SCSI 146GB
Forum: Online membership is generally around 5000 people – the highest record is 13264.
Below, we are based on the
Using Software: Mysqlmigrationtool
Tip the data is too large to import. Modify the my.cnf file Max_allowed_packet = above 100M. In the Windows operating system, MY.CNF may not appear, need to use the editor to enter the address directly: Disk
Configure the world's smallest MySQL server-how to install a MySQL server for the dashboard on an Intel Edison.
Introduced
In one of my recent posts, the Internet of Things, news and MySQL, I showed you if particle Photon's board starts building
First, MySQL master (called Master) from (called slave) Copy principle:
(1). master records data changes to the binary log (binary log), which is the Log-bin specified file (These records are called binary log events binary log event)(2). Slave
This article for everyone to share the PHP operating environment to build installation graphics and text tutorials for your reference, the specific contents are as follows
Install Apache:
1, do not install into a Chinese-language directory:
2,
Today you need to update the MySQL version of the Linux server from 5.1 to 5.7, so the following is a record for future installation manuals
Step one: Check the Linux operating system version
Copy Code code as follows:
MySQL stored procedure parameters (in)MySQL stored procedure "in" parameter: similar to the value of the C language function parameter, this parameter may be modified internally by the MySQL stored procedure, but the modification of the in type
I. Evolution:
The varchar type of MySQL database has a maximum length limit of 255 in the version below 5.0.3, and its data range can be 0~255.
In the MySQL5.0.3 and above versions, the length of the varchar data type is supported to 65535, which
For example, if column A is defined as unique and the value is 1, the following statement has the same effect, that is, if there is a a=1 in the record that is in and out, the C = C + 1 is directly updated without performing the operation of C = 3.
Type of database backup
According to the database size backup, there are four types, applied to different occasions, the following briefly describes:
1.1 Full backups
This is a common way for most people to back up the entire database, including
The MySQL query cache is analyzed in detail from five angles: The working principle of query cache, how to configure, how to maintain, how to judge the performance of query cache, and the suitable business scenario analysis.
Working principle
The
Entering commands on the command line is not a good idea and can create security problems. But if you decide to write an application, the application needs to use a password or other sensitive information on the command line. So, can you prevent
The syntax for creating stored procedures in MySQL is hard to remember, unless you often deal with the storage process for the simple reason that grammar is not a trivial joke. If you control MySQL through the command line, you need to remember the
This article simply narrates the application instance of the Full-text index, the MySQL demo version 5.5.24.Q: What are the applications for Full-text indexing?A: Full-text indexing is the key technology to achieve large data search at present.For
This error occurs frequently when you try to create a foreign key in MySQL, which is very frustrating. An error like this cannot create a. frm file seems to imply incorrect permissions or other reasons for operating system files, but in reality,
Continue to do the following preparatory work:
Create a new test database testdb;
Create DATABASE TestDB;
Create test tables table1 and table2;
CREATE TABLE table1
(
customer_id VARCHAR) not null, City
Background
In normal development, often encountered this update data scenario: first to determine whether a data in the library table exists, there is update, does not exist insert.If you use Hibernate, it takes a saverorupdate method and is
Single-table unique query with: DISTINCTUnique query for multiple tables: Group byDistinct when querying multiple tables, the LEFT join is also valid, the full connection is invalid,
When using MySQL, there are times when you need to query for
When you first install MySQL on a machine, the authorization table in the MySQL database is initialized like this:
You can connect as root from the local host (localhost) without specifying a password. Root user has all permissions (including
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