an3l
commented
5 years ago Getting started with mysql from source:
git clone https://github.com/mysql/mysql-server.git
Download boost - not needed see bellow
- https://www.boost.org/
- https://dev.mysql.com/doc/mysql-sourcebuild-excerpt/5.7/en/source-installation.html
- Read more https://www.boost.org/doc/libs/1_69_0/more/getting_started/unix-variants.html
# This step is not needed, since we are using -DDOWNLOAD_BOOST=1, but make sure you have libssl-dev, and pkg-config installed $ sudo apt-get install libssl-dev apt install pkg-config $ wget https://dl.bintray.com/boostorg/release/1.71.0/source/boost_1_71_0.tar.gz && tar xzvf boost_1_71_0.tar.gz && rm -rf boost_1_71_0.tar.gz && cd ~/boost_1_71_0/tools/build && ./boostrap.sh && ./b2 install --prefix=/home/anel/boost1 && PATH=$PATH:~/boost1/bin/
$ mkdir build-mysql $ cd build-mysql/ && cmake ../mysql-server/ -DCMAKE_BUILD_TYPE=DEbug -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/home/anel/boost1 $ make -j8 # haven't tried with ninja
Starting and stopping mysqld
https://dev.mysql.com/doc/refman/5.7/en/automatic-start.html
- This is the 2 step process:
1. initialize datadir to get the temporary password$mkdir ~/mysql-datadir $ cd build-mysql/sql $ ./mysqld --initialize --basedir=. --datadir=/home/anel/mysql-datadir
A temporary password is generated for root@localhost: DIr/mZ+k4Y8&
2. start the server$ cd build-mysql/sql/ $ ./mysqld --no-defaults --basedir=. --datadir=/home/anel/mysql-datadir --lc_messages_dir=./share --console
Start the client:$ cd build-mysql/client/
$ ./mysql -u root -p
paste the password from above DIr/mZ+k4Y8&
$ ALTER USER 'root'@'localhost' IDENTIFIED BY 'anel123'; # test this (close mysql and open again)
$ Create table json (t json) engine=myisam # for our patch myisam tables are used !
$ insert into json values ('{"key1":"val1", "key2":"val2"}');
#### Debug mysql
```bash
>> gdb
build-mysql/sql$ gdb mysqld
r --no-defaults --basedir=. --datadir=/home/anel/workspace/mysql-datadir --lc_messages_dir=./share --console
b Value::element(size_t pos) -> sql/json_binary.cc:1184
>> client
build-mysql/client$ ./mysql -u root -p (anel123)
mysql> select * from simple_ints_table_json_object;
Milestone 1 for reading the data is finished: https://github.com/MariaDB/server/pull/1211
Alter table <mysql_table_name> FORCE