#################### #shijl: 20150410:my.ini########################记录所有sql语句Log=e:/phpstudy/mysql/log/query.log#记录数据库启动关闭信息, and error messages that are generated during the runLog-error=e:/phpstudy/mysql/log/error.log# All SQL statements except
MySQL things day to the[Email protected] mysql]# LS-LDTR MYSQL-BIN.*-RW-RW----1MySQL MySQL2222211April9 ,: *Mysql-bin.000001-RW-RW----1MySQL MySQL245April9 ,: *Mysql-bin.000002-RW-RW----.1MySQL MySQL -April9 ,: *mysql-Bin.index[[email protected]
Optimal timingGeneral single table more than 5 million, or obviously feel the performance degradation, need to optimizeOptimization scenarios
Read/write separation
Use caching, such as memcached or Redis
Use a search engine, such as
1. Execute the Install commandBrew Install MySQL2. After executing the input MySQL will have the following bugERROR 2002 (HY000): Can not connect to local MySQL server through socket '/tmp/mysql.sock ' (2)3.bug SolutionsUnset TMPDIR4.
1, first download the MySQL installation package, download the link mysql download, and then install.2. Enter the user name and password at the time of installation to connect to the database.3. Install the MYSQ JDBCL driver in Eclipse, the
Beginner MySQL, feel SQL statement is still a bit more, here do some basic MySQL notes, in case forget.1. Connection database: mysql-h hostname-u username-pThe default is to connect to the local database, so the above can be abbreviated as:mysql-u
From: http://www.jb51.net/article/25686.htm website data for our webmaster is the most valuable, we should usually form a good habit of backup data.Shong asked me how to back up the database, here are 3 ways to back up the database:Each database and
Reprint: http://www.cnblogs.com/lyhabc/p/3691555.htmlMy MySQL learning experience (a) simple grammarMy MySQL learning Experience (ii) data type widthMy MySQL learning Experience (iii) View field lengthMy MySQL learning experience (iv) data typeMy
MySQL query a lot of methods, the following for you to introduce the MySQL query statement to achieve the most repeated query records, for learning MySQL query has a good help.In some applications, we need to query some of the most repeated records,
I would say that I have been a garbled problem for almost a day, just solved, bad!!!Here's a great tutorial: http://cenalulu.github.io/mysql/mysql-mojibake/10 minutes to understand MySQL transcoding problemsI have resolved:Before opening the data,
Two different ways:The first type:Sort them first, and then merge the results with the temporary table nesting, noting that the order must be preceded by a limit, otherwise the order by does not workSELECT * FROM (SELECT * to T1 WHERE ID in (1,3,6)
SELECT * FROM res as T1 JOIN (select ROUND (RAND () * (= (select MAX (ID) from res)-(select min (id) from res)) + (select min ( ID)) as ID) as T2 WHERE t1.id >= t2.id ORDER by t1.id LIMIT 1;SELECT * from ' res ' as T1 JOIN (select ROUND (RAND () * (=
There is a lot of information about MySQL paging stored procedures on the Web, but the content is similar. As a beginner, reference the MySQL stored procedure as follows: delimiter $$use ' database1 ' $$--database name drop PROCEDURE if EXISTS '
Sometimes we want to see all the information of a database above some kind of element (such as table name), we can see it very conveniently on MySQL by introducing Information_schema way.Add stepEdit->preferences then select SQL Editor hook in Show
Several useful functions in mysql1. FROM_UNIXTIMEPurpose: display the time stored in INT (11) in MYSQL in the "YYYY-MM-DD" format. Example:
Select mtime, from_unixtime (mtime) from topics limit 10;
2.
CONCAT (str1, str2 ,...)Purpose:
Mysql Transaction Processing
Transaction processing is widely used in various management systems. For example, in the personnel management system, many synchronous database operations require transaction processing. For example, in the personnel
Mysql paging Stored Procedure
There is a lot of information about the mysql paging stored procedure on the Internet, but the content is similar. As a beginner, reference the mysql stored procedure as follows:
DELIMITER $ USE 'database1 '$ --
Mysql modifies an auto-increment primary key int type to a char type. For example, mysqlchar
In the past, the primary key of a table is of the int auto-increment type,Because of business changes, you need to change the int type to the char type
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