mysql - 瞬间流量很高的网站，要频繁的插入数据到数据库，应该怎么解决这个问题？

瞬间流量很高的网站，要频繁的插入数据到数据库，怎么才能解决速度慢的问题？要用到什么技术？

From [MySQLdiscussion group] 2017-04-17 15:15:45 0  7  811

mysql优化 - MySQL中使用UNION进行两表合并，去重导致效率低下，请问如何优化？

如下SQL语句在MySQL中执行需要2秒左右的时间，如果使用UNION ALL进行不去重合并只需要0.4秒，UNION ALL配合DISTINCT来去重速度又变成2秒了，请问如何进行优化？ {代码...}

From [MySQLdiscussion group] 2017-04-17 14:48:54 0  3  810

Please upgrade the MySQL client: MySQL 8.0 - The client does not support the authentication protocol requested by the server

For some reason I can't establish a simple connection to the server. I installed the latest MySQLCommunity8.0 ...

From [MySQLdiscussion group] 2023-10-10 09:34:48 0  2  809

yum - linux7.0安装mysql的问题

安装mysql {代码...} 启动mysqlservice mysqld restart设置密码 {代码...} 可我没设置密码啊，网上找了几个方式都没用。

From [MySQLdiscussion group] 2017-04-17 16:33:55 0  6  809

数据库 - 为什么MSSQL和MYSQL那么的不统一?

目前一个项目需要将愿数据库(sqlserver)中的数据取出并做一定处理后存入目标数据库(mysql),但是mssql和mysql无论是sql语句还是内置函数很多地方都不统一(比如mysql的自增是auto_increm...

From [MySQLdiscussion group] 2017-04-17 14:18:33 0  3  809

linux - MySQL存储引擎选择InnoDB与MyISAM

我要做一个 问答的网站 请问存储引擎改选用那个 后期可以更改存储引擎吗？ 求帮助 谢谢

From [MySQLdiscussion group] 2017-04-17 13:28:16 0  4  809

python - How to write such a mysql statement for GROUP BY in django?

I am a newbie in django (also a scumbag in mysql). I searched on Baidu and tried to write a mysql syntax. I wa...

From [MySQLdiscussion group] 2017-06-07 09:24:57 0  2  808

mysql - table design with multiple roles having different fields

I design a system with multiple roles and they have different fields. Should I design different role tables, o...

From [MySQLdiscussion group] 2017-05-19 10:07:01 0  2  808

Troubleshooting: Error 111 - Unable to connect to MySQL server

I have a MySQL server installed on a Linux host with the IP address 192.168.1.100, but when I try to connect t...

From [MySQLdiscussion group] 2023-08-02 20:16:12 0  2  806

Does anyone know how to modify data in multiple rows and columns in MySql? Please give me some advice.

Does anyone know how to modify data in multiple rows and columns in MySql?

From [MySQLdiscussion group] 2017-06-06 09:51:59 0  5  806

mysql优化 - mysql数据insert快还是update比较快

现在有2个张表,现在的处理逻辑是先往1张表的插入数据,然后再查询出插入的数据再更新到另一张表。这样操作的原因是担心如果直接更新另一张表的话会不会数据量大了导致更新速度慢,没有完全更新导致数据丢失。我这样...

From [MySQLdiscussion group] 2017-04-17 16:27:11 0  2  806

mysql分表之后怎么查询

表结构包含id，week，hot，按周切成7张表，每张表代表一周的第几天，week代表第几周，怎么查询第n周hot排名前十的记录？

From [MySQLdiscussion group] 2017-04-17 14:49:20 0  5  806

数据库 - Mysql 外键为什么不能多对多啊

如下语句 mysql> alter table todomodel_tasks add foreign key(user,projects) references tod omodel_projects(u...

From [MySQLdiscussion group] 2017-04-17 12:58:22 0  1  806

Spring Boot application using MySQL stops suddenly

I have this in application.properties: spring.datasource.url=jdbc:mysql://lin-05779-94506-mysql-primary.server...

From [MySQLdiscussion group] 2023-09-02 10:13:16 0  1  805

php - mysql multi-table query

There are two tables, briefly describe them. Table 1: Relationship table between courses and students rsid cid...

From [MySQLdiscussion group] 2017-05-25 15:08:10 0  3  805