Fulltext results:

IPアドレス-アドレスナンバー @02_freebsd:04_database:01_mysql

6 Hits, Last modified: 13 years ago

umber) | +------+----------------------+ | 4611 | 10.10.0.3 | +------+----------------------+ 1 row in set (0.00 sec) </code> 逆は INET_ATON <code console> mysql> select INET_ATON('10.10.0.3'); +------------------------+ | INET_ATON('10.10.0.3') | +------------------------+ |

MySQL - バックアップ mysqldump @02_freebsd:04_database:01_mysql

4 Hits, Last modified: 11 months ago

sqldump --all-databases | ssh -i key root@192.168.10.10 'cat > dump.sql' ==== リモートへ圧縮してコピー ==== mysqldump --all-databases | gzip | ssh -i key root@192.168.10.10 'cat > dump.sql.gz' ==== リモートへSSHしてからdumpの場合 ==== ssh root@host "mysqldump --all-databases"

mysqldumpでエラー @02_freebsd:04_database:01_mysql

4 Hits, Last modified: 12 years ago

les -u hogehoge --password="hogehoge" -h "192.168.10.10" cloud > cloud.dump mysqldump: Couldn't execute 'show create table `account_netstats_view`': SHOW VIEW command denied to user 'hogehoge@'192.168.10.10 for table 'account_netstats_view' (1142) </code> SHOW VIEW権限を付けてあげると、mysqldumpできました。 <code consol

10 文字列関数MySQL @02_freebsd:04_database:01_mysql

2 Hits, Last modified: 11 years ago

====== 10 文字列関数MySQL ====== 1. CONCAT - 文字列を連結 SELECT CONCAT('Ma', 'ria', 'DB'); -- 'MariaDB' 引数はいく... 現位置を取得 SELECT LOCATE('bar', 'foobarbar'); -- 4 10. REPLACE - 文字列置換 SELECT REPLACE('www.mariadb.org

20 wait_timeoutとthread_cache_size @02_freebsd:04_database:01_mysql

2 Hits, Last modified: 9 years ago

-----------------+-------+ | max_connect_errors | 10 | | max_connections | 100 | +--------------------+-------+ 2 rows in set (0.00 sec) </code... なっていないスレッドの数| <code|my.cnf> thread_cache_size = 100 </code> ===== オンラインで反映 ===== wait_timeoutとth... meout = 360; mysql>SET GLOBAL thread_cache_size = 100; </code> ===== thread_cache_sizeの考察 ===== [[h

MySQLコマンド @02_freebsd:04_database:01_mysql

2 Hits, Last modified: 6 months ago

d6.3 (i386) using 5.2 Connection id: 104553 Current database: syslog Current user... ort: mysql-server-5.1.28 Protocol version: 10 Connection: Localhost via UNIX socke... ql.sock Uptime: 15 days 11 hours 10 min 32 sec Threads: 2 Questions: 2293516 Slo

18 MySQLでALTER TABLEの進捗確認 @02_freebsd:04_database:01_mysql

1 Hits, Last modified: 7 years ago

----+ | 1273517123 | +------------+ 1 row in set (10 min 26.05 sec) $ bash alert_progress.sh 200000 2

MySQL - slow log @02_freebsd:04_database:01_mysql

1 Hits, Last modified: 8 months ago

----------------+-----------+ | long_query_time | 10.000000 | +-----------------+-----------+ 1 row in