Hi there,
I have just upgraded my Win98SE to Win2K and ever since, I could not start Mysqld or
Mysqld-nt (with or without the --install option). I am using Mysql 3.23.30-gamma-win
version.
I am new to Mysql and would appreciate any help from you.
Thank you and regards,
CT Chang
On 06.02.2001 18:09:36 russ wrote:
> Im new to the list, apologies if this has been asked before.
>
> Im developing a backend for a personal site (www.russd.com) using mySQL.
> The site is hosted on NT4 and has myODBC installed, I have some database
access
> working, but I'm looking for a way to
Many thanks to all for the help on this issue.
I've come to the conclusion the simplest way for me to implement this is to use the
ENUM type with two possible values 'True' and 'False'.
I will convert the VB BOOLEAN type to a string before I enter it.
Thankfully when returning a value from mySQL
Hi all,
I have been playing with perl and mysql on debian linux and its now
cooking on gas and I love it thanks to all of you for your help
Well off topic I know, but whilst on this list last time I met some perl
Guru's and once again I need their "Your" help.
I want to write a cgi per
Hello,
I have two tables:
CREATE TABLE categories (
CategoryNumber int(11) NOT NULL,
ItemNumber int(11) NOT NULL,
KEY CategoryNumber (CategoryNumber),
KEY ItemNumber (ItemNumber)
);
CREATE TABLE items (
ItemNumber int(11) NOT NULL auto_increment,
Description varchar(100) NOT
On Tue, Feb 06, 2001 at 12:47:20PM -0800, John Jung wrote:
> Hi All,
>
> I'm trying to port MySQL 3.22.32 to HPUX 10.20 and am encountering some
> problems. I'm on an HPUX 10.20 box with GCC 2.95.2, the configure script
> works fine when I build I get:
>
> mysqld.cc: In function `void close_c
Dear Sir
I am new to MySQL. I've created a table with three keys inside like this:
CREATE TABLE reservation
(
reservation_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
hotel_id INT UNSIGNED NOT NULL,
customer_id INT UNSIGNED NOT NULL,
PRIMARY KEY(reservation_id, hotel_id, customer_id),
I use a short (0 unchecked, 1 checked).
Pat...
- Original Message -
From: "John Halladay" <[EMAIL PROTECTED]>
To: "MySQL List (E-mail)" <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 4:57 PM
Subject: MS Access Checkbox equivalent format in MySQL
> If I am using MS Access and link
Hi there,
suppose I have table table1 with columns col1,col2,col3,col4
I would like to set up a query that omits eg. col1 from the output even
though col1 must satisfy some condition:
SELECT col2,col3,col4 from table where col1=condition
Any suggestions ?
Thanks in advance
A.Hannemann
-
>Bob Hall wrote:
> >
> > >I want to do a select like
> > >
> > >select id from test
> > >where id in (select id from test where value in (1,2,3)
> > >and id in (select id from test where value in (4,6,7)
> > >and id in (select id from test where value in (1,6,25)
> >
> > Even if MySQL sup
>Hi,
>
>I hope that someone can help me with a SQL statement.
>
>I dont know if this is the right place to ask the question, if not
>please redirect me.
>
>I have a table in my MySQL database named "data" with the following fields
>
>date: UNIX Timestamp
>Datasize : Int
>
>now i would lik
Thanks for the help
Typing errors occured
Sorry for the inconvenience
A.Hannemann
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To requ
Hi!
> "ch" == ch <[EMAIL PROTECTED]> writes:
>> Description:
ch> My udf function and an equal udf function I found in the internet
ch> seem to work well as does substring_index. Only when I call them
ch> together I get a bug. As my function (quotet below) is so simple
ch>
Hello,
I've develop the software in Rapid-Q (under Win), It's a bank of data for a medical
ambulance. The main data store will be MySQL. It'll run localy so server will run on
the same machine as my program. The program is free (binary) , not free is the source
code. Only what i'll sell are the
hi
does mysql support any equivalent of DECODE in oracle?
i have been looking all over for info on this, but
cannot find any. i have several SQL scripts in our
code that use the decode stmt, and now that some of
our stuff is being ported to MySQL, i have hit a wall.
will i have to get my perl
Andreas Steinmetz writes:
> Hi,
> the inserts did not change the state after the select finished. The network is
> running full duplex but the only problem I ever encountered with the cards was
> initalization on fast systems. I fixed this and posted it to the linux kernel
> mailing list (sea
I just installed mysql 3.23.32 on my server and it
went without a hitch. I ran mysql_install_db, changed
the root password, started the server. I used GRANT
statements to create another user, then connected
as that user to the mysql client--no problem at all,
ran queries, etc.
But I wrote a PHP
Sean Keplinger writes:
>
> I have a Perl program that gathers data and inserts it into a Mysql
> database via DBI (DBD::mysql). The program performs multiple inserts, one
> right after the other.
>
> On my OBSD 2.7 box, everything works just fine -- but when I try to run
> the same script
> on a related but slightly different example, what would happen if you had a
> Primary Key consisting of 2 columns a & b (so the pkey enforces a unique
> combination of a & b) and then created an index on one of the columns eg b.
> Would the index on b have any effect, or does a primary key on 2
Ryan:
1.) ...WHERE word LIKE '%word%' will never be fast.
2.) Since you said you have indexed the field, if you can limit your
searches to ...WHERE word LIKE 'word%', then you might want to look at
indexing on a subset of the field if it's a big one.
3.) You will get better performance if you p
=?iso-8859-2?Q?Michal_Hal=E1s?= writes:
> Hello,
> I've develop the software in Rapid-Q (under Win), It's a bank of data for a medical
>ambulance. The main data store will be MySQL. It'll run localy so server will run on
>the same machine as my program. The program is free (binary) , not fre
I just tried connecting to the db from kmysql on
the same box--no way, no how. Same can't connect
error message, though I can connect remotely.
--
/"\
\ /ASCII RIBBON CAMPAIGN
X AGAINST HTML EMAIL
/ \AND POSTINGS
---
Hi!
On Feb 06, Mike Boulet wrote:
> I read the Docs about this new feature and its says that only VARCHAR and
> TEXT fields are supported.
> I am not sure if this means that TINYTEXT,MEDIUMTEXT, and LONGTEXT types are
> supported also.
Sure, all the *TEXT types are supported.
Regards,
Sergei
-
Binary is an option on the varchar type
I pulled the following quote from the mysql website.
It just does not seem to be working anymore.
[NATIONAL] VARCHAR(M) [BINARY]
A variable-length string. NOTE: Trailing spaces are removed when the
value is stored (this differs from the ANSI SQL specificat
Yes, I should have been more clear, I know that you can join a table to itself but I
am trying to find out:
1) What is the max number of joins (unique tables/mixture of same table joins)
2) What is the max number of same-table joins
So I guess I had two questions :)
Bill
On Wed, 7 Feb 2001, R
Hi,
first of all: the deadlock happened again today, this time with no slave
running so it isn't a replication issue. It seems we're getting closer as when
I did run 'show processlist', the pending query was (excerpt from output):
1666logreader 10.1.1.4syslog Query 114 Se
Are you sure u try ur mysql server already?
if not start the "mysqld"
Teddy
soon chee keong wrote:
> hi..could someone pls help me
>
> i had created mysql server before in my pc but this morning i discovered
> that i cant access my mysql server.this is what i typed:
>
> shell> mysql
>
>
Dear friends,
as an appendix I have included the bug report generated
from the system. After unzipping and taring the
new issue (3.23.32) of mysqlbinary for hpux-10.20
the mysql_install_db script crashed with a coredump.
The was the first try to install mysql on this machine.
Do You have any ide
> Yes, I should have been more clear, I know that you can join a
> table to itself but I am trying to find out:
>
> 1) What is the max number of joins (unique tables/mixture of same
> table joins)
> 2) What is the max number of same-table joins
>
> So I guess I had two questions :)
>
> Bill
I wou
In a SELECT I have to convert a string into a number.
I used to use something like 'string'+0, where 'string' is a string
rapresentation of an integer.
Now I noticed that in many cases it returns a rounded floating point!!!
For example:
mysql> select '11'+0;
+-+
| '11'+0
> Binary is an option on the varchar type
> I pulled the following quote from the mysql website.
>
> It just does not seem to be working anymore.
A guess:
It seems to me that the problem is not in
your colmn definition, but the silent type
conversions MySQL performs. In the log you
show below, y
Rolf, I'm invoking safe_mysqld with --skip-locking and
--log-update=update_log, among other options. If I run
mysqladmin flush-logs while database updates are occurring,
the update logs sometimes get confused - the scheme I have
is basically
mysqladmin flush-logs
mv name_of_old_update_log
On 06.02.2001 14:38:59 Jacob Friis Larsen wrote:
> Is there any idea in using both a INDEX() and UNIQUE() index on the same
> table field ?
Yes, you can add both to a field - not that it makes much sense IMHO, but yes,
it's possible...
> I just installed mysql 3.23.32 on my server and it
> went without a hitch. I ran mysql_install_db, changed
> the root password, started the server. I used GRANT
> statements to create another user, then connected
> as that user to the mysql client--no problem at all,
> ran queries, etc.
>
> But
On 07.02.2001 10:30:15 russ wrote:
> Many thanks to all for the help on this issue.
> I've come to the conclusion the simplest way for me to implement this is to
use
> the ENUM type with two possible values 'True' and 'False'.
> I will convert the VB BOOLEAN type to a string before I enter it.
>
On Wed, 7 Feb 2001, Carsten H. Pedersen wrote:
> ...but in this case, it means that PHP is trying
> to connect not through TCP/IP as other remote
> machines, but rather through a UNIX socket located
> on the machine as you have described above.
>
> It probably means that
> 1) PHP expects to f
Tom,
Read about the MERGE TABLE type, which might satisfy your needs. It
allows
you do partitioning, and to index across partitions, but it does have
some
limitations.
Cheers,
Kent
-
Before posting, please check:
http://www
Good Morning,
Recently, on an otherwise functioning system, I began getting the following
message
ERROR 1130: Host '' is not allowed to connect to this MySQL server
I am running both the client and server from Solaris 7 machines. MySQL
version is 3.22.32
This started happening about two
It's a bug either in your processor or in your distribution
libraries. Your SELECT returns correctly on my Linux and FreeBSD
servers.
-Tilghman
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
> -Original Message-
> From: Federico Giannici [mai
Here you go...
http://www.zeos.dn.ua/eng/index.html
Paulo Serra wrote:
> I am a DELPHI developer and I need to know if exists
> a MySQL driver for DELPHI.
>
> Does MySQL have a driver for DELPHI???
>
>If it does, please send me it...
>
>My e-mails: [EMAIL PROTECTED]
>
clay bond wrote:
>
> I just installed mysql 3.23.32 on my server and it
> went without a hitch. I ran mysql_install_db, changed
> the root password, started the server. I used GRANT
> statements to create another user, then connected
> as that user to the mysql client--no problem at all,
> ran qu
I ran rpm -Uhv MySql*3.23.32-1.i386.rpm against the sever, the client and the
shared rpms.
It ran without error and created the appropriate files on the 10 gig
/var/lib/mysql.
I moved the contents of mysql to /dbshare and created a symbolic link in /var/lib
called mysql which pointed to /dbshare.I
Is there an idea in having a PRIMARY KEY and UNIQUE key for the same table
column ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To re
Cool, I like this info. (especially key_buffer_size stuff)
However, I was running my numbers against what you said would be good. And this is
what I came up with...
The Key_reads/Key_read_request = 0.002 (much less than you suggest so that is good...
I think)
However this one worries me a b
Run the winmysqladmin.exe in the bin directory. Then do the right click
"install service", right click "start service".
I had to do this the first time. Thereafter it does it on install.
[EMAIL PROTECTED]
National Aeronautics and Space Administration
-- S c i e n c e @ N A S A -
Hi
okie heres a snippet of my php code:
the code below takes a file uploaded from the web with $file as declared filename on
the form.
if ($file_size>0) { //check whether the file is not empty
$data = addslashes(fread(fopen($file, "r"), filesize($file))); //read the file and
add neccessary quote
Web Depressed wrote:
> Hi Bob,
> Many thanks for that. I was hoping (through absolute
> naiveity) not to have to go and calculate the number
> of days with the specified range. Unless, of course
> I could have mysql do this for me.
Question: why are you using reserved words for your column na
On Wed, 7 Feb 2001, CT Chang wrote:
> Date: Wed, 7 Feb 2001 17:14:28 +0800
> From: CT Chang <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Mysql in Win2K
>
> Hi there,
>
> I have just upgraded my Win98SE to Win2K and ever since, I could not =
> start Mysqld or Mysqld-nt (with or without
I installed MySQL 3.23.32 binary distribution for Windows.
I can't find libmysql.a in the lib directory. Where is it? Can anybody send me one?
---
~Agus~
Get your small business started at Lycos Small Business at
http://www.lycos.com/business/mail.html
No. A primary key is a unique key, by definition.
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
> -Original Message-
> From: Jacob Friis Larsen [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 07, 2001 09:58
> To: [EMAIL PROTECTED]
> Su
010207 12:47:42 Error reading packet from server: Contratulations! You have hit the
magic number and can win sweepstakes if you report the bug (0).
I got the magic number, but I prefer a solution instead my prize!
I have a lot of "COOL BUGS".
I'am a MYSQL FAN.
-
At 07:14 07/02/2001, CT Chang wrote:
Hi!
Notice that the command mysqld-nt --install only install the
service on the SCM and for start it you do:
net start mysql
Also you need to know that in the next boot the service is
started automatic.
Regards,
Miguel
>Hi there,
>
>I have just upgraded my
> In a SELECT I have to convert a string into a number.
>
> I used to use something like 'string'+0, where 'string' is a string
> rapresentation of an integer.
>
> Now I noticed that in many cases it returns a rounded floating point!!!
>
> For example:
>
> mysql> select '11'+0;
> +
I guess my command of the english language isn't too
great.
I never realized that this quote from the manual:
"You're allowed to do it (for example, ABS is an
allowed column name), but whitespace is not allowed
between a function name and the `(' when using
functions whose names are also column
Is there a more detailed description of the MyISAM file format than in the
MySQL manual?
---
Mark Cogan[EMAIL PROTECTED] +1-520-881-8101
ArtToday www.arttoday.com
Hello,
server version: 3.22.34-shareware-debug
OS: Windows 98
I tried to access the mySQL- server via the Win-Telnet Client.
If the connection is established, the following mysterious string appears:
(
3.22.34-shareware-debugk7qS,~Z),
After that, I entered some characters.
Then
Working anymore? You mean that it used to work? Now I'm confused!!
The quote from the manual is correct. Using BINARY means that 'A' < 'a' not
'A' = 'a' which is the case without the keyword BINARY.
What is it you are trying to achieve by inserting 0x1 into a CHAR field?
- Original Messa
Firstly, I'm curious as to why you need --skip-locking in the first place.
Now that I know what you are trying to achieve, I can honestly say I'm not
sure. I'd have to read the manual for more detail on how flush-logs
interact with table locking etc.
I presume your daemon, that's accessing the
How to start a replication from without stoping master?
-
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
Yes, you can but you probably need a real good reason to. As Tilghman
pointed out a PK is a unique key. If you have another unique key (a
candidate key) then you need revisit your datamodel and make sure you have a
good reason. Candidate keys to exist in the real world but they are rare.
Cal
htt
It's gives me correct result (integer value 11) on my FreeBSD 3.5, FreeBSD
4.2 and Debian Linux 2.2 Machine
- Original Message -
From: "Carsten H. Pedersen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "MySQL mailinglist" <[EMAIL PROTECTED]>
Sent: Thursday, February 08, 2001 1:15 AM
Subje
Hi,
You don't connect to mysql server using telnet, you use the mysql command
line client 'mysql'.
Regards
Quentin
-Original Message-
From: @ndYD [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 8 February 2001 07:13
To: [EMAIL PROTECTED]
Subject: problems running mySQL via Telnet
Hello,
At 14:31 07/02/2001, Agus Setiono wrote:
Hi!
On Windows you should use libmysql.lib instead. You find it at
/lib/opt directory.
Regards,
Miguel
>I installed MySQL 3.23.32 binary distribution for Windows.
>I can't find libmysql.a in the lib directory. Where is it? Can anybody
>send me one?
>
>-
This works... however it does not fix my problem.
I did a little more research...
Instead of varchar(M) BINARY I can do a tinyblob.
This allows me to do the inserts and selects that I previously
mentioned.
Also the documentation says that you can consider blob as a varchar
binary.
So My qu
Rolf Hopkins [[EMAIL PROTECTED]] wrote:
> Firstly, I'm curious as to why you need --skip-locking in the first place.
I'm not sure that I do - I just thought that if I instead
used --enable-locking that this problem of update logs
getting confused with flush-logs might(?) go away. But I
haven't b
You're trying to use a Telnet client with a MySQL server. Instead,
use a MySQL client with a MySQL server and a Telnet client with a
Telnet server. Mixing protocols doesn't really work for anybody.
-Tilghman
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissi
'varchar(16) binary' works in 3.22 and tinyblob works in 3.23.
by work I mean I can insert hexidecimal numbers into the field.
I am basically treating it as an integer field. I can store 16 byte
numbers in the field and in the case of varchar(16) binary on mysql 3.22
I could store a 32 character
I have a select I'd like to do...I have 2 kinds of people -- those
needing interviews, and those doing interviews. Among other things,
each person has their home address/phone in the tables. I want to
generate lists of interviewers in close geographical proximity to the
interviewees. I can do
How can I get the log-bin initial position?
Like: trevas-bin.001
trevas-bin.002
I want to know in which position trevas-bin.002 began.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Maybe we're doing something really wrong in the way we do each look up.
We have one table with all the defintions on it's own row.
Then we have built off of that table another table that is only the distinct
words, no definitions.
This is because if a word has 10 definitions, it makes it hard to
When we increase the number of connections our 3.22.25 server 'hangs':
mysql> show status;
No connection. Trying to reconnect...
ERROR 1129: Host 'xxx is blocked because of many connection er
rors. Unblock with 'mysqladmin flush-hosts'
ERROR: Can't connect to the server
This happens when we inc
i agree .. the mysql server _should_ accept telnet sessions. Maybe in a
future release ? it'd really be very handy
- Original Message -
From: "Quentin Bennett" <[EMAIL PROTECTED]>
To: "'@ndYD'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, February 07, 2001 7:56 PM
Subject: RE
> "TT" == The Tilghman <[EMAIL PROTECTED]> writes:
TT> You're trying to use a Telnet client with a MySQL server. Instead,
TT> use a MySQL client with a MySQL server and a Telnet client with a
TT> Telnet server. Mixing protocols doesn't really work for anybody.
well, you can use the telnet
Hi!
Last night, one of tables broke. For some reason, I cannot access the table
anymore, trying to do so gives me this error message:
ERROR 1016: Can't open file: 'DownloadCounter.MYD'. (errno: 145)
DownloadCounter is the table that is broken.
How can something like this happen? Is it more p
The problem I'd like to report is when there's an insert with now() in a
datetime field.
The problem is that, when both servers doesn't have their clocks
synchronized, the value of the now() in the Master will be different
from that in the Slave.
I've tried it with MySQL 3.23.32 in both servers.
Check out SUBSTRING in the manual.
On the zip codes, you're better off not trying to do any
comparisons in SQL -- the way they work is extremely
complicated. I would suggest that you purchase distance
measurements between two arbitrary zip codes from the
Postal Service, if you intend to be accur
I think 12 tables is not a large number by any means.
If they _logically_ form one database, I'd not bother about the number.
Only if performance problems pop up, and are positively recognized as being caused
by too many files in the database directory, I'd start looking for a solution.
Which need
Can I implement some sort of exception handling when using the mySQL
client library? I'm running an application and when I issue a query with
an error in it, I catch the error and print output, but the software
throws a general exception. Should this code be in a
try
{
}
catch
{}
routine? If so,
> three digits, dash, four digits). I want to compare the second
> set of three digits to each other, something like
>
> WHERE Interviewee.homephone[4-6] = Interviewer.homephone[4-6]
>
> Similarly for zip codes, I want to compare the first three characters
> of a char[10] (zip plus 4], essen
Does the post office offer this info? There used to be a service (Melissa)
that had Lat. and Long. for the center of each zip code. You could use that
to computer "all addresses in a 50 mile radius". but from what I understand,
it's gone now. I would love to find something where I could make the
When I try to run the following command:
CREATE TABLE Salespersons
(empid INTEGER NOT NULL PRIMARY KEY,
ename CHAR(15) NOT NULL,
rank INTEGER NOT NULL DEFAULT 1 CHECK (rank IN (1,2,3)),
salary DECIMAL(7, 2) NOT NULL DEFAULT 1000.00 CHECK (salary >=1000.00));
gives me the following error:
Yo
Hi,
Depending on you environment, rdate might work. On solaris, it can sync 2
clocks, on Digital UNIX, it gets the 'average' of clocks it can find.
Regards
Quentin
-Original Message-
From: Leonardo Dias [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 8 February 2001 09:27
To: [EMAIL PROTECT
This gives me a seg fault, I know I have the correct user/pw, but I can't get the
thing to run past "First", any ideas why the connect is not working properly?
#include
#include
#include
void main()
{
string dbname = "test2";
string hostname = "localhost";
string uname = "mike";
Couldn't find it on usps.com, but a quick search of google turned
up the following url: http://www.tpsnet.com/html/zipmenu.html
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
> -Original Message-
> From: Cal Evans [mailto:[EMAIL PROTECTED]]
> S
I apologize if this has been discussed already, but I quick poke
at the archives didn't reveal anything.
We have a table that iamchk says is fine. We are trying to get an
SQL dump of this table. But, we keep getting out-of-memory errors.
I've tried several things, all to no avail, and I'm looki
mysql (the monitor) seems not to read the option character-sets-dir out of
any configuration files (at least not /etc/my.cnf on Linux resp. c:my.ini
and windows/my.ini on Windows) if it is started with option -p or
with --password, i.e. if it shows a password prompt
everything works fine if mysq
Two things:
1) Read the manual to see the correct syntax for the CREATE TABLE.
2) Constraints don't actually do anything in MySQL. Again, read the
manual.
-Tilghman
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
> -Original Message-
> Fro
>>Two things:
>>
>>1) Read the manual to see the correct syntax for the CREATE TABLE.
I did, and that's where I don't understand why this is happening. The
furthest I was able to get in the manual and/or any of the archives from
MySQL is:
(straight out of the manual)
CREATE [TEMPORARY] TABLE [
In the last episode (Feb 07), Cal Evans said:
> Does the post office offer this info? There used to be a service (Melissa)
> that had Lat. and Long. for the center of each zip code. You could use that
> to computer "all addresses in a 50 mile radius". but from what I understand,
> it's gone now.
I think the -q option (quick, do not buffer output, but write it
directly to stdout)
is what you need.
Cheers,
Kent
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello mysql,
Peter> mysql 3.23.32 + BDB 3.2.3h
mysql> select * from layers_la00.g03last_hit;
Peter> +++-+++
Peter> | updated| counter_id | stat_id |
On Wed, Feb 07, 2001 at 05:00:12PM -0500, Brian Reichert wrote:
> When I try to do a mysqldump on the localhost, I get an out-of-memory
> error:
>
> # mysqldump -uroot -proot customer audit_trail_271
> mysqldump: Out of memory (Needed 8164 bytes)
> mysqldump: Got error: 2008: MySQL client r
Hi all
I am running mysql on linux (redhat 6.2) using a regular 18Gb
EIDI hard drive. Does anyone know how much (ball park figure) a
SCSI hard drive would speed up selects and inserts?
Thanks everyone!
Michael Thomas
abcXyz.com
[EMAIL PROTECTED]
---
Brian Reichert wrote:
>
> On Wed, Feb 07, 2001 at 05:00:12PM -0500, Brian Reichert wrote:
> > When I try to do a mysqldump on the localhost, I get an out-of-memory
> > error:
> >
> > # mysqldump -uroot -proot customer audit_trail_271
> > mysqldump: Out of memory (Needed 8164 bytes)
> > mysq
On Wed, Feb 07, 2001 at 06:24:58PM -0800, mike thomas wrote:
> Hi all
>
> I am running mysql on linux (redhat 6.2) using a regular 18Gb EIDI
> hard drive. Does anyone know how much (ball park figure) a SCSI hard
> drive would speed up selects and inserts?
That depends. Are your queryes CPU or di
Jeremy,
My queries are disk bound (I think) from watching the Redhat
system monitor when running a query.
Mike
> -Original Message-
> From: Jeremy D. Zawodny [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 07, 2001 4:07 PM
> To: mike thomas
> Cc: Mysql@Lists. Mysql. Com; [EMAIL P
Hello,
I tried to send this using the 'scripts/mysqlbug' script but sendmail
barfed
>Description: configure problem finding size of char type on Sparc 20
>How-To-Repeat: I was doing a fully-standard configure script run
>Fix: unsure at this stage
>Submitter-Id: Craig Dewick "[EMAIL PROT
Use mysqldump -q ...
This will prevent buffering of the table content in RAM.
regards,
P
On Wed, 7 Feb
2001, Brian Reichert wrote:
> I apologize if this has been discussed already, but I quick poke
> at the archives didn't reveal anything.
>
> We have a table that iamchk says is fine. We ar
Greg,
Well, I'm doing like "%stuff%" selects on a single column table
with 20 million records, so any speed gain would be great. Would
I be correct in saying that a select of this type will always do
a table scan?
I think I'll go with SCSI and increase the RAM so I can use a
heap table.
Thanks
Hi,
But the problem is that mysql is not accepting the syntax, not that it will
do nothing with it.
Quentin
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 8 February 2001 12:40
To: SF
Cc: [EMAIL PROTECTED]
Subject: Re: CHECK variable incorrect?
In the l
1 - 100 of 130 matches
Mail list logo
