msyql - Related information

  • On the problem of mysql concurrent repeated insertion

    1. The scenario in which the problem occurs 1. Network delay, or use the FD tool to simulate requests sql select time form order where uid= 15 order by time desc limit 0 br > if (current time-time < 15) { exit (do not request frequently); } INS...

    Apr.21,2022
  • How to build a php production environment that can prevent operational errors?

    the company uses Aliyun s ECS server, which used to be a server (centos7) + a disk, and the environment and code were all put together. Once, when configuring the environment, the system file was deleted by mistake, so that the system could not boot. L...

    Mar.09,2021
  • What is the problem with the data returned by the sql query in the mysql database?

    Multi-table management, because the sum operation is used, so even if there is no data mybatis query will become one. The result is that null, if the default value is set on the sum, such as 0, it will return a piece of data that only the field sum is 0....

    Feb.28,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-1e80a62-468cd.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-1e80a62-468cd.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
    Need Help?