the website
becomes more personalized our caching options are more limited. What I need
is someone to:
- Validate that the general direction we are taking is a sensible one
(replication schema, backups, etc) for our scaling requirements.
- Once we have everything set up, provide assitence
Krishna Chandra Prajapati wrote:
Hi shawn,
As the data grows to 20 millions the insert rate will become very slow.
In such case i am getting 2000 insert/seconds only.
Therefore my objective is not achieved.
I cannot slow up the insert rate of 10,000/second. I am getting data
(inserted by us
If you only need very fast INSERTs, you might try to use ARCHIVE
storage engine (
http://dev.mysql.com/tech-resources/articles/storage-engine.html ). It
was developed for handling INSERTs very fast. Many peoples use it, for
example, for storing logs.
> Hi list,
>
> I want to insert 1 records/s
non-linearity in the insert rate means you have indexes on some columns.
depending on your situation, mysql can be more efficient if drop those
indexes, do bulk inserts, and then add the indexes again.
On 1/23/10 5:02 AM, "Krishna Chandra Prajapati"
wrote:
> Hi shawn,
>
> As the data grows to
Hi shawn,
As the data grows to 20 millions the insert rate will become very slow. In
such case i am getting 2000 insert/seconds only.
Therefore my objective is not achieved.
I cannot slow up the insert rate of 10,000/second. I am getting data
(inserted by users at this rate)
Is there any other
Krishna Chandra Prajapati schrieb:
> Hi list,
>
> I want to insert 1 records/sec into table. There can be n number of
> tables with unique data in each. What are the possible ways to do ?
>
i prefer mysqlimport. just sort your output into a file that is named like the
table
you wish to i
Krishna Chandra Prajapati wrote:
Hi list,
I want to insert 1 records/sec into table. There can be n number of
tables with unique data in each. What are the possible ways to do ?
Thanks,
Krishna
The manual is your friend. It doesn't hurt to consult it.
INSERT ...
http://dev.mysql.com/doc
Hi list,
I want to insert 1 records/sec into table. There can be n number of
tables with unique data in each. What are the possible ways to do ?
Thanks,
Krishna
Friday, August 21, 2009 9:23 PM
> To: wha...@bfs.de
> Cc: MySQL
> Subject: Re: Scaling Mysql
>
> Hi wharms,
>
> Yor are right. It's some kind of queue mechanism. Right now i am working i
> telco company (We used to send sms)
>
> Users will be inserting recor
Have you looked at MySQL cluster? It was created specifically for telco needs.
-Original Message-
From: Krishna Chandra Prajapati [mailto:prajapat...@gmail.com]
Sent: Friday, August 21, 2009 9:23 PM
To: wha...@bfs.de
Cc: MySQL
Subject: Re: Scaling Mysql
Hi wharms,
Yor are right. It&#
Hi wharms,
Yor are right. It's some kind of queue mechanism. Right now i am working i
telco company (We used to send sms)
Users will be inserting records into send_sms @ 30,000msg/min Then those
record will be updated and moved to alt_send_sms and deleted from send_sms.
After that 30,000msg/min
I forgot. It's all done in one sql statement.
Mike
-Original Message-
From: Jerry Schwartz [mailto:jschwa...@the-infoshop.com]
Sent: Friday, August 21, 2009 8:32 AM
To: 'mos'; 'MySQL'
Subject: RE: Scaling Mysql
>
>Krishna,
> Rather than copying
>-Original Message-
>From: Gavin Towey [mailto:gto...@ffn.com]
>Sent: Friday, August 21, 2009 2:45 PM
>To: Jerry Schwartz; 'mos'; 'MySQL'
>Subject: RE: Scaling Mysql
>
>RENAME statement is atomic, and you can specify multiple tables to rename
a
hwa...@the-infoshop.com]
Sent: Friday, August 21, 2009 8:32 AM
To: 'mos'; 'MySQL'
Subject: RE: Scaling Mysql
>
>Krishna,
> Rather than copying rows from one table to another, and deleting the
>previous rows, why not just do:
>
>1) create table send_sms_emp
>
>Krishna,
> Rather than copying rows from one table to another, and deleting the
>previous rows, why not just do:
>
>1) create table send_sms_empty like send_sms;
>
>2) rename table send_sms to send_sms_full;rename send_sms_empty to
send_sms;
>
>3) insert into alt_send_sms select * from send_
At 01:30 AM 8/21/2009, Krishna Chandra Prajapati wrote:
Hi list,
I have two tables send_sms and alt_send_sms. Users are inserting records
into send_sms @ 500/sec ie 3/min. After applying some updates to
send_sms data are transferred to alt_send_sms and deleted from send sms. The
same thing i
Krishna Chandra Prajapati schrieb:
> Hi list,
>
> I have two tables send_sms and alt_send_sms. Users are inserting records
> into send_sms @ 500/sec ie 3/min. After applying some updates to
> send_sms data are transferred to alt_send_sms and deleted from send sms. The
> same thing is happeni
Hi list,
I have two tables send_sms and alt_send_sms. Users are inserting records
into send_sms @ 500/sec ie 3/min. After applying some updates to
send_sms data are transferred to alt_send_sms and deleted from send sms. The
same thing is happening with alt_send_sms table.
Is it possible to in
Hi,
On Tue, Apr 1, 2008 at 5:39 PM, Michael Katz <[EMAIL PROTECTED]> wrote:
> In a replication environment with 1 master and a 2 slaves, does the
> entire database always have to be stored on the master? I understand
> that slaves can come on and off line but I am not sure if the master
> must
In a replication environment with 1 master and a 2 slaves, does the
entire database always have to be stored on the master? I understand
that slaves can come on and off line but I am not sure if the master
must always store a complete copy of DB.
Thanks,
MK
--
MySQL General Mailing List
For li
Scaling would like to sponsor airfare and hotel for one person to
attend who could not otherwise make it. Read more about it here:
http://jcole.us/blog/archives/2006/10/18/want-a-free-ride-to-mysql-camp/
If you're interested in attending on our dime, follow the directions in
that post
awesome yes I will be an eager consumer.
-C
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "chad pratt" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, June 23, 2003 9:01 PM
Subject: Re: scaling
> On Mon, Jun
On Mon, Jun 30, 2003 at 11:44:30PM -0400, chad pratt wrote:
> thanks for the invite. I am too poor to attend.
The slides will all be on-line within a day of the talk, if that's of
any help.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy
thanks for the invite. I am too poor to attend.
-C
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "chad pratt" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, June 23, 2003 6:58 PM
Subject: Re: scaling
> On Sa
On Sat, Jun 28, 2003 at 10:53:48PM -0400, chad pratt wrote:
>
> What are the gotchas with respect to scaling?
Come to OSCON and find out!
http://conferences.oreillynet.com/cs/os2003/view/e_sess/4502
Sorry. They ask that speakers promote their talks on a relevant
mailling list if they
I have some general questions regarding a number of things.. I am not
looking for "what's wrong with my code?" type answers, just some friendly
advice from anyone who want's to answer. HEre goes:
What are the gotchas with respect to scaling? What am I going to wish I
di
My application is intended to be scalable. In the eyes of the marketing
departments, it should be scalable from zero to infinity. But we all know
that this is not possible indefinitely - at some point you reach a
bottleneck. In the case of my system, that bottleneck will eventually be
the MySQL wri
On Fri, Nov 02, 2001 at 03:37:53PM -0800, another oracle dba wrote:
> Hi.
>
> I have a query which completes in about 9 sec when executed alone,
> but the time grows dramatically when I execute several similar
> queries at the same time. If I execute 3 queries the time grows to
> 27-40sec, for 5
Hi.
I have a query which completes in about 9 sec when executed alone,
but the time grows dramatically when I execute several similar
queries at the same time. If I execute 3 queries the time grows
to 27-40sec, for 5 queries - toabout 1min, for 20 queries ran
simultaniously the time jumps to 2-4
r" <[EMAIL PROTECTED]>
From:"Jason Landry" <[EMAIL PROTECTED]>
Date:Sat, 3 Mar 2001 03:38:10 -0600
CC:<[EMAIL PROTECTED]>
Subject: Re: Scaling mysql
Have you considered replication? There's a pretty good chapter in the MySQL
manual on how to objectively determine
t;[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, March 02, 2001 1:24 PM
Subject: Scaling mysql
> hey,
> i'm having a problem with scaling a mysql server. This is the
situation... i have a database with 5 tables containing user data.
hey,
i'm having a problem with scaling a mysql server. This is the situation... i have
a database with 5 tables containing user data. Except one, all the other tables have
only 2 fields. This data is queried often and needs to be accessed by multiple web
servers. Each table
On 11 Jan 2001, at 19:18, Chris Murley wrote:
> Thanks for you help, can anyone tell me what the file size limit is under
> windows?? win 200 or win me?
>
I think the filesize limit on Win OS'es is 2 GB, video editors have
that problem, thats why some implement their own filesystems.
Ralf R. K
om: Chris Murley [SMTP:[EMAIL PROTECTED]]
> > Sent: Friday, January 12, 2001 12:54 PM
> > To: [EMAIL PROTECTED]
> > Subject:The scaling question?
> >
> >
> > I know everyone on this list has discussed scaling over and over.
> >
> > I am
anuary 12, 2001 12:54 PM
> To: [EMAIL PROTECTED]
> Subject: The scaling question?
>
>
> I know everyone on this list has discussed scaling over and over.
>
> I am only in a need of a simple anwser.
>
>
> Can mysql handle a database with 20,000,000 records?
> Subject: The scaling question?
>
>
> I know everyone on this list has discussed scaling over and over.
>
> I am only in a need of a simple anwser.
>
>
> Can mysql handle a database with 20,000,000 records?
>
> There will be several tables(about 10) each with
I know everyone on this list has discussed scaling over and over.
I am only in a need of a simple anwser.
Can mysql handle a database with 20,000,000 records?
There will be several tables(about 10) each with no more that 4 columns.
In each table there will be 20 million records. These
37 matches
Mail list logo
