问答搜索_php.cn

Article Topic Learning Download Q&A Programming Dictionary Game Recent Updates

简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)

Popular searches：
PHP
MySQL
jquery
HTML
CSS

Is it wise to create different tables for the same data for each date?

I have a MYSQLInnoDB table with the following columns (table and column names changed): date (PK, date) var_a (PK, FK, INT) var_b (PK, FK, INT) rel_ab (decimal) where rel_ab is the description Column of relationship between 2 variables var_a and var_b given date. (var_a and var_b refer to different ...

P粉665679053 2023-09-09 17:40:44

Is full count query really that slow on a large MySQL InnoDB table?

We have a large table with millions of entries. Full counting is very slow, see code below. Is this common for MySQLInnoDB tables? Isn't there a way to speed up this process? Even with query caching, it's still "slow". I'd also like to know why the count of the "communication" ta...

P粉291886842 2023-11-07 15:52:43

Prevent MySQL from reading when updating

I have two simple queries, one to read the table and one to update the table. How to lock the read of a select query while the update query is running. Now in MySQLInnoDB, I noticed that writes/updates are locked by default, but reads/selects get the old data before the transaction. I tried using a ...

P粉190883225 2023-11-07 18:05:53

About us Disclaimer Sitemap: php.cn：Public welfare online PHP training，Help PHP learners grow quickly！