On 6/1/06, Colin Charles <[EMAIL PROTECTED]> wrote:
Deniz Ersoz wrote:
>
> Is there a way to get the time spent in the server for each query? Write it
> in a log or append it to the result ???
Will what is in the slow query log help?
See the following:
http://dev.mysql.com/doc/refman/5.0/en/sl
online. I know it's
possible to go the other way, authenticate services off of a MySQL backend,
so I guess I'm looking to go the opposite direction. Any thoughts anybody
has would be much appreciated. Thanks.
-Kyle
On 1/4/06, Tripp Bishop <[EMAIL PROTECTED]> wrote:
>
> We did recently upgrade the server from 4.0.40 to
> 5.0.15 and we did not dump the tables and reimport
> them. On the MAC we did do a dump and reimport. I
> wonder if that could be the cause of this problem. I
> had forgetten about that importa
On 11/16/05, Scott Haneda <[EMAIL PROTECTED]> wrote:
> Sometimes I paste in something in mysql CLI and it just does this:
>"> WHERE products.ship_status != 1
> "> );
> "> /c
> "> \c
> "> \c;
> ">
>
> I tried all the \c commands and nothing will get me out of it, I can
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:
>
> Mysql>show tables;
>
> The resu
On Thu, 23 Sep 2004 17:20:17 -0700, Kyle Kirkland <[EMAIL PROTECTED]> wrote:
>
> Any chance 'IF EXISTS' being added to the 'ALTER TABLE' statements?
> It sure would be nice to execute something like:
>
> ALTER TABLE tmp ADD INDEX joy ( to, the, world
At 4:00 7/27/04, Paul DuBois wrote:
>
>At 16:22 -0500 7/26/04, Ghate, Shishir wrote:
>>I looked at the SHOW COLUMNS statement and they have what I want,
>>but I need to condition off them. For example, I don't want to
>>execute an ALTER TABLE command to add a column if that column is
>>already
I want to take 1 field in a mysql table and use that
information to populate an html form select field
instead of writing the html code, that way when data
changes in that mysql field the form will always be in
sync with the table?
--
MySQL General Mailing List
For list archives: http://lists.mys
http://www.geocrawler.com/archives/3/8/2002/11/50/10245455/
Kyle
- Original Message -
From: "Jeffrey Horner" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 29, 2004 12:05 PM
Subject: Creating index on very large table
> Hi folks,
>
>
about an
hour or so.
You need the processlist to show "repair by sort" not "repair with
keycache".
I'm not an expert - but this worked for me.
Kyle Renfro
[EMAIL PROTECTED]
- Original Message -
From: "Jeffrey Horner" <[EMAIL PROTECTED]>
To: &
On Sat, 2004-03-27 at 13:59, Dan Nelson wrote:
> In the last episode (Mar 26), Kyle Renfro said:
> > I am testing MySQL as a possible replacement for our proprietary db
> > server for several large databases. I really want MySQL but I am
> > getting what seems l
I am testing MySQL as a possible replacement for our proprietary db
server for several large databases. I really want MySQL but I am
getting what seems like slow search times.
Does 6.5 seconds seem slow/typical/fast for the following search?
SELECT main.ownername FROM main, rolledplate WHERE r
ss, writing
the data to disk, that is skipped.
If you have any questions regarding this process, please feel free to
contact me.
Kyle
***
Kyle J. MunnEmail: [EMAIL PROTECTED]
EraGen Biosciences
ost. (this when i press backspace, so i understand you
don't do that in telnet...)
i guess it is getting to mySQL, cuz the 4.0.13 at the beginning is my
version of mySQL
----
i'll paste my my.ini (which is in c:\windows)
thanks so much,
\Kyle, who has been frustrated for a while
Or alternatively, (as I read it), use a char(0). Poss. Values NULL or ''
(empty string).
Kyle
-Original Message-
From: Becoming Digital [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 11:04 AM
To: [EMAIL PROTECTED]
Subject: Re: general questions
Actually, the idea
As I understand it,
You're actually better off, if not HAVE TO, just putting the 3.0.6 connector jar file
into your /common/lib directory in order for Tomcat to be able to see
it.
K
-Original Message-
From: Todd O'Bryan [mailto:[EMAIL PROTECTED]
Sent: Saturday, 5 April 2003 19:44
To
I think you probably need to do one of the following;
Insert into info set referer = ?
Or
Insert into info (referer) values (?)
But I could be wrong.
-Original Message-
From: jsp [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 25 March 2003 07:17
To: 'Tomcat Users List'
Cc: [EMAIL PROTECT
--Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]
Sent: Friday, 14 March 2003 16:48
To: [EMAIL PROTECTED]
Cc: Kyle Lange
Subject: Re: How to implement this query - can you help pls?
* Kyle Lange
> Try as I might, I can't seem to work out the SQL for this query. Can
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]
Sent: Friday, 14 March 2003 16:48
To: [EMAIL PROTECTED]
Cc: Kyle Lange
Subject: Re: How to implement this query - can you help pls?
* Kyle Lange
> Try as I might, I can't seem to work out the SQL for this qu
Sorry people. I switched the receipt off originally, but the filter on
the server sent it back and I just replied forgetting the receipt 2nd
time round.
Apologies.
Kyle
-Original Message-
From: Kyle Lange [mailto:[EMAIL PROTECTED]
Sent: Friday, 14 March 2003 15:46
To: [EMAIL PROTECTED
een. I
think I need to INNER JOIN to the intersection table, but how to then
add the joins to the other relevant tables.
Can you help please?
Thanks in advance.
Kyle
-
Before posting, please check:
http://www.mysql.com/ma
That makes sense.
Thank you Tore.
Kyle
-Original Message-
From: Tore Bostrup [mailto:[EMAIL PROTECTED]]
Sent: Friday, 21 February 2003 01:12
To: Kyle Lange; [EMAIL PROTECTED]
Subject: Re: INSERT ... SELECT - A slightly different question
The typical syntax for this would be:
INSERT
Hi all,
I'm trying to load a 1:M table with rows. I've been thru the manual
and discussion list and each comes close but not quite. I'm trying to
load a full table with 4 cols, but one of them needs to be a key to
another table SELECTed enroute. 'LAST_INSERT_ID()' doesn't help because
the main ta
Maybe you should be a poet, lol
- Original Message -
From: "Jim Bailey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 20, 2002 7:00 AM
Subject: Constraint Hell
> sql, Query
> Hark ye experts!
>
> Here I stand an expert grunt.
> Trying to understand,
> The syntax of co
, I
would like a function that only loads a portion of the text object from the
hard drive.
- Original Message -
From: "Kyle W. Kelly" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, July 16, 2002 8:30 PM
Subject: Re: Beginner'
. Thanks
for the additional help.
- Original Message -
From: "Matthew Scarrow" <[EMAIL PROTECTED]>
To: "Kyle W. Kelly" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, July 16, 2002 8:26 PM
Subject: RE: Beginner's question
> To return the f
s, could I just return the first 500 bytes of a text value?
- Original Message -
From: "Matthew Scarrow" <[EMAIL PROTECTED]>
To: "Kyle and Beth Kelly" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, July 16, 2002 9:14 AM
Subject: RE: Beginne
I am writting a search engine using Mysql. I am trying to return a text
object value ( which contains all of the html), but it is taking about 10
seconds to return each text value matching my query. Is there any way that
a text value can be optimized?
www.cs.uno.edu/~kkelly
--
I am reposting this because it got sent right at the start of all the fun
with the mailing list.
Best,
Kyle
-
I have a series of data in one table that I need to put into a set of ranges.
Here is a simplified version of the tables:
data table fields (data):
val
and not equal tend to cause table scans, but between seems to
work with very different queries. Should I restructure the query somehow?
Any help from the guru's is appreciated.
Best,
Kyle
-
Before posting, please check:
ones back to the old names.
Of course, this will work better if you have MySQL down at the time :-)
It is also possible that the table size has been set when you created the
tables. Look up MAX_ROWS (MAXROWS?) in the online manual.
Best,
Kyle
--
Quicknet's MicroTelco fax and voice se
error already occurded? I just joined this list
There was just a thread on this topic. See the archives for the
thread with the title "Problem with where clause" on the 1st of
February.
At the bottom of each e-mail on the list is a set of useful URLs
to things like the archives.
at(num1,2)=format(12.3,2)
...
the above tells MySQL to compare the two strings that result when
you format the numbers to two decimal places. Those strings should
match.
Best,
Kyle
--
Quicknet's MicroTelco fax and voice service has just added
another carrier giving MicroTelco users more lo
ySQL, I am amazed that it was able to run with any speed at
all. What it looks like is that you allocated your 2G of memory and then
wandered quickly into the weeds.
Swap != RAM.
Best,
Kyle
On Friday 18 January 2002 07:37, Franklin, Kevin wrote:
[snip]
> The behavior suggests that we are running
number so high that the ID was outside the range of 2^32, we got garbage
:-(
Best,
Kyle
--
Cut costs, Fax smart. Use iPrint2Fax worldwide and save!
- iPrint2Fax software is FREE, no fax modem required.
- FREE iPrint2Fax to a single email address.
- iPrint2Fax to PSTN based Fax (Up to 95% Savings)
On Saturday 12 January 2002 20:53, Jeremy Zawodny wrote:
> On Fri, Jan 11, 2002 at 08:08:51AM -0800, Kyle Hayes wrote:
> > We write our own replication system using our own checkpointing and
> > code. We start with the update logs (we're not happy about the
> > future
d.
- we can do SQL rewriting if we really need to.
These problems led us to write our own replication. If you have the
luxury of redesigning your database or of designing with MySQL's native
replication in mind (we did not), then I would use the native version.
Best,
Kyle
--
Comments inline below.
On Wednesday 09 January 2002 18:13, Paul DuBois wrote:
> At 17:23 -0800 1/9/02, Kyle Hayes wrote:
[snipped replication explanation]
> >The program works by getting the contents of the update log and using
> > the Perl DBI do() function on each statement.
>
.
Anyone have an idea? I haven't found anything particularly relevent in
the mailing list archives.
Best,
Kyle
--
Cut costs, Fax smart. Use iPrint2Fax worldwide and save!
- iPrint2Fax software is FREE, no fax modem required.
- FREE iPrint2Fax to a single email address.
- iPrint2Fax to PS
?2) Should I be
> able to properly control two servers using the two safe_mysqld command
> lines above?
We do it all the time. Just make sure that your sockets are differentiated and
that you are using a FQDN if you are trying to connect via IP instead of
a Unix socket.
Best,
Kyle
bot fodder
On Wednesday 31 October 2001 20:06, you wrote:
> On Wed, Oct 31, 2001 at 07:30:12AM -0800, Kyle Hayes wrote:
> > Has anyone used LVM to create snapshots on a master in order to set
> > up replication? We have specialized scripts that are getting harder
> > and harder to main
apshot partition with the main partition
after the snapshot is deleted? What kind of disk slowdown do you
see?
Best,
Kyle
bot fodder: mysql, database, sql
--
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
MicroTelco Services saves money on every Fax:
- Fax to email (FREE)
- Fax to
sure it needs to be "random"? By definition, if it is unique, it
can't be totally random since a random number would have a certain
probability of being the same value twice after a certain number of samples.
Is there a simple SQL statement that will do what you
=2500M
?? Not sure about this one. Check the manual.
> set-variable= thread_cache=8
Best,
Kyle
--
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
MicroTelco Services saves money on every Fax:
- Fax to email (FREE)
- Fax to PSTN based Fax (Up to 95% Savings)
- Fax Broadcasting: Send 1
idered before.
I'd be worried about maintaining the strict "completely new INSERTs only"
policy over time. If you are running stock or measurement data into it where
it is guaranteed that it is always new INSERTs, you should be OK.
Best,
Kyle
bot fodder: database, query, mysql, lion
ou're right. It does look like this might be his most likely
problem... Sigh.
Best,
Kyle
bot fodder: database, SQL, MySQL, whoop whoop whoop
--
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
MicroTelco Services saves money on every Fax:
- Fax to email (FREE)
- Fax to PSTN ba
uption, it usually appears to be disk errors, disk controller errors or
bad memory (not necessarily in order). Run the memtest86 program that is
floating around out there (SuSE has it as a boot option, don't use Red Hat
anymore so I can't say for it).
Best,
Kyle
P.S. buy support fro
uot;
It is running on port 2201. I cannot telnet to that port
mysql.sock is there
whenever i try to run anything to do with mysqld it gives me the error:
"Segmentation fault (core dumped)"
Any ideas how to get mysql up and running correctly?
Thanks a lot f
= the database and table on which you have these privileges
this could be *.* for everything
WWW is your password, unencrypted.
Note that the hostname must actually match. If the grant was given such that
the FQDN of your host was used inst
have put the my.cnf file in
/etc and /var/lib/mysql "the default location for the data" and tried
different configurations and some will let me connect but they will not let
me look at tables or create new ones.
Thanks Kyle
--
On Thursday 18 October 2001 12:31, Bill Adams wrote:
> Kyle Hayes wrote:
> > > I found yesterday (at the advice of this list) that adding an
> > > occasional call to "FLUSH TABLES" fixed my corruption problems. I
> > > would do that right before the
e disk firmware to
reorder the writes to get better speed. This means that your carefully
flushed data will be written in an order _DIFFERENT_ from what you and the OS
thought it was written in. This can completely screw up filesystems and
definitely could have some "interesting" effe
ur
heads on that one.
We got around this by explicitly doing a
SELECT LAST_INSERT_ID()
after each operation where we needed to know the ID. Ugly, but it worked
every time. It was ... fun ... tracking down all the places we'd used DBI
directly :-(
Best,
Kyle
Bot fodder: mysql, q
able to write our own complex code to do this, but it is far from
the level of automation that we want.
Could someone from the MySQL team please give us some details on subselects
and the new load table functionality?
Best,
Kyle
On Tuesday 25 September 2001 14:29, Fournier Jocelyn [Presence-PC
;
> Selects in the queue for the users table that join to other tables
> (and you have plenty of them) will block updates/inserts to those
> other tables.
It has taken us a while to tune our database to do what the other post above
suggests. This is good advice. It has really made
w what
instance it is. We were having problems with people forgetting which
instance they wanted to bring up or down and taking the wrong one down :-(
The hardcoded scripts stopped that error.
Best,
Kyle
-
Before posting, please
QL. DBJ likes to use his CDB code for a lot
of his projects. Is there a FAQ or page I missed?
If people know of any other such servers, I'd love to know!
Best,
Kyle
-
Before posting, please check:
http://www.mysql.com/
omeone gets root on your machine (assuming it is a Linux
machine), then they'll be able to read the memory in which you application is
running and might be able to see the CC number in that memory before it is
encrypted. However, if you have that problem, this may be the least of your
w
done
atomically. The next statement gets back the ID that was set in the first
one. Notice that the SELECT does not have a FROM clause! The database
handles the value of LAST_INSERT_ID on a connection by connection basis so,
you'll get the right value.
This set of SQL state
MAX(ID) ... as that will not do what you want and you'll
corrupt your own data!
Best,
Kyle
P.S. Spam bot: database, row, query, mysql.
On Saturday 23 June 2001 11:07, xris wrote:
> So if the {mysql_insertid} thing is an issue, is there a fix? Does the
> latest DBD/DBI package fix i
Never mind. This was simply my mistake. mysqld had a different copy of
the table in it's cache, so the problem went away when I restarted the
server process.
Thanks anyway,
Kyle Cronan
<[EMAIL PROTECTED]>
-
Bef
o is that the above warning
seems invalid; SHOW processlist reports no client threads accessing this
table.
Even so, why would this cause the problem running the DELETE query? And
attempting to repair the table with myisamchk gets rid of the above
warning but doesn't fix the problem with the quer
purposes and others
need to stay up. We cannot do this with a single instance. We can also
control resource usage on a per-type-of-use basis. Some instances just
perform dumb data logging, others are used for heavy queries.
Best,
Kyle
---
ght find this link useful, the author chroots a whole web set up with
Apache, mod_perl, etc. It was quite informative. There is a brief section
on MySQL, but he doesn't show how to install it in a chroot dir.
http://penguin.epfl.ch/chroot.html
Best,
Kyle
Andrey:
Check your mysql var directory, that's symptomatic of a misconfigured
mysql daemon.
Look for a file called $hostname.err, read it, and fix what its
complaining about.
-Kyle Rollin
[EMAIL PROTECTED]
On Mon, 14 May 2001, Andrey Nepomnyaschih wrote:
> Hello,
>
> I'v
t the data for
BACKUP, it needs _unix_ write privileges for user mysql (can be group too).
If you are trying to backup a table to a directory in your log-in directory,
you need to make sure that the MySQL daemon has write privileges to the
backup directory.
Best,
Kyle
On Sunday 18 March 2001
safe_mysqld and make sure that it
will correctly pass these parameters through to mysqld. We had to make
changes to get the logs to work the way we wanted them and eventually wrote
our own version. Our version is not publically available, sorry.
Best,
Kyle
On Wednesday 14 March 2001 04:16, B
drivers helps. We have a couple of
systems that run much better when we do not use one of the CPUs.
If e2fsck says the partition is fine, then it might not be this problem.
Best,
Kyle
--
Kyle Hayes
Quicknet Technologies t: +1 415 864 5225
520 Townsend St. Suite D
bits on the floor :-(
If you are running BSD, you might have the same problems. Again, I am not
very knowlegable about BSD.
Best,
Kyle
--
Kyle Hayes
Quicknet Technologies t: +1 415 864 5225
520 Townsend St. Suite D f: +1 415 864 8388
San Francisco, CA 94103 w: http:
This statement:
SELECT Drivers.DriverID, Drivers.FName, Drivers.LName FROM Teams INNER JOIN
TeamDetails ON Teams.TeamID = TeamDetails.TeamID INNER JOIN Drivers ON
TeamDetails.DriverID = Drivers.DriverID WHERE Teams.TeamID = 1
works fine when executing natively in MySQL (MySQL-Front).
But when I
ssues that come up if you
are responsible for leaking them.
Best,
Kyle
--
Kyle Hayes
Quicknet Technologies t: +1 415 864 5225
520 Townsend St. Suite D f: +1 415 864 8388
San Francisco, CA 94103
make sure that you set the sock parameter in both the [client] and [mysqld]
sections of the configuration file. This is one of my favorite errors :-/
Best,
Kyle
On Monday 26 February 2001 12:04, Joel Gwynn wrote:
> I tried /etc/my.cnf and got the same results. As far as $DATADIR or $H
t. Actually, it appears that one of these two pieces
of code (DBI or libmysql) uses a signed 32-bit integer somewhere. Alpha
machines may not be effected by this.
Can someone help on this? I have seen Tim Bunce on the list occassionally...
We are in the process of changing our code over to th
010220 19:27:11 Aborted connection 21199 to db: 'vlndb' user: 'root' (Got
an error reading communication packets))
Has anyone experienced this error in MySQL and do you know what it means?
Kyle Higgins
USCO Logistics
UNIX Manager
Emai
Nevermind. I see that the manual online has this information. Sigh. It
doesn't do what I want unfortunately.
Best,
Kyle
On Monday 29 January 2001 09:32, Kyle Hayes wrote:
> The manual section on BACKUP does not state what locking behavior the
> command has. Does it lock all
this:
RESTORE foo_backup.bar, foo_backup.baz, foo_backup.blah FROM
'/tmp/mysqlbackups/'
???
Best,
Kyle
--
Kyle Hayes
Quicknet Technologies t: +1 415 864 5225
520 Townsend St. Suite D f: +1 415 864 8388
San Francisco, CA 94103 w: ht
lclient_r from
different threads is the most likely cause of the problem. I'm going to
investigate with calling it just once in the original thread and see if
that corrects the problem.
By the way, this is mysql 3.23.28-gamma on a Solaris 8 box using pthreads
in the client lib, serve
ausing my problems? Maybe I
need to only load this module in one thread. Should it make any
difference?
Thanks for all your help.
Kyle
<[EMAIL PROTECTED]>
> 4) I still think it is better to use local static MySQL++ objects then
> global, b
Linux RedHat 6.2 (kernel 2.2.14 SMP)
>
> MySQL version:
> 3.23.32 from binary RPM (MySQL-3.23.30-1.i386.rpm)
>
I don't know that MySQL has that much to do with it in this case.
Best,
Kyle
--
Kyle Hayes
Quicknet Technologies t: +1 415 864 5225
520 Townsen
e any help.
Thank you,
Kyle Cronan
<[EMAIL PROTECTED]>
-- Forwarded message --
Date: Fri, 5 Jan 2001 11:55:44 + (/etc/localtime)
From: Kyle Cronan <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Thread safe client with C api (repost)
Further work has led me to believe
80 matches
Mail list logo
