Harald Fuchs wrote:
In article [EMAIL PROTECTED],
Daniel Kasak [EMAIL PROTECTED] writes:
Bryan Cantwell wrote:
Trying to migrate to MySql 5 from Sybase asa. I have a tables that
have column values that are calculated based on other columns in the
table. How can I accomplish the same
, so I can't help you with exactly how
to do 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 PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing
terminal?
The tables names are using latin carachters without exception, i
checked the tables but no error was there.
I have to SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; to skip THAT query.
Thanks for the help.
Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
modules.
Hopefully over Christmas I'll get time to finish it off.
Oh yeah ... did I mention that it's all cross-platform goodness? :) I've
tested on Linux, Windows 2000 and OS-X. You will of course need to
install Gtk2 for the last 2, but it's not that hard - at least on Windows.
--
Daniel Kasak
defense, it's not particularly hard
to do :) After you've written the report definition, you load an array
of data ( eg from a database query ), and pass it to PDF::ReportWriter.
There's a simple example on the webpage, along with a screenshot of the
output ( inside gpdf ).
--
Daniel Kasak
of if(), length(), locate() etc?
--
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
-and-time-functions.html
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Thanks :)
--
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
'%-.64s';
try to repair it' (1034), Error on slave: 'no error' (0)
My question is... what is that %-.64s table? How can i fix?
Thanks in advance.
Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Octavian Rasnita wrote:
From: Daniel Kasak [EMAIL PROTECTED]
OK then.
Lets re-word the question ...
Has anyone been able to successfully enter text of a non-standard
character set ( Latin 1, UTF8 ) into Query Browser?
How about upload via a Perl script?
Yes you can insert those
the data in ( query
browser / in-house Perl Gtk2 app ), the data *looks* perfect when I
paste it in, but when I return to look at it later it's corrupted.
Thanks for the reply, by the way :)
Dan
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW
DBD-mysql-2.9007, compiled against
mysql-5.0.something. I've got gtk+-2.8.6.
Anyone got any ideas? Is this a Gtk2 problem ( Query Browser and my app
are using Gtk2 ), or is it a driver issue, or a table issue?
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North
BÁRTHÁZI András wrote:
Hi Daniel,
I'm trying to copy paste some data from a web page into MySQL ( and
How do you mean pasting into MySQL? Which program do you use on the
destination side?
Query browser *and* an in-house Perl Gtk2 app both produce the same
results. I'm pretty sure I
is:
if ( condition, value_if_true, value_if_false )
You can also use 'case' statements:
case when condition then value_if_true else value_if_false end
Substitute your:
- condition
- value_if_true
- value_if_false
into the above syntax.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific
of thing a while ago:
http://bugs.mysql.com/?id=14307
Unfortunately it's been marked as 'not a bug', which I disagree with,
but since it's only a cosmetic problem in our case, I decided not to
throw any more energy at it. Feel free though ...
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5
than issuing separate inserts per record. You don't
want to include *too* many records at once - there's a maximum packet
size or something like that that you can't exceed.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2
solution is in
order?
--
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
OK then.
Lets re-word the question ...
Has anyone been able to successfully enter text of a non-standard
character set ( Latin 1, UTF8 ) into Query Browser?
How about upload via a Perl script?
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW
Well, off the top of my head, to achieve a local-forwarding, you'd do
something like:
ssh [EMAIL PROTECTED] -L arbitrary high port no:localhost:3306 -N
Remember, localhost is resolved after the tunnel is established, so
refers, actually, to the remote machine :) (The -N option simply
| | | -00-00
||
etc ...
Should I report 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 PROTECTED]
website: http
Jim Winstead wrote:
On Wed, Nov 09, 2005 at 02:06:59PM +1100, Daniel Kasak wrote:
Background on data:
mysql select ID, Loc_FK, BatchNo, EAPDate from EAPosting where Loc_FK=7249;
+---++-++
| ID| Loc_FK | BatchNo | EAPDate
I'm running MySQL (--ersion says mysql Ver 14.7 Distrib 4.1.10a, for
pc-linux-gnu (i686)) on a RedHat Enterprise ES Release 4 system. The datadir
was in it's own filesystem, mounted at /mysql, but it's now filled up (it's
a 15 GB partition and it has 1.5 MB free).
I shut down MySQL (did a
for status variables?
--
Martijn
Yes, bytes_sent and bytes_received are type unsigned long (4 bytes), so
max value is 4.2G.
-Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Michael Stassen wrote:
Daniel Bowett wrote:
Michael Stassen wrote:
Daniel Bowett wrote:
Peter Brawley wrote:
Dan,
/...Total sales for ever would be a simple GROUP BY query with a
sum on the sales - but I cant see how I am going to get this info.
Do I need to use nested queries? /
You
I am unsure how to write this query, can someone help?
I have two tables.
One has a list of retailers (tbl_retailer):
retailerid
name
postcode
e.g.
1 Sprocket Supplies CH23 4PY
The other has the sales by month for each retailer:
retailerid
month_2
sales
e.g.
1 2004-01 100
1
SUBSTRING(month_2,6,2)MONTH(NOW())
GROUP BY r.name;
PB
-
Daniel Bowett wrote:
I am unsure how to write this query, can someone help?
I have two tables.
One has a list of retailers (tbl_retailer):
retailerid
name
postcode
e.g.
1 Sprocket Supplies CH23 4PY
The other has the sales
Michael Stassen wrote:
Daniel Bowett wrote:
Peter Brawley wrote:
Dan,
/...Total sales for ever would be a simple GROUP BY query with a
sum on the sales - but I cant see how I am going to get this info.
Do I need to use nested queries? /
You don't need nested queries. It's a crosstab
.
3.51.06 worked well for me. Alternatively, you can track down 3.51.12 -
there was a link posted to it in the MyODBC mailing list. It also works
for me, but it's not actually released yet, so you might be better going
with 3.51.06.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77
learn to
use the binary log. As I noted before, the plain-text log has some
issues. I'm not sure what all of them are, but I've encountered issues
when using plain-text logs and temporary tables ( eg 2 users create
temporary tables - in the plain text log, it looks like the 1 user ).
--
Daniel
worked. Could anyone help me please?
Thanks in advance
Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
protection around
http://mail.yahoo.com
You damn well bet I'm tired of spam, current thread included.
--
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
way. There's also a plain-text log,
but you'll run into issues if you're using temporary tables, amongst
other things. Also, the plain text log has been removed from 5.0.x ( I
believe ). You can enable either with startup switches or with entries
in the my.cnf file.
--
Daniel Kasak
IT Developer
a new database and try to load the dump file:
mysql NEW_DATABASE db.sql -p
I get an error when I hit an InnoDB table that has a relationship set up
with a table that hasn't yet been created. How do I get around this?
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
by server; consider
upgrading MySQL client
have died down, *then* it's time to upgrade the server.
--
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
directory listings. I don't suppose there's a
Linux download yet?
--
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
Chris Ripley wrote:
What's a good (or best) field type for money or
currency data. Mysql doesn't have a MONEY type for
structure, so what would I have the best luck with?
double
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia
someone else recommend
that ... many years ago now.
--
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
under
graphical clients, but it's nowhere to be found.
--
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 get rid of those, my
question is HOW.
And I have thousands of rows like this and its just ONE field that's
the stumbling block.
Any suggestions ?
M i l e s.
replace()
eg:
update some_table set some_field = replace( my_field, Ò, O );
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level
What API are you using to call the SP from--PHP mysqli, Perl DBD-mysql,
etc.?
-Daniel
Jasper Bryant-Greene wrote:
I have a stored procedure defined as follows:
CREATE PROCEDURE `album`.`getUser`( IN userID INT )
READS SQL DATA
DETERMINISTIC
SQL SECURITY INVOKER
SELECT * FROM
Craig Hoffman wrote:
Anyone know a way to convert MS Access DB files (.mdb) into a format
MySQL can import? I'm on a Mac hence I don't have Access.
mdbtools: http://mdbtools.sourceforge.net/
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW
the online docs. It doesn't mention
anything about performance hits, so maybe it is the way to go. Start at
http://dev.mysql.com/doc/mysql/en/index.html to find more info.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922
key_buffer and 384M.
-Daniel
Matthew Lenz wrote:
so the sql-bench stuff doesn't push the mysqld to its limits?
- Original Message - From: Daniel [EMAIL PROTECTED]
To: Matthew Lenz [EMAIL PROTECTED]
Cc: mysql mysql@lists.mysql.com
Sent: Sunday, September 11, 2005 1:12 PM
Subject: Re: default
server, then optimize your queries.
-Daniel
Matthew Lenz wrote:
infact .. the default debian config (some of these are just explicit
defaults but this is what debian provides):
[mysqld]
user= mysql
pid-file= /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld
.
-Daniel
Scott Haneda wrote:
Unless I am totally off base here, the mysql docs tell very little in
regards to how to performance tune mysql.
So far I have found this article to help:
http://www.databasejournal.com/features/mysql/article.php/10897_1402311_3
But it still leaves me with a ton
, it will be well worth 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 PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives
... it would look interesting above
their 'Novell to Offer MySQL Network' news article :) Clearly one is as
newsworthy as the other.
--
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
MySQL
running? Can't figure out how to compile MySQL on SCO ... fine ...
download and install Linux, and get a Linux binary.
I suspect the deal has more to do with MySQL and SCO than with lowly users.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney
someone at MySQL
confirm this story and elaborate on the relationship?
For those who haven't been paying attention, SCO isn't exactly a model
corporate citizen. In fact, I would suggest that they are the antipathy
of a model corporate citizen.
Comments?
--
Daniel Kasak
IT Developer
NUS
.
--
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
Speaking of Perl scripts that do this: http://codenode.com/mysqlreport
I almost never use SHOW STATUS directly anymore since most the
values have to be transformed one way or another to really be meaningful.
-Daniel
Sid Lane wrote:
I don't know if you can do it directly in a mysql shell like
Hi all,
I'm trying to INSERT values inf or -inf into a field (double) in MySQL
version 4.1.13 but
it has not been possible. MySQL deny the insertion. Can anyone give me
any suggestions to
solving this problem ?
Thanks
--
/
(=\Daniel Guariz Pinheiro
\=)
/Laboratório de
a better idea though.
--
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
--
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
)
Is that user_account1.id field indexed?
show create table user_account1;
--
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
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
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
stable version to work
out-of-the-box with the latest stable MyODBC.
http://bugs.mysql.com/bug.php?id=2273
--
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
Timothy Smith wrote:
Hi, Daniel,
First, here's a trick that *should* work for dumping out the data.
Change directory to the MySQL data directory, and then use this little
shell command:
for d in mysql test; do (cd $d; tables=`/bin/ls -1 *.frm | sed -e s,\\.frm,,`;
mysqldump $d $tables); done
Fajar Priyanto wrote:
This is what I think hit me too, Daniel.
Unfortunately, it's not on my own server (a hosting provider), so my access to
the shell is very limited.
My website is still running, but, I can't export the database using phpMyadmin
anymore, because the troubled table
save the table one by
one as you suggested. I'll inform the result here.
Thanks.
That actually sounds nothing like the problem I'm having. I'm not
getting any 'in use' errors. Perhaps you have a different issue?
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
a zipped copy of my
/var/lib/mysql folder or something, since mysql isn't too keen on giving
up any data voluntarily.
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
.
http://papyrus.treshna.com/
--
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
MySQL and DNS can be such a fun issue because it comes
suddenly and leaves just as suddenly with --skip-name-resolve.
For in-depth info on how MySQL uses DNS, and info about
this potential DNS-related bug: http://codenode.com/mysql/dns
-Daniel
-Original Message-
From: Ben Clewett
This forum has been very helpful.
There is always somebody that is willing to respond to queries.
Does anybody know of a good Oracle forum?
TIA
Dan
that if it was already set at the global level then it would
not be set at the session level (after the show variables). But that
didn't help.
Thanks,
Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
guess my next step is to try and find out why
coldfusion mx 7 is issuing them to MySQL when using MyISAM tables.
Thanks,
Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
...
-bruce
[EMAIL PROTECTED]
You're *far* better off putting everything in one table and using a
field in the table, for example CollegeID, to identify which column
you're dealing with.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T
if everything was in 1 table.
Seriously, put everything in 1 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
Scott Haneda wrote:
I am using 4.0.18-standard
So I do not have `DATEDIFF`, but I need to ability to do so, anyone know
some other simple trick to get days between two dates?
to_days(SomeDate) - to_days(SomeOtherDate)
will give you the number of days between the 2.
--
Daniel Kasak
:
ERROR at line 895: Unknown command '\''.
The line looks properly escaped to me. Should I file a bug report?
--
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
Daniel Kasak wrote:
The data has a field which has some quotes in it. The field looks like
this ( all quotes included ):
'' ''
ie 2x single quotes, a space, and 2x single quotes.
Don't ask me why. I didn't put it there. Anyway, mysqldump has packaged
this field as follows
a new
mysqldump file, and see if the problem persists. If it does, I'll be
back, and I won't destroy the evidence this time...
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
to talk to the new server?
I'm not really up to compiling things on Windows.
--
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
comfortable using such a new version of
php on a production server ... especially when it's someone else's server.
It would be simply lovely if I could just grab some mysql dlls ( offical
if possible ), and then use them with the official MySQL PHP binaries.
--
Daniel Kasak
IT Developer
NUS
the client
libraries are sorted out. While I'm at it, perhaps I should go all-out
and move back to 3.x? Hang on while I roll my eyes towards the sky ...
Thanks for your help anyway.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T
. But if you don't post
*details* to the list, how are people supposed to know what you're doing?
--
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
actual
details.
--
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
I'm missing something, here; what earthly good is there, in having two fields
in the same tuple being created so that they both automatically store exactly
the same data... and if it was valuable, is there no way of more reliably
building this behaviour into the external application?
Okay, so
to the new MySQL database *before* doing the actual
migration. When everything appears to looks OK, truncate all the MySQL
tables, backup the SQL Server database, and do the actual migration.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
on. And
how well or not do the resolvers in /etc/resolv.conf on the master
server resolve the problematic slave's IP address, reverse and
forward? Is the problem slave the one on the different network?
-Daniel
-Original Message-
From: Michael Brown [mailto:[EMAIL PROTECTED]
Sent: Thursday, June
use
it, trying forcing it to at least see what affect it has, like
... FROM helpdesk_tickets ht FORCE INDEX (comp_master_ticket), ...
-Daniel
-Original Message-
From: Terence [mailto:[EMAIL PROTECTED]
Sent: Sunday, May 29, 2005 9:12 PM
To: mysql@lists.mysql.com
Subject: Re: performance
?
Thank you,
Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is there a composite index on (master_id, ticket_id)? Since your queries
are selecting on a particular master_id, and ordering by ticket_id, along
with the limit I think MySQL would be able to use such an index in an
optimization.
-Daniel
-Original Message-
From: Terence [mailto:[EMAIL
conditions, and builds
the final result set as it goes.
-Daniel
On Wed, 2005-05-25 at 21:01 -0700, James Tu wrote:
What does MySQL do internally when you perform a LEFT JOIN?
Let's say you have two tables:
Table A has 1,000,000 rows
Table B has 5,000 rows
When you perform the following LEFT
compiled with gcc-4.0,
perhaps you should do a Gentoo install using gcc-4.0 and pave the way
for the rest of us :)
--
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
My problem is the following and I thank you in advance on any help
offered. Show Innodb Status shows that my DB server has no free
buffers. What is the significance of this, what causes this, and how
bad is it?
Here is the relevant part of the output of that command:
BUFFER POOL AND MEMORY
.
HTH
Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, the problem wouldn't arise.
Furthermore, auto_increments are just integers: there is very little overhead
involved in handling them. Real data is usually either more complex, or is
apt to become so at some point in the future.
Daniel Walker
--
MySQL General Mailing List
For list archives: http
As for your second question, SELECT INTO OUTFILE (making sure mysql user has
write privileges in the directory/file you want to write to).
MySQL give the example:
SELECT a,b,a+b INTO OUTFILE '/tmp/result.text'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY ''
LINES TERMINATED BY '\n'
FROM
performance, you need scsi. However,
If you just WANT good performance but are remotely concerned about
price, consider SATA.
When you have to have performance, you have to have SCSI ... plain and
simple. Just my two cents.
Daniel
On 5/12/05, Larry Lowry [EMAIL PROTECTED] wrote:
We have been using
the auto_increment primary key.
--
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
, such as an unsigned int or a
bigint.
--
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
, Windows and OS X. TheKompany is a
pretty good company ... as far as companies go ... I have no problem
recommending them. They're quite open-source friendly.
Otherwise DBDesigner may or may not do what you want:
http://www.fabforce.net/dbdesigner4/
I've only toyed with it briefly.
--
Daniel Kasak
' everything is OK, or dump, restore from a backup, and
process the transaction log?
--
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
using Access you can of course set
up a query chain as in your example. But if you're using 'pure'
MySQL-4.0.x, you'll have to make a temporary table from the 1st query,
and then run your second query against this temp table.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific
a unique index across them.
--
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 in the next release of 5.X.X.
This does not help as I am stuck with 4.0.X right now.
How can I fix this ?
Michael
Is the server crashing? What does your error log say? If you're using
4.0.x, then my first hunch would be table corruption. Have you checked
for that yet?
--
Daniel Kasak
Have a query that consists of 10 unions. For a period of time it will
constantly return with an error 12. Moments later it might actually
work once or twice. I can find nothing in any logs or whatever. The
odd thing is that when it isn't working, simply reducing the unions to 8
or less
or otherwise. One capable of inserting a row in a table
based on some other row by storing only the fields that differ between the
two, and ideally performing diffs between large text fields. Any clues ?
Thank you,
Daniel
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED
to issue the query from the same connection as when the
query was originally 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: http
installation. It's not MySQL-specific, but there are some tutorials
around demonstrating some graphs based on data from MySQL.
I'm sure there are Perl libraries that also do graphing, but I've never
been bothered to research to much - they'd have to be good to surpass
JpGraph.
--
Daniel Kasak
301 - 400 of 1312 matches
Mail list logo
