Adarsh Sharma wrote:
Thanks for the suggestions.
Last thing to close this topic :-
I create new partitions & files for ibdata files as :-
log-bin=/hdd5-1/mysql-bin
innodb_data_file_path =
/hdd2-1/innodb_data1/ibdata1:250G;/hdd3-1/innodb_data2/ibdata2:250G;/hdd4-1/innodb_data3/ibdata3:8G:aut
- Original Message -
> From: "Adarsh Sharma"
> 1. I am planning to to fix one partition /hdd2-1 for my binary logs
> for HA, rotate them monthly to extra backups.
Keeping binary and other logs on separate disks from your datafiles is a very
good plan. For backup purposes, make sure you
Ya i know that this is absolutely wrong , but I have some questions in
my mind :-
1. I am planning to to fix one partition /hdd2-1 for my binary logs for
HA, rotate them monthly to extra backups.
2. Remaining 3 system partitions ( /hdd3-1,/hdd4-1,/hdd5-1) contains
ibdata1:250GB,ibdata2:250GB,
> Dear all,
>
> I have some doubts regarding the configuration of Innodb files structure.
> As we know all myisam tables are stored in database directory and innodb
> use tablespaces ( ibdata1 ).
> In My application , databases are the mixture of mysql & innodb storage
> engines.
> In my database
Gah, my eyes :-)
That seems... needlessly complex. As a general rule, it's a good idea to have
one datafile per physical disk. Putting more datafiles on a single disk doesn't
magically increase parallellism.
- Original Message -
> From: "Adarsh Sharma"
> To: "mysql"
> Sent: Monday,
http://www.linkedin.com/in/rolandoedwards
-Original Message-
From: Adarsh Sharma [mailto:adarsh.sha...@orkash.com]
Sent: Wednesday, March 16, 2011 5:33 AM
To: Johan De Meersman
Cc: mysql@lists.mysql.com
Subject: Re: Suggestions for InnoDB files
Johan De Meersman wrote:
>> From: &quo
- Original Message -
> From: "Adarsh Sharma"
> Johan De Meersman wrote:
> A Heartiest Thanks from my heart for explaining all these things in a
> fantastic manner. I agreed with your suggestions but one thing which
> isn't explained from your side , as you go deeper in RAID point.
> Q:-
Johan De Meersman wrote:
From: "Adarsh Sharma"
Johan De Meersman wrote:
Interesting, but why like this instead of simply larger disks or raidsets ?
It's the IT-Admin Issue , I can't question that and we have only disks of 300GB
( SAS ).
Your admin is supposed to provide se
> From: "Adarsh Sharma"
>
> Johan De Meersman wrote:
> > Interesting, but why like this instead of simply larger disks or raidsets ?
>
> It's the IT-Admin Issue , I can't question that and we have only disks of
> 300GB ( SAS ).
Your admin is supposed to provide services that benefit the applicat
- Original Message -
> From: "Adarsh Sharma"
>
> Dear all,
>
> I have doubt regarding the storage structure for Innodb files :
>
> Our database server has the following paths :
>
> /dev/sda5 69G 35G 32G52% /hdd1-1
> /dev/sdb1 274G 225G 36G 87% /hdd2
> I'm still kind of new to this, so I'm looking for suggestions on how
> to do this one. I need to recode this site that was designed using
> the old WebCatalog program which we will be phasing out soon. Here's
> the link to a page I need help
> on: http://die-broke.com/books.tpl What's the si
At 02:16 PM 6/15/2006 Thursday, Rob Desbois wrote:
> I'm still kind of new to this, so I'm looking for suggestions on how
> to do this one. I need to recode this site that was designed using
> the old WebCatalog program which we will be phasing out soon. Here's
> the link to a page I need help
> I'm still kind of new to this, so I'm looking for suggestions on how
> to do this one. I need to recode this site that was designed using
> the old WebCatalog program which we will be phasing out soon. Here's
> the link to a page I need help
> on: http://die-broke.com/books.tpl What's the
Ed Pauley II wrote:
I need to come up with a high availability, high performance MySQL
server setup. I have two database servers half way across the country
from one another being replicated through a VPN. These db servers
serve two very busy web sites with multiple applications accessing th
I don't know yet but transactional activity could get
quite large.
I read a bit in the manual (well a page or two)
So I created a sql statement
relating t1-id = t2-id .
I'm imaging that could work ,maybe i'm wrong.
Thank you,
Stuart
--- Jeremy March <[EMAIL PROTECTED]> wrote:
>
> > I have two
> I have two tables that should be related by a customer
> id (established in the customer table). The second
> table is going to have documents in a "text" column.
> I want the ability (at least I think) to have full
> text search for this second table. Hence I chose a
> myIsam table type.
well... I'm not 100% sure of your table structure, but if the children are in same
tables, then join to each:
select *
from action_items a, child_table b, child_table c
where a.owner_id = b.person_id
and a.creator_id = c.person_id
now if the values in the action_items table could be null (no
ECTED]>,
<[EMAIL PROTECTED]>,<[EMAIL PROTECTED]>
Subject: RE: suggestions - server options/mysql variables
Date: Thu, 19 Jun 2003 09:13:33 -0600
If you have queries that are only selects, in small tables, with few
rows, you should have very fast performance as is. Are you
ake a big difference.
Thanks
Eric
From: "Mike Hillyer" <[EMAIL PROTECTED]>
To: "Derick Smith"
<[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Subject: RE: suggestions - server options/mysql variables
Date: Thu, 19 Jun 2003 09:13:33 -0600
If y
If you have queries that are only selects, in small tables, with few
rows, you should have very fast performance as is. Are your queries
properly indexed? What hardware are you running on? What do these
queries look like?
Regards,
Mike Hillyer
www.vbmysql.com
> -Original Message-
> From:
- Forwarded by Peter J. Milanese/MHT/Nypl on 06/05/2003 07:35 AM -
Peter J. Milanese
06/04/2003 09:55 PM
To: Peter J. Milanese/MHT/Nypl
cc: "Mike Hillyer" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Subject: RE: Suggestions on joins/me
Maybe I went down the wrong path with a join
Any more clues?
P
"Mike Hillyer" <[EMAIL PROTECTED]>
06/02/2003 03:04 PM
To:"Peter J. Milanese" <[EMAIL PROTECTED]>
cc:<[EMAIL PROTECTED]>
Subject:
lues?
P
"Mike Hillyer" <[EMAIL PROTECTED]>
06/02/2003 03:04 PM
To: "Peter J. Milanese" <[EMAIL PROTECTED]>
cc: <[EMAIL PROTECTED]>
Subject:RE: Suggestions on joins/merges
Ok...
select ref.zipcodes.
by count DESC
limit 10
That should do it, right?
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Peter J. Milanese [mailto:[EMAIL PROTECTED]
Sent: Monday, June 02, 2003 12:23 PM
To: Mike Hillyer
Cc: [EMAIL PROTECTED]
Subject: RE: Suggestions on joins/merges
, <[EMAIL PROTECTED]>
cc:
Subject:RE: Suggestions on joins/merges
What column is MySQL complaining about being ambiguous? Isn't it just a
matter of adding tablename. To the start of the guilty column?
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Peter
Apologies.. I left that out...
The ambiguous column is 'zipcode'. it is common between all tables.
P
"Mike Hillyer" <[EMAIL PROTECTED]>
06/02/2003 01:38 PM
To: "Peter J. Milanese" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
What column is MySQL complaining about being ambiguous? Isn't it just a
matter of adding tablename. To the start of the guilty column?
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Peter J. Milanese [mailto:[EMAIL PROTECTED]
Sent: Monday, June 02, 2003 11:25 AM
To: [EMAIL PROTEC
The application will be run on windows2000. Or maybe Linux ... there is some
choice ;-)
>>Will this run on Windows or Linux?
Thank you, Martin, Mitko, John Griffin, David Christensen, Michael T. Babcock,
and sundisk
for your replies.
(Sorry for the delay...I work in several locations on Thurs
I second that
> :-) My offering would be to suggest developing in Delphi or Kylix,
> depending on the platform.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
: Thursday, April 03, 2003 10:55 AM
To: [EMAIL PROTECTED]
Cc: MySQL List
Subject: Re: Suggestions for choosing GUI Language that has a MySQL DB
backend
If speed isnt a issue I would say develop with one of the interpreted
languages (Perl/Python) My experience trying to get anything compiled under
linux or
Hi David,
check out http://gtk.php.net/ It is a GUI toolkit with a PHP interface to allow you to
build client applications.
John Griffin
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 03, 2003 11:25 AM
To: [EMAIL PROTECTED]
Subject: Suggestio
I have been asked to write an interactive GUI program that allows for
the display of results from related queries.
For example, launching the application wil generate the first query,
which will return a list of names of individuals.
May I suggest Python with PyGtk+ and using Glade to build th
If speed isnt a issue I would say develop with one of the interpreted
languages (Perl/Python)
My experience trying to get anything compiled under linux or windows because
of missing
headers or libraries will cause you and your project to experience
insufferable delay.
Regards,
Martin
- Original
I would use C + GTK+ (if the os is linux). MySQL has a very nice C API
(which is well-documented, I think) and GTK+ is the most common and
preferred GUI development kit for Linux. If the platform is Windows, the
GUI will be something else but I would still use C for the MySQL stuff.
HTH,
Hi Srinivas,
could it be that you're compiling a really prehistoric version?
Upgrade.
Thomas Spahni
On Fri, 21 Feb 2003, Biruda Raju Srinivasa Raju wrote:
> Hi,
>
> Here is th efollowing error i'am gertting when trying to run configure gor
> mysql
>
> configure --prefix=/usr/local/mysql --witho
If your users are on Windows, try out SQLyog for which I am a beta tester.
Its very simple to use and fast.
Download it at http://www.webyog.com/sqlyog
Insane
- Original Message -
From: "Rafael E. Herrera" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, October 19, 2002 3:54
Brent Baisley wrote:
about the same amount of time, then you don't have a proper index.
The query above needs to read the entire table to compile the stats,
your query should just need to read the records that are NJ if it
really is using the index correctly.
The results would also be inter
That is not normalizing your data. Normalization would be to create a
States table that would list all states (perhaps having abbreviation,
full name, country, etc) and then you would only store a code linking to
the states table. Although this is one of those special cases where full
normaliza
If your contacts are all North American, and this is a typical query, you
may well profit significantly from normalizing the address data. To do so,
create a Cities table and a States table (perhaps call it Regions if you
need to account for CDN provinces). The Cities table would look like:
CityID
I'm able to index 600,000 records in about 5 to 6 minutes on a dual PII
450
running Win2K and MySQL 4.0.0a
Similar stucture
ID
Title
Description
Indexing Title and Description.
On Wed, 2002-01-09 at 20:26, Jon Shoberg wrote:
>
> I have a simple table with A LOT of data, 2.1M rows. this is p
ay to go as well... I
might give that a shot.
-- Nathan
> -Original Message-
> From: Jeremy D. Zawodny [mailto:[EMAIL PROTECTED]]
> Sent: Monday, March 19, 2001 4:01 PM
> To: Neulinger, Nathan R.
> Cc: '[EMAIL PROTECTED]'
> Subject: Re: suggestions for implemen
Ok. The second one below sounds semi reasonable - it does mean that the
table will be somewhat useless for queries during the delete, but that's not
tragic. Is there any way to drop all the indexes on a table with a single
statement?
Third one sounds good as well, but unfortunately, there is a st
On Mon, Mar 19, 2001 at 02:40:58PM -0600, Neulinger, Nathan R. wrote:
>
> Got any suggestions on how these could be implemented? particular
> table types/setups/etc?
>
> I basically have a situation where 300,000+ rows are being inserted
> into a log table daily, and also needing to be cleared ou
43 matches
Mail list logo
