Hi,
I compiled mysql-4.0.18 from ports on CURRENT machine with BUILD_STATIC=yes
option with libpthread.
After installation everything seemed OK. However after few minutes it hang
again.
It seems mysql with libpthread is even more unstable than using linuxthreads.
Ganbold
At 09:30 PM 14.04.2004
Has anyone seen this one? This is with MySQL 4.1.1 source RPM
MySQL-4.1.1-0.src.rpm on SuSE 9.
Using the MySQL binary RPM, I can --chroot=/path and --user=mysql,
and it works fine.
But if I compile the binaries mysql on SuSE 9 it doesn't work
correctly. If I run as root (--user=root) it starts fine
thanks scott,
i've uninstalled and reinstalled and i'm a happy guy!
huge thanks!!
jt
_
Watch LIVE baseball games on your computer with MLB.TV, included with MSN
Premium!
http://join.msn.com/?page=features/mlb&pgmarket=en-us/go/on
on 04/14/2004 09:00 PM, the amazing jt at [EMAIL PROTECTED] wrote:
> scott thanks for the help...but how do i know its uninstalled...i don't
> think it worked.
>
> this is what comes up for me:
>
> rm: /usr/local/mysql: No such file or directory
>
> is this correct if it's uninstalled or not??
- Original Message -
From: Kelvin Chang
To: [EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 3:49 AM
Subject: Mysql 4.0.18 Bug error Message
Dear Sir,
OS : Win XP Professional, Mysql 4.0.18 Category :WinMySQLAdmin 1.4
Description: I've encountered bug error problem using Mysql 4.0.1
scott thanks for the help...but how do i know its uninstalled...i don't
think it worked.
this is what comes up for me:
rm: /usr/local/mysql: No such file or directory
is this correct if it's uninstalled or not??
_
Tax headache? MS
Dear Sir,
OS : Win XP Professional, Mysql 4.0.18 Category :WinMySQLAdmin 1.4
Description: I've encountered bug error problem using Mysql 4.0.18 ver when in
Dos Command prompt, using D:/mysql/bin/mysql --user root-- password give error
message
ERROR 2003 : Can't connect to Mysq
Only way I know of is to write a program for it. But I am a beginner.
Respectfully,
Ligaya Turmelle
"beginner" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
> i just created a db with around 30 tables and i need
> to populate it. Is there any software or special
> technic for
Don't foreign keys need to be explicitly indexed?
Respectfully,
Ligaya Turmelle
"saiph" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
> hi list,
>
> i'm studing foreign keys but my sql code does not react as
> would imagine when i insert inconsistent data.
>
> i.e.
>
> create data
on 04/14/2004 06:47 PM, the amazing jt at [EMAIL PROTECTED] wrote:
> would someone please part with how to uninstall mysql 4.0.18 from mac OS X.
>
> i screwed my installation up...well actually i believe i should have
> installed a prior version...but regardless i have a strong desire to use
> my
would someone please part with how to uninstall mysql 4.0.18 from mac OS X.
i screwed my installation up...well actually i believe i should have
installed a prior version...but regardless i have a strong desire to use
mysql...but at the moment i've hit a brick wall.
please tell me how to uninst
Hi,
i got mysql 4.0.13 on my machine. When i installed it,
i did only basic stuff to get it running (bascilly hit
setup).
Now, i'm getting a little bit closer to mysql (the
system starts to became more friendly), but i got the
following problem:
- if i log as shell>mysql
this user seems to have
Hi,
I compiled mysql-4.0.18 from ports on CURRENT machine with BUILD_STATIC=yes
option.
However ps ax shows only 2 processes:
61652 p0 S 0:00.03 /bin/sh /usr/local/bin/mysqld_safe --user=mysql
--datadir=/var/db/mysql --pid-file=/var/db/mysql/ta
61671 p0 S 0:00.82 /usr/local/libexe
Beer Joseph wrote:
Hi,
is it (mysql v5.0) or might it once be possible, to 'return' a cursor as an out parameter from a stored procedure?
In MS SQL Server a stored procedure can return a 'recordset' by simply defining a select statement. In ORACLE one can define a ref cursor output parameter
> Does this machine have a valid server-id? Run show variables like
> 'server_id' from the mysql monitor.
Interesting. The my.cnf says "server-id = 75" but the "show_variables;"
command says server_id 0 (zero).
Why would that be, and could it be the problem?
>Also, is there anything in the *.
On 14 Apr 2004, at 10:57 pm, Adam Erickson wrote:
(This is probably not the best place for this post, but here goes...)
The (soon to be released) MySQL cluster software docs use a "sample"
cluster node configured with Dual Xeons and 16GB of ram. MySQL has
never been able to use more than 2 gi
On Wed, 14 Apr 2004 16:59:31 -0400, wrote:
>You need to drop the parenthesis. It looks you are trying to do a join
>on a sub-join, and you appear to be missing a join condition. Or you're
>trying to create a join with multiple conditions, which if fine. Near
>as I can tell, you've made this a
(This is probably not the best place for this post, but here goes...)
The (soon to be released) MySQL cluster software docs use a "sample"
cluster node configured with Dual Xeons and 16GB of ram. MySQL has
never been able to use more than 2 gigs of system memory (on 32 bit
platforms.) With M
You need to drop the parenthesis. It looks you are trying to do a join
on a sub-join, and you appear to be missing a join condition. Or you're
trying to create a join with multiple conditions, which if fine. Near
as I can tell, you've made this a lot more complicated than it should.
I'm not sur
Does this machine have a valid server-id? Run show variables like
'server_id' from the mysql monitor. Also, is there anything in the *.err
file on this machine?
-Original Message-
From: jim
To: [EMAIL PROTECTED]
Sent: 4/14/04 3:26 PM
Subject: Server not configured as slave
Hi,
Can anyone
I have 2 tables and 1 query. The problem is when I implement ORDER BY
p.date DESC it hits the wall.
I understand that MySQL is not the best at ORDER BY DESC so I am after
some tips on possible workarounds to avoid using ORDER BY DESC.
The site will list classifieds ads so I need to display them
Hi,
After I've filled my MYSQL_ROW variable, I would like print it into the
screen
--
MYSQL_ROW lop;
db.pgInfoSel();
lop = db.PreRow(); // return the reference to filled row
for(int i = 0; i <= 7; i++)
cout << lop[i] << endl;
but, if I would print from 0 to 7 don't pri
Hi,
Can anyone suggest some troubleshooting tips when setting up a
slave and getting the error:
ERROR 1200: The server is not configured as slave, fix in config
file or with CHANGE MASTER TO
?
The master is already running with other slaves. I have granted
permission and copied the relevant co
On Wed, 2004-04-14 at 16:03, Dan Nelson wrote:
> He mentioned his input file was 3gb, so I assumed this was not the
> problem :)
Ah, sorry, just joined the list & must have missed it.
--
Sean Quinlan <[EMAIL PROTECTED]>
signature.asc
Description: This is a digitally signed message part
My apologies for missing the previous discussion and thanks for the info. A follow up
question: is there a performance penalty associated with using PreparedStatement's
with queries that will never be reused? Clearly, there's a performance benefit for
statements executed multiple times, but ho
Here is what you suggested:
% ulimit
unlimited
I don't know what is going on, since I do have files greater than 2 GB, and
no problem with them...
At the beginning I thought it was a problem in which MySQL couldn't handle
large input files, so I spited my original file into two parts. One a li
In the last episode (Apr 14), Sean Quinlan said:
> On Wed, 2004-04-14 at 15:20, Dan Nelson wrote:
> > Now that's interesting. Max_data_length is set to 4gb, but you're
> > getting an error at 2gb. Could it be a process resource limit? What
> > does the "ulimit" command return? You can reset tha
Hi,
I've moved a Database Application from MSAccess to Mysql, most of the
application seems to work fine, but I'm having trouble with Inner
Joins. (The scripting language is ColdFusion MX 6.1) mySql 4.018.
Any help desperately welcome, including explanation of the principles
SELECT i.*, p.Proje
I am running MySQL version 4.0.18 on a Windows 2000 server system. If I log
in locally as an administrator and issues a command such as "DESCRIBE TABLE
some_table;" - everything works fine. If I come back at a later time and run
the same command again - it fails because of some type of timeout. If
Emmett Bishop <[EMAIL PROTECTED]> wrote:
> I ran into this problem when I installed 4.0.18. All
> of the tables in my database are INNODB and the
> REPLACE statement was failing on tables that had
> foreign key constraints. I just rolled back to 4.0.16
> and the problems went away. Not much of a so
On Wed, 2004-04-14 at 15:20, Dan Nelson wrote:
> Now that's interesting. Max_data_length is set to 4gb, but you're
> getting an error at 2gb. Could it be a process resource limit? What
> does the "ulimit" command return? You can reset that limit with the
> "ulimit unlimited" command.
IIRC, som
hi list,
i'm studing foreign keys but my sql code does not react as
would imagine when i insert inconsistent data.
i.e.
create database urls;
use urls;
create table caths
(
name varchar(7) primary key
) type = innodb;
create table urls
(
name varchar(10) primary key,
home varchar(
I've been working on this all day. I would _greatly_ appreciate it if
anyone had some suggestions. I'll describe the problem in some detail
below. I'm guessing that there is some setting/prereq/version conflict
or such causing this failure, and hoping someone here can easily
identify my mistake.
I
In the last episode (Apr 14), Cesar Bonavides Martinez said:
> Thank you for your fast answer.
>
> I tried everything you told me, but unfortunately another error
> message came through:
>
> Here you have all what you asked me to do:
>
> mysql> SHOW VARIABLES LIKE "large_files_support";
> +-
Thank you for your fast answer.
I tried everything you told me, but unfortunately another error message came
through:
Here you have all what you asked me to do:
mysql> SHOW VARIABLES LIKE "large_files_support";
+-+---+
| Variable_name | Value |
+--
Howdy all,
I've got a query which selects the count all listings
that meet meet a customer's search criteria. In
addition, there is a sent table that keeps track of
which listings have already been sent to that
customer. There are roughly 30,000 listings and 1.2
million sent records. As is stands
Ja! Most RDBMS don't use default values for NOT NULL columns. Rather
they alarm if a statement renders such fields NULL.
I do agree with Michael. Mysql went a different way in this regard, in
that it assigns default values... It only warns if one tries to
explicitly enter "NULL" in NOT NULL colu
Hello B.,
Wednesday, April 14, 2004, 7:02:06 PM, you wrote:
BF> I'm using an older version of Mysql, and I know it doesn't support
BF> trigger. What I'm trying to do, is to delete records from 2 tables
BF> (Sessions & Cart).
In a nutshell - you cannot do it in a single SQL Query on MySQL 3.x
MyS
I'm using an older version of Mysql, and I know it doesn't support
trigger.
What I'm trying to do, is to delete records from 2 tables (Sessions &
Cart).
These experimental statements didn't help:
DELETE FROM Sessions INNER JOIN Cart on Sessions.id where Sessions.id
="$id";
DELETE FROM Sessio
Has anyone had any luck getting MySQL 4.0.18 (specifically
innodb_buffer_pool_size) to use large amounts of memory on a G5 running
OS X Server 10.3.3?
I initially tried with the MySQL built binary, and was unable to get
innodb_buffer_pool_size to go beyond 1.5 GB. Here's the my.cnf section
that a
Hi,
I need help. I have my old mysql server running in my web server and I
can't stop it for make the test of the new version (3.28 to 4.0). I
have installed with compilation of the source code and configure my
socket, var and port. I have make a config file with the --example:
[mysqld
ur primary key, with
dept prepended to it for display purposes only.
Michael
electroteque wrote:
cool so i create a unique field say ticket_number , then when inserting
concat it to look like NEW-20040414-01 or NEW-01 u reckon ?
-Original Message-
From: Terence [mailto:[EMAIL PROTECT
Ruslan U. Zakirov wrote:
Keith C. Ivey wrote:
On 14 Apr 2004 at 17:27, B. Fongo wrote:
I expected a warning because of the Token column shouldn't be NULL!
It's not NULL. It's the empty string, which is the default value,
since you didn't give it a specific default value. See the "CREATE
TAB
What is NOT NULL good for, if Mysql will insert a default value?
I thought Mysql should warn: "Column can't be NULL" if no value is
provided.
Thanks anyway
Babs
-Ursprüngliche Nachricht-
Von: Martijn Tonies [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 14. April 2004 17:39
An: B. Fon
Keith C. Ivey wrote:
On 14 Apr 2004 at 17:27, B. Fongo wrote:
I expected a warning because of the Token column shouldn't be NULL!
It's not NULL. It's the empty string, which is the default value,
since you didn't give it a specific default value. See the "CREATE
TABLE" documentation:
I ran into this problem when I installed 4.0.18. All
of the tables in my database are INNODB and the
REPLACE statement was failing on tables that had
foreign key constraints. I just rolled back to 4.0.16
and the problems went away. Not much of a solution,
but it's buying me a little time. Will I ha
Hi,
> Why does MySQL accept this insert statement with a warning?
>
> Insert into Sessions (id) values (20de8376640263673ea03938);
>
> Query OK, 1 row affected.
>
> I expected a warning because of the Token column shouldn't be NULL!
>
> I have a table with three columns:
>
> Id # int not null
> T
On 14 Apr 2004 at 17:27, B. Fongo wrote:
> I expected a warning because of the Token column shouldn't be NULL!
It's not NULL. It's the empty string, which is the default value,
since you didn't give it a specific default value. See the "CREATE
TABLE" documentation:
If no DEFAULT value i
David,
Ok, I'll bite.:) Why don't you just create the table rfdata the
way you want it and change the column types manually. Before you start your
Select query delete all rows from the table with "Delete * from rfdata" and
then do a "insert into rfdata [(column1, column2 ...)] select ...
Why does MySQL accept this insert statement with a warning?
Insert into Sessions (id) values (20de8376640263673ea03938);
Query OK, 1 row affected.
I expected a warning because of the Token column shouldn't be NULL!
I have a table with three columns:
Id # int not null
Token # char (1) not
"Massimo Petrini" <[EMAIL PROTECTED]> wrote:
> From which version it will be avalaible the possibility to define a
> descriptor of a field (column) ? From example if I define a column as
> CUSTOMER, I need to add a description for which customer is this column, as
> in microsoft office, sql.
>Fr
>From which version it will be avalaible the possibility to define a
descriptor of a field (column) ? From example if I define a column as
CUSTOMER, I need to add a description for which customer is this column, as
in microsoft office, sql.
tks in advance
Massimo
Does this happen with a mysqladmin shutdown command as well?
-Original Message-
From: TO
To: [EMAIL PROTECTED]
Sent: 4/14/04 5:23 AM
Subject: Problems with clean NET STOP MYSQL on Win2000 server after adding
INNODB space
Help!
We're running MySQl on Win2000 server.
The other day our I
> Peter wrote:
> So, what I need to do is get the average of a column ever x rows.
> This is as far as I got:
> SELECT AVG(value) AS every_ten_row_average FROM table GROUP BY [every 10
> rows]
> The part I'm stuck on is the [every 10 rows].
try this:
SELECT 10*FLOOR(X/10) as X, Avg(Y)
FROM ta
You can use the one that comes with Panther. But if you want to install
the latest, download the standard version 4.0.18. I assume you were
wondering between standard and max editions.
On Apr 13, 2004, at 3:34 PM, Daniel Lahey wrote:
Which distribution should I install on Mac OS X Panther? Tha
Hi All,
Can't I install and configure mysql database without have root privs. on linux. If yes
pls. let me know the workaround.
Thx and rgds,
piyush
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
"Tang, Grace H" <[EMAIL PROTECTED]> wrote:
> In my box, mysql server version is 4.0.18.
>
> I tried "> flush logs". Nothing happened in the mysql data directory. All the log
> files
> were not replaced.
>
> Does "flush logs" rename the old log files and create new log files?
FLUSH LOGS closes
Hi,
Can you give me some hints and tricks to compile mysql with libpthread?
What compiler options should I use?
thanks,
Ganbold
At 08:31 PM 14.04.2004, you wrote:
On Wed, 14 Apr 2004 19:59:33 +0900
Ganbold <[EMAIL PROTECTED]> wrote:
> So what threading library should I use with mysql?
> Can some
Franz Klein <[EMAIL PROTECTED]> wrote:
>
> I have installed MySQL 4.0.18-nt on a Windows XP machine connected to a
> network. I have administrator privileges. I have also installed MySQL
> Administrator. When I try to look at the users I get the following error
> message:
>
> Could not fetch User
Hi peeps,
The setup I have is 2 windows 2000 servers,
server A = IIS5
server B = IIS5 + MySQL.
The servers are connected by a 2nd network card in each machine and can see each other
fine.
When I connect to any database on server B using ASP executed on server B its
lightning fast, but connec
Kevin Carlson <[EMAIL PROTECTED]> wrote:
> I have a table with four columns, the first three of which are combined
> into a unique key:
>
>
> create table Test {
> cid int(9) NOT NULL default '0',
> sid int(9) NOT NULL default '0',
> uid int(9) NOT NULL default '0',
> rat
Hi,
So what threading library should I use with mysql?
Can somebody recommend me which to use? Because I'm bit confused.
I used to use linuxthreads and it was pretty good. Now there appears some
other threading libraries:)
Which one is reliable and has good performance?
Ganbold
At 07:41 PM 14.0
Hi
I have installed MySQL 4.0.18-nt on a Windows XP machine connected to a
network. I have administrator privileges. I have also installed MySQL
Administrator. When I try to look at the users I get the following error
message:
Could not fetch Usernames
MySQL Error Nr. 1044
Access denied for user:
Help!
We're running MySQl on Win2000 server.
The other day our INNODB database filled up, so we
stopped the server, backed up the data, and adjusted
the innodb_data_file_path from
ibdata1:500M;ibdata2:500M;ibdata3:500M;
to
ibdata1:500M;ibdata2:500M;ibdata3:500M;ibdata4:500M;ibdata5:500M;
Late e
cool so i create a unique field say ticket_number , then when inserting
concat it to look like NEW-20040414-01 or NEW-01 u reckon ?
> -Original Message-
> From: Terence [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 14, 2004 7:29 PM
> To: [EMAIL PROTECTED]
> Subject: R
homauoon mahboobi <[EMAIL PROTECTED]> wrote:
>
> Are you support Arabic character set an collations in my sql 4.1?
> I work with mysql 4.0 and store Arabic data on it,but i cant sort
> my "varchar" data.Is this problem solved when i upgrade mysql 4 to 4.1?
>From 4.1 you cam use cp1256 and unicode
nope i don't think it's possible
BUT you can use the concat feature to get the result:
select concat('NEW-',running_id), concat('DEP-',running_id')
so long as your running numbers are the same...we use this for our helpdesk
system too :)
good luck.
- Original Message -
From: "electrote
Hi,
is it (mysql v5.0) or might it once be possible, to 'return' a cursor as an out
parameter from a stored procedure?
In MS SQL Server a stored procedure can return a 'recordset' by simply defining a
select statement. In ORACLE one can define a ref cursor output parameter and 'fill' it
within t
Hi there i was wondering if its possible to have two auto-inc fields ? I am
having to generate ticket numbers and i want it to look like DEP-1,
DEP-2, NEW-1, NEW-02 where NEW and DEP are the first 3 letters
of of the department associated with the ticket. How is this possible ? I've
This was the answer for my installaton on Panther, as well. Scott's
instructions provide those extra commands you might need. I thought I had
followed the standard installation instructions VERY carefully, and yet I
got stuck. This got me through . . . .
on 4/14/04 12:26 AM, Daniel Lahey at [EM
> The staff on the other hand, is thinking in using
> ORACLE, and I need very solid arguments to beet them. Any ideas I can
borrow?
There is really only two arguments against Oracle as a DBMS - price and
closed source. But then you have to ask what the argument is against MySQL.
When I star
Hello sir
Are you support Arabic character set and collations in my sql 4.1?
I work with mysql 4.0 and store Arabic data on it,but i cant sort
my "varchar" data.Is this problem solved when i upgrade mysql 4 to 4.1?
Please help me.
Sincerely yours.
homauoon
-
Hello sir
Are you support Arabic character set an collations in my sql 4.1?
I work with mysql 4.0 and store Arabic data on it,but i cant sort
my "varchar" data.Is this problem solved when i upgrade mysql 4 to 4.1?
Please help me.
Sincerely yours.
homauoon
---
homauoon mahboobi <[EMAIL PROTECTED]> wrote:
>
> I install mysql 4.1 on linux,but
> when i type mysql command,command line
> program of mysql is not run properly.
> please help me.
What is exactly wrong with mysql program?
--
For technical support contracts, goto https://order.mysql.com/?ref=
Helle sir
I install mysql 4.1 on linux,but
when i type mysql command,command line
program of mysql is not run properly.
please help me.
sincerely yours
Homauoon
-
Do you Yahoo!?
Yahoo! Tax Center - File online by April 15th
Helle sir
I install mysql 4.1 on linux,but
when i type mysql command,command line
program of mysql is not run properly.
please help me.
sincerely yours
Homauoon
-
Do you Yahoo!?
Yahoo! Tax Center - File online by April 15th
Helle sir
I install mysql 4.1 on linux,but
when i type mysql command,command line
program of mysql is not run properly.
please help me.
sincerely yours
Homauoon
-
Do you Yahoo!?
Yahoo! Tax Center - File online by April 15th
Helle sir
I install mysql 4.1 on linux,but
when i type mysql command,command line
program of mysql is not run properly.
please help me.
sincerely yours
Homauoon
-
Do you Yahoo!?
Yahoo! Tax Center - File online by April 15th
Just thought I'd share my experience with MySQL under Panther. I think
the critical thing that got me going was that the /usr/local/mysql/data
directory was owned by root instead of mysql. I changed that (chown
mysql /usr/local/mysql/data) and everything seems to be a) Hunky b)
Dory, thanks t
79 matches
Mail list logo
