Mysql partition error, and how to optimize the novel subscription table?

{Code...} mysql reported this error when creating a partition: For RANGE partitions each partition must be def...

From [MySQLdiscussion group] 2017-05-18 10:53:57 0  1  914

mysql - sql query statistics

![I need to count the U and A corresponding to each layerid. For example, HYD_NET_LN U 5 A 10 HYD_VAL_PT U 8 A...

From [MySQLdiscussion group] 2017-05-18 10:53:38 0  5  954

mysql optimization - how to explain the problem that mysql primary key is too long and causes secondary indexes to use more space. For example, using uuid as the primary key causes this problem

I read Meituan's article: http://tech.meituan.com/MT_Le... I thought of it, but I don't quite understand the o...

From [MySQLdiscussion group] 2017-05-18 10:53:33 0  1  886

Database design - mysql database integration

For two mysql libraries with the same partial tables, I think I can specify the corresponding relationship bet...

From [MySQLdiscussion group] 2017-05-18 10:53:24 0  1  750

Branch versions and derivative versions of mysql

MariaDB is like a shadow version of MySQL. MariaDB is a branch version of MySQL, not a derivative version (fol...

From [MySQLdiscussion group] 2017-05-18 10:53:12 0  1  893

Could you please recommend a video tutorial for getting started quickly with mysql?

I also want to spend more time learning it carefully, but due to time constraints, I want to get started quick...

From [MySQLdiscussion group] 2017-05-18 10:53:06 0  2  787

mysql - Alibaba Cloud virtual host problem

HSFTimeOutException-Timeout waiting for task. ERR-CODE: [HSF-0002], Type: [Business Problem], More: [http://co...

From [MySQLdiscussion group] 2017-05-18 10:53:01 0  1  956

How to find the average value of specified field data in mysql

Table price, field category, value 55, average field pi category, pi55 10055 10556 13055 9555 8059 11555 10155...

From [MySQLdiscussion group] 2017-05-18 10:52:53 0  1  921

mysql index - How to reorganize (or generate) indexes for mysql tables?

1. Background description I have a user table with the following table structure: The index is as follows: The...

From [MySQLdiscussion group] 2017-05-18 10:52:38 0  3  1066

The problem of group by in Mysql. .

In Mysql, the following writing method is allowed. But is it strict or not? Does it support writing like this?...

From [MySQLdiscussion group] 2017-05-18 10:52:23 0  9  784

Problems after setting the root user of mysql to be accessible from the external network

Modify the root user to be able to log in when not local {code...} After completing the above steps, I encount...

From [MySQLdiscussion group] 2017-05-18 10:52:20 0  1  923

phpmyadmin - mysql searches the index and finds the key_name of id_2. What index is this? ?

Mysql searches the index and finds the key_name of id_2. What index is this? ? SHOW INDEX FROM spm_works, the ...

From [MySQLdiscussion group] 2017-05-18 10:52:17 0  2  976

python2.7 mysql execute() problem

Part of the code for inserting data: {code...} After executing the program, I get {code...} When I entered the...

From [MySQLdiscussion group] 2017-05-18 10:52:05 0  1  856

Mysql under Mac does not support Chinese and the configuration file does not have a my-default.cnf file

1. My mysql does not support Chinese. I followed the online method to change the encoding, but I cannot find t...

From [MySQLdiscussion group] 2017-05-18 10:52:03 0  2  800

c# - mysql query optimization?

1. There are more than 1 million pieces of data. The count speed is very slow. Please let me know how to optim...

From [MySQLdiscussion group] 2017-05-18 10:51:56 0  5  810