Differences

This shows you the differences between two versions of the page.

--- computer_science:databases:mysql:mysql_tips_trics [2021/03/07 17:07] – [Log Queries in Development] carlossousa
+++ computer_science:databases:mysql:mysql_tips_trics [2023/12/01 12:07] (current) – external edit 127.0.0.1
@@ Line 40: / Line 40: @@
 </code>
+check log with:
+<code>
+tail -f /var/log/mysql_queries.log
+</code>
+===== Use Transactions for bulk insert: =====
+**Pros:** Only one re-index, at the end of the transaction.
+**Cons: **Visibility of new data only after commit - this can be considered an upside -.
+**Usage:**
+<code>
+START transaction;
+insert into table values (default, 1);
+insert into table values (default, 2);
+insert into table values (default, 3);
+insert into table values (default, 4);
+insert into table values (default, 5);
+COMMIT;
+</code>