MySQL error when performing a script
mysql.connector.errors.OperationalError: 2013 (HY000): Lost connection to MySQL server during query
We make a complex request in the data group and receive more than 20 million records that we need to count.
When reading the lines from the request, the connection is broken. Mistake of connection to the BD.
must be corrected
Who has great experience in system management.
-
Делать выборку на 20 млн строк - это не очень разумно
Оптимально все писать в отдельную табличку и с ней работать. Может даже сделать выгрузку в другую БД на этом же сервере, чтобы разделять функции БД
-
Current freelance projects in the category Desktop Apps
Add pauses of 10-30 seconds between sending emails.Hello! I am looking for an experienced 1C / BAS (BAF) programmer to promptly resolve a technical issue with email distribution.Problem essence: We use the accounting program BAF (Business Automation Framework), version 2.0. Once a month, there is a need to send about 300 emails… Web Programming, Desktop Apps ∙ 5 days 15 hours back ∙ 10 proposals |
Reverse engineering of console utilities for querying SSD controllers (Flash ID)1. Purpose of the work Extraction of the application programming interface (API) for interaction with SSD/NVMe controllers from the provided set of console utilities (Phison, Silicon Motion, Realtek, Maxiotek, Marvell, JMicron, etc.). The result should be working code in C/C++… C & C++, Desktop Apps ∙ 6 days 2 hours back ∙ 6 proposals |
Modification in the emulator's operation
45 USD
Hello. I downloaded the Gaminator CF Final slot machine emulator from the Internet. I really liked it, but there are some issues. There is an admin panel, but it opens freely and cannot be closed at all. It only closes along with the application. Also, the data does not save… Desktop Apps ∙ 13 days 16 hours back ∙ 10 proposals |