The reporting of two rows thing is to do with how MySQL handles
INSERT ... ON DUPLICATE KEY UPDATE ... statements; it will report 1 row
if it inserts, and 2 rows if it finds a duplicate key and has to update
as well.
http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html
Just after the f
Michael Dykman wrote:
It
worked fine as you wrote it on my v5.0.45, although it reported 2 rows
affected on each subsequent run of the insert statement. I thought
this odd as I only ran the same statement repeatedly leaving me with
one row ever, but the value updated just fine.
I noticed
You might try explicitly formatting your date as the string-type you
are expecting, but it looks to me like it should wokr exactly as you
have it. I would agree with your suspicion about your v5.0.37. It
worked fine as you wrote it on my v5.0.45, although it reported 2 rows
affected on each subseq
Anyone?
I'm trying to diagnose this and not having much luck. I can't even
figure out where to even begin to look. I have two MySQL servers and
getting different results for the same query on both:
SERVER 1:
mysqladmin Ver 8.41 Distrib 5.0.37, for pc-linux-gnu on i686
S
age-
> From: Hiep Nguyen [mailto:[EMAIL PROTECTED]
> Sent: Thursday, November 29, 2007 10:24 AM
> To: mysql@lists.mysql.com
> Subject: repost timestamp for update & insert
>
> i asked this question before, but when i tried what D.Vin suggested, i
> got
> an error.
&g
CURRENT_TIMESTAMP );
-Original Message-
From: Hiep Nguyen [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 29, 2007 8:24 AM
To: mysql@lists.mysql.com
Subject: repost timestamp for update & insert
i asked this question before, but when i tried what D.Vin suggested, i got
an error.
m
i asked this question before, but when i tried what D.Vin suggested, i got
an error.
mysql version is 4.1.12
i tried:
CREATE TABLE tbl_spdate(
spdate_ID int NOT NULL PRIMARY KEY AUTO_INCREMENT ,
spdate_date date NOT NULL ,
spdate_notes varchar( 100 ) ,
spdate_created timestamp default 0,
spdat
riginal Message-
> From: Martin Jespersen [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 04, 2006 5:35 PM
> To: Daevid Vincent
> Cc: mysql@lists.mysql.com
> Subject: Re: FW: How do I find all the users that are new
> since my last login (repost)
>
> You could add an e
You could add an extra field called last_login_date which you'd set only
once per session - at login time. At login time you'd set this to the
value that exists in login_date. Then use that for comparison against
created_on.
Daevid Vincent wrote:
I have a SQL challenge I'm not sure how to sol
I have a SQL challenge I'm not sure how to solve. But it's so common, I feel
kind of stupid asking this...
I have a 'user' table with 'login_date' which is an auto updated DATETIME
column and a 'created_on' which is a DATETIME (but not updated after the
record is created the first time)
I want to
How do I call a MySQL stored procedure from an ASP application and get the
value of an Out Parameter?
I've got the following Stored Procedure defined in my database:
DELIMITER $$
DROP PROCEDURE IF EXISTS `bpa`.`sp_GetNextInv` $$
CREATE PROCEDURE `sp_GetNextInv`(
IN nChapterID Int,
OUT cInvNo Va
I don't have a 5.0+ server to test with right now but this should work
--- Daevid Vincent <[EMAIL PROTECTED]> wrote:
> I was using SQLYog 5.03 RC1.
>
> vmware ~ # mysql --version
> mysql Ver 14.12 Distrib 5.0.19, for pc-linux-gnu (i686) using
> readline 5.1
>
> But just to sanity check. I ssh'
sql@lists.mysql.com
> Cc: 'Shawn Green'
> Subject: RE: FW: New to TRIGGER and CALL. Example gives errors. (repost)
>
> I was using SQLYog 5.03 RC1.
>
> vmware ~ # mysql --version
> mysql Ver 14.12 Distrib 5.0.19, for pc-linux-gnu (i686) using readline
> 5.1
>
skey = 9;
END IF;
END' at line 5
mysql> delimiter ;
mysql>
> -Original Message-
> From: Shawn Green [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 11, 2006 12:41 PM
> To: Daevid Vincent; mysql@lists.mysql.com
> Subject: Re: FW: New to TRIGGER and CALL. Example gi
--- Daevid Vincent <[EMAIL PROTECTED]> wrote:
> This may have been lost, so I'm reposting hoping for a clue as to why
> the
> mySQL example onlie gives me errors...
> -Original Message-
> Sent: Sunday, April 09, 2006 7:41 PM
>
> I'm trying to follow the example in the manual to create a
This may have been lost, so I'm reposting hoping for a clue as to why the
mySQL example onlie gives me errors...
-Original Message-
Sent: Sunday, April 09, 2006 7:41 PM
I'm trying to follow the example in the manual to create a trigger:
http://dev.mysql.com/doc/refman/5.0/en/using-triggers
** I am reposting. **
I am looking for some general rule to determine the innodb_buffer_pool_size and
innodb_log_file_size based on number of innodb tables, transactions, etc.
Setting these values based on how much of the server resources I am allotted is
not adequate.
Thanks
Hello
I am loo
> mysql> create table ABC (col1 varchar(10));
> Query OK, 0 rows affected (0.03 sec)
>
> mysql> show tables;
> +--+
> | Tables_in_userdb |
> +--+
> | abc |
> +--+
> 1 row in set (0.00 sec)
>
> mysql>
>
> NOTE THE FACT THAT THE TABLE IS
Hi,
Anyone experience this problem. I did the following:
C:\perlsrc>mysql -f --user=root --password= --port=3307
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 48 to server version: 5.0.6-beta-nt-log
Type 'help;' or '\h' for help. Type '\c' to clear the
n't forget about xxx_timeout variables.
Tommy McNeely <[EMAIL PROTECTED]> wrote:
> (REPOST: I never got my original post, or any answers, so I am
> reposting, assuming it was lost in the mail)
>
> Hi,
>
> I apologize in advance, I am sure this question h
(REPOST: I never got my original post, or any answers, so I am
reposting, assuming it was lost in the mail)
Hi,
I apologize in advance, I am sure this question has been asked dozens
of times, but my searches came up empty.
I am building an IRC based application "bot" (using libmysq
Hi,
Try to use the same version of php in Solaris as in Windows.
Li
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: Monday, January 17, 2005 3:24 AM
To: mysql@lists.mysql.com
Subject: Re: repost w/code : can mysql work in Windows but not Solaris?
Hello
Hello.
Can you succesfully execute your query in mysql client program on your
solaris server?
"leegold" <[EMAIL PROTECTED]> wrote:
> Is there any reason you can see why the fulltext php/mysql code below
> works OK on my win2k php4.3.6. mysql 4.1.3 pc but does *not* work when
> put on
Is there any reason you can see why the fulltext php/mysql code below
works OK on my win2k php4.3.6. mysql 4.1.3 pc but does *not* work when
put on a Solaris Server with php5 mysql 4.1.6 ?
That is what happens...I'm suspicious of the accent characters in the
code but I am not sure if there's any
Sorry about the characters in the last post. Spambots didn't like it
I hope someone can help me with a problem. I recently changed one of my web
servers over to a new box and this server has an internal MySQL server which
is used to store several web queried databases. My old server ran Apache
Hello list,
im having a hughe problem with the RAND() function
first of all im using mysql 3.23 so subquerys are impossible.
Im having three tables which are joined by ID's now i want to select
a single row random out of the join set whats the best way to do it?
My Table structure is:
table1
Hello!
I am facing a problem when using SQL_CALC_FOUND_ROWS in certain queries.
The query where I am ordering by a column is much more slowly than the same
query NOT using SQL_CALC_FOUND_ROWS
select SQL_CALC_FOUND_ROWS * from table by date desc
- this query takes about 1.2 s
select * from table
Bryan Coon wrote:
Posted this yesterday, but it never showed up...?
Hi,
I have the following table (sorry if the formatting gets tweaked) and
query. The table is around 36k rows long, and the query returns about
350 rows. The query takes 12.15 seconds.
Is there any way I can speed this up?
Posted this yesterday, but it never showed up...?
Hi,
I have the following table (sorry if the formatting gets tweaked) and
query. The table is around 36k rows long, and the query returns about
350 rows. The query takes 12.15 seconds.
Is there any way I can speed this up?
Thanks,
Bryan
mys
At 8:02 -0500 3/6/04, David Jackson wrote:
I'm reposting this question, the online manual doesn't address that quetion:
http://www.mysql.com/doc/en/DROP_TABLE.html
Yet, it's a question asked by 3 different comments posted on the manaul
page listed above. Also please post a solutons to the manual pa
I'm reposting this question, the online manual doesn't address that quetion:
http://www.mysql.com/doc/en/DROP_TABLE.html
Yet, it's a question asked by 3 different comments posted on the manaul
page listed above. Also please post a solutons to the manual page the URL
above.
TIA,
David
--
MySQL G
carreraSC wrote:
No one has any ideas?
Hi,
I've got a sorting question that I can't figure out. The page in
question is here:
http://toolstudios.com/intera/careers/index.php
I'd like it to show up like this:
Accounting
job 1
job 2
Engineer
job 1
job 2
IT
job 1
job 2
B
No one has any ideas?
Hi,
I've got a sorting question that I can't figure out. The page in
question is here:
http://toolstudios.com/intera/careers/index.php
I'd like it to show up like this:
Accounting
job 1
job 2
Engineer
job 1
job 2
IT
job 1
j
Does anyone know this?
In the 4.0.17 and later build, the target table of an INSERT...SELECT can be
the same as the SELECT table (insert into table1...select ...from table1).
Does the process essentially happen in a natural lock? In other words,
could the table change between the data retrieved
OK. I've made some progress. It looks like just doing --with-openssl
doesn't work. You have to specify both the includes and the libs as
well. So, this is what I'm using now:
./configure --with-openssl
--with-openssl-includes=/usr/local/ssl/include
--with-openssl-libs=/usr/local/ssl/lib --
Mark Matthews wrote:
According to 4.4.10.2 Requirements, have_openssl must be YES prior to
setting up certificates. Is this in error?
Sorry, I missed that small fact.
What does the file include/my_config.h say about #define HAVE_OPENSSL
(it's generated by 'configure').
/* OpenSSL */
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Greg G wrote:
>
>
> Mark Matthews wrote:
>
>> Greg G wrote:
>>
>>
>>> I'm still having trouble figuring this out. Please help!
>>>
>>> I compiled MySQL 4.1.1 --with-openssl --with-vio and when I look at the
>>> variables with mysqladmin, "has_openssl
Mark Matthews wrote:
Greg G wrote:
I'm still having trouble figuring this out. Please help!
I compiled MySQL 4.1.1 --with-openssl --with-vio and when I look at the
variables with mysqladmin, "has_openssl" is set to "NO". I've got
OpenSSL 0.9.7c installed. I'm seeing this on both Solaris and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Greg G wrote:
>
> I'm still having trouble figuring this out. Please help!
>
> I compiled MySQL 4.1.1 --with-openssl --with-vio and when I look at the
> variables with mysqladmin, "has_openssl" is set to "NO". I've got
> OpenSSL 0.9.7c installed. I'm
I'm still having trouble figuring this out. Please help!
I compiled MySQL 4.1.1 --with-openssl --with-vio and when I look at the
variables with mysqladmin, "has_openssl" is set to "NO". I've got
OpenSSL 0.9.7c installed. I'm seeing this on both Solaris and Debian
hosts. I'm not seeing any erro
You have the first inequality backwards. You want:
SELECT percentage FROM table_name
WHERE min <= 500.00 AND max >= 500.00
Michael
Mike Blezien wrote:
Sorry..
The query should be:
select percentage from table_name where
min >= 500.00 and 500.00 <= max;
database.
Original Message
Sorry..
The query should be:
select percentage from table_name where
min >= 500.00 and 500.00 <= max;
database.
Original Message
Subject: Query Range
Date: Mon, 08 Dec 2003 11:23:28 -0600
From: Mike Blezien <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Organization: Thunder Ra
I compiled MySQL 4.1.1 --with-openssl --with-vio and when I look at the
variables with mysqladmin, "has_openssl" is set to "NO". I've got
OpenSSL 0.9.7c installed. I'm seeing this on both Solaris and Debian
hosts. I'm not seeing any errors during the configure or compile phases.
What could ha
[Sorry for the accidental premature sending in the first post...]
CREATE TABLE `payments` (
`date` date NOT NULL,
`payee` varchar(255),
`amount` double
)
INSERT INTO payments VALUES ('2003-05-01','david',38);
INSERT INTO payments VALUES ('2003-06-02','david',13.4);
INSERT INTO payments VALUE
> Please don't take this the wrong way, but mission-critical problems
> should be sent thru MySQL's official support channels. Otherwise
> you're at the mercy of a bunch of volunteers...
I don't. :) I use a lot of free/open software. I've found that the
volunteers are often better then paid su
On Tue, Aug 19, 2003 at 09:12:03AM -0400, Jason McCormick wrote:
> Hello all,
>
> Sorry to post this again, but I go not response and was really hoping
> someone can help me as this is a mission-critical problem.
Please don't take this the wrong way, but mission-critical problems
should be sen
Hello all,
Sorry to post this again, but I go not response and was really hoping
someone can help me as this is a mission-critical problem. I have 3
slave MySQL servers (4.0.13) replicating from a master machine
(4.0.13). The master machine is running only MySQL while the slave
machines are
I think I need a MySQL code guru...
I am using the 4.0.12 client library on a Win2k host to
connect to a 4.0.13 linux server.
If I connect directly to the server using mysql_real_connect, everything
runs fine.
However, I want to use SSH tunneling.
So I set up a SSHv2 tunneling connection from l
Hi!
On Jun 13, H M Kunzmann wrote:
> The answer is that a fulltext index can only be built on
> a TEXT field. Even though the mysql documentation describes
> MEDIUMTEXT and LONGTEXT fields as 'BLOB or TEXT field that can hold..',
> they can not be used.
No, this is wrong.
Any xxxTEXT field can be
The answer is that a fulltext index can only be built on
a TEXT field. Even though the mysql documentation describes
MEDIUMTEXT and LONGTEXT fields as 'BLOB or TEXT field that can hold..',
they can not be used.
On Thu, 2003-06-05 at 09:59, H M Kunzmann wrote:
> Hello All.
>
> I am using Redhat
> > When mysql is indexing You can check your data file direcory and You
> > ca see that one file (the index) is growing in size.
> I see it grow up to 8M and it stays there.
Watching this, it grows very slowly. After 5 minutes of indexing, the
file size has barely hit 2MB.
> > The command I use
> I think your index is corrupted because I expect a 1.5 GB index and not 8M!
> You can see word list wit a utility (sorry I don't remember te name ft_dump).
I agree with this :-)
> I suggest You to drop fulltext index, duplicate database and remove
> some rrecords.
> Then create index index aga
create fulltext index Name on Table(field) i didnt get this
i usually do add fulltext field (field) i think , is that wrong ??
-Original Message-
From: Santino [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 6:14 PM
To: [EMAIL PROTECTED]
Subject: Re: REPOST: FULLTEXT searching
I think your index is corrupted because I expect a 1.5 GB index and not 8M!
You can see word list wit a utility (sorry I don't remember te name ft_dump).
I suggest You to drop fulltext index, duplicate database and remove
some rrecords.
Then create index index again.
Some questions:
Do You have d
Hello All.
I am using Redhat 9.0 with MySQL 4.0.12-0.
I've hit something of a dead-end with fulltext searching and I don't
know where to look next.
I have a table that is about 1.5GB with about 400 records.
As you can tell, every record is about 4MB, all of which is
text.
I've created a fullte
On Tue, 2003-03-11 at 07:33, Richard Taubo wrote:
>
> When using the Union statement in MySQL, is it possible to retrieve the
> corresponding table name for a given row? The reason I need to know
> this is that I present info from different tables in their own way. I
> know I can create a colum
Hi!
Sorry for the repost, but I am really eager to hear the verdict so I
give it another go, thanks ;-)
When using the Union statement in MySQL, is it possible to retrieve the
corresponding table name for a given row? The reason I need to know
this is that I present info from different tables
Hi Benjamin,
I hope you have a nice day.
- Original Message -
From: "Benjamin Pflugmann" <[EMAIL PROTECTED]>
To: "Jason Maskell" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, February 17, 2003 1:14 PM
Subject: Re: REPOST: MySQL 3.23.54 is a
On Mon 2003-02-17 at 12:14:12 +0100, [EMAIL PROTECTED] wrote:
[...]
Please disregard this mail. It was not supposed to go to the list.
(forgot to remove the CC that my mailer is set up to automatically
append for mails going to my -mysql address).
My apologies about that, Jason.
Bye,
B
son Maskell" <[EMAIL PROTECTED]>
> Sent: Monday, February 17, 2003 3:35 AM
> Subject: Re: REPOST: MySQL 3.23.54 is a buggy, crashing piece of crap.
>
>
> > On Mon 2003-02-17 at 02:40:57 -0600, [EMAIL PROTECTED] wrote:
> >
quot;Zak Greant" <[EMAIL PROTECTED]>
To: "Jason Maskell" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, February 17, 2003 2:10 AM
Subject: Re: REPOST: MySQL 3.23.54 is a buggy, crashing piece of crap.
> On Mon, Feb 17, 2003 at 01:37:59AM -0600, Jason Mask
On Mon, Feb 17, 2003 at 01:37:59AM -0600, Jason Maskell wrote:
> Perhaps the subject will get someone to actually read this and offer even
> one reply with a suggestion?
I admit that the topic got my attention - perhaps not in the best way
though.
I can offer a few suggestions:
Provide m
Perhaps the subject will get someone to actually read this and offer even
one reply with a suggestion?
NB: This now kills mysql (process hang) in around 24 hours of uptime.
---
I'm hoping someone can help me, I've got a problem with mysql going
insane..
I've a quite busy application (avg 700 qu
Sorry for the repost, I just want to make sure this didn't go unnoticed.
I'm having trouble on one of my SQL servers. It is the slave in a
master/slave setup. select now() returns the wrong time (+5 hours).
The systems time is in EST and "show variables" shows timezone=EST.
Hi all.
Hi spam filter. SQL. Query.
MySQL versions 4.0.3, 4.0.4 and 4.0.5 all have the following problem...
When I use 'mysqladmin shutdown', 2 processes are left running and can
only be killed with a 'kill -9 '.
At midnight I run a script which backs up each database and then
restarts mysql (to
> Hi Guys,
>
> I just installed MySQL-3.23.53, Apache 1.3.27 and Jakarta-Tomcat 4.0.6
(All
> from Tarball). Everythings seems to be fine until the user can't login
from
> a web and from the log file, it said Authentication Error, can't connect
to
> db. But when I restarted the MySQL and Apache/Tomc
On Fri, Aug 09, 2002 at 04:20:42PM -0400, David Miller wrote:
> On Sun, 4 Aug 2002, Jeremy Zawodny wrote:
>
> Hi Jeremy;
>
> I didn't think my server would be doing any name resolution, particularly
> while replace()ing millions of rows in a table. That said,
> --skip-name-resolve *seems* to ha
On Fri, Aug 09, 2002 at 04:04:10PM -0500, Dan Nelson wrote:
>
> A coredump of this state + gdb "thread apply all bt" might be interesting.
>
> > > Hmm. Looks like a problem we solve recently, but yours is a bit
> > > different. We found that FreeBSD's not-so-thread-safe
> > > gethostbyname_r()
In the last episode (Aug 09), David Miller said:
> On Sun, 4 Aug 2002, Jeremy Zawodny wrote:
> > On Sat, Aug 03, 2002 at 11:59:56PM -0400, [EMAIL PROTECTED] wrote:
>
> I didn't think my server would be doing any name resolution,
> particularly while replace()ing millions of rows in a table. That
On Sun, 4 Aug 2002, Jeremy Zawodny wrote:
Hi Jeremy;
I didn't think my server would be doing any name resolution, particularly
while replace()ing millions of rows in a table. That said,
--skip-name-resolve *seems* to have helped. It's definately still
failing, and the ktrace is the same, so it
On Sat, Aug 03, 2002 at 11:59:56PM -0400, [EMAIL PROTECTED] wrote:
>
> Symptoms:
>
> mysqld locks itself in a tight loop, consuming all available CPU cycles.
> a simple "kill" sometimes kills the daemon, other times a -9 is required.
> While in this state, any access to the daemon stops - mysql
I thought I got this through the list, but it doesn't show up in the
search, and I didn't get any responses...
-- Forwarded message --
Date: Wed, 31 Jul 2002 23:14:13 -0400 (EDT)
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: SIGPROF problem in FreeBSD 4.6
This almost bel
hi all,
i've built mysql-3.23.49 on MacOSX Server 10.1.4, as well as Sleepycat's
BerkeleyDB 4.0.14.
i note the "--with-berkeley-db" options in configure, but am stumped as to
if/how to allow support for the bdb 4.0.14 version. mysql (in configure,
acinclude.m4 & aclocal.m4) seems to limit to bd
Is there a master.info file somewhere?
What's your my.cnf look like?
If you want, you can email me the file and I'll be happy to try and
help.
--
sh
On Thu, 2002-03-28 at 10:40, Jonathan Wilzig wrote:
> Sorry to repost. I got one answer and stumped the guy trying to help (thank
Sorry to repost. I got one answer and stumped the guy trying to help (thanks
again btw). If anyone has seen this or has any ideas, any help would be
greatly appreciated.
---
RH 7.2.
mysql-3.23.44
I have a single server running mysql. I have added one database I use. For
some unknown
I didn't receive any response so thought I'd repost with some more
questions.
Is my problem so rare no one knew what to say? or Is there some obvious
solution here and everyone thought *someone else* would straighten me out?
Any pointers and help is appreciated.
Thanks,
Lance
>
Hi,
On 13 Feb 2002, at 12:44, Henning Sprang wrote:
> Was something wrong with this post or is it really such a weird
> problem that there is neither a solution nor anything i could do to
> solve it, nor anything i could do to find out more about it?
Well. Replication is somewhat weird. ;-)
> Sl
Hy,
Was something wrong with this post or is it really such a weird problem
that there is neither a solution nor anything i could do to solve it,
nor anything i could do to find out more about it?
that was the message:
I get some Errors when doing Replication on MySQL 3.23.47. And can't get
i
At Sun, 06 Jan 2002 14:55:53 +0200, [EMAIL PROTECTED] wrote...
:
: Hi!
:
: > "fil" == fil krohnengold <[EMAIL PROTECTED]> writes:
:
: fil> [gcc version 2.95.2; mysql 3.23.47]
:
:
: fil> ctype.lo dbug.lo -lz -lcrypt -lgen -lsocket -lnsl -lm
: fil> rm -fr .libs/libmysqlclient.la .libs/lib
Hi!
> "fil" == fil krohnengold <[EMAIL PROTECTED]> writes:
fil> [gcc version 2.95.2; mysql 3.23.47]
fil> ctype.lo dbug.lo -lz -lcrypt -lgen -lsocket -lnsl -lm
fil> rm -fr .libs/libmysqlclient.la .libs/libmysqlclient.*
fil> .libs/libmysqlclient.*
fil>
fil> ... then I'm stuck there
[gcc version 2.95.2; mysql 3.23.47]
: What was the problem you got with compiling MySQL on this platform?
: If you follow the instructions in the Solaris section in the MySQL
: manual, this should be very straightforward!
I'm not getting any errors. My compile is getting stuck at:
/bin/s
What permissions do you need to have to issue a show slave status
command?
Thanks,
database,sql,query,table
--
Michael Eklund
System Administrator
Netmechanic, Inc.
[EMAIL PROTECTED]
http://www.netmechanic.com
-
Before po
TECTED]]
> Sent: 02 October 2001 19:08
> To: Colin Faber
> Cc: Robin Keech; [EMAIL PROTECTED]
> Subject: Re: repost: Too many open files
>
> Colin Faber wrote:
>
> > it sounds like you've run out of file descriptors, I suggest
> > rebuilding your kernel
Colin Faber wrote:
> it sounds like you've run out of file descriptors, I suggest
> rebuilding your kernel to handle more.
>
> In a bsd kernel you can do this simply by upping the maximum number of
> users allowed to access the machine at any given time.
Or in Linux (in my rc.local):
echo "Set
it sounds like you've run out of file descriptors, I suggest
rebuilding your kernel to handle more.
In a bsd kernel you can do this simply by upping the maximum number of
users allowed to access the machine at any given time.
Robin Keech wrote:
>
> Hi,
>
> Any help would be greatly appreciat
Hi,
Any help would be greatly appreciated as I have a production server that is
struggling.
(I only get the digest list, so could you copy me on any replies -
thankyou).
My error log show this...
011002 9:16:11 Error in accept: Too many open files
011002 9:36:43 /usr/local/mysql/libexec/mys
I am not sure it that would provide everything you want to know, but I was
looking for the same thing last week and I setup this replication database
and it work great and make it very easy.
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
inistration.html#Replication
Hi
I am reposting this just in case someone who would be able to assist me did
not see it first time around.
Thanks
Deon.
I am currently putting together a backup system for our MySQL server. The
way I want to do this is to make use of mysqldump to perform the backup and
have the binary log (o
Hello,
Due to the widespread advertisement of the 3.23.33 MySQL release as
stable and production quality, I had done extensive testing of the
3.23.33 release.
In order to prevent replication of that extensive testing effort,
I would be very grateful if you would continue to leave the
following
Hi,
I recently installed in MySql from binary distribution mysql-
max-3.23.38-pc-linux-gnu-i686.tar.gz. The install worked fine, the
database runs and performs fine but it refuses to shutdown short of a
'kill -9'. This is not so good:( I have tried 'mysqladmin shutdown' and
killing the safe_my
Making another appeal for help Anybody have any clues to what I could do
to fix the problem below?
> I tried to configure MySQL like this:
>
> ./configure --prefix=/usr/local/mysql --with-charset=sjis
>
> After a hundred lines or so of install verifications, it quits the
> installation with
"Thalis A. Kalfigopoulos" wrote:
> Check you don't have empty strings as empty remarks, but that you have NULLs.
> Even with empty strings as remarks though you can bypass them with an extra WHERE
>condition :-)
That was it. I was storing empty strings, instead of NULLs. Thanks!
AMK4
On Thu, 5 Apr 2001, Ashley M. Kirchner wrote:
> "Thalis A. Kalfigopoulos" wrote:
>
> > > +--++--+-+
> > > | task | comment |remarks | history |
> > > +--++--+-+
> > > | task_1 | cmt_1
"Thalis A. Kalfigopoulos" wrote:
> > +--++--+-+
> > | task | comment |remarks | history |
> > +--++--+-+
> > | task_1 | cmt_1| rmk_1| |
> > | task_1 | cmt_2
On Wed, 4 Apr 2001, Ashley M. Kirchner wrote:
>
> Db -> table1, table2 and table3
>
> SELECT table1.task, table2.comment, table2.remarks, table3.history
> FROM table1 LEFT JOIN table2 ON table1.id=table2.todoid
> LEFT JOIN table3 ON table1.id=table3.todoid WHERE table1.id=10;
>
> Resul
Db -> table1, table2 and table3
SELECT table1.task, table2.comment, table2.remarks, table3.history
FROM table1 LEFT JOIN table2 ON table1.id=table2.todoid
LEFT JOIN table3 ON table1.id=table3.todoid WHERE table1.id=10;
Results (roughly) in:
+--++--+-
I checked the known bugs in replication, and I've found a situation where it
definitely does not propogate changes. I'd just like to know if this is normal or
not.
Say you have two databases (call them data1 and data2) on your master server. Only
data1 is being replicated.
Within the mysq
97 matches
Mail list logo
