Hi!
Ananda Kumar said the following, On 28-Mar-07 06:15:
Hi All,
What are all the mysql services i need to monitor to make sure mysql db is
running and send a pager when any one of these services go down.
To check if a database is still running is diffrent then the actuall
process.
Do you wan
Ananda Kumar wrote:
>
> What are all the mysql services i need to monitor to make sure mysql db is
> running and send a pager when any one of these services go down.
>
mysql daemon on Linux and UNIX systems, MySQL service on Windows
in any case all of them supports executing command on daemon (
Hi All,
What are all the mysql services i need to monitor to make sure mysql db is
running and send a pager when any one of these services go down.
regards
anandkl
This is using version: 5.0.18-log on linux.
I have a stored procedure that takes .2 sec the first time,
12 the second, 12 the third. The data is unchanged.
The relevant part of the procedure looks like this.
...
drop temporary table if exists temptab;
create temporary table temptab (index (
Pat,
I am by no means great with sql, but i think i may be able to help you. You
just need to load up your query with or statements. As i understand your
question, you will be searching name for several keywords (x1,x2,...) and
address for several keywrods (y1,y2...)
SELECT * FROM clients
WHER
Here is my problem.
I have a table called dictionary
The dictionary has the following columns
`wordID` int(10) unsigned NOT NULL auto_increment,
`position` int(10) unsigned NOT NULL ,
`WORD` varchar(120) NOT NULL default ''
What this actually holds is a index of words and their locations of a b
well, you'd want to come up with your specifics but it's pretty simple using
ssh...
put this is your shell...
$ mysqldump db-name | mysql -h remote.box.com db-name
$ mysqldump db-name | ssh [EMAIL PROTECTED] mysql db-name
$ mysqldump db-name foo | ssh [EMAIL PROTECTED] mysql bar
hope this hel
If test and production are supposed to be identical, then use this:
mysqldump -h -u... -p... --triggers --routines |
mysql -h -u... -p... -A -D
If you havn't noticed, you do not dump the data to a file and ftp or scp
anything anywhere !!!
This will actually pipe all mysqldump commands striaght
Hello all.
Does anyone out there (in mysql world) have a Linux -csh script to
refresh test with production data.
My developers would like their test database to be refreshed nightly
with production data. The production and test mysql servers do not run
in the same box. They run on different box
Could you post the actual code you are using for the INSERT? Also, what
storage engine are you using?
Jay
andrew collier wrote:
hello,
i am having some trouble getting mysql to perform decently on my machine. it is
a 2 GHz dual core AMD 64 machine (although i am presently running a 32 bit
I always go with REPLACE(REPLACE(STRING, '\n', ''), '\r', ''), since
depending on where your data came from there may be one or the other, or
both. Although if there is a shorthand/more efficient way I'd love to
hear it.
[EMAIL PROTECTED] wrote:
Ok.. I found the problem.. I needed to add a \
On 3/27/07, Tim Lucia wrote:
> -Original Message-
> From: Maciej Dobrzanski
> Sent: Tuesday, March 27, 2007 6:46 AM
> To: mysql@lists.mysql.com
> Subject: Re: Why doesn't the InnoDB count() match table status?
>
> MyISAM and InnoDB (and there are plenty more). RDBMS is not an Office
> spr
Ok.. I found the problem.. I needed to add a \r.. but now that opens up
the question can I have a Multi replace search in replace?
Example can I do something like this in MySQL
REPLACE (STRING,'\r' or '\n',' ')
REPLACE(DESCRIPTION,'\r\n',' ')
Wishing you the best you know you deserve,
_
Ulrich Staudinger wrote:
first of all, thanks for the world's finest open source database!
I would like to know if someone has an estimate for the availability of
v5.1 as a production release. ?
Keep watching http://dev.mysql.com/doc/refman/5.1/en/news.html and its a
safe bet if its Q3/Q4 th
Instead of just saying 'desc ;'
Try using information_schema.columns
mysql> desc information_schema.columns;
+--+--+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
+--+---
Hello Group,
Looking to use this REPLACE to strip multi line data out of my return
data.
I am having problems getting the \n to work correctly, any ideas?
REPLACE(DESCRIPTION,\n,' ')
SELECT
rpad(CASE WHEN DESCRIPTION IS NULL THEN '' ELSE
REPLACE(DESCRIPTION,'\n',' ') END,80,' ') as var
Hi All,
Is there a way to influence the order in which columns are returned in a
describe table statement. Basically I want the same order that I get in the
mysql client (Field, Type, Null, etc) in a little script I am writing, so I
can use the Column headers dynamically.
Thanks
Olaf
--
MySQL
Hi,
I have a HP rp3410 with 4Gb RAM running HPUX 11.11. This is running,
Version: '5.0.26-pro-log' socket: '/tmp/mysql.sock' port: 3306 MySQL
Pro (Commercial)
When this machine is put under load (i.e, a lot of database activity),
the clients are receiving "Error 12" errors and the MySQL lo
FYI - Monday AM, Norton A/V started reporting the uninst.exe and the
sqlyog525.exe files as infected with 'Virus Burst'. This is due to a
NullSoft installer signature problem. SQLyog527 has been released, built
with a newer NullSoft installer, AND the virus definitions from today no
longer quaran
> -Original Message-
> From: Maciej Dobrzanski [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 27, 2007 6:46 AM
> To: mysql@lists.mysql.com
> Subject: Re: Why doesn't the InnoDB count() match table status?
>
> MyISAM and InnoDB (and there are plenty more). RDBMS is not an Office
> spreads
In news:[EMAIL PROTECTED],
"Daevid Vincent" <[EMAIL PROTECTED]> wrote:
> Because we're a huge enterprise product, with 3 databases of > 200
> tables each.
>
> We are migrating from MYISM to INNODB and keeping track of that value
> isn't something we thought we'd need to do. Plus it seems like
> so
Hi All,
I have specified innodb_file_per_table option, can i place .idb and and
tablespace (datafiles) in the same directory.
Also, can i please .idb files in different disk from innodb_data_file_path.
regards
anandkl
22 matches
Mail list logo
