HD Performance With MySql On 2nd Drive
Aug 5, 2008
question regarding hard disk performance.
Right now i have a busy running forum Running on a Single Xeon 5335 with 4GB of RAM,
single 73GB SCSI 15K. And the site seems running fine most of the time except at peak.
The load sometime goes up to 8 for about 1 hour. So i am looking to upgrade my server.
The next server i am thinking about is
Single C2Q 9300, 8GB of RAM, 1x750GB SATAII as primary drive for for webserver, 1x150GB Raptor 10K to serve MYSQL only.
I wonder if the HDD performance on my current server server with future server be the same of better? Since the future server has better CPU and RAM, the only thing i worry is the HDD performance.
So in short, Single SCSI 15K V.S Combination of SATA + RAPTOR. What do you guy think?
i am using Litespeed as webserver and i also will be using litespeed on future server.
View 10 Replies
ADVERTISEMENT
Oct 28, 2009
We have had some old dell 745n that had sata drives in them in the past. These are the only time we have ever used sata. The performance was terrible and we replaced the sata drives more times in over several years and we ever have with sas/scsi drives.
We are looking to get some new disk backup boxes which we plan to go 600gb sas drives, but might be considering 1tb nearline sata from dell.
I would like to hear from anyone using nearline sata and get feedback on performance and reliability overall. Also if you are using for backups, how many backup jobs are you able to run at the same time before performance drops?
View 5 Replies
View Related
Jul 21, 2008
I am trying out all sorts of new drives and raid card adapters because I am finding the 3ware's I have been faithfully using to really suck lately.
We are testing them against areca and adaptec (although I really hate areca from prior bad experience)...
We are using bonnie right now... of course we plan to play around with xen, a couple of domains, prime95, some dd's and then run bonnie too... kind of a stress test.
View 14 Replies
View Related
Mar 8, 2008
Since my linux server is out of disk space, I just use cifs to mount some drives from the windows server for people to download files (usually 100-200mb/file).
But I found the performance is not good. For example, I need to wait for a long time before the download process begin. Also, it seems the load average of the server becomes high too.
Is there any suggestion? Should I mount the windows drives through cifs? Or should I change to another server which allow me to add more local harddisks? How about if I mount drives in other linux machine, will the performance better?
View 1 Replies
View Related
Jul 31, 2008
how much traffic SATA 2 HDD can handle?
While transfer speed is 300 MB/s, it's really not possible to keep transfering data at those speeds 24/7? Or is it?
Wouldn't network line (100 mbps) die first?
View 10 Replies
View Related
Jan 7, 2007
I am considering to upgrade to MySQL 5.0. I am using 4.1 at present. Now I wonder if it will really improve performance... I really have some busy databases... Also wonder if 5.0 is fully downwards compatible to 4.1
View 2 Replies
View Related
May 24, 2007
I have a site that runs from a MySQL database. The database isn't big, it has only 16.1 MB on 17 tables with 103,978 records, and all are properly indexed.
My problem is that my MySQL has a particular problem with this database because I'll have to wait around 5-10 minutes to receive the query results.
I've tuned MySQL, I've tuned Apache and in the daily usage i have usually low Load Averages of 0.19 0.22 0.40. My server specs are Intel P4 at 3GHz with HT, 2Gb of RAM (in dual Chanel), 2 Hdd of 250Gb (backup) and 300Gb (main hdd), both with 16 mb cache. I'm running Debian 3.1 with 2.6 kernel and there is no swapping to disk as i had previous on the 2.4 kernel.
I will post my.conf below and maybe you'll give me a suggestion.
Code:
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "/var/lib/mysql/my.cnf" to set server-specific options or
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# [url]
# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# escpecially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port= 3306
socket= /var/run/mysqld/mysqld.sock
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket= /var/run/mysqld/mysqld.sock
nice= 0
[mysqld]
#
# * Basic Settings
#
user= mysql
pid-file= /var/run/mysqld/mysqld.pid
socket= /var/run/mysqld/mysqld.sock
port= 3306
basedir= /usr
datadir= /var/lib/mysql
tmpdir= /tmp
language= /usr/share/mysql/english
skip-external-locking
#
# For compatibility to other Debian packages that still use
# libmysqlclient10 and libmysqlclient12.
old_passwords= 1
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address= 127.0.0.1
#
# * Fine Tuning
#
key_buffer= 32M
key_buffer_size= 32M
max_allowed_packet= 16M
myisam_sort_buffer_size = 32M
table_cache= 3072
sort_buffer_size= 4M
read_buffer_size= 4M
read_rnd_buffer_size= 4M
join_buffer_size= 2M
thread_stack= 512K
wait_timeout= 300
max_connection = 60
max_connect_errors= 10
thread_cache_size= 100
long_query_time= 2
max_user_connections= 50
interactive_timeout= 100
connect_timeout= 15
tmp_table_size= 64M
open_files_limit= 3072
max_heap_table_size = 64M
#
# * Query Cache Configuration
#
query_cache_limit= 2M
query_cache_size = 64M
query_cache_type = 1
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
#log= /var/log/mysql.log
#log= /var/log/mysql/mysql.log
#
# Error logging goes to syslog. This is a Debian improvement :)
#
# Here you can see queries with especially long duration
log-slow-queries= /var/log/mysql/mysql-slow.log
log-queries-not-using-indexes = /var/log/mysql/mysql-index.log
# The following can be used as easy to replay backup logs or for replication.
#server-id= 1
log-bin= /var/log/mysql/mysql-bin.log
# See /etc/mysql/debian-log-rotate.conf for the number of files kept.
max_binlog_size = 104857600
#binlog-do-db= include_database_name
#binlog-ignore-db= include_database_name
#
# * BerkeleyDB
#
# According to an MySQL employee the use of BerkeleyDB is now discouraged
# and support for it will probably cease in the next versions.
skip-bdb
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# If you want to enable SSL support (recommended) read the manual or my
# HOWTO in /usr/share/doc/mysql-server/SSL-MINI-HOWTO.txt.gz
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem
[mysqldump]
quick
quote-names
max_allowed_packet= 64M
[mysql]
#no-auto-rehash# faster start of mysql but no tab completition
[isamchk]
key_buffer= 32M
sort_buffer_size= 32M
read_buffer= 16M
write_buffer= 16M
[myisamchk]
key_buffer = 32M
sort_buffer_size = 32M
read_buffer = 16M
write_buffer = 16M
I thought that i might need to start rewriting my code in order to be able to fix things but i need at least another opinion from someone who knows more.
View 9 Replies
View Related
Jun 15, 2009
I have published 2 articles about MySQL benchmark results. They can be viewed here:
- super-smack: [url]
- sql-bench: [url]
If you have any results to compare, please let me know, either here or via comments.
View 5 Replies
View Related
Nov 26, 2007
I was wondering if there is a significant performance gain if you use PHP 5.25 and MySQL 5x instead PHP 4.47 and MySQL 4.22?
Let's say that the scripts to be used are all compatible to the said versions.
View 3 Replies
View Related
Nov 8, 2007
I've decided to give VPS a shot. So...
I'm runnning the same query on a 1 & 1 VPS, where the MySQL server is local, and on a 1 & 1 shared server (where the MySQL server is remote).
The MySQL version on the VPS machine is 4.1, while on the shared server it's 4.0.
The exact same query takes 20x longer (!) on the VPS.
View 7 Replies
View Related
Jan 26, 2008
I have the hatchling plan on HostGator. Is there a PHP and MySQL open-source application where I can put up there to test its performance on running PHP and MySql applications? I want to see if there is any performance issue on this host before migrating a large ZenCart app to it.
What are people's experience on HostGator running PHP and MySQL?
View 6 Replies
View Related
Sep 21, 2007
I'm having some performance issues on IIS with my PHP and MySQL applications. I'm also starting to see some errors.
One of my main apps is vBulletin. I've tried posting there for help, but not many people there have experience with IIS.
See this thread:
[url]
View 8 Replies
View Related
Feb 4, 2007
Which Is better and would give me better mysql Performance since mysql eats up huge amounts of CPU and RAM.
AMD 64Bit 3200 Or a Intel Core 2 Duo 1.86 GHz
I know theres many other factors involved but I need to know which processor would perform better with mysql.
View 4 Replies
View Related
Jun 7, 2008
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.
View 14 Replies
View Related
Apr 21, 2008
We have a powerful server for our databases, 8 cores, 4gb ram etc because we have a huge amount of MySQL data. We store the data on a standard SATAII 500GB drive, would we notice a dramatic performance improvement if we stored the data on a SA-SCSI 10/15k drive?
View 2 Replies
View Related
Apr 19, 2007
My server has 2 drives, running on mysql 4.1.21. Can someone give me detailed instructions on how to move mysql to the secondary drive on the same server? The secondary drive has only /backup
View 8 Replies
View Related
Jul 19, 2007
During my poking around performance tips I found the DELAY_KEY_WRITE option (and innodb_flush_log_at_trx_commit = 0 for innodb)
which supposedly for mysql will disable the immediate disk flush for every transaction written and instead update only once every second at most?
One thing I've never had to restart on my vps is mysql, it's been great. So is this safe to turn on? Am I risking corruption? Will the performance gain be worth it with only a 16M cache?
View 4 Replies
View Related
Jan 7, 2008
i moved mysql to another drive, and i am getting these errors
/etc/cron.hourly/modsecparse.pl:
DBI connect('modsec:localhost','modsec',...) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /etc/cron.hourly/modsecparse.pl line 19
Unable to connect to mysql database at /etc/cron.hourly/modsecparse.pl line 19.
[root@viper ~]# ls -la /var/lib/mysql/mysql.sock
lrwxrwxrwx 1 root root 23 Jan 6 20:11 /var/lib/mysql/mysql.sock -> /home3/mysql/mysql.sock
the socket exists.
in cpanel - service manager mysql looks as down, and eximstats the same.
any idea where is the config for modsec and chkserv so that i could set the new mysql.sock location? maybe that will work.
View 6 Replies
View Related
Oct 31, 2009
I have a server that is running linux with cpanel and I am running out of space on a partition.
I was getting this error:
Drive Warning: /dev/sda3 (/var) is 83% full
I looked in the folder and went to /var/lib/mysql and noticed that I have about 6 databases that are a little over 1 GB each. The sda3 partition only has a capacity for 9.9 GB and I was suggested to configure mysql to hold my databases on another partition that has more space..
View 3 Replies
View Related
Jan 26, 2007
1- i did Os Reload with new Hard drive for "home"
2- data "backups" drive lost
3- replaced the old home drive as "/old drive"
4- " /old drive " is now the secondry drive in my server and it has the all sites usres and evry thing
5- what i need , to trasfer, copy this sites from " /old drive " to "home"
but data center said
The /olddrive/home directory contains the contents that were previously in the /home directory. You can copy files from this directory to any other directory on your server.
The command to copy files in the UNIX environment is the "cp" command.
The user directories in /olddrive/home directory contain the web page files for the users. However, simply copying the contents over will not recreate the users or domain entries in DNS/httpd. If you wish these back you will need to recreate them manually or restore them from backups.
View 14 Replies
View Related
Jul 13, 2007
I am using dreamhost host 3 of my web sites and 1 blog. Dreamhost is great, offers alot space and bandwidth.
but I think they are oversellling their space, sometimes it gets really slow. (overselling ? ok, I dont really know, but sometimes its really slow, and most my asian readers said need to refresh to load the page. I am wondering if theres a way to check if they are overselling or not.)
I am thinking about buying vps, even tho, I still got 5 month left with dreamhost.
I found 2 vps companies are highly recommanded on this forum, JaguarPC and LiquidWeb.
theres already a post compared both companies in terms of price and service. I say I will pick JagarPc, cuz, its basic plan just 20 USD, and htey got promotion now, its even cheaper. and basic Liquidweb vps plan is 60 bucks.
I am wondering why Jagarpc is so cheap , are they overselling? how can we check if they are overselling.
I found a few posts saying how good jaguarPc is. and they are not overselling, but those members just signed up this month, and only have 1-3 posts. I cannot really trust those new members.
Can someone share their experience with JaguarPC? compare JaguarPc performance and liquidweb performance. antoher question is switch from dreamhost to JaguarPC basic vPS plan, will performance gets better?
last question: VPS account allows 3 IP, 3ip = 3 domains? if not, how many domains can I have?
View 14 Replies
View Related
Feb 16, 2007
Primary drive (centos/cpanel) is corrupt
The server is displaying these errors when I tried to do an FSCK:
Bad inode IO
ext3-fs error (device(8,3)) IO Failure
I am having a new primary installed and old primary set as 2nd drive. I need to recover the cpanel domain accounts from this 2nd drive after I mount it with the method below:
mkdir /backup
mount /dev/sdb1 /backup
However, how do I actually recover these accounts in an automated process via whm? I've done this before with the same matter (corrupt primary drive, mount as 2nd, etc) but cannot exactly remember the proper steps.
View 14 Replies
View Related
Dec 28, 2007
I just purchased a brand new 10K 150GB drive. How can I take an exact copy of my current drive and transfer everything over to the new drive? I think I need to create a snapshop, or mirror it somehow.
What software will do this? I was told trueimage, but its very pricy, is there anything else?
View 8 Replies
View Related
Jul 9, 2007
I have a dedicated box and I started getting Input/output errors today.
I tried:
# fsck
fsck 1.40-WIP (14-Nov-2006)
e2fsck 1.40-WIP (14-Nov-2006)
/dev/hda2: recovering journal
fsck.ext3: unable to set superblock flags on /dev/hda2
then I tried:
# fsck -a -t ext3 /dev/hda2
fsck 1.40-WIP (14-Nov-2006)
/dev/hda2: recovering journal
fsck.ext3: unable to set superblock flags on /dev/hda2
My data is backed up, so was going to ask for a reimage, but is this an indication of bad hardware? Should I ask for a replacement drive? Is there anything else I should try on my own before going to the host?
View 6 Replies
View Related
Feb 6, 2007
I have a Win2K3 server which has 2 hard drives. I was considering backup options and I thought that I might try mirroring Drive A ==> Drive B. I would think that, then, if Drive A has a hardware failure, I could simply switch Drive B into the Primary slot (A) and the server would continue to hum along as nothing has happened. This would reduce the downtime, hopefully.
I have 3 questions.
1. Is this idea practical (will it work)?
2. What is a good software program to use fto handle the mirroring?
3. Any considerations, warnings, technical advice in regard to this method?
View 4 Replies
View Related
May 8, 2009
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..
View 4 Replies
View Related
Sep 7, 2008
We run a very busy web application written in .net . The backend is SQL 2005. The server running SQL for this web app is slammed constantly. CPU is red lined, and the disks are queuing up because they cant keep up with the demand. What I am wondering is what do the big websites do to gain performance? What direction should we start moving in to get ahead of the curve. We are using an HP DL 580 with 4 x quad core xeons and the fastest SAS drives we could get.
View 14 Replies
View Related
May 12, 2008
Any rumors known already?
View 4 Replies
View Related
Dec 10, 2007
Does anyone have experience using LVM2? We'd rely on hardware RAID mirroring for the underlying physical redundancy, but we're very interested in LVM2's storage virtualization features.
If anyone can share their experiences with LVM2 with regards to performance and possibly use in a SAN environment,
View 2 Replies
View Related
Apr 20, 2007
Hypothetical Scenario:
Let's say I've got a single website built in Drupal (using PHP and MySQL). It gets less than a 1,000 visits per day and needs very little storage or bandwidth. The site is currently on a shared host and it runs okay, but often has very slow page loads due to sluggish MySQL calls and other traffic on the server. Sometimes the homepage loads in 2s but other times it takes 20-30s depending on time of day. The client is sick of this performance on such a low traffic site and wants to improve the situation.
Question: Will a VPS really provide that much better performance than a shared host?
Remember I'm talking ONLY about page load time under minimal load. No need to take into account scaling or Digg/Slashdot effects.
I know dedicated is the best option but it seems crazy for such a low traffic site. A lot of the VPS offers are very attractive in theory (managed and affordable) but in practice I'm concerned that even a 512MB VPS with 1GB burst won't make much of a performance difference.
Mainly I don't want to go to the hassle and extra monthly expense of moving everything to a VPS for only a minimal gain.
View 14 Replies
View Related
Jan 21, 2007
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?
View 1 Replies
View Related
