computer_science:databases:mysql:mysql_tips_trics

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
computer_science:databases:mysql:mysql_tips_trics [2021/03/07 17:05] – carlossousacomputer_science:databases:mysql:mysql_tips_trics [2023/12/01 12:07] (current) – external edit 127.0.0.1
Line 24: Line 24:
 **Cons:** - **Cons:** -
 ===== Log Queries in Development ===== ===== Log Queries in Development =====
 +
 +**Pros: **Great to see Queries happening in Real Time
 +
 +**Cons: **Slightly higher storage requirement
 +
 +Don't forget to disable in Production
 +
 +**Usage:**
 +
 +Update my.cnf and add / change:
 +
 +<code>
 +general_log_file = /var/log/mysql_queries.log
 +general_log = 1
 +
 +</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>
  
  
  • computer_science/databases/mysql/mysql_tips_trics.1615136723.txt.gz
  • Last modified: 2023/12/01 12:07
  • (external edit)