This article has compiled some common methods of MySQL optimization, to do a simple summary sharing, to help those who do not have full-time MySQL DBA to do the basic optimization work, as for the specific SQL optimization, most by adding the
Running MySQL Status View monitor running MySQL, one way is to view MySQL running status. (1) QPS (query amount per second) qps = Questions (or Queries)/seconds mysql > show global status Like ' question% '; (2) TPS (transaction volume per
Xwamp is not going to build a versatile, 0-configuration, easy-to-debug tool. Xwamp just put the original program in a simple combination, using the CMD command control, the real green version, just to learn more about the point of Windows + Apache +
in the Inux systemLinux defaults to UTF8 encoding, and Windows is GBK encoded, so the above garbled problem occurs.Troubleshoot MySQL import and export data garbled problemThe first thing to do is to determine the encoding format of your exported
Reprint: http://www.cnblogs.com/xiaoluo501395377/archive/2013/04/07/3003278.html First, MySQL Introduction When it comes to databases, we mostly think of relational databases, such as MySQL, Oracle, SQL Server, and so on, which are very easy to
The last time the MySQL database was installed, there is no login operation, this time to briefly introduce the basic operation of MySQLI. Access to the MySQL database (after the installation of the initialization process, the default administrator
Today's release of the program, the log error can not find the table, but the system already exists in the table, the last discovery is a SQL case, the MySQL default settings cause these failures.1. Log in with root, modify/ETC/MY.CNF2. Add a line
1.float typeThe default length of the float column type does not find the result. Precision must be specified.For example , num float, INSERT into table (num) values (0.12); Select * FROM table where num=0.12 words. Empty set.Num Float (9,7),
##################################################################################Start off and Login##################################################################################1 Single InstanceMysqld_safe--user=mysql &
1. The Library name, table name, field name must use lowercase letters and be split with underscores. A) MySQL has configuration parameters lower_case_table_names, cannot be changed dynamically, Linux system default is 0, that is, the library table
Variables defined by declare and variables defined by @set are often seen in stored procedures. In simple terms, the declare definition is similar to a local variable, @set defined similar to a global variable.1. The variable defined by declare is
When working on a large data volume databaseIt suddenly turns out that MySQL's different handling of count (*) can result in different resultssuch as executionSELECT Count (*) from TableNameEven for TENS data, MySQL can return results very
Problem, when querying data, the input string is a number, you can query, but when you enter an alphabetic string but can not query, always prompt error 1054Workaround: Enclose the string in single quotation marks field corresponding to the value
Original address: http://www.uml.org.cn/sjjm/201205302.asp00– Basic ConceptsWhen concurrent transactions access a resource at the same time, it is possible to cause inconsistent data. Therefore, a mechanism is needed to order access.A lock is one of
Create three table TB_LATIN1,TB_UTF8,TB_GBK, encoded as LATIN1/UTF8/GBKThe "Hello a" string is encoded as followsGBK:%c4%e3%ba%c3%61UTF-8:%e4%bd%a0%e5%a5%bd%61The test code is as followsPHP//fileencoding=gb2312mysql_query("Set Names
Comparison and usage of distinct and group by statements in MySQL, mysqldistinct
The data table records the bibliography used for user verification. Now I want to retrieve all the bibliography and use DISTINCT and group by to get the expected
Mysql semi-sync source code implementation, mysqlsemi-sync
Mysql replication briefly introduces the causes of mysql semi-sync, and explains how semi-sync ensures that no data is lost. This article focuses on the implementation of semi-sync, and
MySQL root Password forgot SolutionSummary in many cases, the default password of the root user is not blank after mysql is installed. In this case, you need to log on to mysql to reset the password. Step 1: View/root /. mysql is installed in the
Basic tutorial on querying the cache mechanism of MySQL,
The MySQL cache mechanism simply caches the SQL text and query results. If the same SQL statement is run, the server directly obtains the results from the cache without parsing and executing
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