I have a site which has 67000 visitors per day, and around 200 requests in second. On index page I have around 17querys. Site is hosted at some provaider...
Now I have a problem because site is opening very slouly. Yesterday I put mysql on difrent server then apache, and it was working OK since this morning. I have optimize my pages written in PHP for best performans and put out anything that I could. Mysql is set to take 3000 requests in second.
I'm developing a web application with a php framework.
Our client asked us to give him frequent updates. This means we should do ftp uploads and mysql updates in the domain, so client can see the progress of the web app.
Is there a better way to do this? Maybe a svn hosting that can provide mySQL, domain, etc. and host the fully function app, and allow at same time commits & updates from our developers' PCs, so we can keep the app always updated online
I take care of a site that is hosted on a godaddy shared server. The site is built around a highly customized version of oscommerce and is almost completely dynamic. I'd say just about every page includes calls to php and/or mysql. The site gets as many as 100 visitors at a time but averages 25-50. The site is getting slower and slower on average.
At times it is good but sometimes pages take forever to load.
Keep in mind that I have never liked godaddy hosting and would not use them myself.
However, this particular customer seems determined to stay with godaddy and is, typically, willing to eat up all their lies and excuses for bad performance.
Lately they are saying that "optimizing" the database would solve all performance issues.
I've written plenty of php for mysql on many servers and this godaddy server is, by far, the worst from a performance angle. So I just don't see how any database maintenance of any kind could possibly make the site fast.
My advice is don't hinge a good and successful business on $50 a year shared hosting.
Much less godaddy hosting. So I suggested to just try another shared server somewhere else before moving to a dedicated server or vps. But by no means should they consider staying with godaddy.
Am I right or wrong? I feel like I've been lied to by godaddy enough to not believe a single word from the mouth of any level 1 support rep.
To me godaddy is a hosting company with enough credibility to get away with lying.
We've got 7 dedicated boxes now providing PHP/MySQL hosting for around 200 clients. I've started to think about the future and how we can get better performance and manageability.
Our dedicated boxes are generally:
AMD Athlon 3800
2 to 4GB
80GB SATA in a RAID mirror
We currently run a mix of PHP4 and PHP5 with MySQL 4 / MySQL 5 on Apache2. We don't run email from these boxes, we don't run DNS. We have some clients with SSL WEB-DAV access via a second instance of Apache. They're all physically in the same rack.
Whilst this all works great (touch wood) and we don't have complaints about performance, I wonder if replicating our setup every 30 or so clients makes sense from a management point of view.
Has anyone ever looked at speccing two MySQL boxes in a master slave config, then running all their clients (x number of web servers) through essentially one box. Management of backups and patches would be a lot easier, as would the security management. I just wonder if I'd also be increasing my risk of failure.
I keep getting this error :
MySQL Error : MySQL server has gone away
How do I fix it?
my.cnf contents
Quote:
[mysqld]
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 800
key_buffer = 48M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 3000
thread_cache_size = 128
wait_timeout = 90
connect_timeout = 30
tmp_table_size = 128M
max_heap_table_size = 64M
max_allowed_packet = 256M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 4
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 48M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
max_user_connections = 500
[mysqld_safe]
nice = -5
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
Hey all. I have some legacy web applications that requires MySQL 4.X to function. Too much pain to upgrade. Can any of you recommend a VPS linux hosting provider that you can vouch for, who also support MySQL 4?
I am currently using MediaTemple GS which has MySQL 4 support; however, recent problems have made me want to consider other options. Unfortuantely, MediaTemple DV (thier VPS option) does not have MySQL 4 as an option.
Many thanks.
Harrison
I have some legacy web applications that requires MySQL 4.X to function. Too much pain to upgrade. Can any of you recommend a VPS linux hosting provider that you can vouch for, who also support MySQL 4?
I am currently using MediaTemple GS which has MySQL 4 support; however, recent problems have made me want to consider other options. Unfortuantely, MediaTemple DV (thier VPS option) does not have MySQL 4 as an option.
I'm running a VPS at TekTonic.net and so far I have only one problem. I love TekTonic's services in general, but for some crazy reason, I can't get my MySQL server to work.
I've asked MySQL's support staff, and they haven't found an answer to date. I can do just about anything on my MySQL server EXCEPT add/remove a database, which creates a problem. A BIG problem.
what I'm looking for now is a remote MySQL host that will accept connections from my TekTonic-hosted VPS.
Does somebody knows free hosting with PHP, MySQL support? And without banners on the page
View 2 Replies View RelatedDoes anyone know of any shared hosting plans that don't have any MySQL limitations? Aplus.net and Powweb are trying to shut down my accounts because of this problem, and I can't afford dedicated hosting quite yet.
View 12 Replies View RelatedI have subscribed an account in Powweb but since the Powweb does not allow MySQL remote access I need to find another hosting that allow MySQL remote access.
Wich hosting with MySQL remote access do you know?
Does anyone have an opinion on the performance of XO's shared web hosting solution when you're using their built-in MySQL capability with PHP coding?
View 0 Replies View Relatedif there are any recommendations on managed database hosting services. This will be used for a fairly large project running on Mysql DB. Due to the size and complexity of the database a lot of resources are being used, so I prefer to find a company which specializes in dB hosting.
View 8 Replies View RelatedI have a website that runs off a mysql database.
The first month it hit in excess of 400 threads.
Would anyone know whats the cheapest alternative to run a a site this size. Would a VPS account handle it?
MySQL 5.0 supports stored procedures -- but is it safe to allow shared hosting customers to have privileges to create them? If the procedures are global, does that mean that:
a) one customer could write a procedure which accessed another customer's data?
b) any customer could call a procedure created by a different customer?
c) any customer could override an existing mysql function in a way that would affect other customers?
d) any customer could write a function that bound to a system library and crash the entire server instance?
I'm working with a non-profit and we're looking for an inexpensive hosting but we also need to be able to access MYSQL (port 3306) through the internet.
We use Crystal Reports and need to get to the database directly for reports.
I'd like to have the ability to offer hosting in two geographical and network diverse locations for both Apache and MySQL. Two entirely different instances, with different everything. ie: high avail to the max. Obviously the MySQL part is harder due to the dynamic nature.
I can appreciate the technical aspects of the question - such as data needing to replicate to 2 locations, dealing with static versus dynamic data, etc. In short, there's a few ways this could be done.
I've not been able to find a guide in my Google searches, but I'm sure this is something that has been setup before.
If you're someone with experience in having had set this up, perhaps it would be easiest if we just speak directly and work something out, either via payment or giving you a dedicated server on my network. My AIM name is IGSOBEHELPER.
Please note that I am hoping to start a technical discussion about this, hence I am not posting the message in the employment section. I hope this is not off topic because of this.
I'm going to be rolling out a php/mysql driven site soon and I'm pretty much resigned to the fact that the mysql performance dreamhost has given me isn't going to cut it, its probably too oversold. Simple one table one column selects can take 30 seconds or time out depending on how badly the server is being hammered. HTTP requests are usually snappy, but the mysql performance is bogus.
What is a good host for me to launch this site with? Storage wouldn't need to be too terribly high, at least initially. I'm tempted by MediaTemple's slick marketing, but I've seen on here that some people have had poor sql performance (contrary to what some personal friends have experienced, so I'm torn). I was reading about downtownhost on here, but their load times seemed slow when I hit a couple domains listed on here that are hosted by them.
This host needs to be located in the US. Honestly, I like dreamhost and their panel, save for the sql sluggishness I'm getting.
One of my friends uses a popular shared hosting provider, and I was assisting him with a web site issue earlier.
I noticed the following warning in the host's control panel:
"[MySQL databases] may not be used for log evaluation operations, ad clicks, chat systems, banner rotations, or similar applications putting extreme loads on the database under any circumstances."
Is this common at other shared hosts?
which windows share hosting support apache php mysql?
View 7 Replies View RelatedI hosted one aardvark topsite @ PluginSpace.com which consist of high traffics (3500+ unique visitors/day). I'm facing max_users_connection for quite number of times and I also have complain to my hosting but I still get no luck, they fix my problem for a short period and the problem appear again after some time.
I rent myself a dedicated server with 320GB Space and 3400GB Bandwith and 2GB RAM. Everytime I manage to get a lot of traffics to my topsite, maybe 100+ online users at a time, tracked by freeonlineusers[dot]com. I'll got these errors. Can anyone tell me what can I do? Can anyone tell me more about how much visitors can a normal dedicated server handle? Is it my script problem or my server problem?
(ERROR WILL POST IN NEXT POST)
can the dedicated server stand many visitors or suppose a normal dedicated server can handle so many visitors or my hosting maintenance is poor?
Is 40 max_user_connections for MySql typical in a Shared Hosting environment? Or are there Shared Hosts out there that allow more than 40 max_user_connections per account?
View 14 Replies View RelatedI have recently upgraded mysql server from 5.0.75 to 5.1.31 on my Ubuntu server 9.04 32 bit. After that when I am running phpmyadmin it is printing a warning :
Your PHP MySQL library version 5.0.75 differs from your MySQL server version 5.1.31.
Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.
Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..
I'm hosting wmv,wma,mp3 files, streaming of video can be done with Windows hosting, but my website script is with php.
Do you suggest Windows Server 2008 hosting or redhat linux hosting?
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error:
Code:
Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2
However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?
Do website builders generally go with shared hosting or dedicated server? I mean, if they work on several websites would they get a dedicated server instead of shared? From what I understand through reading shared hosting is basically if you only have one website. So one with multiple websites would go with a dedicated server?
View 12 Replies View RelatedWhich server for mysql only?
This is sort of a continuation to this thread here
Based upon the screenshots I provided below. What server would best suit my needs. I need this server to be able to handle the mysql usage and server load.
This server will be only for mysql. The rest of the site (html, videos) will be hosted on a different server.
If you think these servers are not enough for this please let me know any suggestions you have pertaining to server specifications.
Server 1:
Dual Core
Core 2 Duo E4500 2.2Ghz 2MB Cache
500 GB SATA II Hard Drive
2 GB DDR2 SDRAM
Server 2:
Dual Core
Core 2 Duo E8400 3.0Ghz 6MB Cache
500 GB SATA II Hard Drive
4 GB DDR2 SDRAM
Server 3:
Quad Core
Core 2 Quad Q9300 2.5Ghz 6MB Cache
500 GB SATA II Hard Drive
4 GB DDR2 SDRAM
i have install a durpal on my centos server(php5,mysql5,suphp),
for some feature,
i get a lof of error like
---------
Warning: MySQL server has gone away query
---------
i try to google to find some solution,
but the issue is still here,
do you know any problem make this?