We're looking for a client-server instant messaging system (opensource),
powered by MySQL if possible. Anyone know of one?
I've been taking a look at Gaim, Sim etc, but these all piggyback on Yahoo,
MSN etc which is not what we're looking for since it must run on our lan.
Thanks for any ideas...
Hello Everybody,
I am totally new to MySQL. Wanted to know if MySQL supports any options
using which users can specify the row storage order. For instance, Let
us consider the Employee table, Now I want to store rows of this table
in EmpId column order. The rows should be physically stored in asc
Hi again!
This query is ok:
create table TEST (id int,saturs char(255) charset utf8 )
alter table TEST add fulltext (saturs);
drop table TEST;
,
create table TEST (id int,saturs char(255) charset utf8 collate utf8_bin )
alter table TEST add fulltext (saturs)
Can't create table './likumi/#sql-240
Dimitri,
please upgrade to a newer MySQL version.
"
Starting from MySQL 4.0.13, you can use SHOW INNODB STATUS to display a
detailed explanation of the latest InnoDB foreign key error in the server.
"
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for M
On Mon, 7 Jun 2004, Haitao Jiang wrote:
> Marc
>
> mysqld runs on a very powerful Operton machine with
> 16GB memory and barely any other application process
> running, it is hard to believe that a simple select
> that runs under 2 second will utilize all the
> resources...that is why I tend to th
On Monday, June 07, 2004 07:54, Jeff Smelser wrote;
> On Monday 07 June 2004 12:49 am, Emmanuel van der Meulen wrote:
> > I've looked in several books and searched Google but cannot get a way of
> > doing this. It seems Oracle has a 'FIRST' in their select
> which they use
> > for such a use case
Daniel Kasak wrote on Tuesday, June 08, 2004 00:38;
> Emmanuel van der Meulen wrote:
>
> >Hello all,
> >
> >Does anyone have an estimate of when MySql 4.1 will be released for
> >production.
> >
> >MySql.cm says soon.
> >
> >Please advise, would that likely be weeks/months?
> >
> >Kind regards
>
Marc
mysqld runs on a very powerful Operton machine with
16GB memory and barely any other application process
running, it is hard to believe that a simple select
that runs under 2 second will utilize all the
resources...that is why I tend to think there is
something in the mysql set up that caused
Hi All!
Does works fulltext index on utf8 columns on boolean mode
correctly on
MySql 4.1.2 ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
Can someone tell me how I can use mysqld_multi to have one RPM installation
of MySQL(default with RedHat9) to run multiple mysqlds?
Thanks
-Minuk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
starofframe wrote:
Thanks a lot Mike... what's a clear explanation...
You're welcome.
Actually I have used
WHERE crea_dt + interval 1 day < curdate()
before I read ur reply ...but now I guess I better change it to WHERE
crea_dt>curdate-interval 1 day
That's probably just a typo, but just in case, y
On Mon, 7 Jun 2004, Haitao Jiang wrote:
>
> Yes. The time I measure like I said is purely around
> statement.execQuery() call. Connection creation is not
> a factor here at all.
>
> My database has 1.64 million rows and 4 queries are
> all selects, which are identical in both serial and
> parallel
Thanks a lot Mike... what's a clear explanation...
Actually I have used
WHERE crea_dt + interval 1 day < curdate()
before I read ur reply ...but now I guess I better change it to WHERE
crea_dt>curdate-interval 1 day
again thanks a lot... and thanks to Jeff too.
Sukanto
--
MySQL General Mailing L
Oppz! Sorry for overlooking your timing method.
In this case, I believe if you run the query in four different machines
at the same time, the statistics should almost the same as running four
consecutive queries in the same machine.
I believe the multi-threading implemented in the JVM and the OS
Jeff Smelser wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 07 June 2004 10:03 pm, starofframe wrote:
but
delete from table where date_sub(crea_dt, interval 1 day)
Here:
http://dev.mysql.com/doc/mysql/de/Date_and_time_functions.html
I gave you the function.. You can figure out how m
Yes. The time I measure like I said is purely around
statement.execQuery() call. Connection creation is not
a factor here at all.
My database has 1.64 million rows and 4 queries are
all selects, which are identical in both serial and
parallel cases.
In serial cases:
Query 0 took 590
Query 1 took
I just started setting up a dual opteron system with
Suse 9.1 (x86_64). At this point, I am sticking with the
Suse provided rpms.
I am having some odd mysql restarts (crashed with immediate
restart by safe_mysqld). Odd part about it: not a single line
in the error log. The connections just drop a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 07 June 2004 10:03 pm, starofframe wrote:
> but
> delete from table where date_sub(crea_dt, interval 1 day) should delete all data right???
> All I want is compared to date_now
> eg : now is 2004-6-8 and all I want to delete is data t
Yes, I did found out just now...
but
delete from table where date_sub(crea_dt, interval 1 day)
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 08, 2004 9:41 AM
Subject: Re: delete record that passed > 1 day
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 07 June 2004 09:22 pm, Jeff Smelser
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 07 June 2004 09:22 pm, Jeff Smelser wrote:
> On Monday 07 June 2004 09:25 pm, starofframe wrote:
> > Hi Jeff,
> > you mean I can use sql like this
> > DELETE FROM table where date_sub(crea_dt, interval 1 day)
>
> Add: > crea_dt
Could be
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 07 June 2004 09:25 pm, starofframe wrote:
> Hi Jeff,
> you mean I can use sql like this
> DELETE FROM table where date_sub(crea_dt, interval 1 day)
Add: > crea_dt
- --
Anything worth fighting for is worth fighting dirty for.
Hi Jeff,
you mean I can use sql like this
DELETE FROM table where date_sub(crea_dt, interval 1 day)
thanks a lot
Sukanto
- Original Message -
From: "Jeff Smelser" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 08, 2004 8:55 AM
Subject: Re: delete record that passed >
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 07 June 2004 08:36 pm, starofframe wrote:
> description like this : if now()-crea_dt > 0 then delete
select date_sub(crea_dt, interval 1 day)
- --
"If you're like me, and I know *I* am..." -- Joel Robinson
-BEGIN PGP SIGNATURE---
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
> AFAIK, creation of connection from DB is expensive. This is one of the
> reasons why we need connection pooling.
>
Jonathan,
While that might be true for other databases, it's not true for MySQL
(connections are a few ms.
Hi all,
I have mysql table that has a field named 'crea_dt' (it records the creation date of
data)...
I want to delete records that have passed for more than a day
description like this : if now()-crea_dt > 0 then delete
But I just can't find the suitable mysql command for this function.
Anyo
AFAIK, creation of connection from DB is expensive. This is one of the
reasons why we need connection pooling.
Best Regards,
Jonathan Chiu
OOCL Logistics
Unit 1, 4/F., Sun Hung Kai Centre, 30 Harbour Road, Wanchai
TEL: 852 . 2990 0174
FAX: 852 . 28249017
-Original Message-
From: Haitao J
> > 1. The timeout is set to 5 min, because of the number of queries, there
> > are a lot of unused http processes that linger with connections, and the
> > only way to seeminly keep MySQL connections available is to keep
> > timeouts short.
> What about using a connection-pool?
> Like Apache::DBI.
> Thank you very much for your bug report!
> And sorry if I doubted your report at the beginning; I hadn't thought
> of the rpm script.
No problem. I sometimes get bug reports that I know are impossible! Yet they
weren't. This one I would have barely noticed if it had not knocked the
slaves all of
Hi,
I would appreciate any help on this: I got approximate
same timing on following two:
case 1: create 1 jdbc connection and issue 4 queries
sequentially
case 2: create 4 jdbc connections and issue 4 queries
via 4 different threads at the same time
The timing is done around statement.execQuery
Hi,
> 1. The timeout is set to 5 min, because of the number of queries, there
> are a lot of unused http processes that linger with connections, and the
> only way to seeminly keep MySQL connections available is to keep
> timeouts short.
What about using a connection-pool?
Like Apache::DBI.
It sho
I have been maintaining a mod-perl/MySQL4 web search engine with about 3M records,
which gains and drops about 100k records daily.
It runs on a dual-Opteron 242 system with 8GB RAM, 15k SCSI driv, SUSE Professional
for AMD64.
It recently grew to this size (from about 1M records), and I am encoun
Emmanuel van der Meulen wrote:
Hello all,
Does anyone have an estimate of when MySql 4.1 will be released for
production.
MySql.cm says soon.
Please advise, would that likely be weeks/months?
Kind regards
Emmanuel
Months. I'd say at least 6 months.
--
Daniel Kasak
IT Developer
NUS Consulting Gro
Hello,
I am dumping a single innodb DB using mysqldump. Everytime I do it, it
crashes the slave thread.
Below are the commands I'm using to dump [I also have tried
--delete-master-logs command in the actual data dump too (second line)
with the same problem.] I am willing to hear advice on the be
At 22:33 -0700 on 06/06/2004, David Blomstrom wrote about OT: Errors
from Extra Spaces in Spreadsheets:
I've been having a tough time importing
comma-delimited files into my database tables. I just
discovered that most of the errors are similar to this
one:
"060 " is not a valid integer value
I c
At 14:01 + on 06/07/2004, shaun thornburgh wrote about Re: DELETE
from more than one table:
Hi Paul,
Thanks for the reply.
I actually need to delete data from about 10 tables, is this possible?
If the field in the tables is defined as a Foreign Key (with ON
DELETE CASCADE), deleting the root
Ok, it seems I fixed my problem before anybody was available to help me.
The error was due to bad code -- the program was trying to send multiple
queries through the same connection. Even though it was compiled as
"thread safe", you still have to find some way to prevent concurrent
queries on
Hi Scott,
Really in user table not modify nothing, but in db table the privileges
appear ok.
Your user get message of access denied?
Regards,
Renato Cramer.
-Mensagem original-
De: Scott Fletcher [mailto:[EMAIL PROTECTED]
Enviada em: segunda-feira, 7 de junho de 2004 17:29
Para: [EMAIL P
I'm having a little trouble with granting the correct privilege to the
user with one database instead of all databases. When I do this with
all databases, it work great..
--snip--
//Issued SQL Command...
GRANT ALL ON *.* TO 'Username'@'localhost.domain.com'
IDENTIFIED BY 'Password'
//Corre
David,
Daniel is exactly right. In general, it is not a good idea to try to cram
two pieces of data into one column. Your questions at the end of your post
are good examples of why you don't do it that way. With a population column
and a separate population_note column, you can easily answer
On Jun 5, 2004, at 11:40 PM, David Blomstrom wrote:
Here are a few rows from the comma delimited file I
imported. Do you have a hunch what might be going on
here?
Thanks.
"gd","oat",239,,"Grenada","nat"
"gp","oat",240,,"Guadeloupe","dep"
"ht","oat",241,,"Haiti","nat"
"is","oat",242,,"Iceland","nat"
Paul McNeil wrote:
Thank you very much for the response. According to MySQL Control Center the
MySQL DB I am connecting to is version 4.0.17. Possibly that is the
problem.
You'll get quicker (and, on average, better) responses if you keep the
thread on the list.
I have mysql 4.0.17 running on a
is that a problem?
I want to avoid ftp db.txt files and then mysqlimport them
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 02, 2004 4:38 PM
Subject: Re: [mysql-php] mysqlimport error
> "nikos" <[EMAIL PROTECTED]> wrote:
> >
>
Hello,
I am dumping a single innodb DB using mysqldump. Everytime I do it, it
crashes the slave thread.
Below are the commands I'm using to dump [I also have tried
--delete-master-logs command in the actual data dump too (second line)
with the same problem.] I am willing to hear advice on the b
This doesn't quite make sense. You seem to say that several rows will match
but then you say only one will. It must be one or the other. Perhaps I've
misunderstood you. You also seem to imply that with BETWEEN you get a full
table scan even though there is only one match for each row. That
Paul McNeil wrote:
Good morning to all.
I have a problem with a workaround but I wanted to know if others have run
into this.
Are you sure the problem is with mysql? If so, which version do you have?
I have 4.0.20, and I get different (expected) results.
Table DATA
Column strength [double]
CREAT
Hi.
I'm having this problem on 4.1.2, when I run myisamchk -o on my table I
get a bunch of these lines:
Duplicate key 3 for record at 56134200 against new record at 244828223
then it segfaults.
key 3 is a fulltext. I tried the same thing on the same data with 4.0.14
and it worked fine, I als
You're right - it is a data related issue. I finally made it work with
the live data on high speed but in a way that puzzles me. Do you know
the explanation ? (I'm using mySQL 4.1.1a-max-nt on Win2K)
The index of the primary key is using the same data set (content and
size) for both the test and l
>Description:
I have just built 4.1.2 from source (in order to include OpenSSL), and
find that the regression testing fails on the first test. The
master.err contains the following:
CURRENT_TEST: alias
/usr/local/src/db/mysql-4.1.2-alpha/sql/mysqld: ready for connections.
Version: '4.1.2-alpha-d
Hi Paul,
Thanks for the reply.
I actually need to delete data from about 10 tables, is this possible?
From: "Paul McNeil" <[EMAIL PROTECTED]>
To: "shaun thornburgh" <[EMAIL PROTECTED]>
Subject: RE: DELETE from more than one table
Date: Mon, 7 Jun 2004 08:47:04 -0400
I believe you can use...
Delete
In both cases you will have to write your own code. MySQL, so far, only
can store Spatial data and do very simple (still, r-tree optimized) GIS
queries (like: all objects inside rect).
mirza
Terry Pothecary wrote:
Hi.
This may be a daft question, so forgive me:
I am just starting out with the Sp
Thanks, but I have innodb tables as well.
I don't see any caveats in the docs for mysqldump, so I'm *assuming* it'll
work correctly, but I'd like to hear from someone who is counting on it in a
production environment, just to be sure.
Thanks,
Lou
- Original Message -
From: "McKeever Ch
Thanks for the response.
Does this mean that I would not use perl and only program in
VBA?
If I do need perl does it have to be installed on the Windows side?
Where can I get some examples with ODBC in VBA?
thanks.
Mike Hillyer <[EMAIL PROTECTED]> wrote:
Annie Law wrote:
> Hi,I would appreci
Are you catching the error? Are you sure the value returned is what you are
expecting?
-Original Message-
From: Dean Urmson
To: 'Paul McNeil'; [EMAIL PROTECTED]
Sent: 6/7/04 8:16 AM
Subject: RE: Select double value
>> The problem is that in my java.sql.ResultSet.getDouble("strength")
>>
>> The problem is that in my java.sql.ResultSet.getDouble("strength")
>> a zero amount throws a number format exception.
Hi Paul,
Not a Java user so I haven't tested this.
You could try...
SELECT abs( strength ) FROM data ;
It 'might' stop the exception!
Cheers
Dean
--
MySQL General Maili
David Blomstrom wrote:
I just discovered that one of my MySQL tables is
incomplete. I created it by importing a comma
delimited file I had made from a spreadsheet, but it
appears as many as 3,000 rows or so were missing.
So I decided to give it another try. MySQL Front
refused to import it because
On Mon, 07 Jun 2004 12:36:47 +
"shaun thornburgh" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Is it possible to DELETE from more than one table in one command?
>
> Thanks for your help
DROP TABLE IF EXISTS table1, table2, table3;
http://dev.mysql.com/doc/mysql/en/DROP_TABLE.html
Josh
--
MySQL
Good morning to all.
I have a problem with a workaround but I wanted to know if others have run
into this.
Table DATA
Column strength [double]
When I select strength from DATA and the result is a non zero amount it
returns correctly
3.256498
however if it is a 0 amount I get
0.
The p
Hi,
Is it possible to DELETE from more than one table in one command?
Thanks for your help
_
Want to block unwanted pop-ups? Download the free MSN Toolbar now!
http://toolbar.msn.co.uk/
--
MySQL General Mailing List
For list archive
Jesse <[EMAIL PROTECTED]> wrote:
> anyone know why the mysql daemon fails to start after I set the root
> password according to this:
>
> http://dev.mysql.com/doc/mysql/en/Default_privileges.html
>
> I use the command:
>
> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpwd');
> SET PASSWORD
David:
Microsoft has a converter for Works files at
http://www.microsoft.com/downloads/details.aspx?FamilyID=b9e11e83-f51b-4977-b572-8c042df802c1&displaylang=en
I did'nt see any online documentation
HTH,
Martin
- Original Message -
From: "David Blomstrom" <[EMAIL PROTECTED]>
To: <[EMAIL PR
I need to do some operations which insert mass amounts of records which then
must be sorted, and would like to use table locking.
The flow I'm looking for is:
LOCK TABLE A WRITE LOW_PRIO
DELETE FROM TABLE A (This used to be TRUNCATE TABLE A, but that complained
when I started locking)
LOAD DATA IN
Dear ladies and gentlemen,
Upscene Productions is happy to announce a new version of
the database developer tool:
"Advanced Data Generator" (version 1.1.0)
A fast test-data generator tool that comes with a library
of real-life data, presets and much more.
This new release consists of four versio
Hello guys,
I'm new with MySQL and i'm facing problem with the installation!
I've Windows XP pro and when i install MySQL(mysql-4.1.2-alpha-win) it work but when i
try to connect or even open mysqladmin.exe it works but not in windows mode it only
work in command mode!
Also when i tried to open
You are only listing processes owned by you. ps -e will show all
processes, add -f for a full listing.
> -Original Message-
> From: Tobias Bohlin [mailto:[EMAIL PROTECTED]
> Sent: 07 June 2004 11:30
> To: [EMAIL PROTECTED]
> Subject: Can't start server: Bind on TCP/IP port: Address
> alre
Tobias Bohlin wrote:
I have restarted the Linux server. Typing
>mysqld
result:
040607 11:32:47 Can't start server: Bind on TCP/IP port: Address
already in use
040607 11:32:47 Do you already have another mysqld server running on
port: 3306 ?
040607 11:32:47 Aborting
You don't ever start MyS
Hi Tobias
Got the same problem on my local machine.
Try
@ps -aux
And kill all mysql stuff manually
Worked for me
Cheers jan
-Ursprüngliche Nachricht-
Von: Tobias Bohlin [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 07. Juni 2004 11:30
An: [EMAIL PROTECTED]
Betreff: Can't start server:
Hi.
This may be a daft question, so forgive me:
I am just starting out with the Spatial extensions and I am wondering
how I can use it to determine the distances between any 2 landmarks that
have been entered as POINTs in the database. The POINTs are entered with
longitude and lattitude coordina
i dont have that section in my status report (ill tried it before)
here's the report
*** 1. row ***
Status:
=
040607 10:04:41 INNODB MONITOR OUTPUT
=
Per second averages calculate
Hi,
Can somebody tell me if 'key_buffer' and 'key_buffer_size' are the same variables ?
Perhaps it is just a question of syntax, I mean, in the my.cnf
you write key_buffer=100M
or you write set-variable = key_buffer_size=100M
Same question for
sort_buffer and sort_buffer_size,
thread_cache a
Hi!
I have restarted the Linux server. Typing
>mysqld
result:
040607 11:32:47 Can't start server: Bind on TCP/IP port: Address
already in use
040607 11:32:47 Do you already have another mysqld server running on
port: 3306 ?
040607 11:32:47 Aborting
040607 11:32:47 mysqld: Shutdown Complete
T
Hi. SQL
I use mysql-4.0.X under FreeBSD-5.2.1
There is no problem with libc_r.
But under heavy loading with kse mysqld doesn't shutdown.
This problem isn't only with kse.
It was discussed some weeks ago.
And if I remember it is exist with any other pthreads and under linux too.
With kse mysql do
[EMAIL PROTECTED] wrote:
>
> Anybody know how do I know if innoDB is enabled?
SHOW VARIABLES LIKE "have_innodb";
If InnoDB is enabled, you will see 'YES' in the output.
>
> I have MySQL 3.23 installed. The MySQL document says "the simplest way to
> install MySQL-Max is to replace the executabl
Hi,
Anybody know how do I know if innoDB is enabled?
I have MySQL 3.23 installed. The MySQL document says "the simplest way to
install MySQL-Max is to replace the executable mysqld server with the
corresponding executable from the MySQL-Max distribution. " Where can I get
the "mysqld" of MySQL-Ma
Does anyone know how to configure MySQL on JBoss
3.2.3? This is what I have done:
(i) copy /jboss3.2.3/docs/examples/jca/mysql-ds.xml to
jboss3.2.3/server/default/deploy/ where ECPerfDS is
the dtabase jndi name:
++
ECPerfDS
jdbc:mysql://10.10
74 matches
Mail list logo
