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. |
|
Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
Thread Tools |
06-10-2017, 08:53 AM | #1 |
Confirmed User
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"); How? |
06-10-2017, 09:03 AM | #2 |
God Bless You
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 |
06-10-2017, 09:55 AM | #3 |
Confirmed User
Industry Role:
Join Date: Mar 2017
Posts: 59
|
can you give some more info's about your hardware?
__________________
>> Porn Reviews - PornCrash.com <<
xdooz.com - Quality Porn Site Skype: PornCrash Contact: Use this Form |
06-10-2017, 10:11 AM | #4 | |
Confirmed User
Industry Role:
Join Date: Apr 2014
Posts: 380
|
What and where?
Quote:
I asked more info on cpu, they did not answer me, they just say you have 2 cpu |
|
06-10-2017, 03:28 PM | #5 |
Confirmed User
Industry Role:
Join Date: Sep 2015
Posts: 88
|
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.
|
06-11-2017, 08:17 AM | #6 |
Confirmed User
Industry Role:
Join Date: Apr 2014
Posts: 380
|
He he, I opened that post ...
Where did you find a vps at $ 10 per month? |
06-11-2017, 09:14 AM | #7 | |
Too lazy to set a custom title
Industry Role:
Join Date: Feb 2005
Posts: 17,065
|
Quote:
You can get a VPS for that price but it's unmanaged so you need to know how to manage a server. |
|
06-11-2017, 03:43 PM | #8 |
Confirmed User
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. |
06-12-2017, 05:24 PM | #9 |
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
|
06-12-2017, 06:03 PM | #10 |
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. |
06-13-2017, 10:47 PM | #11 | |
Confirmed User
Industry Role:
Join Date: Aug 2005
Location: NEW ZEALAND
Posts: 1,653
|
Quote:
price start as low as $2.50 a month i changes from a shared / semi dedicated hosting to a vps and never looked back |
|
06-20-2017, 09:07 AM | #12 |
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? |
06-20-2017, 03:55 PM | #13 |
Confirmed User
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 |
06-21-2017, 10:17 AM | #14 |
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) **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) 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. |