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: http://porn-update.com/temp/Schermat...2017-42-19.png 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? |
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 |
can you give some more info's about your hardware?
|
Quote:
Quote:
I asked more info on cpu, they did not answer me, they just say you have 2 cpu |
Quote:
|
He he, I opened that post ... :winkwink:
Where did you find a vps at $ 10 per month? |
Quote:
You can get a VPS for that price but it's unmanaged so you need to know how to manage a server. |
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. |
This is what happens when you try to run porn websites without knowing anything about how to run websites
|
@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. |
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 |
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? |
There is an analyze table in my code, but it is only used once a week in cronjob
http://porn-update.com/temp/Schermat...1 00-51-56.png Mysql certainly consumes a lot of resources, but some tables now have almost 1 million rows |
I have a database table with 4.5 million rows running locally on a 4 core LINUX MySQL
Code:
mysql> select count(*) from xvideos; +----------+ **added Code:
mysql> SHOW CREATE TABLE xvideos; 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. |
All times are GMT -7. The time now is 11:37 PM. |
Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
©2000-, AI Media Network Inc