Ayuda!! error en base de datos (SOLUCIONADO)

[vanshyr]

Noooooo! i didnt noticed there was a third page and i was writing similar answer then saw your post!
lol!

Good Job!

PD: (Gaiza) You should learn the ways nuxwin used, for next time you need space, and should resize /home too, because is unused like killburn saied

(08-25-2010 09:02 AM)Nuxwin Wrote:  Ok SOLVED.

The user was using LVM and he had an unused physical volume. It's was easy to solve the problem.

Solution:

1. Extending volume group:

Code:

datacenterdb:~# vgextend datacenterdb /dev/sdb1
  Volume group "datacenterdb" successfully extended

2. Resizing the logical volume (/var):

Code:

datacenterdb:~# lvresize -L +40GB /dev/datacenterdb/var
  Extending logical volume var to 42,79 GB
  Logical volume var successfully resized

Here, I' added 40G. Space still available if necessary in the future.

3. Resizing FS :

Code:

datacenterdb:~# resize2fs -p /dev/datacenterdb/var
resize2fs 1.41.3 (12-Oct-2008)
Filesystem at /dev/datacenterdb/var is mounted on /var; on-line resizing required
old desc_blocks = 1, new_desc_blocks = 3
Performing an on-line resize of /dev/datacenterdb/var to 11217920 (4k) blocks.
El sistema de ficheros en /dev/datacenterdb/var tiene ahora 11217920 bloques.

After that, i've rebooted and now, all work like charm.

Code:

datacenterdb:~# df -kh /var
S.ficheros          Tama�o Usado  Disp Uso% Montado en
/dev/mapper/datacenterdb-var
                       43G  2,7G   38G   7% /var

datacenterdb:~# df
S.ficheros         Bloques de 1K   Usado    Dispon Uso% Montado en
/dev/mapper/datacenterdb-root
                        329233    198792    113443  64% /
tmpfs                   518016         0    518016   0% /lib/init/rw
udev                     10240       776      9464   8% /dev
tmpfs                   518016         0    518016   0% /dev/shm
/dev/sda1               233335     16419    204468   8% /boot
/dev/mapper/datacenterdb-home
                     146303544    358128 138513636   1% /home
/dev/mapper/datacenterdb-tmp
                        376807     10303    347048   3% /tmp
/dev/mapper/datacenterdb-usr
                       4805760   2683864   1877776  59% /usr
/dev/mapper/datacenterdb-var
                      44185488   2735832  39210884   7% /var

Code:

datacenterdb:~# /etc/init.d/mysql restart
Stopping MySQL database server: mysqld
.
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables..
datacenterdb:~#

Code:

datacenterdb:~# ps aux |grep mysqld
root      4724  0.0  0.1   4712  1260 pts/1    S    00:58   0:00 /bin/sh /usr/bin/mysqld_safe
mysql     4761  4.0  2.0 130292 21300 pts/1    Sl   00:58   0:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
root      4762  0.0  0.0   3820   604 pts/1    S    00:58   0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld
root      5629  0.0  0.0   3948   704 pts/1    S+   00:59   0:00 grep mysqld