MySQL

As shown below, PHP connection MySQL error: SQLSTATE[HY000] [2002] Can ' t connect to the local MySQL server through socket ' MySQL ' (2) The test code is as follows: Try{$dsn = ' Mysql:dbname=php-note;host=localhost;port=3306;charset=utf8

MySQL optimization under 8G memory Try the following settings:Key_buffer = 3840MMax_allowed_packet = 16MTable_cache = 1024Sort_buffer_size = 32MRead_buffer_size = 32MRead_rnd_buffer_size = 32MMyisam_sort_buffer_size = 256MThread_cache_size =

The most common way to satisfy a GROUP BY clause is to scan the entire table and create a new temporary table in which all rows of each group should be contiguous, and then use the temporary table to locate the group and apply the cumulative

1, connect MySQL Format: mysql-h host address-u user name-P user Password 1, connected to the MySQL on the computer. First open the DOS window, and then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after the

Similar error messages are as follows:16:52:01.163 [druid-connectionpool-create-1641320886] ERROR com.alibaba.druid.pool.druiddatasource-create Connection error, url:jdbc:mysql://localhost:3306/jf?useunicode=true&characterencoding=utf-8&

When using MySQL5.7 for semi-synchronous replication, it is found that a simple write operation of the main library executes 1s, which is caused by the show profile analysis that is semi-synchronous.Check the master-slave log, found the following

MySQL Database Basics (ii)--mysql character set and garbled parsing one, character set and encoding 1, Character set introductionCharacters (Character) are all kinds of words and symbols, including the national text, punctuation, graphic symbols,

Xtrabackup IntroductionPercona Xtrabackup is open source free MySQL database hot backup software, it can be InnoDB and XTRADB storage Engine database non-blocking backup (for MyISAM backup also need to add a table lock). Xtrabackup supports all

There are non-standard data types such as float,double in MySQL, as well as standard data types such as decimal. The difference is that non-standard types, such as float,double, hold approximate values in db, while decimal saves values as strings.

This article refers to the link: http://blog.csdn.net/jbboy/article/details/46828917"I think the article is more suitable for learning and reference, it is worth a look"This article to provide you with three kinds of in MySQL to avoid repeated

ObjectiveAs a background development, it is necessary to benchmark the database to master the performance of the database. This article describes the basic concepts of MySQL benchmarking and the detailed methods for benchmarking MySQL using Sysbench.

MySQL primary key auto-generated table design MySQL has many primary key generation strategies, and one of the most common is auto-generated. In general, the primary key type is bigint UNSIGNED, and the keyword that automatically generates the

InnoDB How to implement a row lockInnoDB row locks are implemented by locking the index entries on the index, which is different from Oracle, which is achieved by locking the corresponding data rows in the data block. InnoDB This type of row lock

Sometimes when we use commands such as "MySQL", "mysqladmin", "mysqldump" to manage the database, the server throws an error similar to the following: 1 ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket

Using MySQL will of course have access to the MySQL storage engine, which you will see when creating a new database and creating a new data table.MySQL default storage engine is MyISAM, other commonly used is innodb.What kind of storage engine is

Mysql LoadData the Use in the database, the most common way to write data is through Sqlinsert to write, and the other is to restore the database through backup files, this backup file in MySQL is SQL script, actually executed in BULK INSERT

1. Author: moonsbird Title: Windows server integrated configuration experience of Apache + Tomcat + MySQL + jsp + php Time: 2004.8.19 Originally published on jincheng station of Southwest Jiaotong University 2. This Article is a summary of the

Guide for building the JavaEE environment on the CentOS server (Remote Desktop + JDK + Tomcat + MySQL) and centosjavaee--------------------------------------------------------------------------------1. system settings:1.1 remote desktop settings:

Mysql master-slave replication principle and Configuration1 copy Overview The built-in replication function of Mysql is the basis for building large and high-performance applications. This distribution mechanism replicates data from a Mysql host to

This article mainly tells you the five reasons that are worthy of our trust in the MySQL database. We will list the best combinations of MySQL and PHP) the most difficult part of the five reasons is the sorting of these reasons. This is like a story