Completely unrelated I noticed that after I upgraded from Ubuntu 16.04
(Xenial) to latest 18.04 a lot of things related to OSv works much faster.
Both OSv compilation and runtime. In first case possibly due to newer GCC
7.3 (used to have 5.4) and second case due to newer QEMU/KVM (2.11). For
example most of the unit tests (even Java ones) take under single second
and it used to take 2-4 seconds.
Waldek
On Monday, May 28, 2018 at 2:00:53 AM UTC-4, Waldek Kozaczuk wrote:
>
> This patch change MySQL app build script to set storage type to InnoDB
> instead
> of MyISAM in order to support referential integrity and transactionality.
> New version
> uses more explicit way to setup user record so that in case new columns
> are added to the
> User table the insert still works. Both 'set table_type ..' and 'insert
> into user ..'
> statements were broken and prevented MySQL clients from connecting. Please
> note that
> the correct way to connect is to use ip address instead of localhost host
> name:
>
> mysql -u admin -posv -h 127.0.0.1 mysql
>
> Relately it has been noted that the best performance is achieved when
> using
> fairl new version of QEMU/KVM (>= 2.11).
>
> Fixes cloudius-systems/osv#955
>
> Signed-off-by: Waldemar Kozaczuk <jwkozac...@gmail.com>
> ---
> mysql/GET | 4 ++--
> 1 file changed, 2 insertions(+), 2 deletions(-)
>
> diff --git a/mysql/GET b/mysql/GET
> index 2e3d673..788f86e 100755
> --- a/mysql/GET
> +++ b/mysql/GET
> @@ -31,8 +31,8 @@ cd usr
> ./scripts/mysql_install_db --force --basedir=./ --ldata=data
> cat <<EOF | eval './bin/mysqld --bootstrap --skip-grant-tables
> --basedir=./ --datadir=data --max_allowed_packet=8M
> --net_buffer_length=16K'
> use mysql;
> -set table_type=myisam;
> -insert into user values('%', 'admin', password('osv'),
> 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0);
>
>
> +set default_storage_engine=InnoDB;
> +insert into user(Host, User, Password, Select_priv, Insert_priv,
> Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv,
> Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv,
> Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv,
> Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv,
> Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv,
> Create_user_priv, Event_priv, Trigger_priv, Create_tablespace_priv)
> values('%', 'admin', password('osv'),
> 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
>
>
> EOF
>
> cd $BUILDDIR/sql
> --
> 2.17.0
>
>
--
You received this message because you are subscribed to the Google Groups "OSv
Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to osv-dev+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
