I had this problem just this morning and wound up fixing it by changing
the innodb data and log file directories to new folders in the .cnf
file. This enabled to server to start up (new data and log files were
created) and I then restored the data from a dump.
Kathy Mazur Worden
-Original
(selected records in a few tables using Query Browser and
refreshed a few web pages hitting the db). None of the queries have the
no cache option specified.
What else would prevent queries from getting into the cache?
Kathy Mazur Worden
Prairie Area Library System
AgencyInfo ON BuildingInfo.agencyid = AgencyInfo.agencyid ORDER BY
AgencyInfo.Name, BuildingInfo.Name;
There are indexes on the id and name related fields used in the WHERE
clauses.
Kathy Mazur Worden
Prairie Area Library System
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED
The output of that query is:
@@global.query_cache_size
10485760
Kathy Mazur Worden
Prairie Area Library System
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 30, 2006 12:42 PM
To: Mazur Worden, Kathy
Cc: mysql@lists.mysql.com
Subject: RE: query
: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 30, 2006 2:12 PM
To: Mazur Worden, Kathy
Cc: mysql@lists.mysql.com
Subject: RE: query cache question
Please show the output of:
SELECT @@global.query_cache_type;
and then:
SHOW GLOBAL STATUS LIKE 'Qc%';
Thanks!
On Wed, 2006-08-30
Actually no, I'm not using any prepared statements. But thanks for the
pointer on that.
-Original Message-
From: Jay Pipes [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 30, 2006 2:24 PM
To: Mazur Worden, Kathy
Cc: mysql@lists.mysql.com
Subject: RE: query cache question
Ah, I think
I've had success using the fully qualified db, table and column name in
a single query like yours below. Have you tried sending strSQLCombo
through either strConnProd or strConnSales already?
K. Mazur Worden
-Original Message-
From: brent [mailto:[EMAIL PROTECTED]
Sent: Monday
tables
on both.
Kathy Mazur Worden
Senior Associate Web Services
Prairie Area Library System
From: brent [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 08, 2006 9:58 AM
To: Mazur Worden, Kathy
Cc: mysql@lists.mysql.com
to sum up that person's votes between the two
columns. I've tried summing two subqueries but it errors out because of
returning two values.
Any other ways to accomplish this?
Kathy Mazur Worden
Prairie Area Library System
Maggie Doe 9
Cynthia Smith 8
Sally Brown 1
Number of votes needs to sum up the number of votes for one person from both
columns.
Does that help?
Kathy Mazur Worden
Prairie Area Library System
From: Peter Brawley [mailto:[EMAIL
Anyone know if there is a way to defeat the new format for the
timestamp that appears in 4.1 alpha?
I upgraded a MySQL install on a development box that holds a copy of
our production data. I quickly saw that the timestamp format was
changed from:
20030520124559 , to:
2003-05-20 12:45:59
For
too:
http://www.mysql.com/events/uc2003/session.html#Session:MySQLStoredPro
cedures
Personally, I am drooling with anticipation for these additions. :-)
Rob Mazur
---
** ORIGINAL MESSAGE FROM:John Griffin [EMAIL PROTECTED]**
** ORIGINAL MESSAGE SENT:Tue Apr
,
access it anywhere. I'm now considering a java GUI app to manage my
mail (access via RMI perhaps), so having it in the database is very
convenient.
I suppose other people have their reasons for storing email in a
databaseanyone?
Rob Mazur
-
--
MySQL General Mailing List
For list archives
---
** ORIGINAL MESSAGE FROM:Jeff Kilpatrick [EMAIL PROTECTED]**
** ORIGINAL MESSAGE SENT:Tue Apr 01 14:38:21 **
** ORIGINAL MESSAGE BELOW **
---
On Wed 1969-12-31 at 17:59 mazur wrote
a power outage (which
has happened, by the way) would break the system. Does anyone want to offer
up a scenario or two of what they have used/seen?
Thanks for any advice.
Rob Mazur
-
Before posting, please check:
http
.* server
just
fine. So I have done nothing with my client. I have not located anything in the mail
archives
with such a problem.
Any ideas on how to get around this problem and get the server upgraded?
Thanks,
Rob Mazur
p.s. I actually have this symptom on two RedHat6.2 machines
, but ported for
Linux. I am suspecting I may be asking for too much at the moment. As far
as I can see, I can not run Crystal on a Linux web server.
So, what are you guys using to generate reports for the exec's such that you
do not need a Windows machine in any part of the equation?
Rob Mazur
Reports.
Any additional dialog from anyone else (you too J.K. :-0 ) would be
appreciated!
Rob Mazur
- Original Message -
From: Joshua J. Kugler [EMAIL PROTECTED]
To: Mazur [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, July 02, 2001 4:31 PM
Subject: Re: Reporting Tool : Linux
I've been looking around for a database modeling tool, ported for Linux.
I have seen in the archives a few suggestions of Windows-based tools,
but has anyone found or used a Linux-compatible database modeling tool?
Thanks,
Rob Mazur
Seattle, WA
I agree. The online manual is wonderful:
http://www.mysql.com/
...and the book by Paul Dubois is fabulous:
http://www.amazon.com/exec/obidos/ASIN/0735709211/o/qid=991937746/sr=2-1/ref=aps_sr_b_1_1/107-9361976-5006147
These two resources will have you up in no time.
A little reading will get
Here's a left-field question:
Does there happen to be a compelling reason for me to look into php when
using a MySQL database rather than my current Java usage.
I know the easy answer would be that if I know java, then stay with
javait's a more versatile language, and so on. But, are there
This has to have been asked before, but I can't find it in the
database archives...
Is there a web browser based version of this mailing list anywhere?
Thanks,
Rob
-
Before posting, please check:
22 matches
Mail list logo