MySQL Lists are EOL. Please join:

List:Internals« Previous MessageNext Message »
From:Timothy Smith Date:May 31 2001 6:55pm
Subject:Re: how do you create a new database type (DISAM or TEXT)
View as plain text  
On 2001 May 31, DAVE THOMAS <DAVET@stripped> wrote:
> I think I took care of the problem. I wasn't installing the mysqld to the
> correct folder. I was running a version of mysqld from a few days ago that
> didnt have all my changes in it. I installed it to the folder I am executing
> it from and it does not give me a syntax error anymore. Thanks for all the
> help!

Here's what I do:

In my ~/.my.cnf:

[client]
password = XXXXXX

# For debugging; comment out normally
#socket=/home/tim/tmp/me-data/mysql.sock


[mysqld]
# For debugging
basedir = /home/tim/my/3/mysql-test
datadir = /home/tim/tmp/me-data
socket=/home/tim/tmp/me-data/mysql.sock

skip-networking
set-variable = key_buffer=64M
set-variable = table_cache=256
set-variable = sort_buffer=4M
set-variable = record_buffer=1M
set-variable = long_query_time=2

# InnoDB setup
#innodb_data_home_dir = /home/tim/tmp/inno/
## I just want one data file #;ibdata2:37M;ibdata3:100M;ibdata4:300M
#innodb_data_file_path = ibdata1:50M
#innodb_flush_log_at_trx_commit=1
#innodb_log_group_home_dir = /home/tim/tmp/inno/log/
#innodb_log_arch_dir = /home/tim/tmp/inno/log/
#innodb_log_archive = 0
#set-variable = innodb_mirrored_log_groups=1
#set-variable = innodb_log_files_in_group=3
#set-variable = innodb_log_file_size=5M
#set-variable = innodb_log_buffer_size=8M
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
#set-variable = innodb_file_io_threads=4
#set-variable = innodb_lock_wait_timeout=50


The datadir is already set up.  So, when I want to debug MySQL,
I don't have to install.  I just do this inside $HOME/my/3:

$ ddd sql/mysqld&

It picks up the debugging options for [mysqld] from ~/.my.cnf.
Of course, if I don't want to run under the debugger I can just
run ./sql/mysqld& instead.

Tim

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Tim Smith <tim@stripped>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Development Team
/_/  /_/\_, /___/\___\_\___/   Boone, NC  USA
       <___/   www.mysql.com
Thread
how do you create a new database type (DISAM or TEXT)Dave Thomas24 May
  • Re: how do you create a new database type (DISAM or TEXT)Timothy Smith24 May
  • Re: how do you create a new database type (DISAM or TEXT)Sinisa Milivojevic25 May
  • how do you create a new database type (DISAM or TEXT)Michael Widenius26 May
Re: how do you create a new database type (DISAM or TEXT)DAVE THOMAS30 May
  • Re: how do you create a new database type (DISAM or TEXT)Timothy Smith30 May
  • Re: how do you create a new database type (DISAM or TEXT)Sinisa Milivojevic31 May
  • Re: how do you create a new database type (DISAM or TEXT)Michael Widenius31 May
RE: how do you create a new database type (DISAM or TEXT)DAVE THOMAS31 May
RE: how do you create a new database type (DISAM or TEXT)DAVE THOMAS31 May
RE: how do you create a new database type (DISAM or TEXT)DAVE THOMAS31 May
  • Re: how do you create a new database type (DISAM or TEXT)Timothy Smith31 May
RE: how do you create a new database type (DISAM or TEXT)DAVE THOMAS31 May
  • RE: how do you create a new database type (DISAM or TEXT)Michael Widenius1 Jun