Hi,
I just noticed that replication on my servers failed when they were
under heavy load. I have 1 master and 2 slaves.
For example, I have table for all incoming messages.
message_inbox | CREATE TABLE `message_inbox` (
`member_id` mediumint(8) unsigned NOT NULL default '0',
`message_id`
Hello,
I have two date fields (1095689105) in mysql. One is Creation date and
other is Modify date. If news is not modified its value is 0. How can I
sort my news so modify date is more important (if exists) than creation
date?
TNX
--
MySQL General Mailing List
For list archives:
Hello,
I have two date fields (1095689105) in mysql. One is Creation date and
other is Modify date. If news is not modified its value is 0. How can I
sort my news so modify date is more important (if exists) than creation
date?
What about an ORDER BY with a CASE statement that uses
the
On Mon, 4 Oct 2004 11:03:13 +0200, Martijn Tonies [EMAIL PROTECTED] wrote:
Hello,
I have two date fields (1095689105) in mysql. One is Creation date and
other is Modify date. If news is not modified its value is 0. How can I
sort my news so modify date is more important (if exists) than
Hi,
I use MySql version 4.0.18.
We do a lot of bulk inserts and there is no need for transaction integrity.
Currently the isolation level of the database is REPEATABLE-READ.
Iam planning to change that to READ UNCOMMITTED as I dont have any
transactions.
Will this improve DB performance ?
Is
Hi,
I currently have a table with 2 text fields, both of
which are marked as fulltext. I'm using the full-text
boolean search method with fairly good results.
My problems however are:
1. I am on a shared host provider so I can't tweak
the full-text search options such as stop words or
What you are looking for is the MAX() of the Time column (most recent
entry)
select user, host, max(time) as time, count(user) as visits
from userlog where user!=''
group by user, host
order by time desc
limit 10;
The issue you ran into is caused by an non-standard SQL extension created
by
On Monday 04 October 2004 01:18 am, Batara Kesuma wrote:
I have a cron running this every night.
DELETE message_inbox FROM message_inbox LEFT JOIN message ON message.id
= message_inbox.message_id WHERE message.id IS NULL
Message table also has about the same amount of rows.
I notice that
Whenever you get an INNODB error, you can get more details by running a
SHOW INNODB STATUS.
A foreign key means that a value must exist in one table before it can be
used as a value in another table. That's probably why you couldn't add a
record to Table2 before you had a value in Table1. The
You will need the RLIKE comparator.
http://dev.mysql.com/doc/mysql/en/String_comparison_functions.html
http://dev.mysql.com/doc/mysql/en/Regexp.html
I haven't tested this but this is pretty close to what you will need
WHERE page_body RLIKE 'img *' and page_body not RLIKE 'img *alt=*'
you will
Thank you very much. One more question i.e Is there any command to take the
Backup in MySQL 4.0 (windows) classic which does not support innodb.
I know 2 commands like mysqldump and mysqlhotcopy. mysqlhotcopy seems to
support myism but only in linux and
Are you just looking for any column is null or that all columns are null
or that specific columns are null or . what exactly do you need to
determine?
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Scott Hamm [EMAIL PROTECTED] wrote on 10/02/2004 11:21:58 AM:
How do
I'm trying to find a null value anywhere in QA table.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, October 04, 2004 9:46 AM
To: Scott Hamm
Cc: [EMAIL PROTECTED]
Subject: Re: Looking for null values.
Are you just looking for any column is null or
I think what will work for your case is the CONCAT() function
(http://dev.mysql.com/doc/mysql/en/String_functions.html). It will return
NULL if any field in it is null.
SELECT *
FROM qa
WHERE concat(field1, field2, field3,..., fieldn) is null
It won't break any speed records but it will find
Thank you for the answer! However, it doesn't seem to solve my problem. Running the
query
without modifications repeated users (because of the group by user, HOST). I removed
the
HOST, and ran the query over again. Now it returned unique users, but it still didn't
return
the LAST login of
I would be very surprised if this query fails as you say it does.
select user, max(time) as most_recent, count(user) as visits
from userlog where user!=''
group by user
order by most_recent desc
limit 10;
This represents the last 10 users to sign in, when they signed in last,
and many times
Hi!
I am trying to do an inner join of two tables using a char(3) key. The field I am
joining by contains integers with sometimes leading zeros. The inner join works when
the field is a full 3 character field, with for example 566, but when it starts with
a 0, it does not work anymore. Why is
Why does selecting backslash give me an error?
select \
gives me...
#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'\' at line 1
select /
returns /
select \\
returns \
What's the deal w/
Query optimization question
I am selecting from a single table but it has a lot of rows and it has
a very involved calculation. What I really want to do is
is FIRST restrict the number of rows so that the big calculation is only
performed on the ones that are within 3 degrees.
Using 4.0.20
A
[snip]
What's the deal w/ backslash?
[/snip]
It is an escape character. In order to get things with backslashes, as
you have deduced, you
SELECT \\
Do you have a column '\'? If so, why?
Backslashes are often used in this way...
SELECT businessName FROM table WHERE businessName = 'Doc\'s';
At 11:35 -0400 10/4/04, Jeff Burgoon wrote:
Why does selecting backslash give me an error?
select \
gives me...
#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'\' at line 1
select /
returns /
select
Camilla Brodén wrote:
Hi!
I am trying to do an inner join of two tables using a char(3) key. The field I am
joining by contains integers with sometimes leading zeros.
If it is a char(3) field it contains characters, not integers.
The inner join works when the field is a full 3 character field,
Jeff Burgoon wrote:
Why does selecting backslash give me an error?
select \
gives me...
#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'\' at line 1
select /
returns /
select \\
returns \
What's the
Gerald Taylor wrote:
Query optimization question
I am selecting from a single table but it has a lot of rows and it
has a very involved calculation. What I really want to do is
is FIRST restrict the number of rows so that the big calculation is only
performed on the ones that are within 3
Thanks for the replies. This appears to be the right answer:
where page_body regexp '.*img .*.*' and page_body not regexp '.*img .*
alt= .*.*';
bob
==
Bob Ramsey SYSTEMS ADMINISTRATION AND SYSTEMS PROGRAMMING III
MA,
When you don't have subselects, you have two options: temporary tables or
JOINed queries.In your case, I think the temporary table is the better way
to go.
I would also eliminate the ABS() check so that I can compare values
directly against the index. I know the math is correct your way but
Hi,
Is there any suitable command in MySQL 4.0 with out InnoDB for taking the
backup. Please suggest.
Thanks,
Narasimha
Confidentiality Notice
The information contained in this electronic message and any attachments to this
message are intended
for the exclusive
On Mon, 4 Oct 2004 21:55:58 +0530, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
Is there any suitable command in MySQL 4.0 with out InnoDB for taking the
backup. Please suggest.
Have you looked at mysqlhotcopy ?
http://dev.mysql.com/doc/mysql/en/mysqlhotcopy.html
--
Greg Donald
Zend
mysqlhotocpy supports only Linux and Netware software. Will it support windows
operating system. Please clarify.
Thanks,
Narasimha
-Original Message-
From: Greg Donald [mailto:[EMAIL PROTECTED]
Sent: Mon 10/4/2004 10:06 PM
To: [EMAIL PROTECTED]
On Mon, 4 Oct 2004 [EMAIL PROTECTED] wrote:
Hi,
Is there any suitable command in MySQL 4.0 with out InnoDB for taking the
backup. Please suggest.
Thanks,
Narasimha
Hi Narasimha,
when posting a question to a mailing list, please don't
ask it many times, or the users might say hey,
I'm populating a new table from excel sheets and for some silly reason
several column values are populated with \ (not my doing!).
I can easily fix the problem but I was just wondering.
Thanks Everyone.
Jay Blanchard [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
[snip]
What's the
On Mon, 4 Oct 2004 22:10:39 +0530, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
mysqlhotocpy supports only Linux and Netware software. Will it support windows
operating system. Please clarify.
I have heard of people using Perl on windows, so I would guess it will
run, mysqlhotcopy being a Perl
Hai Martin,
I suppose these are the ways with Databases. They don't work the way
we like them to.
So please adjust with it. For this matter I think, any RDBMS will be
doing their or paddings to the scripts when they are loading it in
memories.
just the same way for oracle(where i have some
Hello Eldo,
I suppose these are the ways with Databases. They don't work the way
we like them to.
So please adjust with it. For this matter I think, any RDBMS will be
doing their or paddings to the scripts when they are loading it in
memories.
just the same way for oracle(where i have some
Hi Khan,
I would klike to approach ur problem in a diffrent manner.
My suggestion is that, in both the date fields u use dates only. (I
don't know the useabilty of '0' in a date field). While using this, u
have to store the creation time a the modification time, at the
creation of record. This is
On Tue, 5 Oct 2004 00:27:45 +0530, Eldo Skaria wrote:
I suppose these are the ways with Databases. They don't work the way
we like them to.
So please adjust with it. For this matter I think, any RDBMS will be
doing their or paddings to the scripts when they are loading it in
memories.
But
I suppose these are the ways with Databases. They don't work the way
we like them to.
So please adjust with it. For this matter I think, any RDBMS will be
doing their or paddings to the scripts when they are loading it in
memories.
But that doesn't make it right.
Specifically, I
I agree with keeping only dates or nulls in a date-type column. One other
option, you could use a NULL value for ModifyDate with the COALESCE()
function like this
SELECT, COALESCE(ModifyDate, CreationDate) as recordDate
FROM ...
WHERE ...
ORDER BY recordDate
if ModifyDate is not null, that
Greetings,
I'm trying to update existing records in one table so that value of a
column winds up matching the value of a column in a second table, based on
a match in a second column in each table.
I'm not sure if I'm taking the wrong approach on this, of if I'm missing
something simple in the
I've worked through some of this but still would like
some opinions. Maybe it's not clear but I haven't
received any responses.
Basically to tie the records together I will use the
recordID (auto incrementing) in every table where the
records are written.
Then I can grab everything out of
I'm trying to update existing records in one table so that value of a
column winds up matching the value of a column in a second table, based on
a match in a second column in each table.
I'm not sure if I'm taking the wrong approach on this, of if I'm missing
something simple in the SQL
I guess the docs aren't totally clear on this as you are not the first
person to have problems forming a multiple-table UPDATE statement.
http://dev.mysql.com/doc/mysql/en/UPDATE.html
UPDATE dp_populate_vals
INNER JOIN dp_populate_tables
ON
Tables are tied together by whichever field(s) you use to store their
parent's reference.
For one second, imagine I am writing an inventory control program for
somebody like Wal-Mart or Target. Those businesses have so many locations
that they are divided into regions, each region will have
Is there a version or a product available for LINUX?
On Tue, 28 Sep 2004 13:55:19 -0500, Tim Hayes [EMAIL PROTECTED] wrote:
ari
MYdbAL which you can download at www.it-map.com is completely FREE and
includes data modeling, DDL generation or whatever you need to create your
MYSQL database.
Hi,
I have a process that relies on three tables. There is a Process
table, a Process_description table and a third table that holds some
display decoration hints that depend on the perceived nature of each
process.
The decoration table is static. It looks like
decoration
{
severity_level
Thanks for the suggestions over the weekend! I will be looking in to
this in a few days - for now I think I am just going to have to re-write
my PHP script to make 2 separate queries and array_merge() them - which
invariably seems to solve OR problems. But there should be a better
way, no?
If you aren't tired of this problem, I have one more question...
The last query worked well, except one small detail...
SELECT user, refurl, max( entry ) AS most_recent, count( user ) AS visits
FROM userlog
WHERE user != ''
GROUP BY user
ORDER BY most_recent DESC
LIMIT 10
I am now
A heads-up and a call for advice for anyone compiling from source on
Linux amd64:
The latest Debian amd64 unstable upgrade of libc6-dev to version
2.3.2.ds1-17 broke compiling MySQL 4.0.21 from source using gcc-3.4.
(Also breaks similarly with the default gcc for this platform,
gcc-3.3.4.)
At 04:05 PM 10/4/2004, [EMAIL PROTECTED] wrote:
I guess the docs aren't totally clear on this as you are not the first
person to have problems forming a multiple-table UPDATE statement.
Thanks for the quick response. It's somewhat gratifying to hear that I'm
not alone in my confusion...
Ted
--
I am a beginner, so forgive me.
From mysql if I type:
Mysqlshow tables;
The result scrolls to the last lines and then the prompt again. Is
there an argument or a variable I can set that will act like 'more' or
'less' in unix? I want it to stop scolling so I can walk through the
results.
Mysql \P less
PAGER set to less
Mysql show tables;
You can see other cool flags by typing 'help;' at the mysql prompt.
On Mon, 4 Oct 2004 14:58:29 -0700, OMalley, Brent
[EMAIL PROTECTED] wrote:
I am a beginner, so forgive me.
From mysql if I type:
Mysqlshow tables;
The result scrolls
Thanks!
-Original Message-
From: Kyle Kirkland [mailto:[EMAIL PROTECTED]
Sent: Monday, October 04, 2004 3:15 PM
To: OMalley, Brent
Cc: [EMAIL PROTECTED]
Subject: Re: Real Basic Question
Mysql \P less
PAGER set to less
Mysql show tables;
You can see other cool flags by typing 'help;'
Does anyone has the experience on migrating mysql server from 32bit sysem to a 64bit
system?
Can data files(from 32bit system) be readed properly by mysql server after copy to a
64bit system?
Thank you in advance!
--Alex
__
Do You Yahoo!?
It's a great server (the DL760 G2). They really opened up the bus and the
Xeon 3.0 is superfast.
darren [EMAIL PROTECTED]
10/03/2004 07:51 PM
To: [EMAIL PROTECTED]
cc:
Subject:[OT] HP DL760G2 vs Opteron for large DB on Linux
Hi all,
I am looking to
Anyone have experience with installing the Dyna III electronic ignition?
I put it on my R80/7, but since it wasn't running before I did the install, and it's
not running now, I'm not sure if I installed it correctly or not.
But, after I did the install, I tried to do the static timing as
The safest thing you can do to protect floats and the like is to use
mysqldump to dump them to a .sql on the 32 bit system then import them
again on the 64 bit system.
-Eric
On Mon, 4 Oct 2004 16:38:13 -0700 (PDT), alex ye [EMAIL PROTECTED] wrote:
Does anyone has the experience on migrating
Hi,
Thank you backup is working fine. Any one can help me how to restore the back up
database?. Not at table level. At the database level. How to run a sql file from mysql
prompt?. While restoring any more things to be taken care, regarding database?.
Thanks,
NARasimha
Thanks Eric.
But our data is very big(about 400G), server don't have enough disk space and it will
take long time to finish the dump.
It may cause problem to floats if just copy data files to a 64 bit system?
--Alex
Eric Bergen [EMAIL PROTECTED] wrote:
The safest thing you can do to protect
I'm by no means an expert on this, but some things you might want to
consider...
An alternative method to not impact the disk space on the 32-bit system:
If you have connectivity between the 32-bit and 64-bit systems is to use
mysqldump on the 64-bit system and specify the 32-bit host using the
Thanks for all your help!
Ted Byrne [EMAIL PROTECTED] wrote:
I'm by no means an expert on this, but some things you might want to
consider...
An alternative method to not impact the disk space on the 32-bit system:
If you have connectivity between the 32-bit and 64-bit systems is to use
60 matches
Mail list logo