NetBSD 絹の日記

examplehp@makoto 14:48:19/190217(/export/backup)% sudo pkgin install mysql-server
reading local summary...
processing local summary...
pkg_summary.bz2                                                                                                                                     100% 3106KB 194.1KB/s   00:16    
calculating dependencies...done.

5 packages to refresh:
  icu-63.1nb1 perl-5.28.1 mysql-client-5.7.24nb2 lz4-1.8.3 editline-3.1.20150325

1 package to upgrade:
  boost-libs-1.69.0

1 package to install:
  mysql-server-5.7.24nb1

5 to refresh, 1 to upgrade, 1 to install
73M to download, 433M to install

proceed ? [Y/n] y
icu-63.1nb1.tgz                                                                                                                                     100%   16MB   2.0MB/s   00:08    
perl-5.28.1.tgz                                                                                                                                     100%   11MB   2.2MB/s   00:05    
mysql-client-5.7.24nb2.tgz                                                                                                                          100% 2171KB   1.1MB/s   00:02    
lz4-1.8.3.tgz                                                                                                                                       100%   97KB  96.8KB/s   00:01    
editline-3.1.20150325.tgz                                                                                                                           100%  123KB 123.1KB/s   00:00    
boost-libs-1.69.0.tgz                                                                                                                               100% 4646KB   1.5MB/s   00:03    
mysql-server-5.7.24nb1.tgz                                                                                                                          100%   40MB   2.3MB/s   00:17    
refreshing icu-63.1nb1...
refreshing perl-5.28.1...
refreshing mysql-client-5.7.24nb2...
refreshing lz4-1.8.3...
refreshing editline-3.1.20150325...
pkg_install warnings: 0, errors: 0
upgrading boost-libs-1.69.0...
pkg_install warnings: 0, errors: 0
installing mysql-server-5.7.24nb1...
===========================================================================
$NetBSD: MESSAGE,v 1.1 2016/09/16 06:49:12 adam Exp $

After the tables are set up and the MySQL server is running,
please remember to set a password for the MySQL root user!
This is done by running both:

  /usr/pkg/bin/mysqladmin -u root -p password 'new-password'
  /usr/pkg/bin/mysqladmin -h `hostname` -u root -p password 'new-password'

The "Enter password:" prompt is asking for the existing password.
As there is no existing password, just press the Return key.

There is a script distributed with MySQL that can help you lock down
an installation.  This script has been installed to

  /usr/pkg/bin/mysql_secure_installation.

Please see the manual and the MySQL web site for more instructions.

===========================================================================
pkg_install warnings: 0, errors: 0
reading local summary...
processing local summary...
marking mysql-server-5.7.24nb1 as non auto-removable
exampleh@makoto 14:50:45/190217(/export/backup)%

＠ log:

cat /var/log/mysqld.log

＠ pkg_info -D mysql-server:

examplehp@makoto 15:03:41/190217(/export/backup)% pkg_info -D mysql-server

Information for mysql-server-5.7.24nb1:

Install notice:
===========================================================================
$NetBSD: MESSAGE,v 1.1 2016/09/16 06:49:12 adam Exp $

After the tables are set up and the MySQL server is running,
please remember to set a password for the MySQL root user!
This is done by running both:

  /usr/pkg/bin/mysqladmin -u root -p password 'new-password'
  /usr/pkg/bin/mysqladmin -h `hostname` -u root -p password 'new-password'

The "Enter password:" prompt is asking for the existing password.
As there is no existing password, just press the Return key.

There is a script distributed with MySQL that can help you lock down
an installation.  This script has been installed to

  /usr/pkg/bin/mysql_secure_installation.

Please see the manual and the MySQL web site for more instructions.

===========================================================================

examplehp@makoto 15:51:39/190217(/export/backup)% history

   43  sudo vi /usr/pkg/etc/my.cnf
   44  sudo mysqld -u root -p
   45  sudo vi /usr/pkg/etc/my.cnf
   46  sudo mysqld -u root -p
   47  mkdir /tmp/mysql
   48  sudo chown mysql /tmp/mysql/
   49  sudo mysqld -u root -p
   50  sudo mkdir /var/mysql/tmp
   51  sudo chown mysql  /var/mysql/tmp
   52  sudo mysqld -u root -p
   53  ls -l /var/mysql/iblog/
   54  mkdir /var/mysql/iblog
   55  sudo mkdir /var/mysql/iblog
   56  sudo chown mysql /var/mysql/iblog
   57  sudo mysqld -u root -p
   58  sudo mysqld -u root

