Revision [2098]

Last edited on 2008-12-01 06:14:28 by WikiAdmin
Additions:
default-table-type=innodb
Deletions:
default-storage-engine=innodb

Revision [2097]

Edited on 2008-12-01 06:11:26 by WikiAdmin
Additions:
In 5.1.30ga, --enable-innodb is no longer supported / required.
--with-unix-socket-path=/var/lib/mysql/mysql.sock \
--with-plugins=csv,heap,innobase,myisam,myisammrg,partition,ftexample,archive,federated
Deletions:
--with-unix-socket-path=/usr/local/mysql/run/mysql.sock \
--with-plugins=csv,heap,innobase,myisam,myisammrg,partition,ftexample,archive,federated \
--enable-innodb \
--with-server-suffix=-custom

Revision [2083]

Edited on 2008-11-06 08:57:56 by WikiAdmin
Additions:
This was used to compile mysql-5.1.29rc. --enable-innodb is not documented in configure --help but without it, mysql will be built without innodb! Ref: http://venublog.com/2008/04/21/mysql-5124-innodb-plugin-10-failures-server-crash/
Deletions:
This was used to compile mysql-5.1.29rc. --enable-innodb is not documented in configure --help but without it, mysql will be built without innodb!

Revision [2081]

Edited on 2008-11-06 08:55:20 by WikiAdmin
Additions:
This was used to compile mysql-5.1.29rc. --enable-innodb is not documented in configure --help but without it, mysql will be built without innodb!
Deletions:
--enable-innodb is not documented in configure --help...

Revision [2080]

Edited on 2008-11-06 08:54:29 by WikiAdmin
Additions:
--enable-innodb is not documented in configure --help...
--prefix=/usr/local/mysql \
--sysconfdir=/etc \
--with-unix-socket-path=/usr/local/mysql/run/mysql.sock \
--with-ssl=/usr/local/ssl \
--with-plugins=csv,heap,innobase,myisam,myisammrg,partition,ftexample,archive,federated \
--enable-innodb \
--with-server-suffix=-custom
Deletions:
--prefix=/usr/local/mysql51 --bindir=/usr/local/bin --sbindir=/usr/local/sbin --datadir=/var/lib/mysql \
--enable-share \
--enable-community-features \
--with-zlib-dir=/usr \
--with-big-tables \
--with-ssl=/usr/local/ssl/lib \
--with-plugins=max \
--enable-assembler

Revision [1919]

Edited on 2008-09-02 01:17:48 by WikiAdmin
Additions:
innodb_data_file_path=ibdata1:10M:autoextend #this is for undo and other system data
Deletions:
innodb_data_file_path=ibdata1:10M:autoextend

Revision [1918]

Edited on 2008-09-02 01:16:15 by WikiAdmin
Additions:
innodb_data_file_path=ibdata1:10M:autoextend

Revision [1720]

Edited on 2008-05-14 18:55:01 by WikiAdmin
Additions:
--prefix=/usr/local/mysql51 --bindir=/usr/local/bin --sbindir=/usr/local/sbin --datadir=/var/lib/mysql \
--enable-assembler
Deletions:
--enable-assembler

Revision [1719]

Edited on 2008-05-14 18:46:46 by WikiAdmin
Additions:
--with-plugins=max \
--enable-assembler
Running into problems? Check http://dev.mysql.com/doc/refman/5.1/en/compilation-problems.html
Deletions:
--with-plugins=max

Revision [1718]

Edited on 2008-05-14 18:28:14 by WikiAdmin
Additions:
--with-ssl=/usr/local/ssl/lib \
Deletions:
--with-ssl=/usr/local/ssl \

Revision [1717]

Edited on 2008-05-14 18:25:30 by WikiAdmin
Additions:
IDENTIFIED BY 'pass' WITH GRANT OPTION;
IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
===Installing from source===
./configure \
--enable-share \
--enable-community-features \
--enable-local-infile \
--with-charset=utf8 \
--with-mysqld-user=mysql \
--with-zlib-dir=/usr \
--with-big-tables \
--with-ssl=/usr/local/ssl \
--with-plugins=max
Deletions:
IDENTIFIED BY 'pass' WITH GRANT OPTION;
IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

Revision [314]

Edited on 2007-04-20 08:53:52 by WikiAdmin
Deletions:
{{adsense}}

Revision [232]

Edited on 2007-04-17 07:50:42 by WikiAdmin
Additions:
%%(bash)
%%(bash)
%%(sql)
%%(sql)
%%(sql)
GRANT ALL PRIVILEGES ON ~.~ TO myUser@localhost
GRANT ALL PRIVILEGES ON ~.~ TO myUser@"%"
%%(sql)
delete from user where user='username';
FLUSH PRIVILEGES;
Deletions:
mysql> GRANT ALL PRIVILEGES ON ~.~ TO myUser@localhost
mysql> GRANT ALL PRIVILEGES ON ~.~ TO myUser@"%"
mysql> delete from user where user='username';
mysql> FLUSH PRIVILEGES;

Revision [231]

Edited on 2007-04-17 07:49:46 by WikiAdmin
Additions:
%%(text;my.cnf)
Deletions:
%%(;my.cnf)

Revision [230]

Edited on 2007-04-17 07:49:04 by WikiAdmin
Additions:
%%(;my.cnf)
Deletions:
%%(txt;my.cnf)

Revision [229]

Edited on 2007-04-17 07:48:43 by WikiAdmin
Additions:
%%(txt;my.cnf)

Revision [228]

Edited on 2007-04-17 07:48:19 by WikiAdmin
Additions:
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 2

Revision [131]

Edited on 2007-04-14 21:29:23 by WikiAdmin
Additions:
{{parent page="Mysql"}}

Revision [94]

The oldest known version of this page was created on 2007-04-14 17:22:57 by WikiAdmin
Valid XHTML 1.0 Transitional :: Valid CSS :: Powered by WikkaWiki