HI Peter:
Thanks for your answer. I have understand your answer. Thank you very
much.
――
Best regards
Timo Seven
blog: http://zauc.wordpress.com
#请翻墙浏览，或者指定hosts到74.200.243.252###
UNIX System Admin
2010/3/23 Peter Zaitsev
> Hi,
>
> Lets see If I can help.
Hi,
Lets see If I can help.
Overly long queries (transactions
> in general) are bad for performance as a lot of unpurged versions
> accumulate.
>
> In this sentence, I don't know the meaning about 'unpureged version
> accumulate'
>
When rows are updated new versions are created. They are later
Hi everyone:
I read the presentation about InnodDB performance optimization what
Heikki Tuuri written in april23 2007.
But now I have some sentences don't know how to understanding. Can you help
me?
Overly long queries (transactions
in general) are bad for performance as a lot of unpurged v
Hi Catalin,
Here are some InnoDB performance tuning tips that may boost
your insert speed:
Catalin Trifu wrote:
...
innodb_buffer_pool_size = 256M
Higher is better, in fact pushing this up to 60%-80% on a
dedicated database would be good. If there are other things
running like a web server
On Fri, 2005-07-15 at 13:28 -0700, David Griffiths wrote:
>
David,
Thanks for your suggestions, i'll give them a try.
> There are other tuning choices (including the thread-pool-cache). The
> best resource is the page on innodb performance tuning, and it can be
> foun
ead_buffer_size+binlog_cache_size) +
max_connections*2MB
You should make sure that stays under 2 gigabytes. If MySQL uses much
more memory, it will crash.
There are other tuning choices (including the thread-pool-cache). The
best resource is the page on innodb performance tuning, and it can be
fou
Hi David,
On Fri, 2005-07-15 at 10:25 -0700, David Griffiths wrote:
> Tony,
>
> " - not sure what version you are using
4.1.11. Server is a duel xeon machine with 4gb or ram running mysql and
apache webserver and not much else.
You should have used
> my-innodb-heavy-4G.cnf as the starting p
Tony,
You said that you copied the my.cnf file from "huge.cnf" - not sure what
version you are using (I missed your original post), but the my-huge.cnf
in mysql 4.0.24 is for MyISAM. You should have used
my-innodb-heavy-4G.cnf as the starting point for an InnoDB system. The
my-huge.cnf alloc
Hi,
A few days ago i posted a quaestion about performace, I now have a
little more info, hopefully someone can help.
I have a table, tblShoppingCart with 3 fields,
cartUid (int 11 auto increment)
userUid (int 11, indexed)
strCartHash (varchar 32)
The table is innodb
Nomally my server load i
Hello.
A lot of statistics you could get from 'SHOW INNODB STATUS'.
For example 'FILE I/O', 'INSERT BUFFER AND ADAPTIVE HASH INDEX',
'BUFFER POOL AND MEMORY' could be helpful. See:
http://dev.mysql.com/doc/mysql/en/innodb-monitor.html
Manoj <[EMAIL PROTECTED]> wrote:
> Greetin
Greetings,
I am using MySQL 4.0.24 and all my tables use InnoDB as default
engine. I was interested in finding out the performance of my Buffer
space. How can i do it?. If I were to use MyISQM tables, I could have
looked at the parameters Key_read_request & key_reads to find out the
hit rate b
From: "David Lloyd"
> journalling file system. It's not always that clear cut. I've just
> switched a number of big customer databases to InnoDB and noone's
> noticed any difference - if anything it's going faster.
For small tables (<50,000 records) MyISAM is usually a lot faster. However,
MyISAM
Eko and all,
> >The MyIsam storage engine is a non transactional engine and InnoDb is
> >a transactional engine. That is the main difference. So I think the
> >MyIsam engine should be faster.
However, some file systems that have journals are faster than non
journalling file system. It's not alw
see this link
http://dev.mysql.com/doc/mysql/en/ansi-diff-transactions.html
Reto
Eko Budiharto wrote:
The MyIsam storage engine is a non transactional engine and InnoDb is a
transactional engine. That is the main difference. So I think the MyIsam
engine should be faster.
what is transactional mea
>The MyIsam storage engine is a non transactional engine and InnoDb is a
>transactional engine. That is the main difference. So I think the MyIsam
>engine should be faster.
what is transactional mean?
-
Do you Yahoo!?
Yahoo! Small Business - T
Hello.
Send the piece of 'SHOW PROCESSLIST', 'SHOW STATUS' output and
corresponding configuration file (after applying all previous advices).
It could provide more information to reflection.
Marcin Lewandowski <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I've got webserver. There, I've got p
Jocelyn Fournier napisał(a):
Hi,
What about using another forum ?
phpbb2 is well known to be far for what could be called "optimized" :)
I hate phpbb, but currently we can't change it :(
--
Marcin Lewandowski
[ mailto:[EMAIL PROTECTED] gg:188068 jid:[EMAIL PROTECTED] ]
[ http://www.nosoftwarep
kup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
Order MySQL Network from http://www.mysql.com/network/
- Original Message -
From: "Marcin Lewandowski" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, Ap
Marcin Lewandowski wrote:
> Hi,
>
> I've got webserver. There, I've got phpbb2 with circa 6000 users
> (average 70-100 users online). There was problems with locking or
> something else, when phpbb was using myisam tables. Yesterday, we have
> converted tables to innodb, because it should be more
> I've got IDE hdd. Is there simple way to check, if it's overloaded?
> Would RAID1 help? (I don't know if in raid1 there are parralel reads or
> maybe one disk is only a mirror)
If it's IDE, probably not. Moving the database to a different
subsystem would give more IO. You can use iostat to check
Gary Richardson napisał(a):
Hey,
How much load is system vs user? I found that when my company
converted some large tables on our old server, the concurrent disk IO
increased. Your database server is doing more in parallel and
accessing more from your disk at one time. That would be my guess.
One o
I've changed settings to:
innodb_data_file_path = ibdata1:128M:autoextend
innodb_buffer_pool_size=150M
innodb_additional_mem_pool_size = 50M
and system load is "only" 2 to 3.
kernel napisał(a):
What does the cpu % show when the machine has the high load avg ?
Now, there are about 50% of normal lo
Marcin Lewandowski wrote:
Hi,
I've got webserver. There, I've got phpbb2 with circa 6000 users
(average 70-100 users online). There was problems with locking or
something else, when phpbb was using myisam tables. Yesterday, we have
converted tables to innodb, because it should be more effective.
The MyIsam storage engine is a non transactional engine and InnoDb is a
transactional engine. That is the main difference. So I think the MyIsam
engine should be faster.
Try to adjust the "innodb_thread_concurrency" parameter when you have a
lot of users.
Reto
Marcin Lewandowski wrote:
Hi,
I'v
Hi,
I've got webserver. There, I've got phpbb2 with circa 6000 users
(average 70-100 users online). There was problems with locking or
something else, when phpbb was using myisam tables. Yesterday, we have
converted tables to innodb, because it should be more effective. Since
then we have high
Marcin Lewandowski <[EMAIL PROTECTED]> wrote on 02/08/2005 05:29:39 PM:
> Chuck Herrick napisał(a):
> > 200 - 400 tables is too many.
>
> Is it too many for merge, innodb or both?
>
> > Try having one CUSTOMERS table. You know who is logged in, so you can
> > use that information in a WHERE clau
Chuck Herrick napisaÅ(a):
200 - 400 tables is too many.
Is it too many for merge, innodb or both?
Try having one CUSTOMERS table. You know who is logged in, so you can
use that information in a WHERE clause.
Yes, but If somebody would find a password (maybe using brute-force
attack) to one account
Hi,
I'm writing an windows app, which would connect to mysql server and
modify user's data. There would be a few hundred of users. Every of them
should have access only to few tables. It's not a problem with mysql's
authentication mechanism.
Kind of compilation of the data from users' tables sh
: "DuffMan" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, July 24, 2003 5:07 AM
Subject: Poor InnoDB Performance
> I converted 3 of 30 MyISAM tables to InnoDB. Since
> then I have been constantly reaching my limit of 100
> connections because Selects on the
I converted 3 of 30 MyISAM tables to InnoDB. Since
then I have been constantly reaching my limit of 100
connections because Selects on the InnoDB tables are
slow.
If I cut off traffic and execute a SELECT, it takes
less than 0.01 seconds. If a execute the exact same
query again with traffic, it ta
Nicholas,
- Original Message -
From: ""Nicholas Elliott"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, July 11, 2003 6:04 PM
Subject: InnoDB Performance issues
> --=_NextPart_000_003B_01C3479C.77A1AB60
> Content-Type: t
Hi Nicholas,
How about storing the BLOBS outside of the DB and refering to them ?
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 12日 土曜日 00:06、Nicholas Elliott さんは書きました:
> Hey all,
>
> I've been experimenting with the best way to store a large (~100GB) of data
> for retrieval. Essentially, I'
ED]>
To: "Nicholas Elliott" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, July 11, 2003 11:29 AM
Subject: Re: InnoDB Performance issues
> In the last episode (Jul 11), Nicholas Elliott said:
> > I've been experimenting with the best way to store a l
In the last episode (Jul 11), Nicholas Elliott said:
> I've been experimenting with the best way to store a large (~100GB)
> of data for retrieval. Essentially, I'm storing 9 variables for
> approximately 1,000,000 locations a day for the last ten years. This
> can work out at around 4MB a variable
Hey all,
I've been experimenting with the best way to store a large (~100GB) of data for
retrieval. Essentially, I'm storing 9 variables for approximately 1,000,000 locations
a day for the last ten years. This can work out at around 4MB a variable a day - but
not all variables are always presen
sql,query
At 15:50 -0600 10/25/02, Jeff Mathis wrote:
Paul DuBois wrote:
>(2) drop all indexes on your table(s). rebuild them after loading (this
>alone can give orders of magnitude improvement)
For ISAM or MyISAM, that works. It has no effect for InnoDB.
Do you actually observe a rep
In the last episode (Oct 25), Jeff Mathis said:
> I'll agree to this somewhat:
>
> (1) always bind your variables. whatever code you are using to do your
> inserts, the fewer prepared statements you can make the better.
>
> for example:
> insert into TableName (col1, col2, col2, col4) values (?,?
David Lloyd wrote:
Mark,
Note that mysql does not support bind variables. If you think
you're>using them, whatever API you are using is filling them in
before>sending the statement to mysql. Bind variables do solve
quoting>problems, though, so if you use them, know why you're using
them :)>
At 15:46 -0600 10/25/02, Jeff Mathis wrote:
forgive me.
i was initially using the perl DBI methods to load. I am not intimately
familiar with the inner workings of DBI, but obviously it must be doing
something if you say mysql does not support binding variables
(i am using 4.0.4). This is signifi
Mark,
> >>Note that mysql does not support bind variables. If you think
> >you're>using them, whatever API you are using is filling them in
> >before>sending the statement to mysql. Bind variables do solve
> >quoting>problems, though, so if you use them, know why you're using
> >them :)>
Rumou
Jeff Mathis wrote:
forgive me.
i was initially using the perl DBI methods to load. I am not intimately
familiar with the inner workings of DBI, but obviously it must be doing
something if you say mysql does not support binding variables
(i am using 4.0.4). This is significantly faster than creati
forgive me.
i was initially using the perl DBI methods to load. I am not intimately
familiar with the inner workings of DBI, but obviously it must be doing
something if you say mysql does not support binding variables
(i am using 4.0.4). This is significantly faster than creating a new
prepared st
Jeroen Geusebroek wrote:
[snip]
You where right, what i did use indivudual inserts. Now I have it
segmented in 1000 rows in one query which massively speeds up the whole
inserting progress. 160K records now takes about 20 seconds instead of
the 100 records ;) I'm really impressed by this massive s
_field2),(?,?),(?,?) etc etc
>
> Ric.
>
> - Original Message -
> From: "Jeroen Geusebroek" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, October 25, 2002 12:11 PM
> Subject: Mysql Innodb performance slow
>
> Hi There,
>
> We ha
why the isam table takes about 100
seconds for inserting 160K rows, while innodb takes 700 seconds. (using
individual inserts)
Thanks,
Jeroen
> -Original Message-
> From: Jeroen Geusebroek [mailto:j.geusebroek@;infraxs.com]
> Sent: Friday, October 25, 2002 3:11 AM
> To
ginal Message -
From: "Jeroen Geusebroek" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 25, 2002 12:11 PM
Subject: Mysql Innodb performance slow
Hi There,
We have currently an Interbase Database with millions and millions of
rows which I would
Hi There,
We have currently an Interbase Database with millions and millions of
rows which I would like
to migrate to MySQL if possible to increase the speed.
Transaction support is necessary, so I am using innoDB.
When inserting 160K rows in the database (in an innoDB table) it takes
about 700
Jungshu,
- Original Message -
From: ""Heo, Jungsu"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Monday, October 07, 2002 5:49 AM
Subject: InnoDB Performance Question.
> Hello everyone.
>
> I'm working on migrating Oracle to MySQL
Hello everyone.
I'm working on migrating Oracle to MySQL 4.0.3
MySQL works on Redhat 7.3 and Pentium 550Mhz with 256 Mb RAM.
Our application need Transactions, so I decided to use InnoDB.
But, InnoDB is slower than I expected.
-
mysql> SELEC
Richard,
I calculate 430 s / 116 s = 3.7, not 7 :).
Last time you had extremely slow execution probably
because of fsync. Obviously the doublewrite method
has fixed it, since the performance is not that bad any
more. Linux kernel 2.4 might be better.
Remember that MyISAM uses the file cache of
Though i would give Innodb another go with the latest mysql-max RPM's (3.23.41) for
linux running on a Redhat machine. This is on a Compaq ML-370, 667Mhz with 1gig mem on
kernel 2.2.19. Disks are Raid-5. Huge performance difference between Innodb and MyISAM
for a simple table create (7 times sl
51 matches
Mail list logo
