Thanks Ravi
On Tue, 2006-04-11 at 11:41 +0530, Ravi Prasad LR wrote:
> yes, that is the reason for slowness .
>
> Thanks,
> Ravi
> On Tuesday 11 April 2006 10:51, Mohammed Abdul Azeem wrote:
> > Hi Ravi,
> >
> > Since the sync'ing is done to disk with sync_binlog=1, the update
> > queries to se
yes, that is the reason for slowness .
Thanks,
Ravi
On Tuesday 11 April 2006 10:51, Mohammed Abdul Azeem wrote:
> Hi Ravi,
>
> Since the sync'ing is done to disk with sync_binlog=1, the update
> queries to server are slower compared to the server having sync_binlog=0
> rite ?
>
> Thanks,
> Abdul
Hi Jim - see this for your answers.
1.4.4. How Large MySQL Tables Can Be
http://dev.mysql.com/doc/refman/5.0/en/table-size.html
Regards
Keith
In theory, theory and practice are the same;
in practice they are not.
On Tue, 11 Apr 2006, Jim wrote:
> To: mysql@lists.mysql.com
> From: Jim <[EMAIL
Hi All,
We used to use Interbase which required a new file to be assigned for every
4 gig of data stored in a DB.
Is there any issues like this in mySQL?
Thanks,
Jim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi Ravi,
Since the sync'ing is done to disk with sync_binlog=1, the update
queries to server are slower compared to the server having sync_binlog=0
rite ?
Thanks,
Abdul.
On Tue, 2006-04-11 at 10:51 +0530, Ravi Prasad LR wrote:
> Hi Abdul,
>When sync_binlog is set to 1, innodb
Hi Abdul,
When sync_binlog is set to 1, innodb fsyncs the binary log to
disk after every single write to binary log, but not in the case of
sync_binlog=0.
From MySQL manual:
If the value of this variable is positive, the MySQL server synchronizes its
binary log to disk (fdatas
Atle Veka wrote:
Anyone have any experience to share about running mysql on a linux tmpfs
(using memory)?
tmpfs is swappable. I would use ramfs which is not swappable.
For us it's worked out pretty well and is normally operating lightning
fast compared to an identical SCSI based system. Howev
Hi,
I have a master/slave setup ( replication enabled ) for mysql in two
different geographic locations ( one master/slave set up in each
location). In one location i have configured the sync_binlog=1 . And the
other location does not have the same.
My problem is, when i run similar update proces
Thanks Steve,
Much appreciated, I was hoping there was something a little simpler, but I
will have a go at it.
Anyway of doing this with RegEx, would that simplify things?
Kind regards,
Taco Fleur
Free Call 1800 032 982 or Mobile 0421 851 786
Pacific Fox http://www.pacificfox.com.au an indu
Haven't you answered your own question? From my reading of this question,
there are four entity tables (student, module, question, answer) and three
or more relation tables (association tables) student-module,
module-question, question-answer. There are probably two of the last one -
one which ho
Hi,
I'm storing data against a bunch of people and want to track how it
changes. So, I have a person table where everyone has a person ID and a
results table a bit like this:
| personID | classification | date |
| 1| 0 | 2005-11-10 |
| 2| 3 | 2005-1
Does anyone happen to know where a basic schema for tracking questions and
answers from tests that a student has completed. I don't know why I am
having difficulty with this, but I can't seem to figure out how to set up
the tables correctly to store this information.
The basics
N number of studen
-Original Message-
From: Peter Lauri [mailto:[EMAIL PROTECTED]
Sent: Monday, April 10, 2006 10:45 AM
To: mysql@lists.mysql.com
Subject: Making result rows to one row
Best group member,
Many of you probably do not understand the question; neither would I if
someone ask me, so I will expl
Shawn Green wrote:
I understand now.
You have 3 slave server processes replicating independently from their
own separate master servers. You have a fourth MySQL server process
that shares the same data files as your 3 slaves but it does not know
when replication occurs and when it hasn't (fo
At 7:37 AM +1000 4/11/06, Taco Fleur wrote:
Hi all,
I am trying to find out whether it is possible to return the count of
keywords found in a text field, does anyone know?
For example; "ColdFusion or Java" is entered in the search string and 20
records are found that match, I need to count how m
Hi all,
I am trying to find out whether it is possible to return the count of
keywords found in a text field, does anyone know?
For example; "ColdFusion or Java" is entered in the search string and 20
records are found that match, I need to count how many times "ColdFusion"
and "Java" appears in
Ravi Malghan wrote:
Hi: I have a statement such as follows
SELECT EVENT_DATA.dstport WHERE
FROM_UNIXTIME(utime,'%Y-%m-%d') = (CURDATE() -
INTERVAL 1 DAY) ORDER BY EVENT_DATA.utime;
Instead of using a value of 1 for interval, I want to
pass parameters so it will ask for the value when the
sql st
Joerg: thank you. That worked and much faster too.
WHERE EVENT_DATA.utime >
UNIX_TIMESTAMP(SUBDATE(CURDATE(), 5)) AND
EVENT_DATA.utime < UNIX_TIMESTAMP(SUBDATE(CURDATE(),
4))
Ravi
--- Joerg Bruehe <[EMAIL PROTECTED]> wrote:
> Hi Ravi, all,
>
>
> Ravi Malghan wrote:
> > Joerg: are you saying I
--- Ravi Malghan <[EMAIL PROTECTED]> wrote:
> Hi: I have a statement such as follows
>
> SELECT EVENT_DATA.dstport WHERE
> FROM_UNIXTIME(utime,'%Y-%m-%d') = (CURDATE() -
> INTERVAL 1 DAY) ORDER BY EVENT_DATA.utime;
>
> Instead of using a value of 1 for interval, I want to
> pass parameters so
--- Ravi Malghan <[EMAIL PROTECTED]> wrote:
> Joerg: are you saying I need to compute the start time
> and end time in epoch values and use it in
> select count(*) from EVENT_DATA
> where utime > start_time and utime < end_time ?
>
> Can you provide some pointers and what to search on. I
> h
Hi Ravi, all,
Ravi Malghan wrote:
Joerg: are you saying I need to compute the start time
and end time in epoch values and use it in
select count(*) from EVENT_DATA
where utime > start_time and utime < end_time ?
"need to"?
This is not required in order for the command to work (at all),
b
--- Philippe Poelvoorde <[EMAIL PROTECTED]> wrote:
> 2006/4/8, Philippe Poelvoorde <[EMAIL PROTECTED]>:
> > Hi,
> >
> > 2006/4/8, Dan Buettner <[EMAIL PROTECTED]>:
> > > Seems like what you're looking for is a way to query your
> database
> > > more efficiently/quickly, and still find all links
--- Joerg Bruehe <[EMAIL PROTECTED]> wrote:
> Hi Martin, all,
>
> Martin Olsson wrote:
> > Hi,
> >
> > I get this weird error message:
> >
> > ErrNo: 2006
> > Error: MySQL server has gone away.
> >
> > What does it mean? I couldn't find anything useful on google and
> the
> > error
Hi: I have a statement such as follows
SELECT EVENT_DATA.dstport WHERE
FROM_UNIXTIME(utime,'%Y-%m-%d') = (CURDATE() -
INTERVAL 1 DAY) ORDER BY EVENT_DATA.utime;
Instead of using a value of 1 for interval, I want to
pass parameters so it will ask for the value when the
sql statement is run. I have
Joerg: are you saying I need to compute the start time
and end time in epoch values and use it in
select count(*) from EVENT_DATA
where utime > start_time and utime < end_time ?
Can you provide some pointers and what to search on. I
have searched and can't seem to find any leads on how
to get t
Can you post few lines of the code where you are making the connection?
On 4/10/06, marco stagno <[EMAIL PROTECTED]> wrote:
>
> > Wild stab in the dark here - Java I/O permissions not set correctly
> > on your
> > machine to allow it? If I recall, Java's sandbox feature means you
> > have to
> > s
2006/4/8, Philippe Poelvoorde <[EMAIL PROTECTED]>:
> Hi,
>
> 2006/4/8, Dan Buettner <[EMAIL PROTECTED]>:
> > Seems like what you're looking for is a way to query your database
> > more efficiently/quickly, and still find all links in either
> > direction.
> >
> > I think the use of a UNION statemen
On 10.04.2006 18:32 (+0100), Jorrit Kronjee wrote:
> I'm not entirely sure what you mean. Are `mysql4.mydomain' and
> `mysql5.mydomain' hostnames?
Yes, as I have explained earlier in this thread.
--
Yves Goergen "LonelyPixel" <[EMAIL PROTECTED]>
"This message represents the official view of the
Peter,
Best group member,
Many of you probably do not understand the question; neither would I if
someone ask me, so I will explain a little bit more.
This is what I have:
SELECT tps.strokes FROM tour_player_score tps join tour_scorecard_hole tsh
WHERE tour_player_id=175 AND tps.scorecard
Hi Martin, all,
Martin Olsson wrote:
Hi,
I get this weird error message:
ErrNo: 2006
Error: MySQL server has gone away.
What does it mean? I couldn't find anything useful on google and the
error message isn't exactly "verbose".. :)
AIUI, this message is issued if the client gets an
Can you tell us more about the use case? Why does this need to be in a
single row? Maybe instead of figuring out how to get this into a single
row we could instead figure out how to solve the problem that requires
it to be in a single row.
-Original Message-
From: Peter Lauri [mailto:[EMA
Best group member,
Many of you probably do not understand the question; neither would I if
someone ask me, so I will explain a little bit more.
This is what I have:
SELECT tps.strokes FROM tour_player_score tps join tour_scorecard_hole tsh
WHERE tour_player_id=175 AND tps.scorecard_hole_id=tsh.i
That did work very well, thank you. The DEFAULT value was 0. I am getting
closer in my attempt to generate a leaderboard without php :)
From: Gabriel PREDA [mailto:[EMAIL PROTECTED]
Sent: Monday, April 10, 2006 7:16 PM
To: Peter Lauri
Cc: mysql@lists.mysql
--- Scott Purcell <[EMAIL PROTECTED]> wrote:
> Hello,
>
>
>
> When I do a table describe, I see a MUL on a column I have marked as
> a
> foreign-key. I tried searching for MUL within the docs, but do not
> see a
> concise explanation of what that is?
>
>
>
> Anyone?
>
>
>
> Thanks,
>
Yves Goergen wrote:
On 09.04.2006 23:40 (+0100), Jorrit Kronjee wrote:
You seem to be best off with a setup where you've got the MySQL5 UNIX
socket disabled, MySQL5 bound to one specific IP address, MySQL4
listening on 127.0.0.1 and a simple port forwarding rule to MySQL4.
I'm missing the par
Hello,
When I do a table describe, I see a MUL on a column I have marked as a
foreign-key. I tried searching for MUL within the docs, but do not see a
concise explanation of what that is?
Anyone?
Thanks,
Scott
On 09.04.2006 23:40 (+0100), Jorrit Kronjee wrote:
> You seem to be best off with a setup where you've got the MySQL5 UNIX
> socket disabled, MySQL5 bound to one specific IP address, MySQL4
> listening on 127.0.0.1 and a simple port forwarding rule to MySQL4.
I'm missing the part to connect to M
--- Douglas Sims <[EMAIL PROTECTED]> wrote:
>
> Does anyone know of a thorough discussion of effective dating on the
>
> web, particularly with respect to MySQL, or have any opinions you
> could share?
>
> I've worked with effective-dated tables in MS SQL Server and never
> been particul
--- Alexey Polyakov <[EMAIL PROTECTED]> wrote:
> On 4/8/06, Kevin Burton <[EMAIL PROTECTED]> wrote:
>
> > Is there anyway I can tune MySQL to improve this operation?
>
> There's a fundamental problem with B-trees - inserts in a big B-tree
> can be very slow, cause it may require tree rebalanci
--- Leonardus Setiabudi <[EMAIL PROTECTED]> wrote:
> let me re-explain my situation ..
>
> the mysql server was on /home/mysql/mysql4111
> and the data directory was on /home/mysql/mysql4111/data
> in data directory, there are 4 databases, db1, db2, db3, db4
> all configurations resided in /hom
Wild stab in the dark here - Java I/O permissions not set correctly
on your
machine to allow it? If I recall, Java's sandbox feature means you
have to
supply a permissions file for I/O. Perhaps that file already exists
on the
other machine that works?
I don't know so much Java, but I didn'
> I don't think so, since even with "telnet localhost 3306" or "telnet
> 127.0.0.1 3306" I'm able to see the server prompt..
> and I'm using the standard MySQL port for sure (it's a clean
> installation); and there are no firewall active...
>
> any other suggestion!?
>
> thanks :)
Wild stab in the
Ports closed?
Wrong ports configured?
I don't think so, since even with "telnet localhost 3306" or "telnet
127.0.0.1 3306" I'm able to see the server prompt..
and I'm using the standard MySQL port for sure (it's a clean
installation); and there are no firewall active...
any other suggesti
--- Martin Gallagher <[EMAIL PROTECTED]> wrote:
> "of course you have the problem where john has Joe as a friend but
> Joe
> doesn't have john as a friend. This seeming inconsistency, may or
> may not
> be a problem depending on exactly what kind of a relationship you are
> trying
> to define."
FYI-
I am a moron, and SELinux was enforced, although I thought I had disabled
it.
Thanks-
Peter J. Milanese, System Administrator
Information Technology Group
The New York Public Library
[EMAIL PROTECTED] - 212.621.0203
marco stagno wrote:
I'm trying to understand this error:
java.sql.SQLException: Server connection failure during transaction.
Attempted reconnect 3 times. Giving up.
the java program is trying to connect to MySQL (5.0.19 under Mac OSX/
PPC), with user=root, from localhost.
the grant privileges
I'm trying to understand this error:
java.sql.SQLException: Server connection failure during transaction.
Attempted reconnect 3 times. Giving up.
the java program is trying to connect to MySQL (5.0.19 under Mac OSX/
PPC), with user=root, from localhost.
the grant privileges seems to be ok (I'm
> I need to create a "commands" table. A program will periodically check
on this table whether
> there's a pending command for it to execute or not. Whatever the reason,
this program might read a command but not acknowledge it's
> execution.
> Other program will check out whether the command t
You can do something like this:
SET @diff = 0;
SELECT count(*) AS number_of_holes, tour_player_score.strokes -
tour_scorecard_hole.par AS overpar, IF(overpar<0,
@diff-(overpar*number_of_holes), ELSEVALUE)
FROM `tour_player_score`, tour_scorecard_hole WHERE tour_player_id=175 AND
tour_scorecard_hol
Greetings-
I have a fresh install of 5.0.19, and when I go to start the database
(using the init script), it fails to start. Odd enough, it only logs the
start and end lines in the .err log. Is anyone familiar with this? The only
thing different about the box is that it has dell's openmanag
I need to create a "commands" table. A program will periodically check on
this table whether
there's a pending command for it to execute or not. Whatever the reason, this
program might read a command but not acknowledge it's
execution.
Other program will check out whether the command timeo
Haha, yes I know that. I just created the code in the email editor. :)
-Original Message-
From: Barry [mailto:[EMAIL PROTECTED]
Sent: Monday, April 10, 2006 5:19 PM
To: mysql@lists.mysql.com
Subject: Re: Do if and elseif and other calculations
Peter Lauri wrote:
> Best groupmember,
>
>
I did. The server is windows could this be the problem?
The config.inc.php is in the main phpmyadmin folder not in the config
folder. Is this ok?
Ross
- Original Message -
From: "Dominik Klein" <[EMAIL PROTECTED]>
To:
Sent: Monday, April 10, 2006 11:25 AM
Subject: Re: setting up ph
[EMAIL PROTECTED] schrieb:
http://www.blue-fly.co.uk/screen.jpg
I cannot seem to add a server..anyone shed any light on it?
Just edit config.inc.php
It has good documentation comments, so it should not be a problem.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysq
Peter Lauri wrote:
Best groupmember,
I have this query
SELECT count(*) AS number_of_holes, tour_player_score.strokes -
tour_scorecard_hole.par AS overpar
FROM `tour_player_score`, tour_scorecard_hole WHERE tour_player_id=175 AND
tour_scorecard_hole.id=tour_player_score.scorecard_hole_id GROUP B
Best groupmember,
I have this query
SELECT count(*) AS number_of_holes, tour_player_score.strokes -
tour_scorecard_hole.par AS overpar
FROM `tour_player_score`, tour_scorecard_hole WHERE tour_player_id=175 AND
tour_scorecard_hole.id=tour_player_score.scorecard_hole_id GROUP BY overpar
It gives m
Peter Lauri wrote:
Best group member,
I do this query
SELECT tour_player_score.strokes AS score, tour_scorecard_hole.par AS par,
score-par AS overpar
FROM `tour_player_score`, tour_scorecard_hole WHERE tour_player_id=175 AND
tour_scorecard_hole.id=tour_player_score.scorecard_hole_id
It gives
from the mysql 5.0.18 manual
section 13.1.5. CREATE TABLE Syntax
If a PRIMARY KEY or UNIQUE index consists of only one column
that has an integer type, you can also refer to the column
as _rowid in SELECT statements.
Regards
Keith
In theory, theory and practice are the same;
in practice the
> Best group member,
>
> I do this query
>
> SELECT tour_player_score.strokes AS score, tour_scorecard_hole.par AS par,
> score-par AS overpar
> FROM `tour_player_score`, tour_scorecard_hole WHERE tour_player_id=175 AND
> tour_scorecard_hole.id=tour_player_score.scorecard_hole_id
>
> It gives err
Best group member,
I do this query
SELECT tour_player_score.strokes AS score, tour_scorecard_hole.par AS par,
score-par AS overpar
FROM `tour_player_score`, tour_scorecard_hole WHERE tour_player_id=175 AND
tour_scorecard_hole.id=tour_player_score.scorecard_hole_id
It gives error: [localhost] ER
Hi,
> I created a table and, into it, a timestamp field:
> ... EXPIRES TIMESTAMP NOT NULL, ...
>
> When I issue the command "describe" it shows the field "expires" allows
nulls and defaults to CURRENT_TIMESTAMP. Also, each time I update
> a field other than "expires" in this table, "expires" gets
2wsxdr5 wrote:
> I have a table of people. Some of the people in this table are
> related. You can find out who is related by comparing a familyID
> number. I have a query to select a certain group of people from the
> table and I want to also select anyone who is related to them, even
> though
Hi!
I created a table and, into it, a timestamp field:
... EXPIRES TIMESTAMP NOT NULL, ...
When I issue the command "describe" it shows the field "expires" allows nulls
and defaults to CURRENT_TIMESTAMP. Also, each time I update
a field other than "expires" in this table, "expires" gets updated
Martin Olsson wrote:
Hi,
I get this weird error message:
ErrNo: 2006
Error: MySQL server has gone away.
What does it mean? I couldn't find anything useful on google and the
error message isn't exactly "verbose".. :)
Haha, yeah i like that one.
Somone stole it haha :D
I'm not quite
At 02:57 PM 4/10/2006, Kosala Atapattu wrote:
Hi people,
I have a small problem. I forgot the password for user root in my
personal MySQL instance. I'm a Linux user and running Debian Sarge on my
computer. I have few other DBs which I created and which I have access
to (still I remember the pass
Adrian Co wrote:
> Hi,
>
> Yes, the syntax is not valid. I have tried it. :-)
>
> I was hoping for maybe a workaround to simulate the described
> functionality. There might also be something wrong with the structure of
> my script. Maybe I shouldn't be creating triggers there? But I was
> thinki
Hi
Restart mysqld with the --skip-grant-tables option
More info : http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
--Praj
On Mon, 10 Apr 2006 12:57:32 +0600
"Kosala Atapattu" <[EMAIL PROTECTED]> wrote:
> Hi people,
>
> I have a small problem. I forgot the password for user r
67 matches
Mail list logo
