dates. Just by optimizing the queries and the database
tables, we were able to dramatically diminish the load and query times
(nothing in the slow query log with a slow query being >5 seconds)
Hope this helps
Eric Lamendola
Slingo Inc.
At 08:10 AM 10/31/02 -0600, Benji Spencer wrote:
We are experi
Follow up question,
Well what if you have a user that you want to give permission to from any
computer in the domain.
Such as user: mysqluser with READ|SELECT|UPDATE from anywhere
in: mydomain.com
But not from any other domain.
Thanks,
Eric Lamendola
Slingo Inc.
<<<< And
detail as to the status and
response time of the server.
If not - hey what do I know
Eric Lamendola
At 10:26 AM 9/10/02 -0500, mos wrote:
>Eric,
> Isn't letting an outside connection access to your log file a
> "little dangerous"? Why not create a dummy table
Hey,
I thought you could just use
mysqladmin refresh -pPASSWORD -- or
mysqladmin reload -pPASSWORD
To kickstart logging again?
If not - hey, what do I know
Eric Lamendola
At 11:12 AM 9/10/02 +1000, Daniel Kasak wrote:
>Hi all.
>
>I've been using MySQL-4.0.3 (on Slackware-8.0)
ee if it was a fluke the first time.
This would be a little more real time and allows you to set the frequency
in which you want to monitor the server. Plus, you could set the script to
Email you if the server isnt working.
If not - hey what do I know
Eric Lamendola
At 10:04 AM 9/10/02 +010
t taxing the DB more than it can handle.
We simply changed the DB structure to not include so many tables in each
query and change the way in which information was polled.
Hope this gets you in the right direction
Eric Lamendola
Slingo Inc.
PS - Logging ** ALWAYS GOOD ** (Just make sure you
