According to the documentation, when delay_key_write is active the index
keys aren’t written to disk until the table(s) are closed. When is a table
closed? Is it only when a connection is closed?
Thank you,
Dan
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system
Is there any harm in using the USE_FRM directive by default whenever
repairing a table?
Thanks,
Dan
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.703 / Virus Database: 459 - Release Date: 6/10/2004
Hello,
I have a client that can connect to either a local or remote MySQL server.
LOAD DATA INFILE works fine on a local server, but obviously fails when a
remote server is used. When I add LOCAL to the command, I get: The used
command is not allowed with this MySQL version
I am using
Hello,
I have a client that can connect to either a local or remote MySQL server.
LOAD DATA INFILE works fine on a local server, but obviously fails when a
remote server is used. When I add LOCAL to the command, I get: The used
command is not allowed with this MySQL version
I am using 4.0.18.
I’ve recently started getting an error:
file '.\newsman\messages.MYD' not found (Errcode: 22)
but when I check the database, the file is there and it is OK. I’ve
repaired and optimized it, but no change. What is the root cause of this
error and what should I do to fix it?
Th
MySQL is installed as a service running locally. Also, this error occurs
with version 3.23.53 onwards (I never tested on older versions than
this).
Thanks,
Dan
-Original Message-
From: Dan Cumpian [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 10:27 PM
To: [EMAIL PROTECTED
olve this
issue?
Thank you,
Dan Cumpian
this?
Thanks,
Dan Cumpian
Hello,
I've been running mysqld-nt on W2K and WinXP for awhile now (using
MyISAM tables) and I'm a bit confused by what's in the "max" binary. Is
the biggest difference InnoDB tables?
Thank you,
Dan Cumpian
---
component you added earlier. Finally, drop a ZMySQLQuery component, set
the database property, and then use the ZMySQLQuery as you would a
normal TQuery.
That's the basics...
HTH,
Dan Cumpian
-Original Message-
From: Crescendo Napitupulu [mailto:[EMAIL PROTECTED]
Sent: Monday, Feb
more than one XP Pro setup and have seen the same
results.
MySQL versions: 3.23.52, 3.23.53, 3.23.54
Database connection is using Zeos Database Objects through a Delphi
application. The application has five separate database connections
each in individual threads.
Thank you,
Dan Cumpian
Well, I knew that, but I wondered if using an OPEN would solve the
problem. Does anyone know of a workaround for the "out of sync" error?
Thanks,
Dan Cumpian
-Original Message-
From: Steve Yates [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 06, 2003 10:22 AM
To: [EMAIL
the
tables).
3) Should I do a CHECK TABLE before I do an OPTIMIZE TABLE?
Thanks,
Dan Cumpian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archi
the
tables).
3) Should I do a CHECK TABLE before I do an OPTIMIZE TABLE?
Thanks,
Dan Cumpian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archi
r "INSTALLERS DELPHI" and you should turn it up.
HTH,
Dan Cumpian
-Original Message-
From: Frank Marousek [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 5:03 PM
To: [EMAIL PROTECTED]
Subject: Re: Suitability of mySQL for desktop use?
Dan,
I don't believ
Actually, I think the behavior comes from the components used to connect
to MySQL. Delphi doesn't really care one way or the other.
Dan Cumpian
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 1:41 PM
To: [EMAIL PROTECTED]
Cc
even tell that MySQL is running.
HTH,
Dan Cumpian
-Original Message-
From: Frank Marousek [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 3:57 PM
To: [EMAIL PROTECTED]
Subject: Suitability of mySQL for desktop use?
How suitable is mySQL for use in a desktop application i.e
Linux box, is whether the problem is OS related. In any case, I found
that I couldn't create data structures in the same way as on MSSQL.
HTH,
Dan Cumpian
-Original Message-
From: Joseph Dietz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 1:40 PM
To: [EMAIL PRO
essed yet, then they may show up as modified in your outer query
because (depending on how you are connecting to the database) the server
only returns several hundred rows at a time and caches them as you go
through the record set. But that doesn't sound like it will impact you.
HTH,
D
he ZeosLib
components for Delphi.
Does anyone know what could cause this to happen?
Thanks,
Dan Cumpian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list ar
Michael,
If the database is twice the size, how will that affect performance? I
don't use full-text searches, so that shouldn't be a problem.
Thanks,
Dan
-Original Message-
From: Michael T. Babcock [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 10:28 AM
To: [EMAIL PROTECTE
tables support (query-wise, like
INSERT DELAYED), that is not supported by InnoDB that I might need to
look out for in my application(s)?
Thanks,
Dan Cumpian
-
Before posting, please check:
http://www.mysql.com/manual.php (the
: 3.23.52-nt
Thanks for any advice
Dan Cumpian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EM
I've been running MySQL on Windows 2000 and Windows XP as local services
on my DESKTOP, (I know, I know) without any problems. In fact, I hardly
even know that the services are running except when I process a large
chunk of data...
Dan Cumpian
-Original Message-
From: John Ragan [m
,
Dan Cumpian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscr
25 matches
Mail list logo