MySQL

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

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, first in the Control Panel-management tools-services to stop the MySQL service2. Then locate the My.ini file in the MySQL installation directory and open it using Notepad.My.ini may also be under C:\Windows, please search for the C-drive My.ini

The content is short but is dry, practice + theory Summary, welcome to shoot BricksDisclaimer: The following code does not apply to sorted sets1) Set names and Default-character-set equivalent2) When writing the set names (Default-character-set)

Reprint https://www.zhihu.com/question/19866767/answer/14942009http://whuai.blog.51cto.com/3539000/862197 Oracle: Data files include: Control files, data files, redo log files, parameter files, archive files, password files. This is divided

One, CPU maximum performance mode CPU utilization characteristics 5.1 Maximum usable 4 cores 5.5 Maximum usable 24 cores 5.6 Maximum Usable 64 cores Once query corresponds to a logical CPU If you look closely, there is an

PrefaceThis article summarizes several MySQL database logs, for the daily maintenance process problem solving and performance optimization, a slightly more basic, daily accumulation of use.Part of the article will be the MySQL database and the SQL

In MySQL, an index is a data structure that the storage engine uses to quickly find a target record. Common index types include B-tree indexes, hash indexes, spatial indexes (R-tree), full-text indexes, and so on.Indexes are implemented at the

MySQL database design specification 1, the database naming specification uses 26 English letters (case-sensitive) and 0-9 natural numbers (often do not need) with the underscore ' _ ' composition; the name is concise and clear (the length cannot

let MySQL support emoji emoticons, involving wireless-related MySQL database recommendations are in advance with the UTF8MB4 character set. MySQL version 5.61 solution: Convert the MySQL encoding from UTF8 to UTF8MB4.Requires >= MySQL 5.5.3 version,

If MySQL connection data set unreasonable may lead to very small traffic MySQL will prompt mysql:error 1040:too many connections error, then how to be considered reasonable to set the maximum number of MySQL connection, I would like to introduce to

as a DBA, the core goal is the ultimate goal: to ensure the stability, security, integrity and high performance of the database management system. MySQL DBA There are two kinds: one is to develop the DBA, and the other is the Operation DBA, and the

1, the left connection, the first table in the required data to all, the second table if there is no corresponding matching data will be null.2, when the right connection, the second table in the required data to all, the first table if there is no

MySQL includes character set support this enables you to store data using a variety of character sets and perform Comparis ONS according to a variety of collations. You can specify character. MySQL supports the use of characterMySQL supports

1. Send a header to the client with the server, and the client enters the user name and password to view the returned page.Call header () to set the header information to enable authentication information.Header (' http/1.1401 unauthorized ');Header

Objective:Recently participated in the interview, asked a lot of questions about the optimization of MySQL, the answer is not very good, but also because the original project traffic is not very large, so the MySQL optimization is not too

CentOS 6.5 Installation Configuration Lnmp server (nginx+php+mysql)I. Preparation of the article:1/etc/init.d/iptables stop#shutting down the firewall2 Turn off SELinux3vi/etc/selinux/Config4 #selinux=enforcing #注释掉5 #selinuxtype=targeted

Mysql:1 ": http://www.mysql.com/products/connector/2 "jdbc:[database type]://[IP address]:[port number/[database name]Private String URL = "Jdbc:mysql://localhost:3306/userdata";Private String Driver = "Com.mysql.jdbc.Driver";Private String user =

Because the memory engine does not support Bolb and text types, if the query uses a BLOB or text column and you need to use an implicit temporary table, you will have to use the MyISAM disk staging table, even if there are only a few rows of

Since the project has been updated with a large version, it will not be long before the optimization task of SQL query queries, the Operation and Maintenance section to export a copy of the historical query SQL statement log to the development