```
sudo mysqld -u root
```
と入力すると起動する
/usr/pkg/etc/my.cnf の次の行を有効にする (## の文字を消す)
```
## skip-grant-tables
```
```
sudo mysqld -u root
```
で起動する

次のように入力する

mysql -u root
use mysql;


UPDATE user SET authentication_string=password('  ') WHERE user='root';

flush privileges;

quit

項目の一時変更を元に戻す

1194769      4 -rw-r-----    1 root              mysql                   303 Feb 17 16:07 /var/mysql/ib_buffer_pool
1218011  98400 -rw-r-----    1 root              mysql              50331648 Feb 17 15:50 /var/mysql/iblog/ib_logfile1
examplehp$ sudo chown mysql /var/mysql/ib_buffer_pool
examplehp$ sudo chown mysql /var/mysql/iblog/ib_logfile1

examplehp$ sudo /etc/rc.d/mysqld start
Starting mysqld.
examplehp$ ps ax|grep mysql
 7371 ?     Ss     0:00.08 sh -c logger -t nbmysqld_safe 
10188 ?     S      0:00.00 logger -t nbmysqld_safe 
20232 ?     Ss     0:00.08 /bin/sh /usr/pkg/bin/mysqld_safe --user=mysql --datadir=/var/mysql --pid-file=/var/mysql/.pid 
22494 ?     Sl     0:00.54 /usr/pkg/sbin/mysqld --basedir=/usr/pkg --datadir=/var/mysql --plugin-dir=/usr/pkg/lib/mysql/plugin --
10865 pts/1 O+     0:00.00 grep mysql

time sh -c 'echo "scale=2000; 4*a(1)" | bc -l' > /dev/null
time sh -c 'echo "scale=2000;   e(1)" | bc -l' > /dev/null


							π		e
MaKe	MB/Model	CPU		clock	OS	Release	system	user	system	user
Dell	Precision 3660	Intel	i9-13900K	5.8 GHz	Ubuntu	22.04.1	0.909	0.890	1.70	1.70
(bea)			E3-1270 v6	3.80 GHz	CentOS		0.009	1.393	0.004	2.457
ASRock	H97	Intel	i7-4790K	4.00 GHz	NetBSD	8.99.25	1.41	1.465	2.85	2.851
(usr)		Intel	Xeon Silver 4208	2.1 GHz			0.007	1.831	0.004	3.299
Apple	Mini Late 2014	Intel		3.00 GHz	MacOSX	10.12	1.90	1.87	1.46	1.45
Apple	Mini Late 2014	Intel			MacOSX		2.05	2.03	1.68	1.68
Gigabyte	H81M-DS2	Intel	i3-4160	3.60 GHz	NetBSD	9.0	1.55	1.56	3.37	3.375
Gigabyte	H81M-DS2	Intel	i3-4160	3.60 GHz	NetBSD	7.99.9	1.65	1.690	3.47	3.466
Panasonic	CF-SX3	Intel	i5-4300U	1.90 GHz	NetBSD	8.99.33	2.38	2.39	4.62	4.623
Panasonic	CF-SX2	Intel	i5-3340M	2.70 GHz	NetBSD	8.99.33	2.52	2.51	4.54	4.544
Panasonic	CF-J10	Intel	i5 M 480	1.20 GHz	NetBSD	8.99.30	2.75	2.751	4.80	4.878
Panasonic	CF-J10	Intel	i5 M 480	2.67 GHz	NetBSD	8.99.30	2.75	2.768	4.82	4.865
HP	xw4600	Intel	Core2 Duo CPU E8400	3.00 GHz	NetBSD	9.0_RC1	3.34	2.52	4.48	4.48
Donki	NANOTE-P8	Intel	N4200	1.10 GHz	NetBSD	9.99.92	0.00	3.36	0.00	4.95
HP	MicroServer	AMD	Turion(tm) II Neo N54L	2.20 GHz	NetBSD	8.99.33	4.52	4.54	6.34	6.338
ASRock	n3150-ITX	Intel	n3150	2.70 GHz	NetBSD	9.0_RC1	4.84	4.84	7.22	7.21
Panasonic	CF-SX2	Intel	i5-3340M	1.20 GHz	NetBSD	8.99.33	5.61	5.622	10.21	10.236
Rasberry PI	Model 2B 1.1	BroadCom	BCM 2836	900 MHz	NetBSD	10.0_BETA	0.03	18.09	0.03	16.06

2019年02月16日(土) 旧暦 [n年日記] [更新:"2004/08/09 23:43:33"]

#1 sudo pkgin install mysql-server

＠ log:

＠ pkg_info -D mysql-server:

2019年02月03日(日) 旧暦 [n年日記] [更新:"2023/09/28 00:57:26"]

#1 [bc-bench]