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
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
: 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, 200
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
ldingName',
AgencyInfo.agencyid, BuildingInfo.buildingid FROM BuildingInfo INNER
JOIN 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
Prairi
several
selects (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
ead
Just need to make sure the user has read access to the selected 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
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]
>
Votes
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
2 in each section (just not
in the same row) I need 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
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
---
** 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 ma
red on and handled through one server, in a MySQL
database. I can search the heck out of it, and needless to say,
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
ored Procedures 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]>**
** ORIG
nes into each location working, because 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
.* 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
an add Crystal
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: Monda
ports, 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?
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
Seattl
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
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 yo
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:
http://www.mysql.com/manual
22 matches
Mail list logo
