per minute?
P.S.: we are using mytop and innotop, but it seems that they don't
support such a feature. We see a lot of different queries executed
against MySQL but we can't figure out, which kind of queries is the most
executed, on which database.
Thanks,
--
Daniel
--
MySQL General Mailing
Baron Schwartz schrieb:
On Dec 13, 2007 4:18 PM, Daniel Mikic [EMAIL PROTECTED] wrote:
Baron Schwartz wrote:
Hi,
On Dec 13, 2007 3:53 PM, Daniel Mikic [EMAIL PROTECTED] wrote:
Hi, i hit a weird behavior:
select date(null); #result is null
select if(date(null) is null, 1, 2
Hi, i hit a weird behavior:
select date(null); #result is null
select if(date(null) is null, 1, 2); #result is 2 (not null)
select if(date(null) is not null, 1, 2); #result is 1
I use mysql version 5.0.32-Debian_7etch1-log.
Is this a bug and if not, can anyone explain why?
Thanks,
Daniel
Baron Schwartz wrote:
Hi,
On Dec 13, 2007 3:53 PM, Daniel Mikic [EMAIL PROTECTED] wrote:
Hi, i hit a weird behavior:
select date(null); #result is null
select if(date(null) is null, 1, 2); #result is 2 (not null)
select if(date(null) is not null, 1, 2); #result is 1
I use mysql version
/ TotalDays ) as ProjectedAnnualSpend
from
GasLocations
where
LocID = GasLocationID;
END
---
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http
Nothing,
the server is definetively not running
You get the bug script from me..
regards
Daniel
Datum: Fri, 12 Oct 2007 15:44:29 +0530
Von:Ananda Kumar [EMAIL PROTECTED]
An: Daniel Bau [EMAIL PROTECTED]
Betreff:Re: MySQL Server not running
Kopie an: mysql
]
An: Ananda Kumar [EMAIL PROTECTED]
Kopie an: Daniel Bau [EMAIL PROTECTED], mysql@lists.mysql.com
Betreff:Re: MySQL Server not running
Given that FEHLGESCHLAGEN means failed and coupled with the proceding
text, I would assume that you don't have mysql installed
workes and when I instal the old version it works.
I hope you can help me, in attachment the mysql_bug.script result
Greetings from Germany
Bau Daniel
university for applied science
www.fh-offenburg.de
Der folgende Teil dieser Nachricht enthält einen Anhang im
sogenannten Internet MIME
a problem with the
mysql_install_db but
dont tell me what for problem.
The message say i should execute the bug script and send it to you .
Greetings
Bau Daniel
Datum: Fri, 12 Oct 2007 14:45:45 +0530
Von:Ananda Kumar [EMAIL PROTECTED]
An: Daniel Bau [EMAIL PROTECTED]
Betreff
, and imported, and
everything went fine.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list
#
The only way I can explain the fact that things are still working is
that these files are in fact *not* deleted, and are still in use by
mysql, but not visible to anything else. But that's ridiculous as well.
So what's going on?
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific
? At this point, I
still think it might be a better idea to do a complete reinstall /
restore / transaction log run.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website
again for your response. At least I learned about lsof and
recovering deleted files :)
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http
the enitre SQL here
for u to use, please someone respond as i would like to get this
accomplished as soon as possible,
Your best bet is to post the problem to the mailing list.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61
( commercial distribution of Wine ). Once you've had a stable,
hassle-free desktop for a couple of months, then you can start moving
others with some confidence.
Enjoy :)
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F
on
appropriate fields. Generally you want them on fields used in joins, and
fields in your 'where' clause.
If you post your query and the output of 'show create table
TABLE_NAME' for each table involved, someone might suggest which
fields to add indexes to.
--
Daniel Kasak
IT Developer
NUS Consulting Group
just tell me, for hack one or develop from
scratch.
I'm OK with everything apart from the Java bit. Sorry. It's not really
my cup of tea ( no offence ... I realise that most Java people say the
same thing about Perl ).
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
can't find anything,
and I may ( time permitting, and I obviously can't do it here at work,
or it wouldn't be open-source ) have a go at it.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
The problem is probably due to your using both '\G' and ';' to end your
command statement. You can only use one or the other.
Thanks,
Daniel J. Donckers
-Original Message-
From: Ananda Kumar [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 20, 2007 9:23 AM
To: MySQL General
Subject
language= /usr/share/mysql/english
long_query_time = 1
log-queries-not-using-indexes
skip-external-locking
verbose
log_bin_trust_function_creators = 1
Thanks a lot!
--
Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Hi,
Is there any configuration to be setup to get each query of a stored
procedure, called by a client, in the mysql-slow.log or mysql.log? For
the moment, I just have the stored procedure call in the log file, but I
need to trace every SQL statement of this stored procedure.
# Time:
performance across slow network connections (
eg DSL ).
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing
include it'll be using the latest, stable release of
MySQL 5 and I'll be developing in PHP5 (through CakePHP's database
abstraction layer).
--
Thanks and Gig 'Em!
Daniel Cousineau
http://www.terminalfuture.com/
http://www.linkedin.com/in/dcousineau
[EMAIL PROTECTED]
() if it makes you happy.
This is absolutely baffling and astonishing how a company so seemingly smart
could make such an incredible blunder. :-\
Oh the melodrama! Won't someone please think of the children!
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North
John Sutton wrote:
Hi...
How do I go about posting a question about MySQL?
I think you're getting the hang of it.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL
Hello list,
I'm currently developing a newsletter tool allowing customers to send
their newsletters to their clients and get all kinds of statistics. For
each customer of ours, I need to save up to five different lists of
newsletter recipients with their email addresses and some other stuffs
an answer.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE BLOCK--
--
MySQL General Mailing List
For list
be able to see the
table.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives
or something ).
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives: http
should go back to the previous stable
version ( 3.51.06 ) as recommended, but you will have to also go back to
MySQL-4.0.x or tell your post-4.0.x server to use the old authentication
method.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia
to give them different TCP
ports to listen...
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE BLOCK
to test and choose from multiple options in this matter.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE
on a real system with some
valuable data.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE BLOCK
). It defies logic.
Who knows what's going on?
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
://entropy.homelinux.org/axis/
It's a whole lot faster than VB, and also cross-platform ( tested
heavily under Windows 2000 and Gentoo Linux, and initial development
done on OS-X ).
If you don't wanna use Perl, then try the PHP bindings for Gtk2 instead :)
--
Daniel Kasak
IT Developer
NUS Consulting Group
the SP to the query, but in some other cases, the SP
bit will be quite complex.
Dan
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http
been this way for a couple of years and through a
few upgrades; it very well could be that I have something configured
or installed wrong. What do you think?
Daniel Culver
[EMAIL PROTECTED]
On Jan 20, 2007, at 7:04 PM, Kevin Spencer wrote:
On 1/19/07, Daniel Culver [EMAIL PROTECTED] wrote
will accept any correct password combination
under ShadowHash or other authorising protocol, but you will still be
working in the account you are in with those privileges. HTH
Daniel Culver
[EMAIL PROTECTED]
On Jan 17, 2007, at 4:49 PM, Ed Reed wrote:
Unable to manage user accounts through
Don't include the password, let mysql prompt for it. ' ./bin/
mysqladmin -u root password -p '.
Daniel Culver
[EMAIL PROTECTED]
On Jan 17, 2007, at 7:57 PM, Mariella Petrini wrote:
./bin/mysqladmin -u root password '***'
./bin/mysqladmin: connect to server at 'localhost' failed
I have a table with numerous columns but needing to perform a query
based on three columns:
Lab_number, result, release_time.
What I want to do is search for lab_number where there is a result but
not released. The problem that is making this difficult for me, is that
there are multiple entries
On Wed, 2007-01-17 at 09:56 -0600, Peter Brawley wrote:
Daniel,
find the lab_number where ALL the tests have been performed and
not the lab_numbers which have partial results.
SELECT t1.lab,t1.res,t1.dt
FROM tbl t1
WHERE NOT EXISTS(
SELECT lab FROM tbl t2 WHERE t1.lab=t2.lab AND t2
On Wed, 2007-01-17 at 11:47 -0600, Peter Brawley wrote:
Daniel,
CREATE TABLE tbl (
lab_number int(11) default NULL,
result int(11) default NULL,
release_time datetime default NULL
);
select * from tbl;
+++-+
| lab_number | result
-join all the tables,
and then put the case statement in the select statement.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
through hoops to join to the right table.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
for each record? It's
possible that it does. You could try doing this in a separate query /
calculation, and then pass the result into the query. Anyway,
investigate it ... as I said, I'm not sure how MySQL handles this. Maybe
others can comment.
--
Daniel Kasak
IT Developer
NUS Consulting Group
when I execute complex queries based on
primary key relations? Does it pay to use the ease of the second
solution? Anyone has any experience in similar problems?
What is your opinion?
Thanks,
Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
(latin1_swedish_ci,IMPLICIT),
(utf8_general_ci,COERCIBLE), (utf8_general_ci,COERCIBLE) for operation
'replace'
I have no idea what it's talking about. How do I fix it?
Dan
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2
it be that the problems you mentioned generate warnings and
not errors? If so, then you won't see anything in the error log, only
if you use the log-warnings variable. Check the manual...
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C
sort of consistency (replication?)
between the servers. Oh, combine high load services with M$ and NTFS
and you'll get problems (my personal experience, no flames intended).
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA
VeeJay wrote:
Hi
Where one can find Source Distribution of MySQL Server 5.0 Standard for
FreeBSD?
Not on the website, that's for sure.
Have you tried the usual warez sites, p2p networks, etc?
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW
:
http://dannyman.toldme.com/2006/08/22/mysql-backup-grant-privileges/
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y
easily. You can always install the old
version you had and try copying the file direcly to get the data back,
but I guess the corruption is in the file, so, there's really not much
to do...
Check your filesystem integrity ASAP.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE
there.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE BLOCK--
--
MySQL General Mailing List
For list
this so I have to use old-passwords
option in the new servers :)
Thanks
On 12/11/06, Daniel da Veiga [EMAIL PROTECTED] wrote:
On 12/11/06, Ahmad Al-Twaijiry [EMAIL PROTECTED] wrote:
Hi everyone
I'm using mysqld with option old-passwords in my server (let's call
it serverA)
and in my
and many
dictionary passwords.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE BLOCK--
--
MySQL
On 12/4/06, Jason J. W. Williams [EMAIL PROTECTED] wrote:
Hi Daniel,
Thank you very much for your help and advice. After some examination,
we discovered a couple of things. It looks like our storage array
layout was really bad for the IOPS MySQL was throwing at it, as a
result the InnoDB
Hi all.
I'm about to import a LOT of data ( 20 GB ) into some InnoDB tables. At
the moment, I have:
innodb_data_file_path = ibdata1:10M:autoextend
in my /etc/mysql/my.cnf
The ibdata1 file is 499MB at the moment. What happens when this goes
past 2GB? Do I automatically get allocated
Carlos Proal wrote:
Daniel, innodb data files keep growing as needed, it even be of 20Gb
or more.
I was under the impression that you should avoid files 2GB on 32 bit
systems, which have to do some dodgy stuff to support files bigger than
2GB. Does this advice apply?
If you want several
Paul DuBois wrote:
At 10:57 AM +1100 12/4/06, Daniel Kasak wrote:
Carlos Proal wrote:
Daniel, innodb data files keep growing as needed, it even be of 20Gb
or more.
I was under the impression that you should avoid files 2GB on 32
bit systems, which have to do some dodgy stuff to support
for it.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE BLOCK--
--
MySQL General Mailing List
For list archives
Assuming a decent spec server, would a simple search query on a big
indexed table be quicker than searching the amount of data divided into
separate tables?
The kind of situation I have in mind is a database of events during a
year, this table could top 1,000,000 enteries on the vague kind of
friend is a DBA and he once
told me that if you have to CODE the creation of a database for any
purpose besides restoring a backup, something is wrong.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N
to change password format or start your server
with --old-passwords. I strongly suggest you to change your password
format.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5
... Choose your own :)
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE BLOCK--
--
MySQL General Mailing
),
and then delete the MS Access link when you're done ( and delete the
temporary table ). You can write a function that does this, and call it
view_my_view() or something :)
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F
many records are present.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives
.
My 2 cents.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE BLOCK--
--
MySQL General Mailing
there will be able to
give you more accurate advice than people here?
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General
' to find the exact format and commands to use.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
tools are going to
be the best bet, as they will set up your table definitions.
There is a *remote* chance that Oracle will be able to import from a
'mysqldump' backup. You can also check that out, but I doubt it will
work somehow.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77
for you. It's
been a very long time since I looked at these - probably 5 years or so.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http
You need create your select statement using a variable and the do the
prepare statement;
Drop Procedure If Exists RankStock;
DELIMITER |
Create Procedure RankStock(IN TableNameIn CHAR(20),IN ColNameIn
CHAR(20))
begin
Set @selStmt = Concat(Select ,ColNameIn, from ,TableNameIn,
order by
is:
export PATH=$PATH:/usr/local/mysql/bin
You can use the vi instructions below.
Daniel Salinas
On 9/9/06 3:36 AM, Paul McCullagh [EMAIL PROTECTED] wrote:
Hi Steve,
You have to edit a file called .tcshrc which resides in your users
home directory, and add :/usr/local/mysql/bin to the PATH
Access apps.
If you know some Perl, you can always use something like:
http://entropy.homelinux.org/axis_not_evil
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED
?
Performance. And keep in mind that communication between MySQL and your
application server will be *considerably* faster when they're both on
the same system. If you put them on separate systems, obviously
communication between the 2 will now be over the network.
--
Daniel Kasak
IT Developer
NUS
and zero bugs, and progressively remove
features and add bugs, while decreasing the version number.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http
are used by a
application I don't want to break.
Is a solution without the need to change the tables ?
You won't break anything by adding a timestamp field. Trust us :)
And no, there is no way around this problem other than adding a
timestamp field.
--
Daniel Kasak
IT Developer
NUS Consulting
Andreas Moroder wrote:
Daniel Kasak schrieb:
Andreas Moroder wrote:
Hello,
when I open mysql table with access 97 using the latet mysql-odbc
driver ( 3.51.12 ) I see only deleted records.
What is happening ?
I found many posts about this problem, but I can not, as told in this
posts
?
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
the names that are connecting to it? (ie is
reverse dns set up properly).
Um. Don't know that one. I'll forward this off to their IT guy and see.
Thanks for the quick response :)
Dan
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T
to make sense ... apart from
the fact that this only seems to affect particular tables. But anyway,
I'll certainly DNS lookups for MySQL.
Thanks for your help.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F
launch
MySQL, but this kind of workaround is in most cases something to
avoid.
My advice: first of ALL, upgrade. Then, try again, if it fails, change
your backup tool, if you have any other issue, come back and we may
help.
Good luck.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN
. Remove the filename, or give it a full path.
Try this and let us know.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y
a simple application to monitor the error log file for
changes and check it to see if mysql was shutdown and/or started.
Accourding to the manual:
The error log file contains information indicating when mysqld was
started and stopped snip
--
Daniel da Veiga
Computer Operator - RS - Brazil
instead. Also, check this:
http://hackmysql.com/dns
Hope that helped.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y
or CTRL+ALT+DEL on windows.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE BLOCK--
--
MySQL General
STATSPACK of Oracle for MySQL.
Now I'm pretty sure there's no such thing for MySQL, but someone else
can point me wrong.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP
-constraints.html
Hope that helped.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE BLOCK--
--
MySQL
were trying to run both at once, which in my
opinion is a Bad Idea(tm).
What if each .sql contains a DROP TABLE IF EXISTS statement at the
start? Something to be carefull if its the program that generated the
backup likes to add this tags.
--
Daniel da Veiga
Computer Operator - RS - Brazil
On 8/4/06, Chris White [EMAIL PROTECTED] wrote:
On Friday 04 August 2006 10:35 am, Daniel da Veiga wrote:
What if each .sql contains a DROP TABLE IF EXISTS statement at the
start? Something to be carefull if its the program that generated the
backup likes to add this tags.
What if my website
/downloads/mysql/5.0.html
It wasnt that hard...
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE BLOCK
can also use the binlogs (if you have them).
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
--END GEEK CODE BLOCK
it at all. One with such a big scheme should have a
mirror, plus backups, just in case.
Personally I have daily backups, a slave mirror and another backup of
the backup files (network server with TSM backups).
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version
sort, then deal with the resultset, else it will
connect, and that's all. Maybe if you post the entire PHP code, along
with any error messages...
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X
are in luck.
If you are using MyODBC, then you will have to wait until the v5
connector is complete.
If you are using DBD::mysql, then I'd be interested to hear how it works
out - I'm about to start testing that in the next couple of days.
I don't know the status of the JDBC or PHP drivers.
--
Daniel
.
Nobody will do that, but you can jump for yourself for not googling
for ide scsi sata pata performance. ;) I'm just kidding.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS
(and no one
will EVER sign it, *lol*). SCSI has one more advantage I forgot to add
to my previous message, they can be arranged better in RAID with hot
swap. I can only tell about my company, where servers have all SCSI
disks (IBM, Dell).
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK
a version 4 server on the same machine). How
do I manually enable root access from remote machines as adding % into
the list of hosts for root does not seem to do anything in
Administrator?
grant all privileges on *.* to root@'%' identified by PASSWORD('password');
?
--
Daniel da Veiga
, because the database do not serve
the data, only the info about it. Anyway, its MHO.
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h
101 - 200 of 1312 matches
Mail list logo