Comment 43 for bug 105457

Revision history for this message
Brett Campbell (invsblduck) wrote :

Hello all,

I've experienced this problem today.
I'm feeling lazy, so I'll let you observe:

thor:/var/log$ uname -a
Linux thor 2.6.24-23-generic #1 SMP Mon Jan 26 00:13:11 UTC 2009 i686 GNU/Linux

thor:~$ cat /etc/issue
Ubuntu 8.04.2 \n \l

thor:~$ sudo apt-get install mysql-server mysql-client
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
  libdbd-mysql-perl libdbi-perl libnet-daemon-perl libplrpc-perl
  mysql-client-5.0 mysql-server-5.0
Suggested packages:
  dbishell mysql-doc-5.0 tinyca
Recommended packages:
  libhtml-template-perl mailx
The following NEW packages will be installed:
  libdbd-mysql-perl libdbi-perl libnet-daemon-perl libplrpc-perl mysql-client
  mysql-client-5.0 mysql-server mysql-server-5.0
0 upgraded, 8 newly installed, 0 to remove and 0 not upgraded.
Need to get 36.3MB of archives.
After this operation, 108MB of additional disk space will be used.
Do you want to continue [Y/n]?
Get:1 http://us.archive.ubuntu.com hardy/main libnet-daemon-perl 0.38-1.1 [45.9kB]
Get:2 http://us.archive.ubuntu.com hardy/main libplrpc-perl 0.2017-1.1 [35.0kB]
Get:3 http://us.archive.ubuntu.com hardy/main libdbi-perl 1.601-1 [771kB]
Get:4 http://us.archive.ubuntu.com hardy/main libdbd-mysql-perl 4.005-1 [134kB]
Get:5 http://us.archive.ubuntu.com hardy-updates/main mysql-client-5.0 5.0.51a-3ubuntu5.4 [7826kB]
Get:6 http://us.archive.ubuntu.com hardy-updates/main mysql-server-5.0 5.0.51a-3ubuntu5.4 [27.4MB]
Get:7 http://us.archive.ubuntu.com hardy-updates/main mysql-client 5.0.51a-3ubuntu5.4 [52.1kB]
Get:8 http://us.archive.ubuntu.com hardy-updates/main mysql-server 5.0.51a-3ubuntu5.4 [54.2kB]
Fetched 36.3MB in 1min2s (586kB/s)
Preconfiguring packages ...
Selecting previously deselected package libnet-daemon-perl.
(Reading database ... 147205 files and directories currently installed.)
Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.38-1.1_all.deb) ...
Selecting previously deselected package libplrpc-perl.
Unpacking libplrpc-perl (from .../libplrpc-perl_0.2017-1.1_all.deb) ...
Selecting previously deselected package libdbi-perl.
Unpacking libdbi-perl (from .../libdbi-perl_1.601-1_i386.deb) ...
Selecting previously deselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.005-1_i386.deb) ...
Selecting previously deselected package mysql-client-5.0.
Unpacking mysql-client-5.0 (from .../mysql-client-5.0_5.0.51a-3ubuntu5.4_i386.deb) ...
Selecting previously deselected package mysql-server-5.0.
Unpacking mysql-server-5.0 (from .../mysql-server-5.0_5.0.51a-3ubuntu5.4_i386.deb) ...
Selecting previously deselected package mysql-client.
Unpacking mysql-client (from .../mysql-client_5.0.51a-3ubuntu5.4_all.deb) ...
Selecting previously deselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.0.51a-3ubuntu5.4_all.deb) ...
Setting up libnet-daemon-perl (0.38-1.1) ...
Setting up libplrpc-perl (0.2017-1.1) ...
Setting up libdbi-perl (1.601-1) ...
Setting up libdbd-mysql-perl (4.005-1) ...
Setting up mysql-client-5.0 (5.0.51a-3ubuntu5.4) ...
Setting up mysql-server-5.0 (5.0.51a-3ubuntu5.4) ...
 * Stopping MySQL database server mysqld
   ...done.
Reloading AppArmor profiles : done.
 * Starting MySQL database server mysqld
   ...done.
 * Checking for corrupt, not cleanly closed and upgrade needing tables.

Setting up mysql-client (5.0.51a-3ubuntu5.4) ...
Setting up mysql-server (5.0.51a-3ubuntu5.4) ...

thor:~$ mysql -p -u root
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.0.51a-3ubuntu5.4 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database amarok;
Query OK, 1 row affected (0.00 sec)

mysql> use amarok;
Database changed
mysql> grant all on amarok.* to amarok@localhost identified by 'xxxxxxxx';
Query OK, 0 rows affected (0.00 sec)

mysql> exit;
Bye

thor:~$ top

top - 18:36:57 up 54 min, 1 user, load average: 1.07, 0.88, 0.51
Tasks: 136 total, 3 running, 133 sleeping, 0 stopped, 0 zombie
Cpu0 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 26.0%us, 74.0%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 3622324k total, 1330412k used, 2291912k free, 34860k buffers
Swap: 9004392k total, 0k used, 9004392k free, 830804k cached

  PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
 9661 root 20 0 1772 528 440 S 99 0.0 7:12.71 mysqld_safe

thor:~$ iostat -x 1
Linux 2.6.24-23-generic (thor) 04/01/2009

avg-cpu: %user %nice %system %iowait %steal %idle
          14.50 0.00 36.00 0.00 0.00 49.50

Device: rrqm/s wrqm/s r/s w/s rsec/s wsec/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
sdb 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

thor:/var/log$ ls -l /var/log/mysql*
-rw-r----- 1 mysql adm 0 2009-04-01 18:25 /var/log/mysql.err
-rw-r----- 1 mysql adm 0 2009-04-01 18:25 /var/log/mysql.log

/var/log/mysql:
total 0

                Thanks,
                Brett