HI, Folks:
Can Isolation levels be set per transaction? I know isolation levels can be
set per session or globally, but not sure at transaction level.
if so , can anybody give me an example?
Thanks a lot
Hi, Folk:
I have two questions about the DBA certification exam:
1.how many questions ?
2: how long is the exam?
3.what's the pass score?
I could not find the answers on mysql web
anybody knows?
Thanks a lot
There is almost no VM overhead these days. mySQL is disk I/O bound, not CPU
bound.
With VMWare you can setup your partitions to be raw disks (not virtual disk
files) so you get native I/O. If you were to get some SSD's, I bet you
would even see some significant performance increase too even over a
Hi Jerry,
let's say that support for agents on windows I leave it for later versions.
Seriously, apart from the certification books I never encountered one
windows installation based on named pipes in 9 years.
I would consider quite safe non supporting windows named pipes at this
stage.
thanks fo
Just know that there is not-a-problem in running multiple instances on the
same host,
then all you have to do is to evaluate the performance factor.
In your case I would not introduce the overhead of the VMs,
but take advantage of this to learn how to manage multiple instances on the
same host that
Do you have to worry about named pipes?
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
E-mail: je...@gii.co.jp
Web site: www.the-infoshop.com
>-Original Message-
>From: Claudio Nanni [mailto:claudio.na..
i would use virtual machines because port/socket/configuration
after running our whole infrastructure on vmware i can not understand
how i could live without machine-snapshots and auto-failover :-)
on hardware with virtualization support performance is also
not a problem and ESXi is free without
I've always had a single physical server that is the qc mysql database for
all our applications but it's now up to 85 schemas so I want to break it up
along the same lines as production (where there's redundant pools of mysql
servers by application class).
my basic question is whether it's better
Hi Steve,
Thanks for your tip.
It's not a cluster,
I am building a tool to monitor mysql performances and this information(*IP*)
is required in a stored procedure on the mysql-agents installations.
Being it possible to have multiple mysql instances on the same server the
only unique identifier wo
On Thu, 2011-03-03 at 13:43 -0600, Chris W wrote:
>
> On 3/2/2011 5:59 PM, Reindl Harald wrote:
> > Am 03.03.2011 00:31, schrieb Claudio Nanni:
> >> Anyone knows how to get the server* IP address* thru SQL?
> > no, because it is nonsense and has nothing to do with a db-server
> >
> > if you connec
On 3/2/2011 5:59 PM, Reindl Harald wrote:
Am 03.03.2011 00:31, schrieb Claudio Nanni:
Anyone knows how to get the server* IP address* thru SQL?
no, because it is nonsense and has nothing to do with a db-server
if you connect via tcp you know the ip
Isn't that kind of like going to someone
11 matches
Mail list logo