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-07, 18:49:48

Author Topic: Limit database size to 1 GB  (Read 1272 times)

0 Members and 1 Guest are viewing this topic.

Offline Spacedust

  • Super Grand Master
  • ****
  • Posts: 3,944
  • Karma: +1/-0
    • View Profile
Limit database size to 1 GB
« on: 2014-04-17, 16:22:46 »
Is this possible ? Customers started abusing our databases with big data at about 2 GB size.

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Limit database size to 1 GB
« Reply #1 on: 2014-04-17, 16:31:54 »
No mechanism limiting database size in mysql itself.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline Spacedust

  • Super Grand Master
  • ****
  • Posts: 3,944
  • Karma: +1/-0
    • View Profile
Re: Limit database size to 1 GB
« Reply #2 on: 2014-04-17, 22:51:13 »
No mechanism limiting database size in mysql itself.

Other companies are having something. I think they use quota + mount to limit each database to 1 GB.

How it's made inside cPanel ?

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Limit database size to 1 GB
« Reply #3 on: 2014-04-18, 02:38:48 »
Use special kernel with quota or a trick with mount to virtual directory.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Limit database size to 1 GB
« Reply #4 on: 2014-04-18, 02:51:33 »
Another option is using ulimit for certain user/group (read http://www.cyberciti.biz/faq/file-size-limit-exceeded-error-under-linux-and-solution/).

Sadly, it's not possible implementing for mysql because database directory always owned by mysql (permission 0700).
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

 


Top 10 Social Networking:    Facebook    Twitter    LinkedIn    Pinterest    Google Plus    Tumblr    Instagram    VK    Flickr    Vine
Click Here

Page created in 0.035 seconds with 16 queries.

web stats analysis
 
Mirror created by MasterkinG32.CoM