message with attachments), and their languages also have good database
bindings.
Richard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Monday 12 Jan 2004 22:23, you wrote:
> Richard Davies wrote:
> > Does anyone have any ideas on how to round a number in the form
> > float(3,4) to the nearest sixteenth of an inch.
>
> Multiply by 16, round, divide by 16.
Obvious really,
upd
Does anyone have any ideas on how to round a number in the form float(3,4) to
the nearest sixteenth of an inch.
eg ending in
.0625,
.125
.1875
.25
.3125
etc
I haven't found anything in the manual about this, maybe normal people don't
want to do this.
--
Regards
Richard
--
MyS
On Monday 12 Jan 2004 13:20, Richard Davies wrote:
Thank you to everyone who offered advice on this problem I knew it was easy
but couldn't see how to do it.
Thanks again.
> I receive measurements for a product sometimes in inches, sometimes in
> centimeter
inserting? If this is possible how would
I do it I can't quite make it work.
--
Regards
Richard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Thursday 08 Jan 2004 16:50, you wrote:
> On Thu, Jan 08, 2004 at 02:47:51PM +0000, Richard Davies wrote:
> > On Thursday 08 Jan 2004 12:33, Harald Fuchs wrote:
> > > In article <[EMAIL PROTECTED]>,
> > >
> > > Richard Davies <[E
On Thursday 08 Jan 2004 12:33, Harald Fuchs wrote:
> In article <[EMAIL PROTECTED]>,
> Richard Davies <[EMAIL PROTECTED]> writes:
> > I find at present from reasons I can't work out if the image to be stored
> > is a jpg then there is no problem b
st case less
than once a month so I just dump the blob field to a file and look at it
that way.
CREATE TABLE charts (no int not null primary key, comments varchar(255), chart
mediumblob);
SELECT chart INTO DUMPFILE '/home/richard/image.jpg' FROM charts WHERE no=1
Michael,
Thanks very much for the insites.
Cheers,
-Richard
Michael Stassen wrote:
I've faced the same questions you raise here. Some things which occur
to me:
First, are you certain that 4.0.5a is working "perfectly"? A lot of
bugs have been fixed since then. Is it po
Ah ha!
Thank you Aleksandar. That's a much better solution. In fact, now
youv'e told me this, I looked in the Manual, and the scales where
lifted from my eyes. You've saved me re-writing (and re-thinking) a
large chunk of PHP.
For anyone else's future reference it's all there in plain english
Jay!
Thanks for help with a 'proper' insert. ;-)
Yes, the full statement works fine. (I assume this is something like
the not setting default values from importing DATA files?) All a bit of
a shame, as I'm executing the insert from a PHP script, and was trying
to make the routine as generic as
Hi,
I'm having problems with setting default values for an enum. It's for
a booking system, and I'm keeping track of which day a property starts
a booking period. It's useful to have the enum in day order therefore.
Omitting the prompts, here's what's happening;
*
drop table property;
c
I have a small single user database into which I wish to insert and extract
images.
From the manual this seems to work to insert the image
insert into images values(LOAD_FILE("/home/richard/scan.tiff"));
but how do I get it back again?
I thought this might work but it doesn't
might be. :-)
How do those of you using MySQL in production mode make your upgrade
decisions? As a related question, what version would you run on a
Solaris 2.8 (SPARC) server?
Cheers,
-Richard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Udo,
Thanks - I found the bug in the database. Looks like it's been fixed in
4.0.17 (the bug was reported in 4.0.14 and I'm running 4.0.15).
The bug was also not in my Solairs system - using 4.0.5a.
Thanks,
-Richard
Ugo Bellavance wrote:
-Message d'origine-----
Miguel,
miguel solorzano wrote:
At 16:05 3/1/2004 -0700, Richard S. Huntrods wrote:
I've submitted this problem three times now, and been ignored all
three times.
Sorry for this inconvenience but I suggest you in the next time to
use the MySQL's forums for to report bugs inst
Should be: 0
error: Record-count is not ok; is 4 Should be: 0
warning : Found 4 partsShould be: 0 parts
error: Corrupt
This happens every single time. You cannot use the -autorepair function,
as it reports "appraised.MYD" cannot be opened.
What is goin
of datafile is: 160 Should be: 0
error: Record-count is not ok; is 4 Should be: 0
warning : Found 4 partsShould be: 0 parts
error: Corrupt
This happens every single time. You cannot use the -autorepair function,
as it reports "appraised.MYD" cannot be op
uild the
table), you can run the query dozens of times and never get the error.
Somehow, the SQL in "testDeleteUser" is breaking the table, causing
"testupdate" to break on one insert (always the same place!).
Any ideas???
Thanks,
-Richard
First, the database and user
e, and can anyone point me to the
cause (and solution)?
Thanks,
-Richard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
across a
corruption after a crash of the DB or the operating system (linux).
Richard
On Mon, 2003-12-22 at 09:48, MySQL Support wrote:
> Hello,
>
> My HDD is running low and I MyISAM tables are keep crashing... I think that
> converting to InnoDB will be more stable, but what about th
Okay, that sounds good and all, but how does that help me, since the date is
chosen
from the javascript "calander" in this format: mm/dd/
So then, when I'm selecting a date of at least todays value, or less in the
database
how would I do it, since it's in mm/dd/yy
;
Just checking a second time for anything where the year is less then the
current will cover previous year, regardless of the month, then everything
within this year is covered by the first check.
So far it's working. I'm still open to better ways though ;o)
Thanks,
Richard
- Or
then have to go re-code
half the scripts/databases.
Thank you in advance for any tips/advice you have.
Richard
FRHweb
I was wonder if anyone here could comment on when prepared statements
might be available in the embedded server, I would find it very
helpful. Will they be in the 4.1 release? Are there plans to add
support in some future release?
Thanks,
Richard Tibbetts
--
MySQL General Mailing List
For list
Anyone have any ideas about this?
Thanks,
Richard
-Original Message-
From: Richard Bewley [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 7:10 PM
To: [EMAIL PROTECTED]
Subject: More database replication
Hi,
I have a "mission critical" database, that I want to be
and it works, but only when I type
mysql> LOAD DATA FROM MASTER;
I'd rather have it automatically be replicating rather than have to run that
command every time, or rather than having a cron job do it, which I see as
messy at best.
Any suggestions?
Thanks,
Richard
--
MySQL Genera
Hi,
I did manage to get two-way replication to work properly, but I have to
type:
mysql> load data from slave;
This is the only way it replicates the data. Is there a way to have it
replicate back and forth in real time?
Thanks,
Richard
-Original Message-
From: Richard Bewley [mai
Ok, but the slave would also replicate to the master? Is anyone using this
type of setup?
Thanks,
Richard
-Original Message-
From: Chuck Gadd [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 29, 2003 6:34 PM
To: Richard Bewley
Subject: Re: Database replication
Richard Bewley wrote
Yes, you can insert the binary into a table.
Richard
-Original Message-
From: Zenzo [mailto:[EMAIL PROTECTED]
Sent: Saturday, November 29, 2003 1:42 PM
To: MySQL List
Subject: Images in a table
How can I insert images in a table if I can do it with MySQL
calDiretor. My concern
is, if db0 replicates to db1, what if the LD directs the connection to db1,
and it tries to write to the database. Will those changes be done on db0
also? What would be the best way to go about doing this?
Thanks,
Richard
--
MySQL General Mailing List
For list arch
and mySQL web development by Luke
Willing and Laura Thompson.
Good luck!
Richard
-Original Message-
From: Braulio Lumbreras [mailto:[EMAIL PROTECTED]
Sent: Monday, November 24, 2003 9:48 PM
To: [EMAIL PROTECTED]
Subject: How To Learn php and mysql.
What is the best way to learn php and
ql_bind_param() uses buffer_length to tell
the server about the max argument length, and that mysql_execute()
uses length to decide how much data to actually send for a given
invocation. Is this correct?
Thanks,
Richard Tibbetts
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
I would like to backup databases from a linux MySQL server to another
linux machine on the same private network but I don' see in the docs how
I can do this with mysqlhotcopy or mysqldump. Is there any way to do
this besides using ftp.
Any help would be appreicated.
Richard
--
MySQL Ge
iple CPU's?
Thanks,
Richard
s I'm tierd to stay with an old
version of mysql :(
Thanks in advanced.
( p.s. a binary is NOT an option )
-Original Message-
From: Richard Pijnenburg [mailto:[EMAIL PROTECTED]
Sent: Sunday, October 26, 2003 3:48 PM
To: 'Patrik Fimml'
Cc: [EMAIL PROTECTED]
Subject: RE:
Okay, I've update gcc to : gcc (GCC) 3.3.2
And I'm still getting the same error. It's a RH9.0 box.
Hope someone can shed some light on this.
Thanks in advance.
-Original Message-
From: Patrik Fimml [mailto:[EMAIL PROTECTED]
Sent: Sunday, October 26, 2003 8:21
but i also got this with 4.0.15 and
4.0.15a
with 4.0.14 it's going good.
does anyone know how to solve this?
thanks in advance.
with kind regards,
Richard Pijnenburg
dear list,
i've got the folowing compile error.
/bin/sh ../libtool --mode=compile gcc
-DDEFAULT_CHARSET_HOME="\"/usr/local/mysql\""
-DDATADIR="\"/data/mysql\""
-DSHAREDIR="\"/usr/local/mysql/share/mysql\"" -DDONT_USE_RAID -I. -I.
-I.. -I./../include -I../include -I./.. -I.. -I..
/usr/local/ope
Hi,
You can see the table structure with the command:
> desc host;
after logging in to mysql using the table mysql
Greetings,
Richard
- Original Message -
From: "Gregory Norman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 17, 2003 10:31
I am wanting to protect myself against future potential hard drive
failures on my database server running version 3.23.49a. Should I try
and set up a RAID, a mirror or would the best solution be to set up
MySQL replication. Any suggestions would be greatly appreciated.
Richard
--
MySQL
I am wanting to protect myself against future potential hard drive
failures on my DB server running version 3.23.49a. Should I try and set
up a RAID, a mirror or would the best solution be to set up MySQL
replication. Any suggestions would be greatly appreciated.
Richard
--
MySQL General
None.
>Submitter-Id:
>Originator:root
>Organization:
Richard Runds
>MySQL support: none
>Synopsis: mysqld on off crash
>Severity: critical
>Priority: high
>Category: mysql
>Class: sw-bug
>Release: mysql-4.0.14-standard (
I've installed now mysql-4.0.14 without any problems. So I think it's
something about the .15 version. Does anyone know a thing about it?
With kind regards,
Richard Pijnenburg
-Original Message-----
From: Richard Pijnenburg [mailto:[EMAIL PROTECTED]
Sent: Thursday, September
Sorry, but because I haven't got it I thought it didn't get here.
Sorry!
M.v.g.
Richard Pijnenburg
-Original Message-
From: Antony Dovgal [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 25, 2003 3:42 PM
To: [EMAIL PROTECTED]
Subject: Re: mysql compile error.
On Thu, 2
i'm trying to compile mysql-4.0.15a on my server and i'm getting the
folowing error:
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\"
-DDATADIR=\"/data/mysql\" -DSHAREDIR=\"/usr/local/mysql/share/mysql\"
-DUNDEF_THREADS_HACK -DDONT_USE_RAID -DMYSQL_CLIENT -I. -I. -I..
-I./../include -I../include -I
i'm trying to compile mysql-4.0.15a on my server and i'm getting the
folowing error:
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\"
-DDATADIR=\"/data/mysql\" -DSHAREDIR=\"/usr/local/mysql/share/mysql\"
-DUNDEF_THREADS_HACK -DDONT_USE_RAID -DMYSQL_CLIENT -I. -I. -I..
-I./../include -I../include -
i'm trying to compile mysql-4.0.15a on my server and i'm getting the
folowing error:
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local/mysql\"
-DDATADIR=\"/data/mysql\" -DSHAREDIR=\"/usr/local/mysql/share/mysql\"
-DUNDEF_THREADS_HACK -DDONT_USE_RAID -DMYSQL_CLIENT -I. -I. -I..
-I./../include -I../include -
Does anybody know of any issues when have a large (+1000) databases in
MySQL?
It will be running on RedHat 9. Would there be any problems running backups
with this many DBs on
one box?
Regards
Richard
- Original Message -
From: "Harald Fuchs" <[EMAIL PROTECTED]>
To: &
the max open tables to 512. I don't have much more info than
that unfortunately.
Richard Gabriel
Director of Technology,
CoreSense Inc.
(518) 306-3043 x3951
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Dathan Vance Pattishall"
What kernel are you running?
Also, try increasing the max open tables. That might help.
Richard Gabriel
Director of Technology,
CoreSense Inc.
(518) 306-3043 x3951
- Original Message -
From: "Dathan Vance Pattishall" <[EMAIL PROTECTED]>
To: "'Tom Roos'
hello,
previously is had installed a complete installation of apache/php/mysql but now i
tried to install them all apart, but now i have the problem that when is try to start
mysql i get this error:
C:\Apache2\mysql\bin>mysqld-nt --standalone
030907 14:09:53 Can't find messagefile 'C:\phpdev5\
i have fixed it!
sorry
(c:\my_cfg*)
- Original Message -
From: Richard Korebrits
To: [EMAIL PROTECTED]
Sent: Sunday, September 07, 2003 2:15 PM
Subject: mysqlbug
hello,
previously is had installed a complete installation of apache/php/mysql but now i
tried to install them all
Bonjour Matthew !
MS> Not sure about php syntax, but check out the perl module (in CPAN)
MS> Email::Valid.
I'm not searching the PHP syntax, but the SQL syntax... :)
A +
--
*~~~~*
Rich
email FROM mailing WHERE email
REGEXP '^([a-zA-Z0-9])+([\.a-zA-Z0-9_-])*@([a-zA-Z0-9_-])+(\.[a-zA-Z0-9_-]+)+';
But some of "false" mails are accepted, like "[EMAIL PROTECTED]".
Can you help me ?
Regards
--
*~~~~
Please see below for the answers to your questions. I hope this helps
to diagnose the problem. Please let me know if you need any more
information as this seems to be happening to more and more people.
Thanks.
On Sun, 2003-08-10 at 04:29, Heikki Tuuri wrote:
> Richard,
>
> > t
What OS/kernel are you running? Thanks.
Richard Gabriel
Director of Technology,
CoreSense Inc.
(518) 306-3043 x3951
- Original Message -
From: "Terence" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 11, 2003 2:28 AM
Subject: Error 127, some q
2:21 InnoDB: Started
/usr/sbin/mysqld-max: ready for connections.
Version: '4.0.14-Max-log' socket: '/var/lib/mysql/mysql.sock' port:
3306
This happens often. Any ideas? Thanks.
--
Richard Gabriel <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives:
help
me pinpoint the problem and ultimately get this resolved. Thanks.
Richard Gabriel
Director of Technology,
CoreSense Inc.
(518) 306-3043 x3951
- Original Message -
From: "Jonathan Patton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Even though we don't know what exact query produces this, is there a way to
raise it up to the MySQL team to take a look at? It seems to be more than a
random occurrence. Thanks.
Richard Gabriel
Director of Technology,
CoreSense Inc.
(518) 306-3043 x3951
- Original Message -
Thanks walt. Actually I use "mysqlcheck" to check the databases. This can
be safely run while the server is in use.
Richard Gabriel
Director of Technology,
CoreSense Inc.
(518) 306-3043 x3951
- Original Message -
From: "walt" <[EMAIL PROTECTED]>
To: "Ric
hared library linked to MySQL (I use RPMs)
3. RAID issue causing corruption
Unfortunately I haven't been able to pinpoint which query causes the issue
so I can't report a bug. It anyone else has experienced this or has
information on it, I would really appreciate it. Thanks.
Richard Gabr
into a table using AUTO_INCREMENT as well
and this may be compounding the problem.
I have read the docs, but it's sort of unclear, does LOAD DATA INFILE
work in a replicated 3.23.56-1 setup, only under certain circumstances,
or not at all?
Your help is greatly appreciated. Thanks.
--
Anyone know when it will be considered production stable?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-Original Message-
From: Bruce Feist [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 7:42 PM
To: Richard Bolen
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Select with join query question
Richard Bolen wrote:
>This works! I was then wondering how to get the total numbe
This works! I was then wondering how to get the total number of all
jobs that this condition is true for?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 5:26 PM
To: Bruce Feist
Cc: Richard Bolen; [EMAIL PROTECTED]
Subject: Re: Re
y fields joined from
Submissions that don't have a match in Jobs. Just include at least on
field from Submissions and test for null on that field.
SELECT *,s.status AS ActiveJob FROM Jobs AS j LEFT JOIN Submissions AS
s ON j.job_id=s.job_id
WHERE s.status IS NULL
On Monday, July 28, 2003, at 02:3
I'm trying to write a select query that involves 2 tables. One table
(Submissions) has a one to many relationship with the other table
(Jobs). I'm trying to find all the records in Jobs that do NOT have a
corresponding record in Submissions with a status of 1.
The problem I'm having is that when
mponents of an application connect to create a
comprehensive solution
Please send resumes to [EMAIL PROTECTED] Thanks!
Richard Gabriel
Director of Technology,
CoreSense Inc.
(518) 306-3043 x3951
but it didn't seem to work. Any
suggestions?
Regards
- Richard S.
On Tuesday, July 22, 2003, at 12:06 AM, Peter Lovatt wrote:
search for
my.cnf
If it does not exist you can create it,
http://www.mysql.com/doc/en/Option_files.html
Peter
-Original Message-
From: Richard Sum
Where do I go to set the max_connections settings so I can have over
100?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
forthcoming MySQL 4.0.14 to see if any bugs fixed solve my
problem.
2. Upgrade the kernel to RedHat's 2.4.20 (update to RH 8.0)
3. Try to tweak MySQL settings
4. Install kernel.org's 2.4.21 kernel without RedHat patches.
Does anyone have any other ideas? Thanks again for your help!
Richa
I am running 2.4.18-smp. You said you upgraded to a 2.4 smp kernel and it
solved the problem? What 2.4 version exactly did you run and was it a
RedHat kernel? Thanks.
Richard Gabriel
Director of Technology,
CoreSense Inc.
(518) 306-3043 x3951
- Original Message -
From: "Joseph
What do you consider "high" volume? Also, please keep me in the loop on
this. Any configuration changes that help would be appreciated. Thanks!
Richard Gabriel
Director of Technology,
CoreSense Inc.
(518) 306-3043 x3951
- Original Message -
From: "Tom Roos" &l
Thank you very much for the help. I will schedule the upgrade and see if
helps. I have 2 other machines running 2.4.18 without problems, but they
also do not run the volume that the problematic machine has and they do not
have RAID. Take care.
Richard Gabriel
Director of Technology,
CoreSense
Thanks for the tip. I'll see about upgrading, but it won't be a small task.
Any reason why 2.4.18 problems wouldn't have effected MySQL 3.23? I'm
trying to search for a solution that does not involve upgrading kernels on
20 machines that are in production use right now. Th
-id=1
master-host=192.168.1.3
master-user=repl
master-password=*
master-port=3306
set-variable = query_cache_size=268435456
Log Entries:
[The first entry is repeated many times. The second is from the
mysqlcheck cron that repairs the tables]
030715 0:43:49 read_const: Got error 127 when reading table
030715 2:00:31 Note: Found 23550 of 23551 rows when repairing
Thanks again for your help in advance!
--
Richard Gabriel <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Type the command
echo $PATH
You will see a set of semicolon delimited directory path names. Perhaps
something like
/usr/local/bin:/usr/bin:/bin:/usr/local/sbin:/usr/sbin:/sbin:/usr/X11R6/bin
The configure script is looking in each of these locations for an
acceptable C compiler. Either you do no
I couldn't get the LOCAL option to work; even when I started mysql with
the --local-infile argument. After reading around in the manual I decided
to grant myself the FILE privilege since I am the only user on my computer
where I am teaching myself mysql.
On Friday, July 4, 2003, at 12:08 PM, Pa
I have mysql 3.23.49 on Mac OS-X 10.1.5 and am going through the tutorial
in the "MySQL Reference Manual" in Chapter 3.
I get an empty set with the following command:
SELECT * FROM pet WHERE birth >= "1998-1-1";
I have tried many variations which all give either the empty set or
incorrect resu
Do you have any idea when version 5.0 will be available?
regards,
Richard Duffy
Dresdner Kleinwort Wasserstein
Group Risk Management IT
DDI: +44 (0)20 7475 7652
[EMAIL PROTECTED]
--
If you have received this e-mail in error
Jeremy Zawodny wrote:
On Sun, Jun 29, 2003 at 08:55:30AM +0200, Richard Fuchs wrote:
Jeremy Zawodny wrote:
On Sat, Jun 28, 2003 at 01:14:37PM +0200, Richard Fuchs wrote:
are there any known issues with this combination, or with mysql 4.0.13
or freebsd 5.1 in general? what could be the cause
Jeremy Zawodny wrote:
On Sat, Jun 28, 2003 at 01:14:37PM +0200, Richard Fuchs wrote:
are there any known issues with this combination, or with mysql 4.0.13
or freebsd 5.1 in general? what could be the cause for this, and how
could it be fixed?
You seem to be the first reporting a problem
e that it keeps happening
randomly ;)
are there any known issues with this combination, or with mysql 4.0.13
or freebsd 5.1 in general? what could be the cause for this, and how
could it be fixed?
tia
richard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
many (30 to 50) 2gb InnoDB files adversely effect performance
or the size of the indexes/tables?
Thanks!
--
Richard F. Rebel
[EMAIL PROTECTED]
t. 212.239.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
I just loaded mySql on windows98.
I try to run it and I get the following messages:
C:\mysql\bin>mysqld --standalone --console
030605 19:10:46 InnoDB: Started
C:\MYSQL\BIN\MYSQLD.EXE: ready for connections.
Version: '4.0.13-max-debug' socket: '' port: 3306
I do not get a prompt back. I assume
can you help me with mySql control console.
it is presenting me with a window to register a server.
I am running mySql locally on my workstation.
It wants a Name for the server. I called it TestMySql
host name: I put [EMAIL PROTECTED]
User name: I put root
Password: I don't know what password it i
That changes the query plan and might
> mask the bug whatever it is.
I have done this, and will report if it diminishes or masks the problem.
We cannot upgrade to 4.0 right now as we have several large deployments
and it's a large undertaking to recompile everything with the right
clien
Hello Heikki,
On Wed, 2003-06-04 at 14:29, Heikki Tuuri wrote:
> Richard,
> hmm... maybe mysqld is reporting a wrong query in a crash. Do you have any
> BLOB (or TEXT) tables and what kind of queries you run on them? How big are
> the BLOBs if any?
>
> The hex dump looked
t, we see little change from that 374 megs figure. I
can try and install something that will monitor more than once per
minute (our current granularity).
I will change the buffer sizes as you mention and test.
But, after all of this, where does it lead us? The thing is still
crashing. :(
Best,
numbers tho, but the
last time I did decrease the numbers you mentioned performance dropped
and our batch jobs (not the web queries) now take about 20% longer to
run. Do you think decreasing sort and record buffer figures might
effect performance?
Thanks,
Richard
[EMAIL PROTECTED] log
followed the advice to use the most recent MySQL
and to alter a few variables which did seem to help for a couple of
weeks atleast. Our db traffic really hasn't changed much since then so
I am flummoxed as to why now this would resurface.
Thanks,
Richard F. Rebel.
/usr/sbin/mysqld-max: ready
ne is interested.
Richard Hyatt
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You could try:
Datanamic's Dezign - www.datanamic.com
or you could use MS Visio Professional
HTH
Richard
>> Dear MySQL users developers and programmers,
>> ERWin 4.1 not applicable for MySQL
>> I'd like to model some logical databases in Entity Relationsh
I am with you jeremy... Web based discussion boards are horrible. I never remember to
go daily. I can write my responses to this on the train and send them when I get to my
desk.
Rich
>> On Mon, Mar 31, 2003 at 12:52:43AM -0800, Seth Brundle wrote:
>> >
>> > I really hate mailing lists -
If you had installed RedHat's RPM, then you should be able to start MySQL
with /etc/rc.d/init.d/mysql start
Regards
Richard KHOO Guan Chen
On Wed, 26 Mar 2003, Toto Gamez wrote:
> i installed mysql-3.23.41-1 on my RH7.2 box but when i run safe_mysqld, mysql
> daemon
I am having a problem getting this to work and the documentation
I have found doesn't seem to be helping, hopefully someone out there
can help me.
I am using MySQL 4.01-Gamma on a Debian Linux box. I have configured
MySQL exactly as the manual shows in Section 4.3.9 - Using Secure
Connections, inc
in their own way. I
know I can create a column in each table that describes which table the
row actually is being retrieved from, but I am looking for a more
intelligent solution.
Thanks! :-)
Best regards,
Richard Taubo
! :-)
Best regards,
Richard Taubo
-
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
ne the swapping.
Any help here is greatly appreciated.
Thanks
Richard
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
301 - 400 of 836 matches
Mail list logo