• 16-01-2015, 19:59:03
    #1
    Merhaba

    Digitalocean dan aldığım bir vps e deneme amaçlı Vesta CP kurdum.Panel çok güzel ancak vps i reboot ettiğimde mysql başlayamıyor.
    /var/log/mysql/error.log dosyasına sürekli olarak şu hatayı yazıyor.Log dosyası şişiyor
    Alıntı
    InnoDB: Check that you do not already have another mysqld process
    InnoDB: using the same InnoDB data or log files.
    InnoDB: Unable to lock ./ibdata1, error: 11
    Ancak reboot tan sonra manuel olarak sudo service mysql restart ettiğimde mysql açılıyor.Fakat log dosyası yine aynı şekilde doluyor.

    reboot sonrası mysql log dosysı
    150116 12:56:46 [Note] /usr/sbin/mysqld: Normal shutdown
    
    150116 12:56:46 [Note] Event Scheduler: Purging the queue. 0 events
    150116 12:56:46  InnoDB: Starting shutdown...
    150116 12:56:47  InnoDB: Shutdown completed; log sequence number 1677515
    150116 12:56:47 [Note] /usr/sbin/mysqld: Shutdown complete
    
    150116 12:57:04 [Note] Plugin 'FEDERATED' is disabled.
    150116 12:57:04 InnoDB: The InnoDB memory heap is disabled
    150116 12:57:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    150116 12:57:04 InnoDB: Compressed tables use zlib 1.2.8
    150116 12:57:04 InnoDB: Using Linux native AIO
    150116 12:57:04 InnoDB: Initializing buffer pool, size = 128.0M
    150116 12:57:04 InnoDB: Completed initialization of buffer pool
    150116 12:57:04 InnoDB: highest supported file format is Barracuda.
    150116 12:57:04  InnoDB: Waiting for the background threads to start
    150116 12:57:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    150116 12:57:04 [Note] Plugin 'FEDERATED' is disabled.
    150116 12:57:04 InnoDB: The InnoDB memory heap is disabled
    150116 12:57:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
    150116 12:57:04 InnoDB: Compressed tables use zlib 1.2.8
    150116 12:57:04 InnoDB: Using Linux native AIO
    150116 12:57:04 InnoDB: Initializing buffer pool, size = 128.0M
    150116 12:57:04 InnoDB: Completed initialization of buffer pool
    InnoDB: Unable to lock ./ibdata1, error: 11
    InnoDB: Check that you do not already have another mysqld process
    InnoDB: using the same InnoDB data or log files.
    150116 12:57:04  InnoDB: Retrying to lock the first data file
    150116 12:57:05 InnoDB: 5.5.40 started; log sequence number 1677515
    150116 12:57:05 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
    150116 12:57:05 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
    150116 12:57:05 [Note] Server socket created on IP: '0.0.0.0'.
    150116 12:57:05 [Note] Event Scheduler: Loaded 0 events
    150116 12:57:05 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.5.40-0ubuntu0.14.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
    InnoDB: Unable to lock ./ibdata1, error: 11
    InnoDB: Check that you do not already have another mysqld process
    InnoDB: using the same InnoDB data or log files.
    InnoDB: Unable to lock ./ibdata1, error: 11
    InnoDB: Check that you do not already have another mysqld process
    InnoDB: using the same InnoDB data or log files.
    InnoDB: Unable to lock ./ibdata1, error: 11
    InnoDB: Check that you do not already have another mysqld process
    InnoDB: using the same InnoDB data or log files.
    InnoDB: Unable to lock ./ibdata1, error: 11
    InnoDB: Check that you do not already have another mysqld process
    InnoDB: using the same InnoDB data or log files.
    InnoDB: Unable to lock ./ibdata1, error: 11
  • 16-01-2015, 20:00:49
    #2
    sunucunuzda hem 32 bit hemde 64 bit mysql kurulu olabilir.

    rpm -qa mysql komutu ile kontrol edebilirsiniz.
  • 16-01-2015, 20:06:00
    #3
    victories adlı üyeden alıntı: mesajı görüntüle
    sunucunuzda hem 32 bit hemde 64 bit mysql kurulu olabilir.

    rpm -qa mysql komutu ile kontrol edebilirsiniz.
    rpm -qa mysql komutu giriyorum ancak birÅŸey gelmiyor.
  • 05-05-2016, 15:10:21
    #4
    Vestacp apache ve mysql cpu %100 kullanimi bizdede var.