|
- °Ë»öµÈ °Ô½ÃÆÇ ¸®½ºÆ® (1°³ÀÇ °Ô½ÃÆÇ, 27°³ÀÇ °Ô½Ã±Û, 1/3 ÆäÀÌÁö)
- MYSQL Timezone [ț̢]
<div>MYSQL Timezone</div><a href="http://devstory.ibksplatform.com/2018/05/mysql-db-time-zone.html">http://devstory.ibksplatform.com/2018/05/mysql-db-time-zone.html</a> 2021-02-03 13:11:57 ÃÖ°í°ü¸®ÀÚ
- MYSQL ¿¬°áÁ¤º¸ [»õâ]
<div style="color: rgb(0, 0, 0); font-family: ±¼¸²; font-size: 9pt;"><font face="±¼¸²"><span style="font-size: 12px;"># mysqladmin -u root -p extended-status |egrep '(Max|Threads_)'</span></font></div><div style="color: rgb(0, 0, 0); font-f¡¦ 2018-03-09 09:45:00 ÃÖ°í°ü¸®ÀÚ
- mysql shell À» ÅëÇØ µ¥ÀÌŸº£À̽º Å©±â È®ÀÎ [»õâ]
<div><font face="±¼¸²"><span style="font-size: 12px;">MariaDB [(none)]> SELECT table_schema "database", sum(data_length + index_length)/1024/1024 "size in MB" FROM information_schema.TABLES GROUP BY table_schema;</span></font></div><div><font face¡¦ 2017-06-02 09:42:58 ÃÖ°í°ü¸®ÀÚ
- MYSQL Äõ¸® Å×½ºÆ® [»õâ]
<font face="±¼¸²"><span style="font-size: 12px;"><a href="http://www.tutorialspoint.com/mysql_terminal_online.php" target="_blank">http://www.tutorialspoint.com/mysql_terminal_online.php</a> <br></span></font><div><font face="¡¦ 2016-12-06 13:05:46 ÃÖ°í°ü¸®ÀÚ
- Graphing MySQL ¸ð´ÏÅ͸µÅø - Grafana [»õâ]
Graphing MySQL performance with Prometheus and Grafana<br><a target="_blank" href="https://www.percona.com/blog/2016/02/29/graphing-mysql-performance-with-prometheus-and-grafana/">https://www.percona.com/blog/2016/02/29/graphing-mysql-performance-with-prometheus-and-grafana/</a><¡¦ 2016-06-21 10:03:44 ÃÖ°í°ü¸®ÀÚ
- SQL ¹®°ú MongoDB ºñ±³ [»õâ]
<font face="±¼¸²"><span style="font-size: 12px; line-height: 18px;">Ãâó : http://jy86.tistory.com/26</span></font><div><br style="line-height: 18px; color: rgb(64, 64, 64); font-family: verdana, tahoma, µ¸¿ò; font-size: 12px; background-color: rgb(245, 245, 245);"&g¡¦ 2015-06-26 13:33:06 ÃÖ°í°ü¸®ÀÚ
- [MYSQL] TIMEZONE [ț̢]
<div><font face="±¼¸²"><span style="font-size: 12px; line-height: 18px;">MariaDB [(none)]> select @@time_zone;</span></font></div><div><font face="±¼¸²"><span style="font-size: 12px; line-height: 18px;">+-------------+</span></fo¡¦ 2015-06-09 03:22:17 ÃÖ°í°ü¸®ÀÚ
- [MYSQL] mysqldump Á¶°Ç¹® where, like [»õâ]
<font face="±¼¸²"><span style="font-size: 12px; line-height: 18px;"># mysqldump -u ${DB_USER} -p ${DB_NAME} ${TABLE_NAME} --where="${Á¶°Ç FILED} like '2015-02-10%'" > TABLE_20150210_1847.sql</span></font><div><font face="±¼¸²"&¡¦ 2015-02-10 16:32:37 ÃÖ°í°ü¸®ÀÚ
- [MYSQL] Å×ÀÌºí ½ºÅ°¸¶¸¸ ¹é¾÷ [»õâ]
# mysqldump -u ${user_name} -p -d ${DATABASE_NAME} ${TABLE_NAME} > schema.sql<div> -d, --no-data No row information.</div> 2015-01-29 09:49:51 ÃÖ°í°ü¸®ÀÚ
1 2 3 ¸Ç³¡
|
|
|
|