Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact us.

Post New Thread Reply

Register GFY Rules Calendar Mark Forums Read
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >
Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed.

 
Thread Tools
Old 06-10-2017, 08:53 AM   #1
porn-update
Confirmed User
 
porn-update's Avatar
 
Industry Role:
Join Date: Apr 2014
Posts: 380
Mysql --open-file-limit-100000

Hello to all,
In the last few days, my servers have been limited because they consume too much cpu.
Looking for some problem I found this:


But what is this?

Is a server problem?
Is my problem?
Are 100,000 open files or the weight of a file?
Do I have some queries, somewhere that requires 100,000 rows?
Could this be?
Code:
$db->query("ANALYZE TABLE ".$prefix."photo");
Am I in shit? Can I fix it?

How?
porn-update is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-10-2017, 09:03 AM   #2
magneto664
God Bless You
 
magneto664's Avatar
 
Industry Role:
Join Date: Aug 2014
Location: Glasgow, $cotland
Posts: 1,467
We have 2017 year, I don't understand why people still use fake hosting companies like hawkhost or hostgator where you have a hard memory or open file limit.
get proper hosting - stupid VPS cost 3-4 buks per month
__________________
magneto664 📧 gmail.com
Adult Backlinks 💘Best Website Stats 💘 Best CDN for Adult Content
My Fav: 👍Chaturbate 👍 Stripchat 👍 Dateprofits 👍 AdultFriendFinder
magneto664 is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-10-2017, 09:55 AM   #3
porncrash
Confirmed User
 
porncrash's Avatar
 
Industry Role:
Join Date: Mar 2017
Posts: 59
can you give some more info's about your hardware?
porncrash is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-10-2017, 10:11 AM   #4
porn-update
Confirmed User
 
porn-update's Avatar
 
Industry Role:
Join Date: Apr 2014
Posts: 380
Quote:
Originally Posted by magneto664 View Post
get proper hosting - stupid VPS cost 3-4 buks per month
What and where?

Quote:
can you give some more info's about your hardware?
https://www.hawkhost.com/semi-dedicated-hosting, Nestling

I asked more info on cpu, they did not answer me, they just say you have 2 cpu
porn-update is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-10-2017, 03:28 PM   #5
tomash999
Confirmed User
 
Industry Role:
Join Date: Sep 2015
Posts: 88
Quote:
Originally Posted by porn-update View Post
What and where?


I asked more info on cpu, they did not answer me, they just say you have 2 cpu
Look for the post "Some good servers?" on this forum, there are good answers. I think that people talks about shared hosts here only because they are affiliates, but if you plan any type of adult website you should take at least 1GB VPS (~10$/month on average), nothing will work well below it.
tomash999 is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-11-2017, 08:17 AM   #6
porn-update
Confirmed User
 
porn-update's Avatar
 
Industry Role:
Join Date: Apr 2014
Posts: 380
He he, I opened that post ...

Where did you find a vps at $ 10 per month?
porn-update is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-11-2017, 09:14 AM   #7
Denny
Too lazy to set a custom title
 
Denny's Avatar
 
Industry Role:
Join Date: Feb 2005
Posts: 17,042
Quote:
Originally Posted by porn-update View Post
He he, I opened that post ...

Where did you find a vps at $ 10 per month?
Some people assume everyone is a server admin so they automatically suggest unmanaged hosting plans.

You can get a VPS for that price but it's unmanaged so you need to know how to manage a server.
__________________
Denny is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-11-2017, 03:43 PM   #8
porn-update
Confirmed User
 
porn-update's Avatar
 
Industry Role:
Join Date: Apr 2014
Posts: 380
What do you mean to admin a server?

Some time ago I tried with digitalocean, centos and CWP (centos web panel), but honestly I did a lot of effort to get more or less the same results as a hosting or a shared server.
porn-update is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-12-2017, 05:24 PM   #9
wankawonk
Confirmed User
 
