Hi!
I hope that this message goes to the right 'thread' in the mailing
list; not replied to a thread before.
Monty recommended that we should wait still for a few weeks before
releasing MySQL 4.0/Innobase-alpha, to keep source code versions in
control.
But I can now report here the current stat
Hi again
Now i've tried running with the 3.23.26-beta from the ports tree for a
couple of days, and the server has got a lot more stable, but stil we
experience appox. 20 restarts a day. Furthermore we are getting a lot of
these:
Aborted connection 64 to db: 'username' user: 'testuser' host: `lo
>Description:
when i compile apache and php4 with mysql and postgresql support i have this
error for mysql
#
<=== src/modules
gcc -c -I./os/unix -I./include -DLINUX=2 -I/usr/src/php-4.0.4pl1
-I/usr/src/php-4.0.4pl1/main -I/usr/src/php-4.0.4pl1/main -I/usr/src
>Description:
when i compile apache and php4 with mysql and postgresql support i
have this error for mysql
This is the error
#
<=== src/modules
gcc -c -I./os/unix -I./include -DLINUX=2 -I/usr/src/php-4.0.4pl1
-I/usr/src/php-4.0.4pl1/main -I/usr/src/php-4.0
Hi,
> That's no bug. That is what timestamp is, current date and current time no
> matter whether you insert or update. Read the manual more carefully. What
> I think you want is date column, not timestamp.
If you really do want to store an actual timestamp figure in your table
without it bei
Stuart Fox wrote:
>
> Hi
>
> Can anybody tell me what this error means
>
> user@server#isamckh -av {database}/*.ISM
>
> isamchk: error: 22 when opening ISAM-table '{database}/tax.ISM'(all
> tables)
>
If this was part of a script, then database was a variable that
contained the full
path to th
That's no bug. That is what timestamp is, current date and current time no
matter whether you insert or update. Read the manual more carefully. What
I think you want is date column, not timestamp.
- Original Message -
From: "Marc Swanson" <[EMAIL PROTECTED]>
To: "mysql list" <[EMAIL P
[EMAIL PROTECTED] wrote:
>
> The grant was done by:
>
> # echo "grant INSERT,SELECT on snort.* to
> snortdb@'XXX.XXX.0.0/255.255.0.0';" | mysql -u root -p
>
> The system has TCP wrappers setup and the hosts.allow file is empty and
> hosts.deny is set to ALL:ALL. next time I'm at work I'll try
Hello list,
I am wondering if this bug I found in 3.23.22-beta is a known bug that has
been fixed in laater servers.
How to replicate:
create table test_bug (
text_field varchar(20) NOT NULL,
date_field timestamp(14)
);
insert into test_bug (text_field,date_field) values
('foo','2001010708
Hello
After upgrading to 3.23.31, FULLTEXT selects give often "error -1 from
table handler" for me. The error log says "ft_read_first: Got error
-1 when reading table foo". I think I have not seen those for older
3.23.x versions (x=28 or so), at least not that frequently.
A small example to re
Hi everybody,
This my first message and I'm french so be patient with me.
I have Apache, Mysql and PHP 4.0 unning on my P.C. with Windows 98.
Untill soon I have no trouble.
But this week mysql gone crazy.
When I look with phpmyadmin to my mysql base it's seems thats mysql look on
the wrong di
>Richard Ellerbrock wrote:
>
>> I am not 100% sure I understand you but I presume you are talking about the
>2Gig file size limit of some OS'es? If this is the case, just find out where
>MySQL stores its databases and have a look at the filesize - you are using the
>C API, so doing a call to ge
Richard Ellerbrock wrote:
> I am not 100% sure I understand you but I presume you are talking about the 2Gig
>file size limit of some OS'es? If this is the case, just find out where MySQL stores
>its databases and have a look at the filesize - you are using the C API, so doing a
>call to get t
Thimble Smith wrote:
>
> > >Description:
> > I just downloaded MySQL 3.23.31 and the "patched version" of
> > Berkeley DB 3.2.3h from the www.mysql.com site. I ran configure
> > with the option to enable the Berkeley DB, but it fails, telling
> > me I don't have the prope
Hello,
I have a problem with mysql 3.23.30-gamma. On the busy days with much
traffic on t he website, it hapens that suddenly mysql is taking all the
resources of the machine at very high speed. The swap increases quick,
the threads increase from about 30 (which is average) to over 70 and if
I am not 100% sure I understand you but I presume you are talking about the 2Gig file
size limit of some OS'es? If this is the case, just find out where MySQL stores its
databases and have a look at the filesize - you are using the C API, so doing a call
to get this info should be trivial.
Dat
Normally connecting to the true DNS hostname or the ip address of the machine will do
the trick. Connecting to localhost will connect via the loopback address of 127.0.0.1.
--
Richard Ellerbrock
[EMAIL PROTECTED]
>>> Ben Peter <[EMAIL PROTECTED]> 2001/01/19 02:19:47 >>>
Hi all,
can I force the
I need to test the relative "fullness" of a given table
relative to its maximum size on the OS. I am doing
everything through the C API. What I would like is
to be able to ask is, how full is table "bletch?", and get back
something like 87%.
The reason I am doing this is that I am dealing with
hu
Hi all,
can I force the mysql clients to use a tcp/ip connect if connecting to
'localhost'?
This need stems from the following situation:
I have an ssh account and a mysql DB on one host at my isp. The db can only
be accessed from 'localhost', not from any other.
I use an ssh tunnel to forward
> >Description:
> I just downloaded MySQL 3.23.31 and the "patched version" of
> Berkeley DB 3.2.3h from the www.mysql.com site. I ran configure
> with the option to enable the Berkeley DB, but it fails, telling
> me I don't have the proper version of the DB. Here are the
>We are thinking of moving to MySQL. We have a table of several tens
>of millions of rows, with two indices, which will be accessed by
>roughly 100 different processes. At any one time, 5 or so of the
>processes will be doing selects on the table, while 40 or so will be
>doing updates. However, n
>Hi.
>
>On Thu, Jan 18, 2001 at 05:39:25PM -0500, [EMAIL PROTECTED] wrote:
> >
> > How can I do the following:
> >
> > update location set location.city_id = location_city.city_id where
> > location.city = location_city.name;
> >
> > I want to update one field in a table with values from an
>This gives me one instance of each file name in the DOCUMENTS column
>submitted into the database. The only thing though is it gives me the
>oldest of the file name in the DOCUMENTS column which are submitted. Any
>ideas how to get the newest one? I've tried adding: , MAX(ID) after the
>SELECT
>I have a table called CONTENT. Columns called ID (primarykey), DOCUMENT
>(varchar(50)), DESCRIPTION (text). People submit files to our intranet and
>we collect info. about them in this table. If people have made changes to
>the doc. they just resubmit it to the intranet. So there can be many re
Hi!
> "Chris" == Chris Johnson <[EMAIL PROTECTED]> writes:
>> Description:
Chris> I just downloaded MySQL 3.23.31 and the "patched version" of
Chris> Berkeley DB 3.2.3h from the www.mysql.com site. I ran configure
Chris> with the option to enable the Berkeley DB, but it fails, telling
C
Hi
Can anybody tell me what this error means
user@server#isamckh -av {database}/*.ISM
isamchk: error: 22 when opening ISAM-table '{database}/tax.ISM'(all
tables)
System is RedHat 7.0 i386 SMP Standard Kernel
mysql-3.22.32 standard compile from source --prefix=/usr/local
Ive tried with/withou
john1 writes:
> dear Sir :
>
> MySQL 3.22 on my linux 486 PC seems work so good. when I compile
> a simple C API programe which catched from the MySQL tutorial, it
> chokes at the end of compile process . the programe is as follows:
>
> #include
> #include
>
> #define def_host_name
[EMAIL PROTECTED] writes:
> Hi there,
> I am setting up a lab on MySQL and I am not able to.
> Its a red hat 7.0 server and has PHP installed and working with apache.
> I installed MySQL from the very RPMs Red Hat provided.
> Whenever I try to start the server, I get the error message:
>
> Can't
I use mysql-jdbc-java.
I connect java with my database and I've this message :
DBLocationHandler: Figuring out the locations and names! (This is a one-time
operation!)
*** ERROR ***
DBLocationHandler:SQL Exception: Column Index out of range
*
java.sql.SQLException: Column Index o
Mike Yuen writes:
> Is there anyway to tell how many connections are currently being served by
> MySQL. I'm using this in combination with PHP. Also, does MySQL
> automatically shut down when you leave the page? I'm not using
> mysql_pconnect - just the regular mysql_connect.
Hi!
You are prob
ps -ef|grep -c mysql
Subtract 3 from this as this is the default number of daemons that
start. One is spawned for each new child.
Yes, if the php script terminates, the mysql child will also terminate.
This is not the behaviour with persistant connections though. Please
move this over to the php
Read the manual on INSERT statement. You can INSERT and SELECT at the
same time.
Alejandro Lujan Toro wrote:
>
> I have a calendar db, and in there a base table (with
> holidays and such). I need to create a table, exactly the
> same as the base (data included). Is there an easy way of
> doing t
Matt Wagner wrote:
>
> Greg Cope writes:
> > Chris Johnson wrote:
> > >
> > > >Description:
> > > I just downloaded MySQL 3.23.31 and the "patched version" of
> > > Berkeley DB 3.2.3h from the www.mysql.com site. I ran configure
> > > with the option to enable the Berkele
101 - 133 of 133 matches
Mail list logo