Revision [3897]

Last edited on 2011-02-25 08:23:57 by KenFong
Additions:
~==[[MysqlProcedures Procedures or Functions]]==

Revision [3857]

Edited on 2010-10-03 22:49:31 by KenFong
Additions:
~==[[MysqlCharacterset CharacterSet]]==

Revision [3855]

Edited on 2010-09-26 17:42:30 by KenFong
Additions:
~==[[MysqlBinlog Binlog]]==
~==[[MysqlBenchmark Benchmarking]]==
Deletions:
~~==[[MysqlBinlog Binlog]]==

Revision [3752]

Edited on 2010-07-15 01:50:31 by KenFong
Additions:
===sum of size of all tables===
mysql> select sum(DATA_LENGTH)/1024/1024/1024 from INFORMATION_SCHEMA.TABLES;

Revision [3483]

Edited on 2009-08-13 03:04:54 by WikiAdmin
Additions:
~~==[[MysqlBinlog Binlog]]==

Revision [2296]

Edited on 2009-04-28 00:39:48 by WikiAdmin
Additions:
~==[[MysqlPartitions Partitions]]==
-----

Revision [2175]

Edited on 2009-01-24 09:21:28 by WikiAdmin
Additions:
~==[[MysqlDBSize Check DB size]]==
Deletions:
~--[[MysqlDBSize Check DB size]]==

Revision [2174]

Edited on 2009-01-24 09:21:17 by WikiAdmin
Additions:
~--[[MysqlDBSize Check DB size]]==

Revision [2122]

Edited on 2008-12-22 23:21:00 by WikiAdmin
Additions:
~==[[MysqlProxy MysqlProxy]]==

Revision [2120]

Edited on 2008-12-22 01:30:49 by WikiAdmin
Additions:
~==[[MySQLLocks Locks]]==
Deletions:
~~==[[MySQLLocks Locks]]==

Revision [2119]

Edited on 2008-12-22 01:30:30 by WikiAdmin
Additions:
~~==[[MySQLLocks Locks]]==

Revision [1966]

Edited on 2008-09-24 01:46:16 by WikiAdmin
Additions:
===slow queries===
%%(text; my.cnf)
log-slow-queries=/var/log/mysql-slow.log

Revision [1730]

Edited on 2008-05-26 22:45:55 by WikiAdmin
Additions:
~== [[MysqlCSVExport Export to CSV]]==

Revision [1640]

Edited on 2008-04-14 07:23:38 by WikiAdmin
Additions:
[[http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html MySQL multi master hack]]

Revision [1593]

Edited on 2008-04-01 20:55:36 by WikiAdmin
Additions:
$link = mysql_connect('localhost:/tmp/mysql.sock', 'mysql_user', 'mysql_password');
Deletions:
localhost:/tmp/mysql.sock

Revision [1592]

Edited on 2008-04-01 20:55:10 by WikiAdmin
Additions:
===MySQL===
===php use socket instead of tcp===
Put this in host parameter
localhost:/tmp/mysql.sock

Revision [1567]

Edited on 2008-03-27 01:34:58 by WikiAdmin
Additions:
~==[[MySQLDML DML]]==
~==[[MySQLDDL DDL]]==
--key_buffer_size=128M --sort_buffer_size=128M \
--read_buffer_size=1M --write_buffer_size=1M \
/path/to/datadir/*/*.MYI
Deletions:
--key_buffer_size=128M --sort_buffer_size=128M \
--read_buffer_size=1M --write_buffer_size=1M \
/path/to/datadir/*/*.MYI

Revision [1513]

Edited on 2008-03-18 23:26:29 by WikiAdmin
Additions:
[[http://dev.mysql.com/doc/refman/5.0/en/secure-create-certs.html Encrypt MySQL connection with SSL]]

Revision [1392]

Edited on 2008-02-11 19:34:44 by WikiAdmin
Additions:
**Show databases on remote host**
**Show processes on mysql**
**Show query statistics**
**Display table statistics**
**Export to CSV**
**Explain mysql error code**
Deletions:
# Show databases on remote host
# Show processes on mysql
# Show query statistics
# Display table statistics
# Export to CSV
# Explain mysql error code

Revision [1391]

The oldest known version of this page was created on 2008-02-11 19:33:13 by WikiAdmin
Valid XHTML 1.0 Transitional :: Valid CSS :: Powered by WikkaWiki