Dry goods: MySQL Database optimization reference

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

MySQL Status View qps/tps/cache Hit ratio view

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

Build your own Web server Windows + Apache + PHP + MySQL

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 +

MySQL Import and export data Chinese garbled solution summary

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

Installing MySQL under Linux (Centos)

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

MySQL Database (ii) Basic operation of MySQL database

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

Mysql Case-sensitive issues

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

MySQL float double type

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),

MySQL additions and deletions, login close, password modification hack application

##################################################################################Start off and Login##################################################################################1 Single InstanceMysqld_safe--user=mysql &

MySQL Development specification

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

Differences between declare and set-defined variables in MySQL stored procedures

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

PHP and MySQL Web development from novice to expert, 4th day-Build basic framework

1. Add the homepage index.php, the final suburb fruit: 1.1 Edit Homepage Content DOCTYPE HTML>HTML>Head>MetaCharSet= "UTF-8">title>Joke Management Systemtitle>Head>Body> H1>Joke Management SystemH1> ul> Li>ahref= "jokes/">Manage Jokesa>Li>

MySQL Count (*), distinct usage and efficiency studies

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

MySQL Error 1054

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

MySQL database InnoDB lock mechanism in the storage engine--reprint

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

MySQL Character set encoding garbled test is as follows

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

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 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 Solution

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,

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

Total Pages: 3233 1 .... 517 518 519 520 521 .... 3233 Go to: GO

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.