Thanks for the suggestions. I will change the tables to in innodb and change my
php coding. Then I will revisit the benchmarking with hopefully improving
results. Thanks again!
Regards,
Alvin
On Aug 16, 2011, at 7:57 PM, Johnny Withers wrote:
> This is a poor benchmark because the query never
This is a poor benchmark because the query never changes. Query cache takes
over after first request.
Sent from my iPad
On Aug 16, 2011, at 4:28 PM, "Alvin Ramos" wrote:
> I know my previous email was vague, it was sent via smartphone. I’ve got a
> simple PHP page pulling information from o
you noticed that most optimizing in 5.5 affects InnoDB
and if you are using MyISAm in your benchmark it
is useless?
having MySQL 5.5 running on InnoDB with some GB big tables
and REALLY concuerrent load as for a mailserver (dbmail)
you will notice a hughe performance increasment
Am 16.08.2011 23:
I know my previous email was vague, it was sent via smartphone. I’ve got a
simple PHP page pulling information from one of larger database tables:
PHP Code:
0)
{
// yes
// iterate through result set
// format query results as table
ech
I've been running some bench marking between 5.1 and 5.5 myself and haven't
notice any huge performance improvements on 5.5. Even though white papers claim
it put performs 5.1. Any noticing the same or have some input in my findings?
Regards,
Alvin
On Aug 16, 2011, at 3:55 PM, Prabhat Kumar wr
correct. you have to understand the problem first.
but still its recommendable to always use latest stable version.
On Tue, Aug 16, 2011 at 10:02 AM, Reindl Harald wrote:
>
>
> Am 16.08.2011 17:59, schrieb Luis Daniel Lucio Quiroz:
> > as far as my readings, they claim that 5.5 is the best
> >
>
s proud to announce the next
> version of the popular multi-DBMS development tool:
>
> " Database Workbench 4.1.3 Pro "
>
> This release includes the FREE Lite versions for InterBase, Firebird
> and MySQL.
>
>
> For more information, see http://www.upscene.
Am 16.08.2011 17:59, schrieb Luis Daniel Lucio Quiroz:
> as far as my readings, they claim that 5.5 is the best
>
> my question is, shall i jump from 5.1 to 5.5.
>
> right now i have a performance problem, would 5.5 help me in that?
>
> Regards,
>
> LD
>
why do you believe without any information
as far as my readings, they claim that 5.5 is the best
my question is, shall i jump from 5.1 to 5.5.
right now i have a performance problem, would 5.5 help me in that?
Regards,
LD
rebird
and MySQL.
For more information, see http://www.upscene.com/go/?go=news&id=20110816
For a full list of fixes in this release, see:
http://www.upscene.com/go/?go=tracker&v=4.1.3&id=3
Database Workbench supports:
- Borland InterBase ( 4.x - XE )
- Firebird ( 1.x, 2.x )
-
在 2011-08-16二的 16:18 +0800,linshengke写道:
> hi all,
> hear is basic information
>
> [root@localhost mysql-5.5.15]# uname -a
> Linux localhost.localdomain 2.6.18-128.el5 #1 SMP Wed Jan 21 10:44:23 EST
> 2009 i686 i686 i386 GNU/Linux
>
> [root@localhost mysql-5.5.15]# rpm -qa | grep gcc
> libgcc-4.
hi all,
hear is basic information
[root@localhost mysql-5.5.15]# uname -a
Linux localhost.localdomain 2.6.18-128.el5 #1 SMP Wed Jan 21 10:44:23 EST 2009
i686 i686 i386 GNU/Linux
[root@localhost mysql-5.5.15]# rpm -qa | grep gcc
libgcc-4.1.2-50.el5
gcc-c++-4.1.2-50.el5
gcc-4.1.2-50.el5
[root@loc
12 matches
Mail list logo