I got some questions about dedicated mysql server.
I read some things about compression used, should I give this a try?
Image
Any other tweaks? The current os is centos (The server is donated) I plan to switch to debian etch or freebsd 6.2
I got my.cnf tweaked right for the 2gb of ram I think but seems alittle slower then when it was on localhost, I was thinking dedicated mysql server would be quicker, its slow enough that my light weight mysql pages are running much slower
As for the 100mbit line, what else do you guys run? I'm thinking of going to 1000mbit so I'd get about 200mbps atleast, any better way?
I 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.
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?
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
My site is getting big and my server can barely hold all the mysql processes.
Once I had a similar problem with bandwidth because my media files were eating quite a big chunk of it. So, I just bought a media server and changed some HTML to hotlink all the media from the media server. I would like to do something like that with my MySQL databases, to get some load off my main server.
Should I get my current host to cluster another server for mysql? Or can I use a completely different server (from a different webhost) for mysql?
we got this error on mysql db after that we have change the my.cnf value
Description : MySQL server has gone away. Please contact with your host provider, the connection time should be increased a little.
It's the reason of the session issue (I see that sometimes it's caused on the session table update). It seems like there are some problems with search.
here's my.cnf how can we fix this prpblem?
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-locking skip-innodb #skip-networking safe-show-database query_cache_limit=1M query_cache_size=128M ## 32MB for every 1GB of RAM query_cache_type=1 max_user_connections=200 max_connections=500 interactive_timeout=10 wait_timeout=20 connect_timeout=20 thread_cache_size=128 key_buffer=512M ## 128MB for every 1GB of RAM join_buffer=1M max_connect_errors=20 max_allowed_packet=16M table_cache=1800 ## era a 1024 record_buffer=1M sort_buffer_size=4M ## 1MB for every 1GB of RAM read_buffer_size=4M ## 1MB for every 1GB of RAM read_rnd_buffer_size=4M ## 1MB for every 1GB of RAM thread_concurrency=4 ## Number of CPUs x 2 myisam_sort_buffer_size=64M server-id=1 log_slow_queries=/var/log/mysql-slow-queries.log long_query_time=2 collation-server=latin1_general_ci
telling me that mysql is hitting loads of 25, which he says is very high and i don't quite know what it means. He is strongly recommending that i shld get another dedicated server for mysql alone.
So can i get some advice on how I can assess the validity of his recommendations? I see that my CPU is load is hitting 125-150% daily. So i suppose there is some truth?
He is recommending that i get a raid-5 which is best. How can i know a suitable configuration of a new server to get? Of course, if i got all the money in the world i shld buy the best. But with constraints on budget, i want to get one (if i really need a new server) that is good for current loads with some projected margins for growth.
I've a huge site that runs on PHP and MYSQL, I'm going to get a dedicated server and make it for MYSQL so I need to know what server should I get for MYSQL ?
does it need to have lots of ram or should I get high CPU ?
I did an apache rebuild and about two hours later, my mysql stopped working.
So i tried various rebuilds to see if perhaps it was suoshin (this caused php to stop working on my server before) but to no avail, this hasnt fixed it. I cant even access the databases via phpmyadmin.
I've restarted the mysql server, apache, i've rebooted a couple times. I don't know what to do.
to pickup a dedicated MySQL 5 server from Dell running Linux. I have the option of either getting:
(1x) Quad Core Xeon E5430 2x6MB Cache 2.66Ghz
OR
(2x) Quad Core Xeon E5405 2x6MB Cache 2.00Ghz
They are about the same price. What option is best? The 4 cores but 666mhz faster each core, or double the cores (8), but less mhz per core. Can MySQL 5 even use 8 cores effectivley?
What can you do to stop so many users on your server that use mysql as apart of their website from getting this message: MySQL server has gone away
Like there has to be something installed or configured on the server that causes this as well, as I know people are taking too long to load something and it through that message, but it has to be something you can do server wide to get reed of it?
I have setup php and mysql on a windows IIS 6 server. php has installed fine and works but I have 2 problems
1. When i browse to http://localhost i get a 403 error but when browsing to http://localhost/index.php it works fine. It makes me think that the server does not know what extension to default to when doing a directory listing
2. I have phpmyadmin installed and the cfg file is set to do a 'config' authentication. That works but everytime i go to submit a form to create a new database or anything i get prompted with an HTTP user/pass. I'm not sure if this is a phpmyadmin issue or a php configuration issue
I was trying to upgraded MySql on my godaddy V.dedicated server.. And basicly ive screwed it up somehow.
I need to get back up and running and could do with some help on the best way to do that..
Ive visited the MySql website.. ive been playing with the shell (a little too much thats why its screwed up) so i can access the server via that and the server is running
Operating System: Red Hat Fedora Core 2
Can anyone point me first of all to the right download. and maybe point me to a tutorial or give me some advice on installing.. if ive messed up mysql does this also have any impact on the php or anything else?
