So I'm pretty new to MySQL in general, and even newer to HeidiSQL -- but I've found an issue that I can't seem to solve.
I can connect to my databases fine and edit them through the HeidiSQL GUI just fine. Inserting rows works like a charm... until in the bottom it shows a timeout and says "connection to [site] closed". Once that happens, every time I try to insert a new row into a table, it INSERTs two of the same thing I just entered, instead of one. If I close the connection and reopen it altogether, the problem is no longer there.
Is this an issue on my side? Anything I can do to prevent this?
Thanks!
Doubling inserts after timeout?
Same.
Version 8.0 4502
Also does it on Updates which causes warnings.
/* Connecting to #.#.#.# via Percona (TCP/IP), username ****, using password: Yes ... */
/* Connected. Thread-ID: 110200738 */
SHOW STATUS;
SHOW VARIABLES;
USE `lbmedia_pbmag`;
INSERT INTO `lbmedia_pbmag`.`pb_category` (`category_name`) VALUES ('Alternative You');
SELECT LAST_INSERT_ID();
SELECT `category_id`, `category_of`, `category_name` FROM `lbmedia_pbmag`.`pb_category` WHERE `category_id`=5;
SHOW CREATE TABLE `lbmedia_pbmag`.`pb_category`;
SHOW COLLATION;
SHOW ENGINES;
INSERT INTO `lbmedia_pbmag`.`pb_category` (`category_name`) VALUES ('Alternative You');
SELECT `category_id`, `category_of`, `category_name` FROM `lbmedia_pbmag`.`pb_category` WHERE `category_id`=5;
SELECT `category_id`, `category_of`, `category_name` FROM `lbmedia_pbmag`.`pb_category` LIMIT 1000;
SHOW CREATE TABLE `lbmedia_pbmag`.`pb_category`;
/* Connection to #.#.#.# closed at 2013-09-03 18:53:45 */
Version 8.0 4502
Also does it on Updates which causes warnings.
/* Connecting to #.#.#.# via Percona (TCP/IP), username ****, using password: Yes ... */
/* Connected. Thread-ID: 110200738 */
SHOW STATUS;
SHOW VARIABLES;
USE `lbmedia_pbmag`;
INSERT INTO `lbmedia_pbmag`.`pb_category` (`category_name`) VALUES ('Alternative You');
SELECT LAST_INSERT_ID();
SELECT `category_id`, `category_of`, `category_name` FROM `lbmedia_pbmag`.`pb_category` WHERE `category_id`=5;
SHOW CREATE TABLE `lbmedia_pbmag`.`pb_category`;
SHOW COLLATION;
SHOW ENGINES;
INSERT INTO `lbmedia_pbmag`.`pb_category` (`category_name`) VALUES ('Alternative You');
SELECT `category_id`, `category_of`, `category_name` FROM `lbmedia_pbmag`.`pb_category` WHERE `category_id`=5;
SELECT `category_id`, `category_of`, `category_name` FROM `lbmedia_pbmag`.`pb_category` LIMIT 1000;
SHOW CREATE TABLE `lbmedia_pbmag`.`pb_category`;
/* Connection to #.#.#.# closed at 2013-09-03 18:53:45 */
Please login to leave a reply, or register at first.