On Tue, 11 Jun 2002 08:36:55 +0200
Leo De Geer <[EMAIL PROTECTED]> wrote:
> im not abel to get mysql to use more then one thread on my freebsd 4.5-stable
> any one having a klue that wrong?
>
from what method / tools, you get this information ?
try mysqladmin -p status
--
> Linux is not
im not abel to get mysql to use more then one thread on my freebsd 4.5-stable
any one having a klue that wrong?
regards leo
--
MVH C. Leo De Geer
www.dinsignal.com
www.ktv.se
www.teknikshoppen.nu
-
Before posting, please c
I'm writing some routines which generate SQL queries, and I'm trying to
keep things generic. As such, I have a routine to SQL Escape some text,
such that it can be used in a query without breaking anything. This
routine predominantly consisted of preceeding all single quotes (') with
a backsla
Hi,
I tried to flush the logs but still the rotation doesn't happen.
What else could be the problem ??
I get the same message again
My config file read like this
"/var/log/mysqld.log" {
rotate 5
size=100k
create 0
> Indexes are only used if they significantly reduce the number of reads
> required vs a full table scan (I believe 30% is mysql's threshhold).
> An IS NOT NULL clause may very well use an index if almost all of the
> records have NULL in that particular field. A != clause is a bit
> harder, sinc
In the last episode (Jun 10), Dan Nelson said:
> In the last episode (Jun 11), César L. Aracena said:
> > I have a problem when posting. The thing is that every time I post to
> > the mailing list, I get an error saying that the message could not be
> > delivered but it does indeed.
> >
> > I had
In the last episode (Jun 11), César L. Aracena said:
> I have a problem when posting. The thing is that every time I post to
> the mailing list, I get an error saying that the message could not be
> delivered but it does indeed.
>
> I had the same problem when posting at one of the php.net mailin
G'day César
> I have a problem when posting. The thing is that every time I post to
> the mailing list, I get an error saying that the message could not be
> delivered but it does indeed.
It's getting delivered to the list OK but one of the subscribers to the list
is rejecting it. I've seen
Each time I post to the MySQL list I get two messages as follows.
- Original Message -
From: Mailer-Daemon <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 10, 2002 9:10 PM
Subject: NDN: Re: Here's something
> Sorry. Your message could not be delivered to:
>
> mailing lis
Well... thanks Cal & Day. Your thoughts are brillant.
It makes me very proud that more experienced DB designers think I'm
doing great.
About the normalization rules, I have them inside the "PHP and MySQL Web
Development" book, written by Luke Welling and Laura Thomson, but since
my native langua
No other way that I know of, renaming the files via a script looks like the
best option, and should be pretty safe too.
Regards,
Bhavin.
- Original Message -
From: "Luc Foisy" <[EMAIL PROTECTED]>
To: "MYSQL-List (E-mail)" <[EMAIL PROTECTED]>
Sent: Monday, June 10, 2002 1:11 PM
Subject: I
Hi all,
I have a problem when posting. The thing is that every time I post to
the mailing list, I get an error saying that the message could not be
delivered but it does indeed.
I had the same problem when posting at one of the php.net mailing lists,
and was solved after I announced it. Does it
In the last episode (Jun 10), Erv Young said:
> MySQL AB staff:
And the thousands and thousands of regular people reading this list :)
> 1) The recent discussion on the subject "Not using indexes???"
> brought to light an opportunity for interpreting the documentation in
> contradictory ways.
Looks okay to me except table teach_classes should have a
unique id for each record.
teach_clases (taught_id, class_id, teach_id)
Over the long term, the same class probably will be taught more than
once and the same teacher probably will teach more than one class
so neither class_id nor teach_i
Hmmm...
If your just requiring two tier client server there are several.
This one is open source and free.
http://sourceforge.net/projects/zeoslib
- Original Message -
From: "Proliant Business Solutions" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Monday, June 10, 2002 2
Wow,
for your first shot, you've got a very normalized database. GOOD JOB!
The only thing wrong is your payments table.
It needs to be more like:
payment
-
payment_id
=
class_id
user_id
date
amount
-
-
(The primary key is the combination of class_id and userID)
Then you cou
Hi all. This is my first post here, so please be patient with me.
I dont know if theres a program already made that does what I need, so
I dont have to reinvent the wheel. Im using PHP & MySQL to make most
of the web sites and web-based Corporate Intranets programs. What I
need now, is to
do a
select patient_id,treatment_date from patient_treatment_history order by
treatment_date desc limit 1;
I am not sure but max(treatmen_date) might work too as such:
select patient_id, max(treatment_date) from patient_treatment_history group
by treatment_date;
In your original query the group by
Hi,
I got a table named patient_treatment_history
Below is some of the records inside the table.
patient_id,treatment_date,charges
1014,2002-01-28,20
1001,2002-02-02,100
1026,2002-04-08,74
1001,2002-04-15,85
1014,2002-05-05,50
1030,2002-05-16,125
1030,2002-06-18,180
1001,2002-06-25,125
I try to
Does MySQL offer anything to take the place of Oracle's roles?
I'm especially interested in the ability, when adding a new table (or a new
view, in the future) to the database, to be able to grant the desired
access to everyone who ought to have access, without having to enumerate
those people
what do you mean it doesn't do anything?
you should be able to set it on the command line as:
--set-variable=max_connections=200
or you could edit the my.cnf file that mysql is using when it
starts-up. if you can't find the my.cnf, then you should create one. here
is a link to the manpage a
Hi all,
I am trying to set max_connections to 200 on my server. Currently it is 100.
My mysql version 3.22.32. My problem is I am not able to find my.cnf. And if
I set the variable on command line like this:
--set-variable = max_connections=200;
Then it does not do anything.
What am I doing wr
MySQL AB staff:
1) The recent discussion on the subject "Not using indexes???" brought to
light an opportunity for interpreting the documentation in contradictory
ways. The page http://www.mysql.com/doc/M/y/MySQL_indexes.html does not
mention the IS NOT NULL comparison operator, nor does it
YES! As stated before JUST THIS VERY DAY. If you are selling a program and
DISTRIBUTING MYSQL then you have to pay.
1: Why would you consider NOT paying for it if you are making money off of
it? (It's a killer piece of work!)
2: Please check the archives or better yet, the web page. Everything
> Yes. MySQL attempts to get the current time zone from the OS, but this can
> be overridden by setting the TZ variable. (The manual suggests doing this
in
> the safe_mysqld script; there's already code in there for setting it from
a
> command line argument.)
>
> Valid settings of TZ are techni
Subject: MySQl price
From: "Peder Hanghøj" <[EMAIL PROTECTED]>
===
I will make a delphi-program that uses MySQL.
I want to sell the program, do I have to pay each time I sell a program?
Do I have to pay for MySQL?
Thanks Peder
---
You may find the Access conversion easier to do using MysqlFront,
downloadable at www.mysqlfront.de.
- Original Message -
From: Egor Egorov <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 10, 2002 8:08 AM
Subject: Re: FW: RE: support UTF-8
> Mehdi,
> Saturday, June 08, 2
can't insert into questions( ) select from questions .
the error is : not unique table or alias .
tried with insert into ... select a.field1 , a.filed2 from questions as a .
not working ;)
- Original Message -
From: "Brent Baisley" <[EMAIL PROTECTED]>
To: "cristian ditoiu" <[EMAIL PROTEC
ASTA at www.astatech.com
M:)
> What is the best way to connect with Delphi 5/6 to Mysql?
>
> Johan
>
> -
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (t
What is the best way to connect with Delphi 5/6 to Mysql?
Johan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e
Mysql does not own the database and its tables;
chown -R mysql /usr/local/mysql/var
( or whatever the database location is. )
Kariuki, JohnX K wrote:
>Hi I am pretty new to linux and I was trying to setup and use mysql, I
>followed the directions you provided about compiling it and installing
Hi,
I'd like to do the following in mysql:
I have a table with field1 and field2. Both fields are not unique.
Field2 can have the value of 0 or 1.
I'd like to join the results of these two queries:
query 1: select field1, count(field2) as total from table1 group by field1
query 2: select fiel
Hi I am pretty new to linux and I was trying to setup and use mysql, I
followed the directions you provided about compiling it and installing it,
but when I try to start the server the mysql daemon fail right away : saying
mysqld ended. I looked at the error log and this is what it says :
/usr/loc
Sorry for the long reply:
At 02:57 PM 6/10/2002 -0500, you wrote:
>[snip]
>SELECT
> head.po
>FROM
> head
> LEFT JOIN line ON (head.sn=line.snHead)
>WHERE
> head.po > 1
> AND line.dateETA<='2002-06-10'
>LIMIT 50
>
>As is, this query is very fast (0.01 second
We are running mysql on a red hat box.
We replicate a single database twice, once on another red hat box(thank whatever is
holy), once on a winnt box.
The winnt box cares not for case sensitivity, so it created all our table names in
lower case ( our standard is to use CAPS for tablenames )
(
[snip]
SELECT
head.po
FROM
head
LEFT JOIN line ON (head.sn=line.snHead)
WHERE
head.po > 1
AND line.dateETA<='2002-06-10'
LIMIT 50
As is, this query is very fast (0.01 seconds when there are 25,000 records
in 'head', and 50,000 records in 'line'). However,
Why not just use something like:
insert into questions (field1,field2,...) select...
You don't need to create temp tables for your data and all the other
complicated stuff.
> hello .
> i use php 4.12 + mysql 3.23.49 on linux .
> i've developed a online testing(quiz) -aplication that now is expe
Hi List,
I sure do appreciate this list.
I'm stumped on the following query:
SELECT
head.po
FROM
head
LEFT JOIN line ON (head.sn=line.snHead)
WHERE
head.po > 1
AND line.dateETA<='2002-06-10'
LIMIT 50
As is, this query is very fast (0.01 seconds when the
[snip]
But my program not use only mysql (able to oracle, paradox and MS Sql
Server), However, do i need license?
> I'm developing a program, that is not free software and i'm using mysql
with
> myodbc. The question is if i need a license or not...
>
> According to this http://www.mysql.com/suppo
But my program not use only mysql (able to oracle, paradox and MS Sql
Server), However, do i need license?
- Original Message -
From: Jay Blanchard <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 10, 2002 4:10 PM
Subject: RE: license...
> [snip]
> I'm developing a progra
[snip]
I'm developing a program, that is not free software and i'm using mysql with
myodbc. The question is if i need a license or not...
[/snip]
According to this http://www.mysql.com/support/arrangements.html
yes..
HTH!
Jay
-
I'm developing a program, that is not free software and i'm using mysql with
myodbc. The question is if i need a license or not...
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists
That is pretty ugly, but if I can't find anything else, then I may just
have to try this out. Thanks for the help!
--shak
Michael Bacarella wrote:
>On Thu, Jun 06, 2002 at 02:49:05PM -0700, Shakeel Sorathia wrote:
>
>
>>we start up mysql. Mysql binds to the port, then it takes about 15
>>
Hi All,
I wish to download MyCC from mysql official site and i try allmost all the
mirroring site.The message is the next:
"You are downloading: mycc-0.8.3-src.tar.gz"
"There was an error with the mirror site you selected. Please choose another
mirror."
My question is:
from where i can download
I guess it's a question of semantics, but I would consider a stored
procedure, in general, any series of commands to be executed 'in' the
database engine. Postgres, for instance, allows stored procedures to be
written in a number of different languages. Commercial engines have similar
capabiliti
hello .
i use php 4.12 + mysql 3.23.49 on linux .
i've developed a online testing(quiz) -aplication that now is expected to
behave somehow different from what i've had in mind at the begining . More
exactly :
i have 3 tables (MyIsam):
1. tests (id,name,desc)
2. questions (id,id_test_fk,
Hi,
I have just installed and run my mysql server as the root user. I have
entered
the MYSQL minitor. WHen I typed 'use mysql', I got the message--
"Error 1044: Access denied fro user: 'root@localhost' to database
"mysql'".
Same error message appeared when I tried to grant all on mysql to root
use
On 10 Jun 2002, at 17:10, Elsad YUSIFLI wrote:
> WHERE (a.HOST_NAME regexp rtrim(b.ip)+'%')
What are you trying to accomplish there? '%' is not a special
character in regular expressions. Are you mixing up REGEXP and LIKE?
Even if that's what it is, I'd expect a column called ip to be a
com
Try using LIKE instead of regexp and create index on HOST_NAME if not
present.
Nilesh
-Original Message-
From: Chris Knipe [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 10, 2002 1:24 PM
To: Elsad YUSIFLI; [EMAIL PROTECTED]
Subject: Re: 45 seconds
I have multiple tables on a 166MMX wi
I have multiple tables on a 166MMX with 64MB ram, all containing more than
250,000 records each Mine takes less than 5 seconds
I think there's something wrong at your side :-)
Kind Regards,
Chris Knipe
MegaLAN Corporate Networking Services
Tel: +27 21 854 7064
Cell: +27 72 434 7582
--
> E.g. the non-equivalence operator is the same. MySQL will use indexes
> for "foo>0", but not "foo<>0", which ask for the same result (presumed
> foo is an unsigned column).
Perhaps I was a bit unclear... Using "foo > 0" does *NOT* use an index.
Using "foo > 0 AND foo < somevalue" *DOES* use an
In the last episode (Jun 10), Kaan Oglakci said:
> Hi,
> For some reason when I try to set up grants for a database by typing this
> GRANT ALL ON newstesting.* to clients@% IDENTIFIED BY 'pass';
>
> I get this error
> ERROR 1064: You have an error in your SQL syntax near '% IDENTIFIED BY
> 'pa
Hi,
For some reason when I try to set up grants for a database by typing this
GRANT ALL ON newstesting.* to clients@% IDENTIFIED BY 'pass';
I get this error
ERROR 1064: You have an error in your SQL syntax near '% IDENTIFIED BY
'pass'' a
t line 1
But when I type in a host name it works fine
G
Kevin,
Monday, June 10, 2002, 5:20:00 PM, you wrote:
K> I am using the now() function to insert the current timestamp in a mysql
K> table.
K> My problem is that the server is using EST while I would like the time to
K> reflect PST.
K> Can this be done?
K> Thanks.
It depends on what OS do you us
Kiss,
Monday, June 10, 2002, 5:19:17 PM, you wrote:
KD> I studied the MySQL and InnoDB manual, but I did not find anything about
KD> the internal usage of foreign keys.
KD> I mean that I would like to know if foreign keys are used for query
KD> optimizations or functions like that.
KD> Because
Hello,
The reason that it takes so long is because you are using regexp on a
function to join the table. That means that MySQL can't use indexes for
that column. If you run an EXPLAIN on the query you will see that is
true.
To speed up the query some you could add an index on
new_raw_log(G
- Original Message -
From: "Charlie Thunderberg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 10, 2002 8:23 AM
Subject: RE: No Warnings after changed data
> Hello,
>
> I think that my problem boils down to the unimplemented getWarnings()
method
> in the mm. JDBC driver.
Now it works!!!
My problem was that I didn't know that if I set up passwords for users I had
to tell it to the web pages where I connect to the database (postgres
doesn't work like that).
I know this is stupid, but I began my message with "I am new to mysql" :-)
Anyway thank you for your replies.
InnoDB supports foreign keys. And, an index must be created on the foreign
key; this would help from an optimization point of view.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: harm de laat [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 10, 2002 8:43 AM
To: Kiss Dániel
Cc: [E
You need to get logrotate to flush-logs otherwise mysql will still write to
the old file.
eg add after the create 0644 mysql mysql line:
postrotate
if test -n "`ps acx | grep mysql`";then
/path/to/mysqladmin -u logflusher -ppassword flush-logs
fi
endscript
Assuming a mysql users called
Yes. MySQL attempts to get the current time zone from the OS, but this can
be overridden by setting the TZ variable. (The manual suggests doing this in
the safe_mysqld script; there's already code in there for setting it from a
command line argument.)
Valid settings of TZ are technically not "tim
Both of the connections shown below are for the same database server.
If both dbs are on the same server you only need one connection, but
then you need to use mysql_select_db($database_name,$link1) for each
database.
Andrew Hazen
-Original Message-
From: Fred Kamwaza [mailto:[EMAIL PRO
If you create in index on your FK then it will be used to optimize the
query.
=C=
*
* Cal Evans
* Techno-Mage
* http://www.calevans.com
*
- Original Message -
From: "Kiss Dániel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 10, 2002 9:19 AM
Subject: Foreign keys in quer
Check that your fields are indexed.
This usually fixes it.
George
- Original Message -
From: "Elsad YUSIFLI" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 10, 2002 3:10 PM
Subject: 45 seconds
>
> i have a table and 51000 records in it.
> it has got an index on HOST_NAM
Kiss Dániel wrote:
> I studied the MySQL and InnoDB manual, but I did not find anything
> about the internal usage of foreign keys.
MySQL does not support foreign keys at the moment. This will be
implemented in version 4.1.
For more info see:
http://www.mysql.com/products/mysql-4.0/index.ht
> Subject: Re: replication question
>
>
> Are you positive that you are running compatible versions
> of MySql on both
> platforms?
>
linux: mysql rebuild from source rpm:
/usr/sbin/mysqld, Version: 3.23.49-log, started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
openbsd: mysql build from
Are you positive that you are running compatible versions of MySql on both
platforms?
- Original Message -
From: "Terry" <[EMAIL PROTECTED]>
To: "Luc Foisy" <[EMAIL PROTECTED]>; "MYSQL-List (E-mail)"
<[EMAIL PROTECTED]>
Sent: Monday, June 10, 2002 9:59 AM
Subject: RE: replication questio
Hi All,
I have a RH-7.2 server running mysql 3.23.41-1. I need to rotate
the mysqld.log based on some size criteria. I have a config file
as follows :
mysqlrotparams.conf
***
"/var/log/mysqld.log" {
rotate 5
Thanks for your reply.
I am actually using PHP and I tried what you suggested.
$link1 = mysql_connect("server1.com", "www", "pass") or die("could ...");
$link2 = mysql_connect("server1.com", "www", "pass") or die("could ...");
there is no error but it is not working.
Please not that I am
I studied the MySQL and InnoDB manual, but I did not find anything about
the internal usage of foreign keys.
I mean that I would like to know if foreign keys are used for query
optimizations or functions like that.
Because I think foreign keys should be used not only for keeping the data
integ
Hello,
I am using the now() function to insert the current timestamp in a mysql
table.
My problem is that the server is using EST while I would like the time to
reflect PST.
Can this be done?
Thanks.
--Kevin
[EMAIL PROTECTED]
i have a table and 51000 records in it.
it has got an index on HOST_NAME field.
next query lasts 45 seconds to execute...
is it normal ? server is PIII 500 double cpu
SELECT b.ip as ip, b.country , b.hostname , a.HOST_NAME as host, COUNT(a.HOST_NAME)
as number
FROM new_raw_log as a, dns as b
hello,
>
> I am replicating to NT Server system from Red Hat Linux
> was not aware of any issues to win2k from linux with replication
>
> Is there something I am not aware of?
i dont know, but i am having major problems with it.
i keep getting Slave: Failed reading log event, reconnecting to retr
Simona,
Monday, June 10, 2002, 4:31:33 PM, you wrote:
SDA> Hi! I am new to mysql and this is my problem.
SDA> The daemon runs well but I can start it only with --skip-grant-tables
SDA> option, otherwise nothing will work.
SDA> I set the password for the root user but when I exit the Mysql monitor
Ritu,
Friday, June 07, 2002, 8:11:34 AM, you wrote:
RS> Starting mysqld with --flush, flushes tables to database or disk
RS> log??
If you start mysqld with --flush option all your changes will be
written on the disk immediately. So, --flush will make less probable
that data will lost on crashes,
Fred,
Monday, June 10, 2002, 2:22:25 PM, you wrote:
FK> I have two databases on one MySql sever and I would like to transfer
FK> certain information from one databases to another. I want to transfer,
FK> record by record, from a particular table, after examining the record. How
FK> can I ope
Mehdi,
Saturday, June 08, 2002, 8:33:29 PM, you wrote:
MZ> Egor,
MZ> Could you let me know when 4.1 will be release ?
MZ> I'm building a website and want to decide whether I can use mySQL
MZ> instead of SQL Server or not?
MZ> The most important factor is support of Unicode.
I don't know exactly
What happend when you ran scripts/mysql_install_db ?
Also when you run the databases with --skip-grant-tables as soon as you
grant a user acess and flush privileges it will then use the grant tables (I
think)..
Simon
-Original Message-
From: Simona D'Ambrosio [mailto:[EMAIL PROTECTED]]
Se
I am replicating to NT Server system from Red Hat Linux
was not aware of any issues to win2k from linux with replication
Is there something I am not aware of?
> -Original Message-
> From: Bartomiej Dolata [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 10, 2002 9:44 AM
> To: Mysql@Lists.
hello,
can someone please explain why it is not possible to do the
replication between e.g. linux and bsd systems ?
why wouldnt it be possible to exchange data in system-independent
fashion ?
i have set up replication between mysql running on win2k, but am
unable to do that with
linux<>w2k nor l
Errata:
> We could use MySQL and imlement stored procedures outselves. (Using some
> scriptlanguages like perl or python).
A stored procedure is by definition a collection of SQL statement
stored and executed in the RDBMS, not an external script, etc.
//Anders - sql, query
---
Hi! I am new to mysql and this is my problem.
The daemon runs well but I can start it only with --skip-grant-tables
option, otherwise nothing will work.
I set the password for the root user but when I exit the Mysql monitor and
try to get in again, no password is request.
When I set the password I
>Description:
i got wrong values from a select statement using a
case value when .. then .. else .. end instruction
i made a select statement from this two tables
corriere
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+
Hello,
I think that my problem boils down to the unimplemented getWarnings() method
in the mm. JDBC driver. If it was implemented, I could detect if the data
was e.g. truncated. Can anybody help me find an implementation for this
method?
Thank you again,
Charlie
Hi.
:I'd like to find out
Hi Rob,
thanks for your reply.
> -Original Message-
> From: Rob [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 10, 2002 2:57 PM
> To: Peter Romianowski; [EMAIL PROTECTED]
> Subject: Re: "dynamic table width"
>
>
> As usual, there are several different approaches, each with different
It looks to me like 'a' is '127-30-127-1'
Notice the dashes.
I don't believe you are splitting the IP address into 4 separate numbers.
Chris Knipe wrote:
>Hi again,
>
>Not to long ago, I had a query regarding the best way to store IP addresses
>in a DB, and make sure that they are unique.
>
>I
First, you should ensure that your GRANT permissions get set correctly for each system.
Your connection handler will need to look after which database to connect to depending
on the type of query you ask for. So whatever you are using, java, php C, that is what
will have to organize such
> --
As usual, there are several different approaches, each with different
advantages and disadvantages.
The simplest approach is just to put all the "optional" fields in the main
table, and each user can decide how many of them they can be bothered to
fill in. The disadvantages here are that there is
First of all, let me apologize for repeaditly sending my e-mail message
to the list.
Roger Baklund wrote:
>
>I don't know. Not in the nearest future, they have just begun the coding.
>
Oka
>I don't get it... does it "work perfectly with mysql", or do you "realy need
>stored procedures"? And ho
What are the main api's available for Mysql?
And what is the meaning of API?
And can one use VB with mysql?
IS API are used for making connection?
plz reply
__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yaho
* harm de laat
> Subject: when will mysql 4.1 be released?
I don't know. Not in the nearest future, they have just begun the coding.
> I'm implementing a bridge between MySQL and Lotus Domino.
> In our application we realy need stored procedures (triggers).
> I saw that MySQL does not yet suppor
Hi,
I got a table with standard userdata (email, address). I want
to be able to provide additional fields (like age, gender etc).
Generally I have about 8 standard fields and up to 30 optional
fields which may vary. Say something like this:
Customer A wants its users to provide email, address an
Hi all,
I'm implementing a bridge between MySQL and Lotus Domino.
In our application we realy need stored procedures (triggers).
I saw that MySQL does not yet support stored procedures. (This will be
one of the features of version 4.1). Is it worth to wait for version 4.1
or should we switch to
System,
Sunday, June 09, 2002, 10:24:27 PM, you wrote:
SAakaTRotP> Since 020606 mysql has been crashing and then I have to manually
SAakaTRotP> restart.
SAakaTRotP> The error log is below:
SAakaTRotP> 020607 00:46:27 mysqld started
SAakaTRotP> /usr/contrib/libexec/mysqld: ready for connection
asong,
Sunday, June 09, 2002, 5:16:00 PM, you wrote:
a> I change the max_connections to 200, and I am not sure it works, when I
a> use mysqladmin to check the variables, I find the value is still displayed
a> as 100, but trough checking the log file, I am sure the max_connections have
a> chan
Weaver,
Friday, June 07, 2002, 11:28:41 PM, you wrote:
W> I believe the autoextend functionality won't be available until 4.0.2.
autoextend is only supported since 3.23.50
Anyway it's not available in 4.0.1
W> --Walt Weaver
W> Bozeman, Montana
W> -Original Message-
W> From: vlady [ma
tlack,
Saturday, June 08, 2002, 2:19:39 AM, you wrote:
>Description:
t> Change datadir in /etc/my.cnf or elsewhere. Start server (i.e.,
t> /usr/local/share/mysql/mysql.server start) and then try to stop it
t> (/usr/local/share/mysql/mysql.server stop)
All worked fine for me.
>How-To-Repeat:
t
Can you help!!
I have two databases on one MySql sever and I would like to transfer
certain information from one databases to another. I want to transfer,
record by record, from a particular table, after examining the record. How
can I open the two databases at the same time?
The only way I
Markus,
the problem is that name_id is UNSIGNED in the first table and SIGNED in the
second.
As stated in the manual, integer columns must have the same signedness and
size in a foreign key constraint.
Regards,
Heikki
Innobase Oy
- Original Message -
From: "Markus Lervik" <[EMAIL PROT
Hello list,
I am running mysql-3.23.49 on Linux 2.4.18 for production purpose.
Now I want to define a proper max_connections value in mysql. The
document said,
"The maximum number of connects MySQL is depending on how good the thread library is
on a
given platform. Linux or Solaris should be a
1 - 100 of 111 matches
Mail list logo