Industry Role:
Join Date: Aug 2015
Posts: 999
This is what happens when you try to run porn websites without knowing anything about how to run websites
wankawonk is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-12-2017, 06:03 PM   #10
tomash999
Confirmed User
 
Industry Role:
Join Date: Sep 2015
Posts: 88
@porn-update yes, @denny is correct, I assumed that you know how to setup a server.

Managed services will cost 25$+/month, and many companies that offers VPS, have a managed service too, except those with the lower pricing.

If this is for any kind of website with membership, you should not choose a shared host, but a managed one.
tomash999 is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-13-2017, 10:47 PM   #11
bigalownz
Confirmed User
 
bigalownz's Avatar
 
Industry Role:
Join Date: Aug 2005
Location: NEW ZEALAND
Posts: 1,651
Quote:
Originally Posted by porn-update View Post
What and where?



https://www.hawkhost.com/semi-dedicated-hosting, Nestling

I asked more info on cpu, they did not answer me, they just say you have 2 cpu
see me sig for a vps

price start as low as $2.50 a month

i changes from a shared / semi dedicated hosting to a vps and never looked back
__________________
$100 free credit for all hosting needs
bigalownz is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-20-2017, 09:07 AM   #12
Barry-xlovecam
It's 42
 
Industry Role:
Join Date: Jun 2010
Location: Global
Posts: 18,083
https://stackoverflow.com/questions/...-analyze-table

https://dev.mysql.com/doc/refman/5.7...yze-table.html

You are perhaps locking the tables and using up your memory allocation. That is from a script you wrote?
Barry-xlovecam is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-20-2017, 03:55 PM   #13
porn-update
Confirmed User
 
porn-update's Avatar
 
Industry Role:
Join Date: Apr 2014
Posts: 380
There is an analyze table in my code, but it is only used once a week in cronjob


Mysql certainly consumes a lot of resources, but some tables now have almost 1 million rows
porn-update is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 06-21-2017, 10:17 AM   #14
Barry-xlovecam
It's 42
 
Industry Role:
Join Date: Jun 2010
Location: Global
Posts: 18,083
I have a database table with 4.5 million rows running locally on a 4 core LINUX MySQL
Code:
mysql> select count(*) from xvideos;                                            +----------+
| count(*) |
+----------+
|  4543335 |
+----------+

1 row in set (0.00 sec)

mysql> ANALYZE TABLE xvideos;
+-------------+---------+----------+----------+
| Table       | Op      | Msg_type | Msg_text |
+-------------+---------+----------+----------+
| seo.xvideos | analyze | status   | OK       |
+-------------+---------+----------+----------+
1 row in set (0.01 sec)
I am using a terminal not an interpreter code. Who wrote the code? I think the code may be the issue?

**added

Code:
mysql> SHOW CREATE TABLE xvideos;
.....
  KEY `category` (`category`(10)),
  FULLTEXT KEY `idx_1` (`category`),
  FULLTEXT KEY `idx_2` (`tags`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 

1 row in set (0.00 sec)
See whats there ... and what you are indexing.

Your alternatives are to fix whatever the issues are or to just buy more CPU time. In other words bad code can be remedied with more hardware -- not really recommended but... If that ANALYZE locks the tables too long your users will get no return from the db. So, if it's fast and dirty, just pay for the spike in CPU and move on.
Barry-xlovecam is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Post New Thread Reply
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >

Bookmarks

Tags
100, 000, file, files, queries, weight, requires, shit, fix, .$prefix.photo;, table, server, rows, $db-queryanalyze, 2017-06-10, servers, days, limited, open-file-limit-100000, consume, del, mysql, 17-42-19.png, found, cpu
Thread Tools



Advertising inquiries - marketing at gfy dot com

Contact Admin - Advertise - GFY Rules - Top

©2000-, AI Media Network Inc



Powered by vBulletin
Copyright © 2000- Jelsoft Enterprises Limited.