Jigal van Hemert wrote:
Nick Sinclair wrote:
"[.] WHERE date_format(timestamp, '%Y-%m-%d %T')
<=DATE_SUB(CURDATE(),INTERVAL $BLACKLIST_DECAY HOUR)"
* ...It only resolves to the DAY and not an hourly resolution. I have
included a script below that I use f
it's
> tough to narrow down the problem.
>
> sk
Yes, I understand, but that's not what I'm getting. I'm getting rows
returned where "apples" is not present in any of the columns in any way. I
think it's a syntax mistake in my query, but I can't see it.
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I previouslly compiled my own version of MySQLd 4.0.14 on FreeBSD 4.8 with
LinuxThreads using Jeremy Zawodny's config/compile options
(http://jeremy.zawodny.com/blog/archives/000458.html) and have had no
problems. However, I've got 4.9 install with updated ports, etc. and I
can't seem to get 4.0.
--- Original Message -
From: "Nick" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, February 02, 2004 1:30 AM
Subject: FreeBSD 4.9 + MySQL 4.0 + LinuxThreads
>
> I previouslly compiled my own version of MySQLd 4.0.14 on FreeBSD 4.8 with
> LinuxTh
other words, if a resource is in a high priority task and a low
priority task, I only want to show the high priority task.
Thanks for the help!
-Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
entire table.
I really want to group by the resource, but still have all the info
available for what ever the highest priority task it is in.
-Nick
Btw, all the fields are varchars with the priorities being Hi, Medium,
Low, but I could really care less on what particular priority it is atm
That works great. =D
Knew it shouldn't be that difficult, thanks a bunch.
And it actually works with the Priorities being in text form to (low, med,
hi).
-Nick
> At 02:52 PM 7/24/2003, you wrote:
>>After some searching around different books/manuals/google I still can't
>&
Yep, saw that and did just as you stated :)
> Nick, As you stated, your priority field datatype is "varchar", with
> possible
> values "Hi", "Medium" and "Low", as opposed to being integers. The use of
> max
> function, as suggested by
Dear ALL
I am Nick, I come from Taiwan company - EC-SERVER~~I have two WEB
SERVER to make load balance. Both of the WEB SERVER was installed mysql~~
I used the mount NFS instruction the storage spaces in linux.At the
same time,WEB's Data and mysql's data both in NFS parat
The following code is incorrect in safe_mysqld on 3.23.54 at least (that
is all I have checked)
Line 162:
if $NOHUP_NICENESS -gt 0
then
$NOHUP_NICENESS="nice --$NOHUP_NICENESS nohup"
This needs to be:
if test $NOHUP_NICENESS -gt 0
then
NOHUP_NICENESS="nice --$NOHUP_N
I am currently running MySQL3.23.53-max with no problems, well
my_print_default complains about the same thing that MySQL-3.23.54
complains about, but MySQLd runs fine. I am attempting to upgrade to
MySQL3.23.54 (mysql-max-3.23.54-pc-linux-i686.tar.gz) and MySQLd does
not run at all, below are the
I am running the Solaris 8 binary on all of my Ultra Sparc II Solaris 7
servers with no problems at this time, however I am not doing any of the
advanced features, such as MySQL-Max or replication.
Nickg
-Original Message-
From: Lenz Grimmer [mailto:[EMAIL PROTECTED]]
Sent: Monday, Dec
erver and let it sit there for a
min. or two. It will then proceed to recieve signal 11's
restart, wait a few, signal 11, restart
>Fix:
>Submitter-Id:
>Originator:Nick Stuart
>MySQL support: none
>Synopsis: Server keeps getting signal 1
wscrash.sql
>Fix:
Unknown
>Submitter-Id: Nick Kralevich
>Originator:Nick Kralevich
>Organization:
Nick Kralevich
>MySQL support: none
>Synopsis: Full Text Multicolumn search bug
>Severity: serious
>Priority: medium
>Category: mysql
>Class:
Are you sure that you are running the server at all?
Nikodim
Here's my bug report
Version: MySql 3.23.51.
OS: Linux linux 2.4.18 #4 Fri May 31 01:25:31 PDT 2002 i586 unknown
Memory: 64MB + 256MB(Swap)
Distibution Name: mysql-3.23.51-pc-linux-gnu-i686
I runned MySQL with the command: bin/sa
Are you sure that you are running the server at all?
Nikodim
Here's my bug report
Version: MySql 3.23.51.
OS: Linux linux 2.4.18 #4 Fri May 31 01:25:31 PDT 2002 i586 unknown
Memory: 64MB + 256MB(Swap)
Distibution Name: mysql-3.23.51-pc-linux-gnu-i686
I runned MySQL with the command: bin/sa
Does MyCC is able to connect to MySQL servers in the local network...or it can connect
only to localhost?
NN
___
NOCC, http://nocc.sourceforge.net
-
Before posting, please check:
http:/
estions on some
working codes that gets both of these statments into one?
Thanks!
Nick
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Password
I did this as a machine data source
When I try to connect I get the error message
S1000[TCX][MYODBC] Host " is not allowed to connect to this MySQL
Server.
Any Ideas why this may be happening?
Thanks
Nick S
Can someone tell me where / how to get the Windows 2000 equivalent of the
mod_auth_mysql.so in Linux.
Thanks
Nick
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
y compiling/running the demo code given above.
>Fix:
Add "-mieee" to CXXFLAGS and CFLAGS.
>Submitter-Id:
>Originator:Nick Hilliard
>Organization:
>MySQL support: none
>Synopsis: FP problems on alpha / gcc
>Severity: serious
>Priority:
Hello
I have been looking at planning the database strategy for openstreetmap
(http://www.openstreetmap.org).
There are several data types stored in tables with longitude and
latitude columns. Select statements work by selecting
where lat>$lat1 and lat<$lat2 and lon>$lon1 and lon<$lon2
I h
Alexey Polyakov wrote:
On 4/23/06, Nick Hill <[EMAIL PROTECTED]> wrote:
I've noticed a couple things.
1) Right now you're emulating spatial index.
2) In future, you're going to emulate partitioning.
Why do you think that doing this stuff manually is better than using
buil
Hello Adam
Adam Wolff wrote:
Actually runs through the table four times instead of twice, and maybe
can't even use the index for the whole query.
Assuming my results are not typical of MySQL query times, this would
explain the sqrt() relationship of returned rows to query time.
I have tried
that I get this problem even when the
temporary table doesn't exist, on a brand-new connection.
I've had this code running for a couple of weeks and just noticed the
problem, so I'm not sure if it cropped up right away or not. Haven't
had a chance to bounce the server yet.
Hello John
There are two approaches to this.
1) Best, save date into table as a number. Select date like
WHERE date>=$date1 AND date<=$date2
2)Otherwise, if storing dates a strings:
WHERE date=$date1 OR date=$date2 OR date=$date3 OR date=$date4 OR
date=$date5.
In general, if you want to
Hi All,
I seem to be having a problem with the resolution using the timestamp
function. I am accessing the database "snort" on an ACID/SNORT/MySQL
installation utilizing a collection of shell scripts that are run as
cron jobs and function as a "bot" adding and removing firewall rules
(iptables
Hi All,
I seem to be having a problem with the resolution using the timestamp
function. I am accessing the database "snort" on an ACID/SNORT/MySQL
installation utilizing a collection of shell scripts that are run as
cron jobs and function as a "bot" adding and removing firewall rules
(iptables
Does anyone know if it is possible to populate values
into an Excel spreadsheet from a MySQL database? Can I
do this directly in Excel or do I need to create an
external program to do the work (i.e. in VB).
Thanks
-Nick
__
Do You Yahoo!?
Tired of
oven to be less than useful so far in my endeavor.
Also, thanks to James for his suggestion on using the
ODBC query directly from Excel. This will get us
started for the time being, and give me some leeway so
I can work on doing this in PHP.
Thanks to you both!
-Nick
__
--- Partha Dutta <[EMAIL PROTECTED]> wrote:
> Nick Jones wrote:
>
> >--- "J.R. Bullington" <[EMAIL PROTECTED]>
> wrote:
> >
> >
> >
> >>Automatically populate??
> >>
> >>Not that _I_ know of, but of course ther
eet.
Thanks to everyone here for their insight. I coudln't
have achieved it without all of you!
-Nick
--- inferno <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I had to do the same thing on a project and the
> problem was that if
> you use CSV you will not be able to mak
Is there a way to have foreign keys and force referential integrity? I have
a main table and a lookup table, i want to be able to require that the main
table is using values from the lookup table. I am just not sure how in
MySQL. Thanks
Somebody give me some ammo for this. I flagged MySQL v5 to our CTO and
got shot down. We currently develop in MSSQL and I don't know enough
about either to make a constructive argument. I'm not even sure I
understand what he's on about with 'table functions' and 'nested
selects'. I couldn't find th
ll let me use the function.
I hit a problem using functions in stored procedures, too, and I'm wondering
if these are related.
Nick
--
Nick Arnett
[EMAIL PROTECTED]
Messages: 408-904-7198
ut the stored procedure debugger -- does all the
functionality in the documentation work with MySQL? Anybody used this with
MySQL, who could describe their experience with it?
I would really love a good SP debugger!
Nick
--
Nick Arnett
[EMAIL PROTECTED]
Messages: 408-904-7198
Hi, experts
How can I make mysql database users password with expire date?
Does mysql can do it?
--
NiCK
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
9","NGU10","NGU11","NGU12","NGU13","NGU14","NGU15","NGU16","NGU17","NGU18","NGU19","NGU20","NGU21","NGU22","NGV09","NGV10","NGV11","NGV12","NGV13","NGV14",
"NGV15","NGV16","NGV17","NGV18","NGV19","NGV20","NGV21","NGV22","NGX09","NGX10","NGX11","NGX12","NGX13","NGX14","NGX15","NGX16","NGX17","NGX18","NGX19","NGX20","NGX21","NGX22","NGZ09","NGZ10",
"NGZ11","NGZ12","NGZ13","NGZ14","NGZ15","NGZ16","NGZ17","NGZ18","NGZ19","NGZ20","NGZ21","NGZ22");
Running query b gives me a result set as follows:
| 2010-01-15 | NYMEX | NGZ22 | 8.9620 | 8.9680 | 8.9620 | 8.9680
| 0 |
++++-+-+-+-++
86765 rows in set (4.46 sec)
I then because I want to generalize query b I continue by creating query c
as follows:
mysql> select * from endOfDayData where endOfDayData.market like 'NYMEX'
and endOfDayData.symbol IN (select names.symbol from names where
names.market like 'NYMEX' and names.name like 'natural gas {%');
Query c seems to have good syntax as neither the command line mysql
interface nor the gui spit it back but it literally takes forever to run;
I've waited at least twenty minutes and not got anything back. I'm running
Ubuntu 9.10 on an intel core i7 with 4GB RAM and 12GB swap... the process
monitor doesn't even flinch so I'm not thinking hardware here... why is the
sub-query running so slow?
Thanks for you help!!
Nick
Hello Everyone,
I was wondering if the MySQL devel files tar was available for download? I
was
only able to find rpm on the mysql site.
Thanks in Advance,
Nick.
Hello Everyone,
Thank you so much for your response. I don't need the entire MySQL server
just the
development libraries. I found "MySQL-devel-5.5.16-1.linux2.
6.i386.rpm", but there is
no MySQL-devel-5.5.16-1.linux2.6.i386.tar.gz.
Thanks Again,
Hello Everyone,
Thank you so much for your response. I don't need the entire MySQL server
just the
development libraries. I found "MySQL-devel-5.5.16-1.linux2.
6.i386.rpm", but there is
no MySQL-devel-5.5.16-1.linux2.6.i386.tar.gz.
Thanks Again,
Nick.
That being said, does cmake have a --help friend? I just don't want to
install the complete MySQL server, just MySQL-devel, as
mentioned earlier.
Nick
I will post the cmake that get's just the devel header files shortly.
Nick.
Thanks Shawn!
Ninus from Montreal.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hello Everyone,
I am looking to build just the mysql client, and not the entire server
from source.
Which cmake flags do I need to install just the mysql client/devel header files.
The actualy mysql server is on a different machine.
Thanks in Advance,
Nick.
--
MySQL General Mailing List
For
I should have mentioned that this is using mysql 5.5.15
Thanks Again,
Nick.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ailed to create sys files
make[2]: *** [include/mysqld_error.h] Error 1
make[1]: *** [extra/CMakeFiles/GenError.dir/all] Error 2
make: *** [all] Error 2
Thanks in Advance,
Nick.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
in_symax |
+---+
| acc |
ERROR 1146 (42S02): Table 'symax.acc' doesn't exist
I should mention that we have deleted the ib_* files in the past. Is
it ok if I post our config
for a quick review?
Thanks in Advance,
Nick.
On Tue, Nov 1, 2011 at 10:09 A
Hello Reindl, I just noticed that I misspelled your name. Sorry about that!
Cheers,
Nick.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
This is what happens when a large conglomerate writes large
checks. Everyone goes on the aggressive... I'm KIDDING!@!!@#!@!!
N.
On 4/6/13, Noel Butler wrote:
> On Sat, 2013-04-06 at 16:18 +, attee...@gmail.com wrote:
>
>> You don't have to be a jackass to him/her.
>>
>
>
> He's always a
This was reported in 5.5.31, a patch, VERY SIMPLE was submitted.
The problem goes ignored by oracle
5.5.32 releases, same error, apply the same simple patch and builds
/tmp/mysql-5.5.32/vio/viossl.c: In function 'ssl_do':
/tmp/mysql-5.5.32/vio/viossl.c:175: error: 'SSL_OP_NO_COMPRESSION'
undecla
n fix made available to them months ago,
should, get me a win to move away from mysql. (perhaps this is what
oracle wants anyway, since mysql earns them no money)
On 6/9/13, Claudio Nanni wrote:
> Hi Nick,
>
> It seems it is fixed already in MariaDB:
> http://bugs.mysql.com/bug.php?id=
Hello Everyone,
We installed mysql 5.6.11 from source without server, and was
wondering what happened to the mysql command?
/usr/local/mysql/bin/
innochecksummysql_waitpid replace resolveip
my_print_defaults perror resolve_stack_dump
Kind Regards,
Nick
Just out of curiosity, is the hardware stationed, or traveling close
to the speed of light (i.e., 18,000 miles per second)? Sorry I could
not help it
N.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Question, is building the source exactly the same as mysql?
Meaning, if I build it with set CMAKE options building mysql, can I
use those exact same options building mariab?
eg:
cmake -DCMAKE_INSTALL_PREFIX=/usr -DINSTALL_INCLUDEDIR=include/mysql
-DINSTALL_LIBDIR=lib/mysql -DMYSQL_USER=mysql
-D
--++
| Variable_name | Value |
+---++
| time_zone | +00:00 |
+---++
SELECT @@global.sql_mode;
+---+
| @@global.sql_mode |
+---+
| |
+---+
Not sure why I am getting this error.
Thanks in Advance,
Nick.
On Wed, Aug 21, 2013 at 10:39 PM, wrote:
> >>>> 2013/08/21 18:03 -0400, Nick Khamis >>>>
> We have the following mysql timetampe field
>
> startdate | timestamp | NO | | -00-00 00:00:00
>
> When trying to insert a long value in th
:)
Nick.
What is the best way to backup your database. Which are the files that
I need to store on a usb disk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
rude awakening. What is an effective easy to
follow protocol for backup and recovery in mysql!
Nick from Toronto
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
I want to install MYSQL from source on Windows.
Now, i have compiler success with Microsoft Visual Studio 2005 and Cmake on
Windows XP.
But nothing happened!!
I have read the "INSTALL-WIN-SOURCE" that is in source, but no use.
So, who can help me what should I do the next step to install MYSQL
hdparm -Tt /dev/sdX ?
Ian Simpson wrote:
That's pretty much what I've been doing to get that the drive is running
at 100% bandwidth.
What I'd like is something that just gives the bandwidth of the device
in terms of Mb/s: you can probably work it out using that iostat
command, seeing how mu
,
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is there an easy way to build MySQL client library, server and start-up script
so that /etc/my.cnf is ignored?
I need to build client and server so that it in no way interacts with the global
system install, and build programs against that client library which also don't
interact with the glob
Hello Jeremy
Thank you for the pointer. After make clean, re-configured, re-compiled then
tried, but /path/to/bin/mysql --help still shows /etc/my.cnf as the default file.
Jeremy Cole wrote:
Hi Nick,
This should do it:
--sysconfdir=DIR read-only single-machine data [PREFIX/etc
looked at using LOCK IN SHARE MODE, but I don't see how to be sure
that a SELECT ... LIMIT... statement will select the same messages as UPDATE... LIMIT... unless I
lock the whole table, which seems needless.
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
tement and that would just slow you down, wouldn't it?
Indeed, which was one reason I went with the HEAP table... which is also a TEMPORARY table so that
two clients can work concurrently.
Thanks.
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
e never been able to see how we can find out which connection has the lock
on a given table. If
that's possible, I'd like to know that, too, so I could at least know how it
got locked in the first
place.
Could a misbehaving client do this in a way that would cause the lock to
persist even
p.productname LIKE '%Apples%')
OR (p.productfamily LIKE '%Apples%')
OR (v.vcategory LIKE '%Apples%')
GROUP BY v.vbusiness
Where am I going wrong? The results aren't random, but I can't see how
they're coming up with what they're coming up with.
TIA,
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks. That was it. I'm glad it was something so simple. Just needed a
careful set of eyes. I was worried my understanding of SQL/JOINs was
screwy.
Thanks again.
Nick
PS I'll read up on the FULLTEXT matching. I don't know it well.
>> $query = "SELECT v.vbus
were on 4.0.18).
I see some changes to datetime handling in the 4.1.x releases, but
nothing that seems immediately obvious.
I hope to fix this is by re-building MySQLdb based on the 4.1.10
libraries. Any other suggestions? I'm using MySQLdb.times to format
the datetimes before inserting.
able4.something
AND
table1.something LIKE table5.something
AND
table1.something LIKE table6.something
;
----( Nick Pasich )
On Mon, Apr 25, 2005 at 12:51:53AM +0200, Schalk Neethling wrote:
> Greetings everyone.
>
> Hope someone can give me some
rd to
track down at first because the manually compiled version of MySQL didn't
give me near the details the binary version did.
Thanks!
nickg
-Original Message-
From: Jeremy Zawodny [mailto:]
Sent: Wednesday, February 11, 2004 12:55 AM
To: Nick
Cc: [EMAIL PROTECTED]
Subject: Re: F
nserting quite a few at a time, you might disable indexing, do
the inserts, then allow the indexing to happen all at once. For a large
number of inserts, you might also try writing them to a file, then loading
it. That's much faster for really large numbers of inserts, and you can
also suspend indexing as I mentioned. I use the latter for building
externally generated text indexes (frequency tables and such), generating a
couple of million records at a shot. It made an enormous difference. But
I'm working in Python and can't help you with the C API, as I said.
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ing INTs to STRINGs with
that last bit, in which case you'd want to change the column type for
pricelevel or put quotes around the numbers in the query? I hit that
problem all the time using 1 and 0 as Booleans in an ENUM column.
Nick
--
MySQL General Mailing List
For list archives: http:/
lumn (int has
> support for
> up to 2.1 Billion records wheras mediumint is up to 8.3 million - more
> efficient for your data type).
If he only has a few million records, why would this be more efficient?
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
o insert fewer
records at once or increase MAX_ALLOWED_PACKET, if I recall the correct
variable.
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
hole bunch of fields
and don't really want to go down the route on all of the fields. But if
I have to I will.
Thanks for the advice!
-Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks for pointing that one out. Unfortunately relplace(table.*, ...)
does not work (syntax error) so I'll stil have to go through each field
individually. This will be two statements per-field which kinda stinks,
but oh well.
Thanks again!
-Nick
On Mon, 2003-06-23 at 11:10, Mike Hillyer
reate the mySQL user on Mac OS X?
2. How can I delete all that stuff about root users and start anew?
3. What can I do about the socket error?
#3 may not be an issue once I fix the others.
Please consider helping a poor guy out.
Thanks,
Nick Boudreau
--
MySQL General Mailing List
For list archives
mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: Cannot continue operation.
030709 12:53:27 mysqld ended
Anyone know what could be causing this? I'm baffled.
Thanks,
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysq
Yep, that was it, along with what Mark said.
On Wednesday, Jul 9, 2003, at 15:10 US/Central, gerald_clark wrote:
Nick Boudreau wrote:
Trying to start mysqld for the first time after a reinstall on Mac OS
X gives me this error:
030709 12:53:26 mysqld started
030709 12:53:27 InnoDB
not set right. Any help would be greatly
appreciated.
Nick
Oh, and I can not find ANY log files anywhere (/var/lib or
/usr/local/mysql/data).
Here are some messages:
[EMAIL PROTECTED] mysql]# pwd
/usr/local/mysql
[EMAIL PROTECTED] mysql]# bin/safe_mysqld --console
Starting mysqld daemon with
ght near the beginning of the HTML, where it has lots of (annoying, I
suppose) backslashes, quotes and other stuff that is a pain to encode
properly by hand.
Any help will be most gratefully accepted. My hair will thank you, too.
Nick
--
Nick Arnett
Phone/fax: (408) 904-7198
[EMAIL PROTE
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 17, 2003 9:38 PM
> To: Nick Arnett; [EMAIL PROTECTED]
Well, Paul, just knowing you were on the job inspired me and I finally
realized the dumb thing I'd done. The list I'm
e future?
Thanks for any info...
--
Nick Arnett
Phone/fax: (408) 904-7198
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
n to find out who uses a
given application, the query would be along these lines (this uses the
column 'app_id' as the key:
SELECT used_by FROM nms_apps, user WHERE nms_apps.app_id = user.app_id AND
app_name = "Application Foo"
Hope that helps. If you grasp this, you'll
ere was a bug that it was specified as a
> NO_ARG parameter.
I noticed some of your other messages about that. It's probably time for me
to update.
Thanks very much. I really appreciate the speed with which you respond (not
just to my messages, I read the list regularly).
Nick
--
MySQL
no longer a
transaction.
The culprit was some table locking that improved performance quite a bit
when the tables were MyISAM. Gotta go look for more of those lurking in the
corners, I guess.
--
Nick Arnett
Phone/fax: (408) 904-7198
[EMAIL PROTECTED]
> -Original Message-
> Fr
data
chgrp -R mysql data
in the mysql directory. Obviously you need to have a mysql user, and
this lets that user, and only that user write to the data directory, or
even enter it for that matter (besides root of course).
HTH!
-Nick
On Wed, 2003-07-30 at 01:19, Peter Bradley wrote:
> Hi Sa
I know the replication method is different in MySQL 4.0 then MySQL
3.23.x, but I have a bug that causes problems. The following query will
cause MySQL's logic to not properly read any of the following my.cnf
commands on slave servers:
replicate-wild-do-table
replicate-wild-ignore-table
replicate-
> Hello,
>
> I have aproximately 1,000,000 rows and I would like to do some query.
> The first one is to get the number of row so I do :
>
> mysql> SELECT COUNT(*) FROM `Log`;
> +--+
> | COUNT(*) |
> +--+
> | 969129 |
> +--+
> 1 row in set (0.00 sec)
MyISAM tables keep
since
it will have copied them to the same table, then delete them.
I can do it the way above, but I'm thinking there might be a better way...
Thanks!
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
OMMIT off and COMMIT when appropriate?
Thanks!
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
27;s what I was just reading!
So... is this the equivalent of using BEGIN and COMMIT, for which I have
methods in the Python MySQLdb module? Or is there an advantage to the
latter?
Thanks again,
Nick Arnett
Director of Business Intelligence Services
Liveworld Inc.
--
MySQL General Mailing List
Fo
Dathan Pattishall wrote:
Use char
And use fixed-length types for *all* columns... one variable-length
column makes all records variable-length.
Nick
-Original Message-
From: Marc Michalowski [mailto:[EMAIL PROTECTED]
Sent: Friday, January 28, 2005 10:28 AM
To: mysql@lists.mysql.com
ull-text engine when a record is added or modified, and the
pointer for deletes.
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ry_key
and if I do the equivalent SELECT:
EXPLAIN SELECT * FROM a, b WHERE a.primary_key = b.primary_key
it shows that it's doing a table scan on table b.
Is this normal? Is it because primary keys are unique? I had imagined
that this would be a very fast operation, but it's not, it&#x
x27;ll be interested!
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ches
that work for it do apply... but unless interoperability matters, it's
hard for me to imagine a good reason to bother with XML.
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 - 100 of 312 matches
Mail list logo
