Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2017-11-08, 02:08:31

Author Topic: Problem with mysql  (Read 1893 times)

0 Members and 1 Guest are viewing this topic.

Offline azielazny

  • Junior Member
  • *
  • Posts: 27
  • Karma: +0/-0
    • View Profile
Problem with mysql
« on: 2014-05-18, 22:02:49 »
I have problem with mysql. After updating mysql running a few minutes and  turns off. Then I can't restart mysql. I have big problem with memory in kloxo too.
I tried to change the settings in the system (php and myisam).

This is my sysinfo:

Code: [Select]
[root@CentOS-65-64-minimal ~]#  /script/restart-all
Stopping mysqld:                                           [  OK  ]
MySQL Daemon failed to start.
Starting mysqld:                                           [FAILED]
Stopping Djbdns for:
  - axfrdns    [  OK  ]
  - tinydns    [  OK  ]
Starting Djbdns for:
  - axfrdns    [  OK  ]
  - tinydns    [  OK  ]
Stopping qmail-toaster: svscan qmail logging.
Starting qmail-toaster: svscan.
Stopping xinetd:                                           [  OK  ]
Starting xinetd:                                           [  OK  ]
Stopping kloxo-phpcgi:                                     [  OK  ]
Starting kloxo-phpcgi:                                     [  OK  ]
Stopping kloxo-hiawatha:                                   [  OK  ]
Starting kloxo-hiawatha:                                   [  OK  ]
Stopping php-fpm:                                          [  OK  ]
Starting php-fpm:                                          [  OK  ]
[root@CentOS-65-64-minimal ~]#  /script/sysinfo

A. Kloxo-MR: 6.5.0.f-2014051002

B. OS: CentOS release 6.5 (Final) x86_64

C. Apps:
   1. MySQL: mysql55-5.5.37-1.ius.el6.x86_64
   2. PHP: php53u-5.3.28-3.ius.el6.x86_64
   3. Httpd: httpd-2.2.27-1.el6.x86_64
   4. Lighttpd: --uninstalled--
   5. Nginx: nginx-1.7.0-1.el6.x86_64
   6. Qmail: qmail-toaster-1.03-1.3.38.mr.el6.x86_64
      - with: courier-imap-toaster-4.1.2-1.3.16.mr.el6.x86_64
   7. Dns: djbdns-1.05-17.3.mr.el6.x86_64

D. Php-type (for Httpd/proxy):

E. Memory:
                total       used       free     shared    buffers     cached
   Mem:           490        436         53          0          1         23
   -/+ buffers/cache:        411         78
   Swap:            0          0          0

I now have an additional problem beyond mysql. When I try change the Webserver then I see Alert: remove_nginx_failed [parent]
« Last Edit: 2014-05-19, 00:47:58 by azielazny »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Problem with mysql
« Reply #1 on: 2014-05-19, 03:47:07 »
Go to 'switch programs' and then change web to 'lighttpd' and then change back to 'nginx-proxy'.

Also go to 'webserver config' and then change php-type to 'mod_php_ruid2' and then change back to 'php-fpm_event'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline azielazny

  • Junior Member
  • *
  • Posts: 27
  • Karma: +0/-0
    • View Profile
Re: Problem with mysql
« Reply #2 on: 2014-05-19, 09:52:26 »
I can't switch server to lighttpd,because I still see alert: remove_nginx_failed [parent], when I try change web. Change php-type does not help to me.

Maybe I should change the web server via ssh. What is the command to change this on the ssh?


Mysql work only after reboot. /script/restart-all give me mysql failed
« Last Edit: 2014-05-19, 12:03:55 by azielazny »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Problem with mysql
« Reply #3 on: 2014-05-19, 12:22:09 »
Inform here 'sh /script/sysinfo; yum list installed php* httpd* nginx* hiawatha* lighttpd*'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline azielazny

  • Junior Member
  • *
  • Posts: 27
  • Karma: +0/-0
    • View Profile
Re: Problem with mysql
« Reply #4 on: 2014-05-19, 14:30:33 »
sh /script/sysinfo; yum list installed php* httpd* nginx* hiawatha* lighttpd*

A. Kloxo-MR: 6.5.0.f-2014051002

B. OS: CentOS release 6.5 (Final) x86_64

C. Apps:
   1. MySQL: mysql55-5.5.37-1.ius.el6.x86_64
   2. PHP: php53u-5.3.28-3.ius.el6.x86_64
   3. Httpd: httpd-2.2.27-1.el6.x86_64
   4. Lighttpd: --uninstalled--
   5. Nginx: nginx-1.7.0-1.el6.x86_64
   6. Qmail: qmail-toaster-1.03-1.3.38.mr.el6.x86_64
      - with: courier-imap-toaster-4.1.2-1.3.16.mr.el6.x86_64
   7. Dns: bind-9.9.5-1.el6.x86_64

D. Php-type (for Httpd/proxy): php-fpm_worker

E. Memory:
                total       used       free     shared    buffers     cached
   Mem:           490        485          4          0          1         48
   -/+ buffers/cache:        435         54
   Swap:            0          0          0

Loaded plugins: fastestmirror, priorities, protectbase, replace
Loading mirror speeds from cached hostfile
 * base: mirror.checkdomain.de
 * extras: mirror.checkdomain.de
 * mratwork-epel: mirrors.n-ix.net
 * mratwork-ius-stable: mirrors.ircam.fr
 * updates: mirror.checkdomain.de
0 packages excluded due to repository protections
Installed Packages
hiawatha.x86_64              9.5-2.mr.el6         @mratwork-release-version-arch
httpd.x86_64                 2.2.27-1.el6         @mratwork-centalt
httpd-tools.x86_64           2.2.27-1.el6         @mratwork-centalt
nginx.x86_64                 1.7.0-1.el6          @mratwork-centalt
php52s.x86_64                5.2.17-12.mr.el5     @mratwork-release-version-arch
php53u.x86_64                5.3.28-3.ius.el6     @mratwork-ius-stable
php53u-bcmath.x86_64         5.3.28-3.ius.el6     @mratwork-ius-stable
php53u-cli.x86_64            5.3.28-3.ius.el6     @mratwork-ius-stable
php53u-common.x86_64         5.3.28-3.ius.el6     @mratwork-ius-stable
php53u-fpm.x86_64            5.3.28-3.ius.el6     @mratwork-ius-stable
php53u-gd.x86_64             5.3.28-3.ius.el6     @mratwork-ius-stable
php53u-mbstring.x86_64       5.3.28-3.ius.el6     @mratwork-ius-stable
php53u-mcrypt.x86_64         5.3.28-3.ius.el6     @mratwork-ius-stable
php53u-mysql.x86_64          5.3.28-3.ius.el6     @mratwork-ius-stable
php53u-pdo.x86_64            5.3.28-3.ius.el6     @mratwork-ius-stable
php53u-pear.noarch           1:1.9.4-3.ius.el6    @mratwork-ius-archive
php53u-pecl-geoip.x86_64     1.0.8-1.ius.el6      @mratwork-ius-stable
php53u-pecl-imagick.x86_64   3.1.2-1.ius.el6      @mratwork-ius-stable
php53u-pgsql.x86_64          5.3.28-3.ius.el6     @mratwork-ius-stable
php53u-xml.x86_64            5.3.28-3.ius.el6     @mratwork-ius-stable

 


Top 4 Global Search Engines:    Google    Bing    Baidu    Yahoo
Click Here

Page created in 0.039 seconds with 17 queries.

web stats analysis
 
Mirror created by MasterkinG32.CoM