You could modify your INSERT to be something like this: INSERT INTO tablename (tag) SELECT $tag FROM tablename WHERE NOT EXISTS( SELECT tag FROM tablename WHERE tag = $tag ) LIMIT 1 Where $tag is the tag (properly quoted or as a placeholder of course) that you want to add if it isn’t already there. … Read more
Have you tried the following? SET autocommit=0; SET unique_checks=0; SET foreign_key_checks=0; From the MySQL References https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-bulk-data-loading.html See Section “Bulk Data Loading Tips“
These instructions worked for me in a fresh install of MariaDB in Arch Linux: systemctl stop mariadb rm -R /var/lib/mysql/* mysql_install_db –user=mysql –basedir=/usr –datadir=/var/lib/mysql systemctl start mariadb
For InnoDB, the following seems to work: create the new empty database, then rename each table in turn into the new database: RENAME TABLE old_db.table TO new_db.table; You will need to adjust the permissions after that. For scripting in a shell, you can use either of the following: mysql -u username -ppassword old_db -sNe ‘show … Read more
From Wamp Version 3.2.6 Just edit this file: C:\wamp64\bin\mysql\mysql8.0.27\my.ini Change the config for innodb-default-row-format value from innodb-default-row-format=compact to innodb-default-row-format=dynamic Restart mysql
The reason for this issue is a change in MySQL 5.6.20 as one could read in the change log: As a result of the redo log BLOB write limit introduced for MySQL 5.6, the innodb_log_file_size setting should be 10 times larger than the largest BLOB data size found in the rows of your tables plus … Read more
The main difference is that InnoDB supports transactions while MyISAM does not. There are numerous other differences, however the common one’s i am aware of are: MyISAM has typically been considered faster at searching, but recent InnoDB improvements are removing this difference and improving high concurrency workload performance InnoDB support transactions whilst MyISAM does not … Read more
You can edit your /config/database.php file, search for mysql entry and change: ‘engine’ => null, to ‘engine’ => ‘InnoDB’, This saves you from adding $table->engine = “InnoDB”; for each of your Schemas 😉
TLDR; Mysql can’t restart because it’s out of memory, check that you have an appropriate swapfile configured. Didn’t help? If that’s not your issue, more qualified questions to continue research are: mysqld service stops once a day on ec2 server https://askubuntu.com/questions/422037/optimising-mysql-settings-mysqld-running-out-of-memory Background I had exactly this problem on the very first system I set up … Read more
I have been trying to understand the difference between the two. I’ll document what I have found in hopes it’ll be useful to the next person. Both LOCK IN SHARE MODE and FOR UPDATE ensure no other transaction can update the rows that are selected. The difference between the two is in how they treat … Read more