Hi Everyone,
I have had similar problems in the past, and have managed to usually
stumble my way around them. But now this officially is just not
making any sense... to me at least ;)
Problem: I want to backup a database from server1 and restore it to
server2. The database size is ~10GB,
I would say caching, on multiple levels (CPU, DB, File System). By
splitting at least some of the load, it's possible for parts of the
cache to become old and get flushed. When everything is on one
machine, the box has a complete picture of the traffic patterns and
can optimize better.
This is a good idea. Thanks.
This e-mail, including any attachments, may be confidential, privileged or
otherwise legally protected. It is intended only for the addressee. If you
received this e-mail in error or from someone who was not
A good article on crosstab queries in MySQL is located at:
http://dev.mysql.com/tech-resources/articles/wizard/print_version.html
A method of making a stored procedure based on the above article is hosted
at:
http://www.futhark.ch/mysql/106.html
If you replace the 'sum' function with 'max' you c
Hi,
Weston, Craig (OFT) wrote:
In Access, designing a "crosstab" query is fairly straight forward. You
just choose "crosstab" in the query design form. Is there some simple
way to replicate this functionality within mysql?
The simplest way -- if you're used to Access -- is probably to use Acce
In Access, designing a "crosstab" query is fairly straight forward. You
just choose "crosstab" in the query design form. Is there some simple
way to replicate this functionality within mysql?
Thanks,
Craig
This e-mail, including any atta
Hello,
I have a problem that came up when upgrading my server from version 5.1.7 to
5.1.17. When trying to connect to the databases on my server via the "MySQL
Manager" tool, I get the following error:
"ERROR 1568 (HY000): Cannot proceed because the tables used by events were
found damaged a
Hi all,
First of all, sorry for the lengthy subject, but it serves to describe
my problem:
I'm having problems entering Portuguese accented characters (with a
Portuguese keyboard) in "MySQL monitor" (MySQL command line / console
client), when I'm in a SSH (Secure Shell) Session, in a Linux Server
It might have been a dumb question, but I really wasn't sure where to start.
Union does exactly what I need! Thanks a bunch.
Thanks,
David Ruggles
CCNA MCSE (NT) CNA A+
Network EngineerSafe Data, Inc.
(910) 285-7200 [EMAIL PROTECTED]
-Original Message-
From: Wm Mussatto [mailt
> I want to find the value 123 in the field "id" in any one of these
tables.
SELECT id FROM TableA WHERE id = 123
UNION
SELECT id FROM TableB WHERE id = 123
UNION
SELECT id FROM TableC WHERE id = 123
Please note that UNION requires that the same number (and type?) of
fields be selected from each
On Tue, July 31, 2007 8:52, David Ruggles said:
> I need to find a userid across several different tables.
>
> What is the best way to do this?
>
> For example I have three tables
> TableA
> TableB
> TableC
>
> They all have a field "id"
>
> I want to find the value 123 in the field "id" in any one
I need to find a userid across several different tables.
What is the best way to do this?
For example I have three tables
TableA
TableB
TableC
They all have a field "id"
I want to find the value 123 in the field "id" in any one of these tables.
Thanks,
David Ruggles
CCNA MCSE (NT) CNA A+
Netw
Hi there,
I am trying to compute "cycle time" between two dates in mysql. This is
a measurement of business hours between two datetimes, in hours. In
Excel, I can use the "networkdays" function to get partway there. What
I am trying to calculate is:
# hours between start time and resolved time,
> >> LOL - an entertaining read!
> >>
> >
> > Entertaining? I feel to see the humor in his post.
> >
> >
> I thought it was concise and well written, with an undertone of "I know
> I'm swearing in church but...". So yes, I found it entertaining (I agree
> that it was not necessarily humorous or fun
A puzzler for you guys.. all plausible explanations (and suggestions
for proving them) gratefully received.
We run several MySQL database servers in the traditional master-slave
configuration and attempt (rather poorly) to spread select queries
between them. Normally the slave gets 1/3 o
Hi,
I have a slave (version 5.0.26) replicating from master (version 4.1.13).
The slave's /etc/my.cnf contains the following (just once!):
# what we should replicate
replicate-do-db = bge
replicate-do-db = blog
replicate-do-db = lawlist
replicate-do-db = library
replicate-do-db = mandate
replic
Unfortunately I tried to change one of the tables in InnoDB, but the inserts
in that table continue to be slower than in the MyISAM table.
(From the MyISAM table no program is searching for data).
Octavian
- Original Message -
From: "Brent Baisley" <[EMAIL PROTECTED]>
To: "Octavian Ra
17 matches
Mail list logo
