;"ca15027"
"Test" "Normal" "" "0"
I'd like to update the url_server and url_port fields in this example
for B15127 and B15227 to the values contained in B15027. There are other
examples as well. I w
That appear to have been it, thanks to all for the assist and have a
great weekend!
Dirk Bremer - Senior Systems Engineer - Utility - AMS
NISC Lake St. Louis MO - USA Central Time Zone
636-755-2652 fax 636-755-2502
dirk.bre...@nisc.coop www.nisc.coop
-Original Message-
From: Johnny
rror-log.
I followed the instructions here:
http://forums.mysql.com/read.php?26,9390,242387#msg-242387
With negative results.
Dirk Bremer - Senior Systems Engineer - Utility - AMS
NISC Lake St. Louis MO - USA Central Time Zone
636-755-2652 fax 636-755-2502
dirk.bre...@nisc.coop www.n
well, stupid, but have
struggled with it the last few days to no avail. All servers are using
the same version of 4.1.22-community-nt.
I feel a bit naked without the replication so your assistance in helping
me getting it up and running will be very appreciated.
Dirk Bremer - Senior Syste
Indiana has two time zones as I recall. The state is divided roughly in
half between the two.
Dirk Bremer - Senior Systems Engineer - Utility - AMS - NISC Lake St.
Louis MO - USA Central Time Zone
636-755-2652 fax 636-755-2502 [EMAIL PROTECTED] www.nisc.coop
-Original Message-
From: Hiep
erate an
error, the info also doesn't reach the intended website.
I hope there is a smarter way to have PHP perform this task, without me
actually having to reveal sensitive info to the user. Is there anyone
willing to point me in the right direction?
Kind regards,
Dirk
--
MySQL General
doesn't generate an
error, the info also doesn't reach the intended website.
I hope there is a smarter way to have PHP perform this task, without me
actually having to reveal sensitive info to the user. Is there anyone
willing to point me in the right direction?
Kind regards,
D
> -Original Message-
> From: Chris [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 27, 2006 22:42
> To: Dirk Bremer
> Cc: mysql@lists.mysql.com
> Subject: Re: Mysqlcheck issues
>
> Dirk Bremer wrote:
> > I am using MySQL server 4.1.10 on Windows 2003 Se
> -Original Message-
> From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 27, 2006 22:40
> To: Dilipkumar; Dirk Bremer; mysql@lists.mysql.com
> Subject: RE: Mysqlcheck issues
>
> The trouble with myisamchk is that it requires the se
x27;t understand what is causing the service to abort.
Your thoughts?
Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO
- USA Central Time Zone
636-755-2652 fax 636-755-2503
[EMAIL PROTECTED]
www.nisc.coop
--
MySQL General Mailing List
For list archives: http://lists.mysq
transfers.queue.test = @test
# and ftp_transfers.queue.cycle = @cycle
# and (@cur_date <= ftp_transfers.queue.queue_time)
# and param5 not like '%ebi%'
order by ftp_transfers.queue.ident desc limit 50)
order by ftp_transfers.queue.ident asc
I'm not in an immediate position to upgrade to 5
ectory. There is also a corresponding file:
MAILCD3-relay-bin.index
In this instance, MAILCD3 is the name of the server. There are least 346
of the relay-bin files.
Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO
- USA Central Time Zone
636-755-2652 fax 636-755-2503
I should add I ran a FLUSH LOGS on the master and this had no effect on
the relay-bin files.
Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO
- USA Central Time Zone
636-755-2652 fax 636-755-2503
[EMAIL PROTECTED]
www.nisc.coop
> -Original Message-
> From
were
inserted, from lowest-ID to the highest-ID. This will prevent the query
from showing possible hundreds of results.
There are multiple customers in the table.
Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO
- USA Central Time Zone
636-755-2652 fax 636-755-2503
[
erence to deleting the relay-bin
files. Thankfully, the relay-bin files are small in size, but I would
still like to prune them.
Thoughts?
Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO
- USA Central Time Zone
636-755-2652 fax 636-755-2503
[EMAIL PROTECTED]
www.
query?
Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO
- USA Central Time Zone
636-755-2652 fax 636-755-2503
[EMAIL PROTECTED]
www.nisc.coop
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
a six-digit number)
I have about 350 of these files and they all appear to be held open by
the mater, i.e. they cannot be deleted from Windows. I assume that these
files have something to do with replication.
How can I purge these files to a more manageable number?
Dirk Bremer - Senior Systems Eng
> -Original Message-
> From: Peter Brawley [mailto:[EMAIL PROTECTED]
> Sent: Monday, May 01, 2006 16:55
> To: Dirk Bremer
> Cc: mysql@lists.mysql.com
> Subject: Re: Finding duplicates, etc.
>
> Dirk,
>
> >I would like to know where there ar dupli
port on them.
I can't figure out a way to accomplish number 3 but know that in the
given data set that this condition does occur.
Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO
- USA Central Time Zone
636-755-2652 fax 636-755-2503
[EMAIL PROTECTED]
www.nisc.coop
-long-didn't-read kinds).
Any link to a code snippet opening a connection, sending a query and
closing the connection would be highly appreciated.
Dirk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> -Original Message-
> From: David Godsey [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 17, 2006 08:42
> To: Dirk Bremer
> Cc: Gordon Bruce; [EMAIL PROTECTED]; gerald_clark;
> mysql@lists.mysql.com; David Godsey
> Subject: RE: Byte Swapping (Re Post)
>
>
Rather than changing the function of the mysqldump program, why not
massage its output to your specifications.
Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO
- USA Central Time Zone
636-755-2652 fax 636-755-2503
[EMAIL PROTECTED]
www.nisc.coop
> -Original Mess
is opposite between big-endian and
> little-endian, then if you can get the bytes in a string REVERSE()
> should flip the order.
>
REVERSE would alter the order of the bytes. To convert between
big-endian and little-endian, I believe that you need to reverse the
order of the bits in eith
contains lines like this:
\. today.sql
\. status.sql
\. active.sql
Save this file. Execute this file from the client. I did not try nesting
more than this example (1-level), but suppose it would work for more.
Note that the '\.' equates to the 'source' command.
Dirk Bremer - Senior Systems
m the display width.
Dirk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
nmail.frm
I tried myisamchk with different options, but no go.
Any clues? Any way to recover the data (for re-import)?
Regards,
Dirk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ctive).
Dirk Bremer - Senior Systems Engineer - ESS/AMS - NISC Lake St. Louis MO
- USA Central Time Zone
636-755-2652 fax 636-755-2503
[EMAIL PROTECTED]
www.nisc.coop
-Original Message-
From: Kieran Kelleher [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 28, 2005 16:21
To: Brian Dunning
Cc:
hardware itself consist of an SUN V440 with 4 x 1.2 GHz CPUs and 16 GB RAM
The System Usage is about 40% average
The Storage System (NetApp Filer) is far from being "under load"
Dirk
Dirk Steinmeyer
Systemadministrator / ITS SystemService
SevenOne Intermedia GmbH
Ein Unternehmen de
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Dirk Bremer (NISC)" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, September 27, 2004 14:30
Subject: Re: Date Range
> I think you are very close but you are missing the LAST day of each mont
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Dirk Bremer (NISC)" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, September 27, 2004 11:40
Subject: Re: Date Range
> To compute the date range for "two months ago". (if the curre
ore than one statement per
> request.)
I am using the command-line client. I have it working but it is off by
one-month, run as is, it is showing July data rather than August. I am
checking into it.
Dirk Bremer - Systems Programmer II - ESS/AMS - NISC St. Peters
USA Central Time Zone
636-922-9
m, I'll gladly code an exception for that day.
Thanks for your tips, the query now always takes 0.03s in stead of about
0.33s.
Dirk.
Bill Easton wrote:
Dirk,
If you use a function on the column, MySQL will not use the index on that
where clause. You need to somehow arrange to not use a functio
Wow Bill,
Thanks!
It's so obvious! But only experience can bring such sollutions.
I'll change the query to a more "hardcoded"-look!
Thanks again!
Dirk.
Bill Easton wrote:
Dirk,
If you use a function on the column, MySQL will not use the index on that
where clause. You need t
a little overkilling
for what it is used for, so I think my visitors should accept that that
query is a slow one.
Thanks for all your help!
Dirk.
Jocelyn Fournier wrote:
Hi,
The query is still slow because MySQL can't use the index to search the
right putdatetime.
So unless you store in sep
sometimes only takes 0.33 seconds, and at other times the query takes 22
seconds? Is this something everyone here experiences? Or is there
something wrong with my configuration?
Regards,
Dirk.
Jocelyn Fournier wrote:
Hi,
I would say for this one you need an index on (put, front, putdatetime) to
get
the rows of the table (18775). You can imagine
how slow this query is.
Is there a way to improve this one?
Thanks and sorry about the lot of messages you are receiving, but I'm
learning a lot here!
Dirk.
Jocelyn Fournier wrote:
Are you sure this not because your query is cached by the MyS
he has to process 6243 rows. And that's probably the reason why MySQL
keeps using my index and I need USE INDEX (...) to force him into using
yours.
But I don't understand the difference in rows to process... do you?
For now, I will put USE INDEX (...) into the query as I also need t
Hello,
Now this I don't understand, now the query takes only 0.05s on any of
the two indexes.
I didn't do anything! Not even the analyze table I was going to try!
I'll keep you posted, thank you for the explanation, I understand the
reason for the filesort now.
Dirk.
Jocelyn Fou
that, why would your index avoid a filesort?
I don't understand that.
Any other suggestion on how to speed up?
Anyway, thanks for all the help,
Dirk.
Jocelyn Fournier wrote:
Hi,
You can try to add an index on (put,front,topcategory,putdatetime) to avoid
MySQL has to do a filesorting on the
No, it doesn't improve the speed. I think that is because almost all
rows in that table are approved.
Are you also convinced that this is a very long time for such a query?
Or is it normal?
Andrew Kreps wrote:
On Sat, 18 Sep 2004 22:25:12 +0200, Dirk Schippers
<[EMAIL PROTECTED]> wro
of the total of 18818).
The table will certainly grow a lot in the future so I am very worried
about the performance.
What can I do about this? Is there any way to improve this?
Enabling the cache is not an option as the data in the table is altered
a lot.
Anyone?
Dirk.
--
Schippers Dirk
Zaakv
cannot tell me anything about
this. Can you please? How does this work, what's the syntax? Is this
ANSI-SQL standard (or compatible to other DBMS)? Or is it even
documented?
--
Schippers Dirk
Zaakvoerder Frixx-iT
htt
think that Oracle is that much smarter than MySQL.
Can anyone tell me what's going on? Are there MySQL parameters that can
improve things? Or is MySQL really that slow? I won't believe the
last one...
I tested these queries on a MySQL 3.3 and a MySQL 4.0 database, all with
the same sp
prove handy
for some things.
Dirk Bremer - Systems Programmer II - ESS/AMS - NISC St. Peters
USA Central Time Zone
636-922-9158 ext. 8652 fax 636-447-4471
[EMAIL PROTECTED]
www.nisc.cc
- Original Message -
From: "Eamon Daly" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]&
ll. Why did the MySQL server complain about the logfile size from a
.cnf file? Should I be using a .cnf file and where should it be located? I
have but a single, small database with only two tables.
Dirk Bremer - Systems Programmer II - ESS/AMS - NISC St. Peters
USA Central Time Zone
636-922-9158 ex
Bingo, Shawn wins the virtual beer(s). I never looked at the unix_timestamp
function. Thanks to everyone else and wishing you virtual beers as well!
Dirk Bremer - Systems Programmer II - ESS/AMS - NISC St. Peters
USA Central Time Zone
636-922-9158 ext. 8652 fax 636-447-4471
[EMAIL PROTECTED
13 |
13 |
+---+-+-++--
--+
15 rows in set (0.01 sec)
Which appears to be working correctly (Transfer Time1) except for ident =
1309, which spans a date boundary. So, back to the drawing board to figure
out the date boundary
Looking at the results further reveals that a numeric subtraction is being
performed on the two datetime fields rather than a date-type subtraction.
Any thoughts on how to perform a date subtraction in version 4.0.18?
Dirk Bremer - Systems Programmer II - ESS/AMS - NISC St. Peters
USA Central
1 09:03:30 | 2004-06-11 09:23:44 | 00:33:34 |
2014 |
| 1314 | 2004-06-11 09:24:32 | 2004-06-11 09:24:45 | 00:00:13 |
13 |
+---+-+-++--
--+
15 rows in set (0.00 sec)
Dirk Bremer - Systems Programmer II - ESS/AMS
rsion 4.1.x has a lot more date/time functions, but I'm wondering if
something similar can be arrived at under the version that I am using.
Dirk Bremer - Systems Programmer II - ESS/AMS - NISC St. Peters
USA Central Time Zone
636-922-9158 ext. 8652 fax 636-447-4471
[EMAIL PROTECTED]
w
> > select job_coop as 'Job/Coop', count(*) as Count from queue group by
> > job_coop order by Count;
>
>
> The other alternative is to omit the 'as Count' and use this query:
>
> select job_coop as 'Job/Coop', count(*)
> from queue
> group by job_coop
> order by 2;
>
> where the '2' in the 'order
the count(*)?
Dirk Bremer - Systems Programmer II - ESS/AMS - NISC St. Peters
USA Central Time Zone
636-922-9158 ext. 8652 fax 636-447-4471
[EMAIL PROTECTED]
www.nisc.cc
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> At 16:03 -0500 4/20/04, Dirk Bremer (NISC) wrote:
> >I have a couple of questions concerning the MySql client program.
> >
> >1. Are the option for the client program, i.e. --auto-rehash, etc.
> >documented anywhere? I searched the included HTML file and could not
the
database server program residing on a different machine?
Dirk Bremer - Systems Programmer II - ESS/AMS - NISC St. Peters
USA Central Time Zone
636-922-9158 ext. 8652 fax 636-447-4471
[EMAIL PROTECTED]
www.nisc.cc
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
- Original Message -
From: "Victor Pendleton" <[EMAIL PROTECTED]>
To: "'Dirk Bremer (NISC) '" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, April 16, 2004 15:57
Subject: RE: SQL Query Question
> If your data is stored in the
- Original Message -
From: "Victor Pendleton" <[EMAIL PROTECTED]>
To: "'Dirk Bremer (NISC) '" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, April 16, 2004 15:06
Subject: RE: SQL Query Question
> WHERE queue_time = Now()
I have a simple table where one of the columns is named queue_time and is
defined as a timestamp-type. I would like to query this table for all rows
where the queue_time equals the current date. I an a newbie and have been
wrestling with the docs for a solution. You help will be appreciated.
Dirk
I will be out of the office starting October 11, 2002 and will not return
until November 4, 2010.
Please contact Gerry McNamee ([EMAIL PROTECTED]) or Aurelien Thouard
([EMAIL PROTECTED]) since I left IBM
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
mmand, and I need it !!! ;-)
Any hint ?
Dirk Hennrichs
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-ma
"correct" entries from the end of the table while X>=5 just jumps in its
middle again.
Workaround: Rewrite the query using some "order" clause. While this is
shuffling all entries compared to before, it seems to guarantee that all
entries are processed and transmitted.
No
ut 20 minutes).
>From what I can see OR I'm doing something wrong to set the timeout
OR there is a bug within the connect API
Public Declare Function API_mysql_connect Lib "libmysql.dll" Alias
"mysql_connect" (ByRef TMYSQL As API_MYSQL, ByVal host As
recordset.Close
I get a sequence error when I try to go back to the first record
however if i enter ONE record with a description .. it works
Is there anyone out there that can point out the logic behind this ?
Thanks in adv
Hello everybody,
I have to create a table on a MySQL-Server with fieldnames like a35#70.
if I ty it that way
create table test (
a35#70 char (70));
on the mysql - prompt, the creation fails. Even brackets like in MsSQL
or '`' doesn't help.
Can anybody tell me what to
edx,%ebx
ret
.strxmov_end:
! .sizestrxmov,.strxmov_end-strxmov
>Submitter-Id:
>Originator:Dirk Zoller
>Organization:
e-mail: [EMAIL PROTECTED]
>
>MySQL support: none
>Synopsis: Build problem with files strings/-x86.s
>Severity: n
hich resulted in
2000-10-09 04:00:00
This is not exactly midnight but normally this shouldn't move the date
forward by one, should it?
I'm using the Win32 V3.23 release.
Regards,
Dirk Illenberger.
-
Before posting,
65 matches
Mail list logo
