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 qu
t our web sites and its slower than the 5.1 server.
Any suggestions, anything I should change on the 5.5 server? The hardware and
OS is identical from the 5.1 server. Thanks!
Alvin Ramos
From: w...@pythian.com [mailto:w...@pythian.com] On Behalf Of Singer X.J. Wang
Sent: Tuesday, August 1
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, Pra
to see what was going on.
Under the column "State" I saw the value "copying to tmp table" which
lasted a good 6 seconds. So I'm thinking that the copying to tmp table is
slowing down the query - but I don't know why.
I think I'm not the only
e codes to connection and open
the database for mySQL using myODBC??
I have already setup myODBC and tested the data source. It works! :P
Please help!
Thanks!
alvin
-
Before posting, please check:
http://www.mysql.com/manual.
be due
to the Access database.
Can anyone please advise how i could go abt it and what are the things i
should look out for?
Can i just install myODBC and export Access database to mySQL? Not sure how
to do that too...
Please he
cate the config.log
file in my system. If you need more informations, pls let me know.
Thanks.
Alvin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
t;
> A "tbl" reference is at
> http://www.primate.wisc.edu/software/troffcvt/tbl.html.
This question strikes a chord with me also. I started looking to see if
there is any Perl modules/Bundles/Packages for generating postscript
reports.
What I have found is fairly prima
EATE privileges (FILE privileges are not needed, If I am
> not mistaken).
If you can without becoming the "mysql user" and running a shell do what
you want. then you have found a real MySQL bug. For example try t
f the wan
try and only run actions where the time of trasmission is much less than
the time to perform the transaction. You may want to think about keeping
a local database for more transient or time-critical information.
--
Alvin Starr || voice: (416
10 matches
Mail list logo
