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. 2024-04-28, 04:00:58

Author Topic: Mysql consuming much ram  (Read 6948 times)

0 Members and 1 Guest are viewing this topic.

Offline usama742

  • Junior Member
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Mysql consuming much ram
« on: 2014-05-15, 10:37:37 »
I install kloxo mr on my vps, my vps ram is 1 gb.
Mysql consuming much ram, it almost consumes 420 mb ram.
How we can set mysql to use less ram ?

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Mysql consuming much ram
« Reply #1 on: 2014-05-15, 11:18:04 »
Run 'sh /script/mysql-convert --engine=myisam'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline usama742

  • Junior Member
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: Mysql consuming much ram
« Reply #2 on: 2014-05-15, 14:03:51 »
i run this script, then i restart mysql and rebooted my vps, but nothing happens.
Still same amount of ram. :(

Offline I<3Kloxo

  • Senior Member
  • *
  • Posts: 205
  • Karma: +0/-0
    • View Profile
Re: Mysql consuming much ram
« Reply #3 on: 2014-05-15, 20:13:13 »
Run 'sh /script/mysql-convert --engine=myisam'.

With this command you what exactly are we doing (what's going on)  ?

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,807
  • Karma: +119/-11
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Mysql consuming much ram
« Reply #4 on: 2014-05-16, 02:50:56 »
Change mysql storage-engine to myisam and add 'skip-innodb' in /etc/my.cnf.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline usama742

  • Junior Member
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: Mysql consuming much ram
« Reply #5 on: 2014-05-17, 18:36:06 »
admin please help me with this, whenever I try to access phpmyadmin, i am getting this "PHP 5.3+ is required"

please tell me how to upgrade to php 5.3 or up version ?

Offline usama742

  • Junior Member
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: Mysql consuming much ram
« Reply #6 on: 2014-05-17, 19:00:47 »
when i checked my component info, php version is
php53u-5.3.28-2.ius.el6.i686

Offline azielazny

  • Junior Member
  • *
  • Posts: 27
  • Karma: +0/-0
    • View Profile
Re: Mysql consuming much ram
« Reply #7 on: 2014-05-18, 21:43:29 »
try:
Code: [Select]
yum remove kloxomr-thirdparty-phpmyadmin
yum install kloxomr-thirdparty-phpmyadmin-4.0.10

Offline usama742

  • Junior Member
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: Mysql consuming much ram
« Reply #8 on: 2014-05-19, 04:41:32 »
Thank you, now its working fine. :)

 


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

Page created in 0.042 seconds with 19 queries.

web stats analysis