Re: shall i jump from 5.1 to 5.5

2011-08-16 Thread Alvin Ramos
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

Re: shall i jump from 5.1 to 5.5

2011-08-16 Thread Johnny Withers
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

Re: shall i jump from 5.1 to 5.5

2011-08-16 Thread Reindl Harald
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:

RE: shall i jump from 5.1 to 5.5

2011-08-16 Thread Alvin Ramos
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

Re: shall i jump from 5.1 to 5.5

2011-08-16 Thread Alvin Ramos
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

Re: shall i jump from 5.1 to 5.5

2011-08-16 Thread Prabhat Kumar
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 > > >

RE: Database Workbench 4.1.3, the multi-DBMS IDE now available!

2011-08-16 Thread Daevid Vincent
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.

Re: shall i jump from 5.1 to 5.5

2011-08-16 Thread Reindl Harald
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

shall i jump from 5.1 to 5.5

2011-08-16 Thread 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

ANN: Database Workbench 4.1.3, the multi-DBMS IDE now available!

2011-08-16 Thread Martijn Tonies
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 ) -

Re: build mysql 5.5.15 err

2011-08-16 Thread Sharl.Jimh.Tsin
在 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.

build mysql 5.5.15 err

2011-08-16 Thread 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.1.2-50.el5 gcc-c++-4.1.2-50.el5 gcc-4.1.2-50.el5 [root@loc