ould I add a autoincremented
> > primary key?
>
> > 4. Is it better to have a seperate table for this or, is it better to
> > update my existing table, and add a blob column. Does it matter in terms
> > of speed of queries?
>
> > Queries will be done via php.
>
n. Does it matter in terms
of speed of queries?
Queries will be done via php.
Thanks!
Pete
--
___
Pete Kuczynski
Sr. Field Engineer
DHL Airways Inc.
Infrastructure Technology & Services
(773)-462-9758
24/7 Helpdesk
Hi,
since Nusphere release the source code for gemini yesterday I believe it
was, I was wondering if Mysql AB was going to incorporate it into a
future release if it's database.
I realise in light of recent .org events
Pete
--
___
Pete Kuczyns
aste the above to your my.cnf
> and adjust directories, file sizes, and pool sizes to your needs. Files must
> be
> < 4 GB currently.
>
> Hope it now succeeds!
>
> Heikki
>
> -Original Message-
> From: Pete Kuczynski <[EMAIL PROTECTED]>
> To: He
gt; > set-variable = innodb_file_io_threads=4
> > set-variable = innodb_lock_wait_timeout=50>
> > Then you use mysql\bin\mysqld-max-nt --install to install it as a service.
> > You can run SHOW VARIABLES to see the which table types are available.>
> > That's
set-variable = innodb_additional_mem_pool_size=10M
> > set-variable = innodb_file_io_threads=4
> > set-variable = innodb_lock_wait_timeout=50>
> > Then you use mysql\bin\mysqld-max-nt --install to install it as a service.
> > You can run SHOW VARIABLES to see the which tab
t find any documentation on instaling mysql on NT with InnoDB
> "compiled" in. Is there such a thing? Where?
> Bottom line, how do I get InnoDB "compiled" in with a standard mysql
> database installation. All I want out of this is transaction support.
>
&g
Thanks Monty!
will this work on NT as well? or do I need to move to Linux.
I don't much care if the tables are BDB or InnoDB, just that I have
transaction support.
Good luch with the Nusphere thing!
Pete
Michael Widenius wrote:
>
> hi!
>
> >>>>> "Pete
on on instaling mysql on NT with InnoDB
"compiled" in. Is there such a thing? Where?
Bottom line, how do I get InnoDB "compiled" in with a standard mysql
database installation. All I want out of this is transaction support.
Best Rgards!
Pete
_______
Hi,
I understand mysql supported InnoDB and BDB table types for the purposes
of transaction logging, which I need to use.
Which is recommended by you folks for NT4 boxes.
Pete
___
Pete Kuczynski
Sr. Field Engineer
DHL Airways Inc.
Infrastructure Technology
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
___
Pete Kuczynski
Sr. Field Engineer
DHL Airways Inc.
Infrastru
.com/doc/S/E/SET_TRANSACTION.html
>
> Regards,
> --
> Don Read [EMAIL PROTECTED]
> -- It's always darkest before the dawn. So if you are going to
>steal the neighbor's newspaper, that's the time to do it.
--
___
nt on transactions. The rest of us, however, can
> usually live without 'em.
--
> Hi Pete
> To emable logging use the --log option eg --log-update when stating the
> server...
>
> Simon
___
Pete Kuczynski
Sr. Field Engineer
DHL Airways Inc.
rently it's in d:\mysql\bin
Pete
Original Message
Subject: RE: backup/restore of mysql
Date: Tue, 10 Jul 2001 17:48:31 +0100
From: Simon Green <[EMAIL PROTECTED]>
To: "'Pete Kuczynski'" <[EMAIL PROTECTED]>
Hi Pete
To emable loffing use the --
Very cool.
Thaks very much Simon!
Pete
Simon Green wrote:
>
> Hi Pete
> To emable loffing use the --log option eg --log-update when stating the
> server...
>
> Simon
>
> -Original Message-
> From: Pete Kuczynski [mailto:[EMAIL PROTECTED]]
> Sent: 10 Jul
atabase
recovery in the event of a crash.
Kindest thanks!
Pete
--
___
Pete Kuczynski
Sr. Field Engineer
DHL Airways Inc.
Infrastructure Technology & Services
(773)-462-9758
24/7 Helpdesk 1-800-434-5767
--
between the time of the
backup and the crash?
Thanks for any help!
Pete
--
___
Pete Kuczynski
Sr. Field Engineer
DHL Airways Inc.
Infrastructure Technology & Services
(773)-462-9758
24/7 Helpdesk 1-800-434-
>From what I can tell, Mysql does NOT support transaction logging, at
> least not for NT.
>
> Can anyone help, if transactions are not supported, how are those folks
> that have mysql running on NT, restoring a database?
> I'm using Mysql version 3.23.27.
>
> Thanks!
cen tell, Mysql does NOT support transaction logging, at
least not for NT.
Can anyone help, if transactions are not supported, how are those folks
that have mysql running on NT, restoring a database?
I'm using Mysql version 3.23.27.
Thanks!
Pete
_______
Pete
067: The process terminated unexpectedly.
>
>I have tried to remove the service, uninstalled the mysql and reinstalled it. I
>got the same result.
>
>Any help would be appreciated.
>
> Regards,
> Michael
--
___
Pete Kuczynski
ECTED]>
> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> > --
> > Joshua Kugler, Information Services Director
> > Associated Students of the University of Alaska Fairbanks
> > [EMAIL PROTECTED], 907-474-7601
> >
>
I can't seem to find any documentation on how to set this up an a
windowz box.
Can anyone help?
Pete
Gerald Clark wrote:
>
> Run your transaction log against the restored database.
>
> Pete Kuczynski wrote:
>
> > Hoping someone can point me in the right directio
Pete
___
Pete Kuczynski
Sr. Field Engineer
DHL Airways Inc.
Infrastructure Technology & Services
(773)-462-9758
24/7 Helpdesk 1-800-434-5767
-
Before posting, please check:
http://www.
r them
out.
Thanks for any insight in advance!
Pete
--
___
Pete Kuczynski
Principal Field Engineer
DHL Airways Inc.
Infrastructure Technology & Services
(773)-462-9758
24/7 Helpdesk 1-800-434-5767
--
PM -0500 6/27/01, Pete Kuczynski wrote:
> >Thanks Paul!
> >ps works great!
> >I modified the database with a UNIQUE column like you recommended
> >earlier, this will now help in the PHP script to trap the duplicate
> >entry and advise the user of the dup.
>
> B
no insert
if (mysql_num_rows($result) != 0) {
echo "error";
} else {
// DO INSERT
}
?>
Pete
Paul DuBois wrote:
>
> At 3:13 PM -0500 6/27/01, Pete Kuczynski wrote:
> >Hi,
> >How wou
--
___
Pete Kuczynski
Principal Field Engineer
DHL Airways Inc.
Infrastructure Technology & Services
(773)-462-9758
24/7 Helpdesk 1-800-434-5767
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
le
to connect ..."
I suspect I cannot, but some insight into this would help.
Thanks!
Pete
--
___
Pete Kuczynski
Principal Field Engineer
DHL Airways Inc.
Infrastructure Technology & Services
(773)-462-9758
24/7 Helpdesk
g staff?
>
> I am a Sr. SUN Solaris Engineer with more than 10years experience if that
> helps at all. Good luck with your work.
>
> Kris-
>
> _
> Get your FREE download of MSN Explorer at http://explor
Home
___
Pete Kuczynski
Principal Field Engineer
DHL Airways Inc.
Infrastructure Technology & Services
(773)-462-9758
24/7 Helpdesk 1-800-434-5767
-
Be
ysql.com/manual.php (the manual)
>http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/ph
31 matches
Mail list logo
