optimized - Related information

• Front-end css/js/html file cache

  when a user uses Ctrl+F5 to force a page refresh, the css js html file is reloaded. if the css js html file is not modified, it will take a long time to reload. after looking up the data, you can determine whether the file has been updated by adding...

  Front-end optimized

  Oct.22,2021
• Mysql optimization

  SELECT COUNT (*) AS num FROM test WHERE ( a = 111AND cid = 21432 OR s_status < > yes OR t_status < > yes ) AND test . delete_time IS NULL LIMIT 1 explain the statement type is displayed as ALL. How to optimize it? ...

  Mysql optimized

  Mar.21,2021
• One query is a list, one query is details, how to better combine the two?

  because of my interest, I am working on a web application in my spare time. At present, I have a big performance problem. I would like to consult you here. I hope you will not hesitate to give me your advice. there are two tables, one is the exchange ...

  Mysql optimized

  Mar.20,2021
• Which mysql statement performs better

  select * from a where aa=1 and bb=2; select * from a where in (select id from a where aa=1 and bb=2); ...

  Mysql optimized

  Mar.18,2021
• MySQL suddenly hung up and the service could not be started. How to restore it?

  A crawler was used before hanging up, and an error of 2006-MySQL server has gone away occurred when entering the library. According to Baidu, change the my.conf file max_allowed_packet=500M wait_timeout=288000 After interactive_timeout = 288000 , t...

  Mysql optimized

  Mar.04,2021
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b3b864-2c2a4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b3b864-2c2a4.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?