You may try DBT2 (TPC-C like) workload.
On Sat, Oct 11, 2008 at 6:31 AM, Sachin Gaikwad [EMAIL PROTECTED] wrote:
On Fri, Oct 10, 2008 at 6:29 PM, Martin Gainty [EMAIL PROTECTED] wrote:
Hello Sachin
have you looked at using Benchmark Suite?
My reply was with regards to the answer in this post.
http://lists.mysql.com/mysql/214827
Anyways thanks for the concern from your end.. Mike :) My query was
answered.
Thanks Regards
Sudhir Menon
Folks,
I work at a Web Hosting company and we were frustrated by our
inability to account for user activity on a busy server. We could see
gross spikes in activity by SHOW STATUS, but couldn't tell where they
were coming from easily. We finally developed an extensive set of
patches for MySQL and
Karthik,
I have included some of the parts of your original posting.
You may need to do some experiments, but these actions may help you
greatly. You may also want to consider the book High Performance
MySQL, it has helped us a lot:
1. Make sure you have indexes on any column
Hi,
This Thursday, Stewart Smith will give a MySQL University session:
http://forge.mysql.com/wiki/Checking_Threading_and_Locking_With_Helgrind
(topic: Checking Threading and Locking With Helgrind)
*** Note that this particular session starts 9:00 BST / 10:00 CET /
18:00 Brisbane/Melbourne ***
Folks,
In efforts to increase our visibility (this is also
posted in the jobs forum) and not to offend anyone;
please take a look at the following URL and job
description. Info about the company is also included.
Feel free to email or call me directly.
We are in need of multiple DBAs in both
In mysql 4, can one replicate a database to another server but have the DB
name on the slave server be different?
Master : dbname1
Slave: dbname1
AND
Slave : dbname2 (but contains data from db2name1)
A project manager is asking for this.. don't blame the guy asking :-)
Regards,
Martin
On Mon, Oct 13, 2008 at 11:43 AM, AM Corona [EMAIL PROTECTED] wrote:
In mysql 4, can one replicate a database to another server but have the DB
name on the slave server be different?
Master : dbname1
Slave: dbname1
AND
Slave : dbname2 (but contains data from db2name1)
A project
In the last episode (Oct 13), AM Corona said:
In mysql 4, can one replicate a database to another server but have the DB
name on the slave server be different?
Master : dbname1
Slave: dbname1
AND
Slave : dbname2 (but contains data from db2name1)
So you want the same data in two
I've run into the following scenario: we've got several database servers
with 2+TB of data spread across several 900GB InnoDB data files. We can
move to innodb_file_per_table in an incremental fashion (ie ALTER TABLE
ENGINE='InnoDB' one table at a time), however, to complete this task, we'll
need
Hi Karthik,
You have many columns in a single table (although you can). But, if you
break the below table into two tables ( Vertical partitioning). It will help
you to run your query faster. You haven't shown join_buffer_size and
sort_buffer_size.
Secondly, check your all the queries with
Although, it's a time taking task. But, you can try the below method.
Create table with different name with same structure myisam table. Move the
content to newly created table. rename the original table to tem. Rename the
newly created table to original name. In this way you can convet all your
Hi,
I have two hard disk on debian system. Each of 80GB. I want to use both the
hard disk for storing the *mysql data. *On one hard disk the data has
reached up to 73GB.
What changes, I can do to use both the hard disk for storing mysql data.
Quick response is highly appreciated.
Thanks
--
Move your logs to the second drive
I wouldn't do this, but you can move a db to drive2 and link it into the
/data/dir
--Original Message--
From: Krishna Chandra Prajapati
To: mysql@lists.mysql.com
Sent: Oct 13, 2008 22:33
Subject: STORE MYSQL DATA ON TWO HARDDISK
Hi,
I have two hard
14 matches
Mail list logo