Best unofficial Apache Server developers community

Answers

Why should we store log files and bin-log files on different path or disks in mysql

⇧

⇩

41 views

Hi All,

I have replication setup mysql databases....the log file location the bin-log file all are at one path that is default my data directory of mysql.

I have read that for better performance one should store them seprately.

Can anyone provide me how this improves the performance. Is there is documentation available for the same. The reason why one should do so?

Regards, Manasi

mysql log disk usage space

asked May 24, 2011 12:53 am CDT

MySQL DBA

posted via StackOverflow

2 Answers

Newest Most Voted

⇧

⇩

Mainly because then, reads and writes can be made almost in parallel. Stored separately meaning on different disks.

Linux and H/W optimizations for MySQL is a nice presentation of ways to improve MySQL performance - it presents benchmarks and conclusions of when to use SSD disks and when to use SCSI disks, what kind of processors are better for what tasks.

Very good presentation, a must read for any DBA!!

answered May 24, 2011 1:23 am CDT

Tudor Constantin

⇧

⇩

It also can be really embarrassing to have your log files fill the file system and bring the database to a halt.

answered May 24, 2011 1:23 am CDT

Charlie Martin

Your answer

Similar discussion threads

disks and data files
December 13, 2010 05:30:36 AM
I am reading the kafka design documentation ( http://sna-projects.com/kafka/design.php) and I came across this (under constant time suffices) : Intuitively a persistent queue could be built on simple reads and appends to files as is commonly the…

store less files
April 1, 2011 02:58:45 AM
Hi, When I run the below pig codes: a = load '/logs/2011-03-31'; b = filter a by $1=='a' and $2=='b'; store b into '20110331-ab'; It runs a M/R that have thousands maps, and then create a output store directory that have the same number so many…

RE: store less files
April 2, 2011 03:26:45 PM
That's a good call, thanks Mridul. Something reproducible like taking a hash of a tuple field is much better. As for the concern about having to move all the data -- until hdfs allows multiple writers to a single file (not on the roadmap afaik),…

use DistributedCache to add many files to class path
February 16, 2011 09:51:33 PM
I use DistributedCache to add two files to class path, exampe below code : String jeJarPath = "/group/aladdin/lib/je-4.1.7.jar"; DistributedCache.addFileToClassPath(new Path(jeJarPath), conf); String tairJarPath =…

Using Cassandra to store files
February 3, 2011 06:34:24 AM
This is a multi-part message in MIME format. Hi Would anyone recommend using Cassandra for storing hundreds of thousands of documents in Word/PDF format? The manual says it can store documents under 64MB with no issue but was wondering if anyone…

RE: Using Cassandra to store files
February 4, 2011 02:37:57 AM
This is a multi-part message in MIME format. Hi Daniel When you say "We are doing this" do you mean via NFS or Cassandra. Thanks Brendan Brendan Poole Systems Developer NewLaw Solicitors Helmont House …

RE: Using Cassandra to store files
February 4, 2011 02:39:47 AM
The first line on the couchDB website doesn't fill me with confidence... "The 1.0.0 release has a critical bug which can lead to data loss in the default configuration" Brendan Poole Systems Developer NewLaw Solicitors …

Recall: Using Cassandra to store files
February 4, 2011 02:41:17 AM
This is a multi-part message in MIME format. Brendan Poole would like to recall the message, "Using Cassandra to store files". Brendan Poole Systems Developer NewLaw Solicitors Helmont House Churchill Way Cardiff …

Is it possible to store text files(or blobs) in Voldemort?
November 8, 2010 02:46:59 AM
Is there a possibility to store a text file inside Voldemort?

about how the hdfs choose datanodes to store the files
May 5, 2011 02:00:09 AM
Hi: all! we know that the hdfs divide a large file into several blocks(with each 64mb, 3 replications default). and once the metadata in the namenode are modified, there goes a thread dataStreamer to transport the blocks to the datanode. for…

Query, edit and store CSV files using JSP and MongoDB
January 5, 2011 07:25:14 PM
Hi Mongoers, I have been using MongoDB for as large databases to store <key,value> and interact with Map/Reduce. It works just fine. Now I need to setup a website for project evaluation. The web is written in JSP(Java Server Pages), and we…

Created] (CAMEL-3815) Add relative path to parent pom.xml in examples pom.xml files
March 29, 2011 01:44:04 AM
Add relative path to parent pom.xml in examples pom.xml files

Migrating from Lighttpd/Apache combo: extra path on static files
February 11, 2011 10:06:50 AM
Hi, I'm migrating a setup for a friend, and hit a snag, I can't seem to find the proper way to do this on nginx. Assume a directory /my/files/ with a.gif inside. He is using: location /files { alias /my/files; } but then he is requesting…

Created: (GERONIMO-5365) Parentheses in JAVA_HOME path prevent *.bat files from running
June 3, 2010 12:08:54 PM
Parentheses in JAVA_HOME path prevent *.bat files from running

Updated: (HIVE-1326) RowContainer uses hard-coded '/tmp/' path for temporary files
October 26, 2010 03:02:48 PM
[ https://issues.apache.org/jira/browse/HIVE-1326?page=com.atlassian.jir a.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-1326:

Assigned: (HIVE-1326) RowContainer uses hard-coded '/tmp/' path for temporary files
December 20, 2010 10:56:28 PM
[ https://issues.apache.org/jira/browse/HIVE-1326?page=com.atlassian.jir a.plugin.system.issuetabpanels:all-tabpanel ] John Sichi reassigned HIVE-1326:

Commented: (HIVE-1326) RowContainer uses hard-coded '/tmp/' path for temporary files
December 20, 2010 10:30:46 PM
[ https://issues.apache.org/jira/browse/HIVE-1326?page=com.atlassian.jir a.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=1 2973466#action_12973466 ] Jeff Hammerbacher commented on HIVE-1326:

Created: (MAPREDUCE-1977) [Rumen] Do Not Store CDFs in Output JSON Files
July 28, 2010 05:02:19 AM
[Rumen] Do Not Store CDFs in Output JSON Files

Created: (MRM-1429) Proxying of xml files from one archiva server to another fails, when jar files s
November 18, 2010 07:05:36 PM
Proxying of xml files from one archiva server to another fails, when jar files succeed

Loading CSV Files & LOAD large files behavior in local mode
August 19, 2010 02:49:46 AM
What loader should I use on csv files with quoted strings that contain embedded commas? (i.e. Embedded commas should not be a separator.) And when LOADing large files in local mode, does Pig just store it all in memory? Or does it have memory…

Questions and Answers are licensed under cc-wiki license.

Why should we store log files and bin-log files on different path or disks in mysql

2 Answers

Your answer

Join with account you already have