From: Michael Widenius Date: March 26 2010 5:34pm Subject: Re: MySQL execution List-Archive: http://lists.mysql.com/internals/37835 Message-Id: <19372.61501.501117.438604@narttu.askmonty.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi! >>>>> "Karthik" == Karthik Gurukuntala writes: Karthik> Doesnt that require 'make install' at that location Karthik> everytime i re-compile the source with some Karthik> changes?(Actually am debugging the code to learn some Karthik> aggregation operations' execution.) You can run mysqld directly from the source directory (without doing make install). - Copy the following to your ~/.my.cnf file (This is a copy of the file I use) # Example mysql config file. # You can copy this to one of: # /etc/my.cnf to set global options, # /mysql-data-dir/my.cnf to get server specific options or # ~/my.cnf for user specific options. # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password #port=3306 #socket=/tmp/mysql.sock # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] #port=3306 #socket=/tmp/mysql.sock skip-locking temp-pool set-variable = key_buffer=16M set-variable = thread_cache=4 loose-innodb_data_file_path = ibdata1:1000M loose-mutex-deadlock-detector gdb ######### Fix the two following paths # Where you want to have your database data=/data # Where you have your mysql/MariaDB source + sql/share/english language=/usr/local/src/mysql/sql/share/english [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash [myisamchk] set-variable= key_buffer=128M ----------------------------- (End of ~/.my.cnf) - Go to your source directory and execute: ./scripts/mysql_install_db - Start mysqld in debugger cd sql ddd mysqld & ----------------- Regards, Monty