Hi All,
innodb_file_per_table will create individual .ibd file for each table. If
mysql master has single ibdata file and mysql slave (used
'innodb_file_per_table') has multiple .ibd files. Is there any other issues
by having replication in this way.
Thanks
--
Krishna Chandra Prajapati
MySQL
Hi.
I've installed 'mytop' on my Linux server and would like to log the
data provided in order to store it for future situations.
Does anybody know how to perform it? Thank you very much,
--Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi.
I've been finding some queries by using 'mytop' which takes +200
seconds to be executed. It wastes tons of CPU resources on my server
and would like to detect them automatically and kill them.
Does anybody have experience with this issue? Thank you very much,
--Thomas
--
MySQL General
Hi Bruce,
delimiter |
create trigger mfgtst after insert on masterHostTBL
for each row begin
set @tmp = 55;
insert into masterTestResultStartTBL
set hostID = NEW.id,
testResultVal = 88;
/*
set @q = masterTestResultStartValTBL.serverStartVal;
Hi,
select
mnr,
kw,
sum(pzt),
sum(uu),
sum(u01),
sum(u02),
sum(u03)
from mde
where mnr=63210 group by kw, mnr
results in:
mnr kw sum(pzt)sum(uu) sum(u01)sum(u02)sum(u03)
63210 02 773850 131 0
At 06:40 AM 12/11/2007, you wrote:
Hi.
I've been finding some queries by using 'mytop' which takes +200
seconds to be executed. It wastes tons of CPU resources on my server
and would like to detect them automatically and kill them.
Does anybody have experience with this issue? Thank you very
I'm looking at a situation I haven't run into before, and I'm a bit
puzzled by it.
I have this table structure:
Table USERS: userid, class
Table OBJECT: userid, class, result
Now I want to query the database for a certain user's result in a
specified class, which is very, very easy. No
On Dec 11, 2007 8:38 AM, Anders Norrbring [EMAIL PROTECTED] wrote:
I'm looking at a situation I haven't run into before, and I'm a bit
puzzled by it.
I have this table structure:
Table USERS: userid, class
Table OBJECT: userid, class, result
Now I want to query the database for a certain
On Dec 11, 2007, at 10:46 AM, Rob Wultsch wrote:
On Dec 11, 2007 8:38 AM, Anders Norrbring [EMAIL PROTECTED] wrote:
I'm looking at a situation I haven't run into before, and I'm a bit
puzzled by it.
I have this table structure:
Table USERS: userid, class
Table OBJECT: userid, class, result
On Dec 11, 2007 6:30 AM, Volker Duetsch [EMAIL PROTECTED] wrote:
Hi,
select
mnr,
kw,
sum(pzt),
sum(uu),
sum(u01),
sum(u02),
sum(u03)
from mde
where mnr=63210 group by kw, mnr
results in:
mnr kw sum(pzt)sum(uu) sum(u01)
Anders,
I also want to find out the user's position relative to others
depending on the result.
For a given pUserID, something like this?
SELECT userid,result,rank
FROM (
SELECT o1.userid,o1.result,COUNT(o2.result) AS rank
FROM object o1
JOIN object o2 ON o1.result o2.result OR
Hello every one,
I have two questions actually. If there is a database server with couple of
databases, and we only want to take the dump of few of them, can we specify
a list of those on either mysqldump or mysql prompt ( for any other purpose
).or we have to run the mysqldump command seperately
from the mydump help screen:
$ mysqldump --help
mysqldump Ver 10.10 Distrib 5.0.22, for redhat-linux-gnu (x86_64)
...
with all databases selected.
--add-drop-database Add a 'DROP DATABASE' before each create.
--add-drop-tableAdd a 'drop table' before each create.
jekillen wrote:
Hello:
The saga of this machine continues:
FreeBSD v6.2
latest mysql version installed from ports:
mysql51 client, serve, and scripts.
There is no /usr/local/mysql
it did not create this dir.
No idea where it should put the files, a freebsd list might be able to
point you in
14 matches
Mail list logo