Setting up a basic monitoring system can be used to alert for certain
thresholds, like 95% full volumes for example. WIth some simple shell
scripting it can alert for InnoDB tablespace getting full as well.
Examples of monitoring systems: Nagios (Freeware), Argus (Freeware), HP
Openview (Lots of m
Should be almost instantaneous. Do a show slave status on the
slavealso check the error log.
Jesse wrote:
I'm playing with setting up replication on two MySQL Servers that I
have set up here. I set it up according to the instructions found on
the MySQL web site, then I went in on the ma
I'm playing with setting up replication on two MySQL Servers that I have set
up here. I set it up according to the instructions found on the MySQL web
site, then I went in on the master and added a new record to one of the
tables, then checked the slave about 30 minutes later, and the record ha
I shut down a database using:
mysqladmin -uroot -pxxx shutdown
and the db shutdown as expected. But then it restarted! My only guess
is that mysqlmanager can't tell the difference between a clean shutdown
and a crash.
Maybe this is expected? But then what good is the shutdown command
availabl
You will not be able to search on encrypted fields.
Sure you can. MySQL will also be able to use the index provided you are
using an "=" when searching. But you can't use ">" or "<" on an encrypted
field and still expect it to use an index.
I've found talking to MySQL developers about the
OK, I think we've solved this one.
Procedure:
> [EMAIL PROTECTED] ~]# urpme MySQL-client MySQL MySQL-common
> [EMAIL PROTECTED] ~]# mv /var/lib/mysql /var/lib/mysql.old
> [EMAIL PROTECTED] ~]# urpmi MySQL-client-5.0.27-3mdv2007.1
> MySQL-5.0.27-3mdv2007.1 MySQL-common-5.0.27-3mdv2007.1
This ser
I'd second the Rosicrucian Egyptian Museum:
http://www.egyptianmuseum.org/
Also the Computer History Museum (located in the former SGI
International Sales Office, I believe) is HIGHLY recommended by
me...one of the docents there the last time I visited was Gene
Amdahl! They have a working
I think in the software world pretty much anything can be done,
not 100% to the specs but using the 'for all practical purposes'
criteria.
it's a matter of the cost but the PHP + mysql combination
certainly can't protect the datamodel because most of it
can be hacked from the data files themselves
> You will not be able to search on encrypted fields.
Right. There are ways around it but obviously all sorts of subtle
application work will go with the data, depending
on what exactly is that you are trying to protect.
Overall my opinion is that if you distribute it in a country where
softwa
[EMAIL PROTECTED] wrote in news:[EMAIL PROTECTED]
R04.sysops.aol.com:
> Something like distributing files with encrypted data in most columns
> can be done
I think the OP is more concerned with protecting his datamodel, and this
cannot be done in my opinion.
--
felix
--
MySQL General Mailing
[EMAIL PROTECTED] wrote:
Something like distributing files with encrypted data in most columns
can be done, with the encryption key being a combination
of some hardware-related stuff such as MAC address that the user will
provide to you, and the key you generate and provide to the user.
Of course
Something like distributing files with encrypted data in most columns
can be done, with the encryption key being a combination
of some hardware-related stuff such as MAC address that the user will
provide to you, and the key you generate and provide to the user.
Of course it creates a problem when
> [EMAIL PROTECTED] jim]# mysqladmin -u [EMAIL PROTECTED] password new_password
> mysqladmin: Can't turn off logging; error: 'Access denied; you need the SUPER
> privilege for this operation'
HUH? What's wrong? :
> [EMAIL PROTECTED] jim]# mysql -u [EMAIL PROTECTED]
> Welcome to the MySQL mon
If you are into ancient Egypt, check out the Rosicrucian museum in San Jose.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: Eric Braswell [mailto:[EMAIL PROTECTED]
> Sent: Tu
Hi Ed,
the subject line of your message indicates you live in California
in which case Santa Clara won't add much to the experience,
but most other people could enjoy visiting California a lot
especially if they don't mind dedicating entire day driving to Sierra
Nevada.
One off the beaten path
You're left joining invoices, then left joining receipts. A left join will replicate rows on the left side to match the number of
rows it found in the join, or just leave 1 row with NULL values (as you probably know). This is where your problem is. You were
correct to try to use left joins becaus
Hi,
> The error I get while trying executing is "Unknown column
> 'products.product_id' in 'on clause'. Since I am selecting all
> columns from that table (products), I can't really see why there's a
> fuss about it!
# SELECT products.*, manufactors.*,
# IF((
# SELECT i.supplier_id FROM pro
Hi Kim,
Kim Christensen wrote:
The error I get while trying executing is "Unknown column
'products.product_id' in 'on clause'. Since I am selecting all
columns from that table (products), I can't really see why there's a
fuss about it!
I'm thankful for every tip I can get, and please let me kno
Hey list,
I've been tinkering with a query the past few hours, and it's about to
drive me coconuts. It's using quite a few (messy) control statements, so
I guess I'm staring myself blind trying to solve it.
Could be a combination of that, and too much coffee.
Anyway, here's the query:
http://p
Thank you everybody for your replies. Seems like I got an answer as no.
Thank you again,
Suhas
On 1/30/07, Dotan Cohen <[EMAIL PROTECTED]> wrote:
On 30/01/07, peter lovatt <[EMAIL PROTECTED]> wrote:
> Hi
>
> You probably cant make it 100% secure, because php is not a fully
compiled
> language
On 30/01/07, peter lovatt <[EMAIL PROTECTED]> wrote:
Hi
You probably cant make it 100% secure, because php is not a fully compiled
language, and as such an expert techie could probably add extra code to your
app that wouild allow access to the database, BUT you can get pretty close.
You will ne
I'm missing something really silly in a query.
I want to produce a list of accounts, the invoices and receipts and the
balance against them.
Simply, there is an accounts table, invoices and receipts.
I want to show the account details, sum(invoices), sum(receipts) and the
balance. There is a sit
On a different note just running a slave will not help when there is some
accidental deletion of data or tables or databases. Hence have a slave as
Mikhail mentioned and also run regular backups on the slave. Preferably a
tar of your mysql server after shutting it down, also ensure you have
log-bi
Hi Manuel,
Manuel Vacelet wrote:
I have query that joins 2 tables. I have an index on each part of the
join but unfortunately the 2 columns don't have the same type so the
index is not used for the join (I guess it's the reason why). On one
hand I have an INT and on the other and a VARCHAR.
This
Hi all,
I have query that joins 2 tables. I have an index on each part of the
join but unfortunately the 2 columns don't have the same type so the
index is not used for the join (I guess it's the reason why). On one
hand I have an INT and on the other and a VARCHAR.
Is there any way to write the
Hello All
While my mysql code was running, the disk where the database was present got
full and wht happened was tht the process hanged. It would not return from
the query. N in the log file it was showing
070130 10:22:47 [ERROR]
/usr/local/mysql-max-5.0.27-hpux11.11-hppa2.0w-64bit/bin/mysqld:
Di
Hi
You probably cant make it 100% secure, because php is not a fully compiled
language, and as such an expert techie could probably add extra code to your
app that wouild allow access to the database, BUT you can get pretty close.
You will need to encrypt everything in the database using MySql e
[EMAIL PROTECTED] ("Suhas Pharkute") wrote in
news:[EMAIL PROTECTED]:
> I want to distribute the MySQL DB to different user with an PHP web
> app.
Make sure you have read and understood the MySQL licensing policy, if your
app is not open source (as it seems to be).
> My biggest problem is MyS
On 1/30/07, Dan Nelson <[EMAIL PROTECTED]> wrote:
In the last episode (Jan 29), Suhas Pharkute said:
> Ok, I will explain it again,
>
> I need a way so that if some body gets the DB files (.MYD and .MYI)
> from my distribution, they can put it in their DB engine and can read
> my DB. I would like
Great idea! Tips on how to get around, good local restaurants (if you
like Vietnamese, San Jose is the place), and other things to do when you
need a break... There is really a great deal just a short distance
away, but you have to know how to get there. It's possible there was
something like
30 matches
Mail list logo
