ormation in a table
> might want that?
>
> Keith Murphy
> http://www.paragon-cs.com
>
> --
>
> (c) 850-637-3877
>
> On Tue, Sep 17, 2013 at 10:19 AM, Wayne Leutwyler
> wrote:
> Hello List,
>
> I have a customer who is wanting to use the Archive Engin
Hello List,
I have a customer who is wanting to use the Archive Engine. I have no
experience with this engine, other than what I am been reading. Why would I
want to use Archive over InnoDB. They are only going to be placing audit
information in the table.
Walter "Wayne" Leutwyle
write debug information
to the mysqld.log file? Could a client tool do something like this? We have
reviewed the app privileges and the they have no ability to write debug info.
Thank you,
Walter "Wayne" Leutwyler, RHCT
Sr. MySQL Database Administrator
Mobile: 614 519 5672
Office: 614
for user 'root'@'localhost' (using password: NO)'
Do I have a msyql/php version mismatch? I have tried a number of potential
remedies I found on line but have been unsuccessful to this point. Guidance
from experts would be much appreciated.
Wayne Leslie
Hello All,
Question. In mysql 5.5 what are the defaults for these values:
max_connections = ? (is this set to 151 in 5,5)
max_user_connections = ?(is this set to unlimited unless you provide
the exact number)?
Thank you so much.
Wayne Leutwyler, RHCT
Open Source + Open
Hi,
I asked this question over on stackoverflow - basically I have a query
and when using EXPLAIN I see that around 2400 rows are still being
scanned. I'd added various indexes but it cannot make it perform any
better.
I would appreciate if anyone has any further ideas?
http://stackoverflow.com/
when I start mysql 5.1.30 up it fails to startup,the error info is:
*[ERROR] Error message file '/usr/local/mysql/share/english/errmsg.sys' had
only 617 error messages,
but it should contain at least 619 error messages.
Check that the above file is the right version for this program!*
I setup mys
for example,one user has the 'select' right on talbe 'test'(innodb,million
records),however,he sometimes execute query like 'select * from test'.That
will slow down the whole database.
Is there a way to disable some queries for some users? Or,mysql's authority
can be more detailed?
thx
mikael
thank you very kindly; that did the trick.
On Saturday 09 April 2005 16:49, Mikael Fridh pronounced:
> Allen Wayne Best wrote:
> >hello;
> >
> >I am having a spot of trouble getting to MySQL to start. Here is the
> > message:
> >
> >050407 22:43:49
le had been corrupted. No change. (I put the original
one back.)
So, I am stumped. Any suggestions are greatly appreciated.
--
regards,
allen wayne best, esq
"your friendly neighborhood rambler owner"
"my rambler will go from 0 to 105"
Current date: 8:6:16::98:2005
The real re
and
mod_mod_calendar_events which is new. How can I combine the the old
into the new? I read about union but dont know how to do the query.
What would I write to do this?
Regards, Wayne in Japan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
How would one join multiple table and selected all
records from a joined table whether they exist OR not?
I can get the records if they exist in a second table
and I can get the records if they don't exist, but is
there a way to combine the two?
I have, for example, a statement like this (selects
64 64
max_connections 100 50
open_files_limit na 0Can this be set for hpux
10.20? Documentation indicates 0 for some systems, but which ones?
Are there any other variables I need to be aware of and set properly?
Thanks in advance
Wayne
Hi All,
silly question... does anyone know how to search for '%'? i.e.
overriding the normal wildcard use
Wayne
Wayne
[EMAIL PROTECTED]
http://www.Micromouse.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.
Have you tried it without it? I cannot seen a reason for using it...
With out it all records in subscriptions will be updated with pick+1
where username='webmaster' and dbname.....
Wayne
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 23 June 200
I had someything similar It was all down to permissions...make sure
that the permissions on the sql dbfolder allow the sql demon access. And
you have run the install_db script to create it in the first place
Wayne
-Original Message-
From: Jason Steig [mailto:[EMAIL PROTECTED]]
Sent
n index but you can figure out the difference for
tablescans (consider how many rows fit into a page) and range scans
(consider the affect of the primary key as a cluster index).
-Wayne
-Original Message-
I am not sure. Does anyone know any real examples of
mysql handling huge database
ox->Show ;
}
-- end ---
with this message:
An error occurred during a rollback operation
DBI::db=HASH(0x851f8c4)->errstr
does mysql not support rollback (documentation indicates that it does!) or is
there something obvious that i am missing???
any assist is greatly
n" ) ;
}
i get this message:
mysql://webuser@localhost/doug
DB Error: no such database
any suggestions would be greatly appreciated.
--
regards,
allen wayne best, esq
"your friendly neighborhood rambler owner"
"my rambler will go from 0 to 105"
Current date: 8:2:21::275:20
Hi All,
First thanks to all who worked on InnoDB, it is truely exciting to get its
features in an open-source DB. We've had an excellent experience thus far
with a few exceptions. Any help on solving the problem below is greatly
appreciated ...
We experienced a hard lockup a few days ago with my
we are running MySQL w/php. When trying to connect to the database via mysqlGUI from
a win200o workstation, we get the following error:
access denied for user: 'root@ipaddress' (Using password: Yes)
-
Before posting, pleas
definition.
Wayne
Wayne O. CorelliWayne.Corelli <[EMAIL PROTECTED]>
Compaq <http://www.testdrive.compaq.com/>
MRO1-3/F1 508-467-4138 (OFFICE)
200 Forest Street 508-467-1468 (fax)
Marlborough, MA 01752 Em
One of the best Windows clients for editing queries is
urSQL
(http://www.urbanresearch.com/software/utils/urbsql/urquery.php)
--- Sander Pilon <[EMAIL PROTECTED]> wrote:
>
> But... there are numerous mysql clients available,
> also for windows. I
> bet you can find one with fine edit capabilities
Hi,
Is their any way to have multiple masters for one slave?
The purpose of this is to backup multiple databases to one server
easily, if their is no way to do this with replication are their any
other methods of remote backup?
Thanks
Wayne
> --
> From: Entryon Corp., Chief Technical Officer - P.
> Hasenfratz[SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, February 15, 2001 12:13 PM
> To: mysql EN
> Subject: user variables length
>
> How many Bytes can I save in a user variable?
>
> Because I have the fol
ind file:
'./mysql/host.frm' (errno: 13)
010128 20:09:46 mysqld ended
The path to host.frm is:
/var/lib/mysql/mysql/host.frm
>How-To-Repeat:
run safe_mysqld
>Fix:
Get it to point to the right place, but I have not been able to
>Submitter-Id: Wayne Renshaw
>
the
benefits as well as the detractions that we can use to physically show a
client. I would appreciate any help.
thanks,
wayne
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
27 matches
Mail list logo
