Re: select query taking too long

2005-10-19 Thread Michael Dykman
I"m a little confused by the query you posted.. it looks like it would work, although with many redundant subqueries to get there. From your requirement, I don't understand why you needs to wrap it in a self- referencing subquery.. Why does this not give you the same logical value? selec

Re: script error in program.

2006-01-11 Thread Michael Dykman
are correct... there are always a million things that could go wrong at runtime. Each of those php mysql_XXX calls will return a null or false on failure .. if you check every time you will save yourself a lot of hassle in the long run, - michael dykman - [EMAIL PROTECTED] On Thu, 2006-01

Re: REPOST: ON DUPLICATE failure

2009-01-21 Thread Michael Dykman
subsequent run of the insert statement. I thought this odd as I only ran the same statement repeatedly leaving me with one row ever, but the value updated just fine. - michael dykman On Wed, Jan 21, 2009 at 10:54 PM, Ashley M. Kirchner wrote: > > Anyone? > > > I'm trying

Re: Are dates stored as String? Or Integer?

2009-01-27 Thread Michael Dykman
/en/date-and-time-types.html You may also save considerable space.. from http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html DATE3 bytes TIME3 bytes DATETIME8 bytes TIMESTAMP 4 bytes YEAR1 byte - michael dykman On Wed, Jan 28, 2009 at 12:31 AM, mos wrote

Re: Are dates stored as String? Or Integer?

2009-01-27 Thread Michael Dykman
e going to squeeze out any performance benefit by converting to int.. you might even lose some ground to the special handling your date-as-int your app might have to do. - michael dykman On Wed, Jan 28, 2009 at 1:30 AM, mos wrote: > At 11:43 PM 1/27/2009, Michael Dykman wrote: >> >&g

Re: Curious Error, anyone have a guess?

2009-02-07 Thread Michael Dykman
o any arbitrary string, so it si inevitable that you will get unsafe input sooner or later. - michael dykman On Sun, Feb 8, 2009 at 12:31 AM, wrote: > Hello mysql, > > On one of my sites, I have a query that logs attempts to access the > site by potential bad guys. It has been working for

Re: What ever happened to NitroEDb engine for MySQL

2009-02-08 Thread Michael Dykman
gt; can I expect it? TIA >> > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com > > -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some

Re: What ever happened to NitroEDb engine for MySQL

2009-02-08 Thread Michael Dykman
y different than the operational business data which is the backbone of our day-to-day business. - michael dykman On Sun, Feb 8, 2009 at 5:51 PM, mos wrote: > At 11:14 AM 2/8/2009, Michael Dykman wrote: >> >> We recently began using infobright in my shop.. reporting queries >&g

Re: mysql optimization tips

2009-02-10 Thread Michael Dykman
Can anyone help me suggest the right optimization for our company's server. > > I suggest High Performance MySQL, Second Edition :-) There's no way > to really give any good advice without knowing what you use the server > for. > I enthusiastically second that recommenda

Re: how to deal with multiple authors for one book

2009-02-16 Thread Michael Dykman
ur ordinal field (I use 'ordinal' by convention as 'order' is a SQL keyword) AUTHORS - authorid - name -- other fields BOOKS - bookid - title -- other fields A2B - bookid - authorid - ordinal -- - michael dykman - mdyk...@gmail.com - All models are wrong. Som

Re: how to deal with multiple authors for one book

2009-02-16 Thread Michael Dykman
On Mon, Feb 16, 2009 at 8:37 PM, PJ wrote: > Michael Dykman wrote: >> On Mon, Feb 16, 2009 at 5:20 PM, PJ wrote: >> >>> In my db there are a number of books with several authors; so, I am >>> wondering how to set up a table on books and authors to be able to >

Re: Best RAID for a DB + LVM?

2009-02-22 Thread Michael Dykman
I work for a high-volume web site and we use nothing but RAID 10 on all databases which requires a minimum of 4 disks. The write penalty for raid 5 is just too high for our application. Much of that space goes unused, but we need the stripe to keep up with the I/O. - michael dykman On Sun

Re: insert question

2009-02-24 Thread Michael Dykman
7;2')"; >$result2 = mysql_query($sql2, $db); > $sql2 = "INSERT INTO authors (first_name, last_name, ordinal) VALUES ('$first_nameIN', '$last_nameIN', '1'), ('$first_name2IN', '$last_name2IN', '2

Re: MySQL Log and Data directories

2009-03-04 Thread Michael Dykman
tion logs onto separate spindles.. Separate partitions on the same physical device will be of little-to-no-value. For systems like Oracle or DB2, this is part of the standard installation drill. ON MySQL, I do not do this routinely, but I do when I am expecting high, sustained loads, -- - mi

Re: Upgrade large databases from 4.1 to 5.1

2009-03-24 Thread Michael Dykman
changes along the way using a similar slave-driven, process-as-much-as-you-can-in-advance plan. It was excruciating, but we pulled it off. - michael dykman On Tue, Mar 24, 2009 at 9:38 AM, Craig Dunn wrote: > Baron Schwartz wrote: >> >> If you can't take downtime, I&

Re: MySQL - facts

2009-03-31 Thread Michael Dykman
ing your report. -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Include SQL files

2009-04-01 Thread Michael Dykman
No include is possible, but this is done pretty routinely: cat *.sql | mysql ... - michael dykman On Wed, Apr 1, 2009 at 10:19 AM, Jørn Dahl-Stamnes wrote: > Hello, > > After googling for an hour I gave up to find a solution. > > Problem: A framework is creating a lot of SQL

Re: binlog question

2009-04-18 Thread Michael Dykman
No, I'm afraid not. - michael dykman On Sat, Apr 18, 2009 at 7:11 AM, Uwe Kiewel wrote: > Hi, > > is it possible to have separated binlogs for each mysql-db? > > Thanks, >Uwe > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.

Re: binlog question

2009-04-18 Thread Michael Dykman
for binlog-do-db - michael dykman On Sat, Apr 18, 2009 at 12:10 PM, Uwe Kiewel wrote: > Michael Dykman schrieb: >> >> No, I'm afraid not. > > So, how it's possible to replicate one specific db? I have 4 db's writing > into binlog. I need only one of th

Re: size of database on disk

2009-04-27 Thread Michael Dykman
ommand: SHOW TABLE STATUS; I hope this helps. -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: How to generate unique primary key in MySQL?

2009-04-27 Thread Michael Dykman
ed ie. SELECT uuid(); and produces a guaranteed unique 36 character sitrng, but this might not be very efficient in joins as your dataset grows. - michael dykman On Tue, Apr 28, 2009 at 12:59 AM, yuan edit wrote: > I have a shopping cart table like this: > > CREATE TABLE shopping_cart

Re: How to generate unique primary key in MySQL?

2009-04-28 Thread Michael Dykman
want to display it format it for display using LPAD. ie.: mysql> SELECT lpad(5,8,'0'); +---+ | lpad(5,8,'0') | +-------+ | 0005 | +---+ -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some models are useful.

Re: expired mysql connection ?

2009-05-04 Thread Michael Dykman
me restart after the shutdown event or did it stay stopped? If it did restart, was your perl program able to recognize that and start using it again or did your application stop on first detecting that error? - michael dykman On Sun, May 3, 2009 at 11:21 PM, Randomcoder wrote: > Hi, > > I run

Re: Creating a New DB / User

2009-05-13 Thread Michael Dykman
Your directive looks fine assuming dublin expects to always connect from localhost. One thing though: your user does not need the 'WITH GRANT OPTION' bit as that gives them permission to gratn permissions to other users, which I don't think is what you want. - michael dykman

Re: How to copy an statement in Mysql console

2009-05-14 Thread Michael Dykman
7;, 'Mr', 345 987 5500) > in the MySql console in order to avoid typing it each time you want to fill > a new record. > I tried to right click my mouse,it doesn't select what I need to highlight. > > Please,any advice is welcome. What you have at the console is his

Re: Large insert question

2009-05-20 Thread Michael Dykman
d the size of the data per connection.  Anyone know what setting I > need to tweak to ensure that it can accept large inserts of this size? > > Thanks, > > Gary As I recall, max_allowed_packet is what controls that limit. -- - michael dykman - mdyk...@gmail.com - All models a

Re: cannot alter table - rather urgent

2009-05-21 Thread Michael Dykman
need a little more information. The table looks sound but is clearly designed to link 2 other tables. If you are failing to insert or update, it seems likely that it is because the data is absent in the foreign tables. Can you confirm? Because without that forgeign data, these rows are pretty meaningl

Re: cannot alter table - solved

2009-05-22 Thread Michael Dykman
On Fri, May 22, 2009 at 12:26 AM, PJ wrote: > Michael Dykman wrote: >> On Thu, May 21, 2009 at 11:06 PM, PJ wrote: >> >>> I have a seemingly impossible situation. I cannot insert values into the >>> tables and I cannot alter or delete the primary key (which sh

Re: Date Time

2009-05-22 Thread Michael Dykman
+0700). I don't think you do. You would have to get your application to parse out the date into something that MySQL can negotiate. The only reason this works at all in your case is because you happen to have + which we can safely ignore. -- - michael dykman - mdyk...@gmail.com - A

Re: cannot alter table - solved

2009-05-22 Thread Michael Dykman
, 2009 at 3:17 PM, PJ wrote: > Michael Dykman wrote: >> On Fri, May 22, 2009 at 12:26 AM, PJ wrote: >> >>> Michael Dykman wrote: >>> >>>> On Thu, May 21, 2009 at 11:06 PM, PJ wrote: >>>> >>>> >>>>> I have a seemingly i

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Michael Dykman
 I > don't see a need to run mysql_fix_privilege as I manually copied the > necessary privilege data. > > > /Per Jessen, Zürich > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:    http://lists.mysql.com/mysql

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Michael Dykman
PM, Per Jessen wrote: > Per Jessen wrote: > >> Michael Dykman wrote: >> >>> Have you tried running the offending SQL manually against you new >>> installation?  Does it come back clean in the isolated case? >> >> No, not manually, but the job/the SQL is

Re: mysql error 2013 Lost connection to MySQL server during query

2009-05-25 Thread Michael Dykman
that would have reacted. - michael On Mon, May 25, 2009 at 12:19 PM, Per Jessen wrote: > Michael Dykman wrote: > >> Given the new hardware, I'm now suspecting the RAID controller. I have >> seen misconfigured RAIDs or bad RAID drivers take out a server in just >>

Re: Create function ignore deps

2009-05-27 Thread Michael Dykman
.sql ... and then wrote a shell script to fire them off in sort-order. I deliberately used the numbering convention from line-numbered basic to allow me to inject intervening files without having to renumber the set. -- - michael dykman - mdyk...@gmail.com - All models are wrong. Some mode

Re: Mysterious progress after recovery in MySQL Community Edition 5.1.34

2009-06-12 Thread Michael Dykman
[Note] Event Scheduler: Loaded 0 events > 090612 11:07:25 [Note] /usr/sbin/mysqld: ready for connections. > Version: '5.1.34-community-log'  socket: '/var/lib/mysql/mysql.sock' port: > 3306  MySQL Community Server (GPL) >  2 3 4 5 6 7 8 9 10 11 12 13 14 1

Re: how to get the timestamp from remote mysql

2009-07-04 Thread Michael Dykman
but it will work - michael dykman On Sat, Jul 4, 2009 at 2:48 AM, Nathan Huang wrote: > Hi guys > I am going to fetch out the data from remote mysql database according to > timestamps colmmen, however my local date is different from the one on > remote mysql database, > how can I g

Re: show warnings;

2009-07-13 Thread Michael Dykman
be guaranteed of consistent behaviour, explicitly ask for what you want. - michael dykman On Mon, Jul 13, 2009 at 8:20 PM, Artie Ziff wrote: > Hello, > > I am returning to mysql after long break, so not experienced with > details. I inherited a text file with the mysql DDL stat

Re: Date Translation Issues

2009-07-14 Thread Michael Dykman
0 |    742892 | NULL    | > ++---+-+---+-++---+-++-+-------+-+--+--+++---+--+--+--+---+

Re: Update Syntax

2009-07-26 Thread Michael Dykman
you that if you create a unique key for when ever your 'search' criteria is, you can get this behaviour like so: INSERT INTO mytable SET col1 = val1, ... ON DUPLIATE KEY UPDATE - michael dykman On Sun, Jul 26, 2009 at 1:11 PM, Victor Subervi wrote: > Hi; > I would like to te

Re: Does InnoDB ever not cluster data by primary key?

2009-07-30 Thread Michael Dykman
we'll see a lot of ordered bulk inserts. > > It ran counter to the results that we were seeing so I had to verify > that InnoDB always clusters by primary key regardless of the position > of the auto increment column in the primary key. > Kyong > > On Thu, Jul 30, 2009 at 7

Re: Mysql batch file help

2009-08-08 Thread Michael Dykman
>> >> > > -- > - > Johnny Withers > 601.209.4985 > joh...@pixelated.net > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:    http://lists.mysql.com/mysql?unsub=mdyk...@gmail.

Re: mysqldump warning or actual error?

2009-09-02 Thread Michael Dykman
If you look at the options for mysqldump more closely, you will see that you can specify the version of the server which will be importing the result file. These cause MySQL to taylor the SQL syntax according to the target platform. - michael dykman On Wed, Sep 2, 2009 at 11:03 AM, Matt

Re: HOW TO Backup a mysql innodb on windows?

2009-09-14 Thread Michael Dykman
If I may, If you have foreign keys on your InnoDB, you can still import your data to MyISAM but foreign keys will be lost. Otherwise, the data will load just fine. - michael dykman On Mon, Sep 14, 2009 at 11:14 AM, Todd Lyons wrote: > On Mon, Sep 14, 2009 at 7:44 AM, Néstor wrote: >&

Re: HOW TO Backup a mysql innodb on windows?

2009-09-14 Thread Michael Dykman
A mysqldump will work just fine. By default, that dump is going to explicitly specify the table type .. you will have to edit it if you want to import to MyISAM. - michael dykman On Mon, Sep 14, 2009 at 10:44 AM, Néstor wrote: > Maybe one of you experts know the answer. > > I have

Re: incremental name search?

2009-09-21 Thread Michael Dykman
Perhaps this could help you out.. http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_soundex - michael dykman On Mon, Sep 21, 2009 at 11:51 AM, Mike Spreitzer wrote: > Suppose I have a table of a few thousand people, with a FirstName field > and a LastName field.

Re: Correct way to start new .MYD & .MYI files

2009-09-25 Thread Michael Dykman
> > Thx again > > -Original Message- > From: Michael Dykman [mailto:mdyk...@gmail.com] > Sent: Friday, September 25, 2009 3:42 PM > To: Jones, Keven > Subject: Re: Correct way to start new .MYD & .MYI files > > If you are prepared to accept that any data ass

Re: Correct way to start new .MYD & .MYI files

2009-09-25 Thread Michael Dykman
 me."   Winnie the Pooh > http://blog.imabug.net/ > PGP KeyID = 0x1F9779FD, 0x319393F4 > PGP keys available on request         ICQ 3113529                 O- > --------- > > On 09/25/2009 04:04 PM, Michael Dykm

Re: login issue..pls help

2009-10-02 Thread Michael Dykman
action Engines > > http://dev.mysql.com/doc/refman/5.1/en/storage-engine-compare-transactions.html > > -- - michael dykman - mdyk...@gmail.com Don’t worry about people stealing your ideas. If they’re any good, you’ll have to ram them down their throats! Howard Aiken -- MySQL Genera

Re: No tuples, but AttributeError about tuple!

2009-10-04 Thread Michael Dykman
This looks like much more of a python question than a MySQL question.. I'll reply offline. - michael dykman On Sun, Oct 4, 2009 at 2:04 PM, Victor Subervi wrote: > Hi; > I have the following python code: >      sql = 'insert into products values(%s, %s, %s, %s, %s, %s, %

Re: [OT] Suggestion of query manager

2009-10-12 Thread Michael Dykman
kp5.png > > Thanks! > > -- > Marcelo de Assis > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:    http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com > > -- - michael dykman - mdyk...@gmail.com Don’t

Re: mysqldump Unknown command '\''.

2009-10-14 Thread Michael Dykman
mysqldump is by no means the fastest way to move data between systems. For a bulk job of this magnitude, try this: http://dev.mysql.com/doc/refman/5.1/en/load-data.html - michael dykman On Wed, Oct 14, 2009 at 3:59 AM, Claudio Nanni wrote: > We dumped a mysql 4.1.22 database using

Re: Mysql service will not stop

2009-10-14 Thread Michael Dykman
Brian, You could spend a lot of time crawling through version release notes looking for something which might refer to your issue, or you might just upgrade to 5.0.86-0 which is the latest 5.0. There have been close to 2 years worth of bug-fixes since 5.0.51a - michael dykman On Wed

Re: MySQL Cluster / NDB & MyISAM mix

2009-10-14 Thread Michael Dykman
I can think of no reason why this shouldn't work, My administrator colleagues would probably beat me with 2x4's for handing them such a delicate construct to maintain in production but it seems perfectly feasible to me :-) - michael dykman On Wed, Oct 14, 2009 at 11:03 AM, Christian

Re: Inserting csv

2009-10-15 Thread Michael Dykman
If you could show us the table structure (SHOW CREATE TABLE membership), we could easily correctly the query.. you seems to have some data among your field names... If the question is about the CSV converter, you will have to ask them. - michael dykman On Thu, Oct 15, 2009 at 11:26 AM

Re: Inserting an Image

2009-10-15 Thread Michael Dykman
Victor, again, your question has more to do with python usage than MySQL per-se.. you would be better off pursuing these questions in a python forum. - michael dykman On Thu, Oct 15, 2009 at 3:28 PM, Gavin Towey wrote: > "Image in string form"  sounds like you're not ins

Re: Error - "Select Column Not Found Within Trigger"

2009-10-17 Thread Michael Dykman
LL default '0', >  `rep_id` int(11) NOT NULL default '0', >  `description` text collate utf8_bin NOT NULL, >  PRIMARY KEY  (`line_number`) > ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;  - michael dykman On Sat, Oct 17, 2009 at 2:20

Re: Passwords not working

2009-10-19 Thread Michael Dykman
your network setup? Not the safest of practices, but for dev accounts, I usually create one for user@'%' and sometimes one one for u...@localhost if needed and that works very well for me.. - michael dykman On Mon, Oct 19, 2009 at 7:30 PM, John Oliver wrote: > I have a probl

Re: START TRANSACTION COMMIT ROLLBACK

2009-10-27 Thread Michael Dykman
That is correct. Many db interfaces off programmatic abstractions of these facilities, but you may certainly just issue the statments. START TRANSACTION INSERT that UPDATE that on success: COMMIT on error: ROLLBACK - michael dykman On Wed, Oct 28, 2009 at 12:07 AM, Mosaed AlZamil wrote

Re: START TRANSACTION COMMIT ROLLBACK

2009-10-28 Thread Michael Dykman
that >> >>   on success: COMMIT >> >>   on error: ROLLBACK >> >>   - michael dykman >> >> >> >>   On Wed, Oct 28, 2009 at 12:07 AM, Mosaed AlZamil >> wrote: >> >>     Hello Everyone, >>     I am a newbie using i

Re: help with group by

2009-10-28 Thread Michael Dykman
| smccoy      | Computer Software   |       15 | > | smccoy      | Networking          |        4 | > | smccoy      | New User            |        1 | > | smccoy      | Printer             |        2 | > | smccoy      | Server              |        4 | > | sokolsky    | Computer Software   |        1 | > | sokolsky    | Telep

Re: Choose certain columns in mysqldump?

2009-10-29 Thread Michael Dykman
structure via LOAD INFILE http://dev.mysql.com/doc/refman/5.1/en/load-data.html - michael dykman On Thu, Oct 29, 2009 at 1:09 PM, Brian Dunning wrote: > Sorry if this is a n00b question, I did read the docs for mysqldump before > posting, but couldn't figure it o

Re: insert .. values('OH'No')

2009-10-30 Thread Michael Dykman
generally used. python appears to use prepared statements under the covers.. it provides an similar facility, at any rate. What are you working in? - michael dykman On Fri, Oct 30, 2009 at 12:06 PM, Sydney Puente wrote: > Hello, > > I am populating mysql with data, from an extern

Re: insert .. values('OH'No')

2009-10-31 Thread Michael Dykman
as values in SQL statement.. I don't know the name of that function off the top of my head, but I"m pretty sure 'escape' is the keyword. - michael dykman On Sat, Oct 31, 2009 at 7:29 PM, Sydney Puente wrote: > Thanks michael, > > Good question/observation - I

Re: Raid level suggestions for mysql-server

2009-11-02 Thread Michael Dykman
needs, often leaving a lot of unused raw storage space. The system was usually deployed on a single disk, being more-or-less static and easily reproducible.. Once you are booted and primed, the system disk barely gets touched.. all the important stuff is in RAM. - michael dykman On Sun, Nov 1, 20

Re: missing ttydefaults.h

2009-11-04 Thread Michael Dykman
Let me guess, you are doing a source build on a linux box? Have you installed the kernel headers? - michael dykman 2009/11/4 Martin Gainty : > > In file included from readline.c:54: > readline/readline.h:70:29: sys/ttydefaults.h: No such file or directory > > any clue whe

Re: Alphabetical search to and from

2009-11-04 Thread Michael Dykman
> Konkurs: Wygrywaj nagrody z Pudzianem! > Sprawd¼ >> http://link.interia.pl/f240e > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:    http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com > >

Re: Alphabetical search to and from

2009-11-04 Thread Michael Dykman
> You're right on one hand. But on the another in some languages you have a > more characters after the Z letter. > Apart from that try this: > > select 'F' as test > union > select 'FAA' > order by test; > > and you'll see: > > test &

Re: CONNECTION_ID() and Threads

2009-11-04 Thread Michael Dykman
connection and then have a closer look at whatever component is managing that.. apparently, its' doing it wrong. - michael dykman On Wed, Nov 4, 2009 at 10:36 AM, Tompkins Neil wrote: > Hi > > Thanks for your quick response.  In our test environment running MySQL > 5.1.31

Re: trigger

2009-11-04 Thread Michael Dykman
Well you might need to parenthesize the expression, but note that simple integer math done on a DATE or DATETIME, the units are days. you probably want ... where first_seen < (NOW() - 5); michael dykman On Wed, Nov 4, 2009 at 2:28 PM, Stefan Onken wrote: > Hello, > > I am

Re: CONNECTION_ID() and Threads

2009-11-05 Thread Michael Dykman
y behviours of the connection manger that are giving you trouble, then you will have to look at however that is configured.. in your case, that is an ASP/.net matter and you should consult the gurus there. - michael dykman On Thu, Nov 5, 2009 at 5:42 AM, Tompkins Neil wrote: > Thanks for

Re: Finding users who haven't posted in a week

2009-11-08 Thread Michael Dykman
the function max(), among others, makes no sense in the absence of a GROUP BY clause. try adding "GROUP BY user_id" - michael dykman On Sun, Nov 8, 2009 at 9:40 AM, John Meyer wrote: > I want to get a list of all users who haven't posted in a week. But when I > use t

Re: DROP TABLE TOOK 39MIN

2009-11-09 Thread Michael Dykman
Under InnoDb, you could use file-per-table which would have significantly reduced the inter-dependencies.. given the large data size and heavy I/O you report, it might be a wise way to go. - michael dykman On Mon, Nov 9, 2009 at 3:41 AM, Johan De Meersman wrote: > Presumably because you

Re: storage difference in VARCHAR(size)?

2009-11-10 Thread Michael Dykman
nce it goes above 255 because of the length, but is there a storage > difference between VARCHAR(100) and VARCHAR(255)?  Obviously there's a > functional difference in what gets cut off when I try to store into that > table, but is that the only difference? > > Thanks for

Re: Query!

2009-11-17 Thread Michael Dykman
ng up database access pretty good. OR have the external updating process record a log of changes to a particular table, then you monitor thread can scan that table for new entries. - michael dykman On Tue, Nov 17, 2009 at 7:06 AM, Gaurav Nigam (TMP-Japan) wrote: > Can somebody ple

Re: MySQL being hacked with commands through URL

2009-11-18 Thread Michael Dykman
* > *Please block this account's access to the     * > *internet until its cleaned up.  We are basing * > *this on an analysis of the header NOT the FROM* > *address.                                      * > &

Re: Rename Database - Why Would This Not Work?

2009-11-22 Thread Michael Dykman
whole list in here, the whole statement will be applied to the system atomically meaning all changes logically take place at the same time. I have done this under 4.1 at an industrial level.. works like a charm for any table type I tried. - michael dykman On Sun, Nov 22, 2009 at 3:01 AM, Rob

Re: MySQL Performance with large data

2009-11-24 Thread Michael Dykman
queries (not to mention expected performance targets) but 4x64 CPUs churning that kind of data could really take advantage of a lot more RAM. - michael dykman On Tue, Nov 24, 2009 at 12:25 PM, Johan De Meersman wrote: > First off, for 4.000.000.000 records at 1867 byte per record, you'

Re: How to concatenate a constant to an int?

2009-11-24 Thread Michael Dykman
; > Any ideas? > > Thanks, >        Neil > > -- > Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net > Host Joomla!, Wordpress, phpBB, or vBulletin for $25/mo > Unmetered bandwidth = no overage charges, 7 day free trial > > > -- > MySQL General Mailing List >

Re: How to concatenate a constant to an int?

2009-11-24 Thread Michael Dykman
ct_id = l.client_id > > Any ideas how to do this? > > Thanks >        Neil > > -- > Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net > Host Joomla!, Wordpress, phpBB, or vBulletin for $25/mo > Unmetered bandwidth = no overage charges, 7 day free trial > &

Re: Are you serious? mySQL 5.0 does NOT have a RENAME DATABASE?

2009-12-11 Thread Michael Dykman
on of this table always exists: RENAME TABLE active.geo to archive.geo, standby.geo to active geo; - michael dykman On Fri, Dec 11, 2009 at 8:58 AM, Johan De Meersman wrote: > On Fri, Dec 11, 2009 at 1:56 PM, Ken D'Ambrosio wrote: > >> > rename table olds

Re: Stored Proc's

2009-12-11 Thread Michael Dykman
am here asking :) > > Thanks in advance! > > Steve Staples. > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:    http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com > > -- - michael dykman - mdy

Re: Are you serious? mySQL 5.0 does NOT have a RENAME DATABASE?

2009-12-11 Thread Michael Dykman
command would have the same limitations. - michael dykman On Fri, Dec 11, 2009 at 11:35 AM, Jim Lyons wrote: > Can you use that syntax if the databases are on different file systems?  If > you can, and the original table is big, the command would take a while as it > moved data from one fi

Re: Stored Proc's

2009-12-11 Thread Michael Dykman
Yeah, that's exactly right You can also do some partials like 'user'@'192.168.2.%' - michael dykman On Fri, Dec 11, 2009 at 11:33 AM, Steven Staples wrote: > They are actual IP's, not domain names. > > So it would be like `us...@`192.168.0.100` and `

Re: Are you serious? mySQL 5.0 does NOT have a RENAME DATABASE?

2009-12-11 Thread Michael Dykman
. Depending on how your data is stored, it might now be 'quite' as simple as a unix 'mv' command.. if this is a production system, I would recommend you do a dry run with a replicant/slave. No amount of theorizing will tell as much as the experiment. - michael dykman On Fri,

Re: Help saving MySQL

2009-12-12 Thread Michael Dykman
more important than it is today! - michael dykman On Sat, Dec 12, 2009 at 5:29 PM, Michael Widenius wrote: > > Subject: Help saving MySQL from Oracle! > > I, Michael "Monty" Widenius, the creator of MySQL, is asking you > urgently to help save MySQL from Oracle&

Re: Help saving MySQL

2009-12-13 Thread Michael Dykman
ve this in the hands of the highest bidder? - michael dykman On Sun, Dec 13, 2009 at 11:23 AM, Neil Aggarwal wrote: > Doug: > >> I do not >> see anyone willing to put up anything to support mysql... you >> don't like >> it... put up a billion dollars an take contr

Re: Help saving MySQL

2009-12-14 Thread Michael Dykman
Thank you John, You have hit on my point exactly. There are thousands on companies and 100's of thousands of jobs which are owed to this product. That is what we are defending. - michael dykman On Mon, Dec 14, 2009 at 4:27 AM, John Daisley wrote: > >  Claudio Nanni wrote: &

Re: copying a static table

2009-12-17 Thread Michael Dykman
n but significantly similar. Lock the tables and rsync again; the second time is MUCH faster and the result is correct. Against a 'quieted' MyISAM table, your technique sounds fool-proof. Of course, test your resulting tables before you commit to anything. - michael dykman On Thu, De

Re: last_insert_id

2009-12-27 Thread Michael Dykman
last_insert_id() returns the last id auto-incremented in *the current session*. If you disconnect and reconnect, it can not be retrieved. - michael dykman On Sun, Dec 27, 2009 at 11:42 AM, Victor Subervi wrote: > On Sun, Dec 27, 2009 at 11:27 AM, Mattia Merzi wrote: > >> 2009/

Re: Is there a better way than this?

2009-12-28 Thread Michael Dykman
Gavin, very nice, - michael dykman On Mon, Dec 28, 2009 at 2:16 PM, Gavin Towey wrote: > No, that won't work, remember that the WHERE clause is applied to each row > individually -- y is 25, then it also cannot possibly be 24 at the same time, > so AND condition has no meanin

Re: Is anything ever equal to NULL?

2009-12-28 Thread Michael Dykman
No, nothing will ever equal null. In strict relational theory, which I don't know well enough to begin expounding on here, null does not even equal another null. That's why SQL provides IS NULL and IS NOT NULL as explicit cases. - michael dykman On Mon, Dec 28, 2009 at 2:32 PM

Re: Join with OR-condition and Indexes

2010-01-05 Thread Michael Dykman
ght >> FROM matches >> >> ) >> >> UNION >> ( >> >> SELECT team2_partner_id, teammatch_id, match_type, team1_score, >> team2_score, >> team1_points, team2_points, no_fight >> FROM matches >> >> ) >> >> ) m ON

Re: Exporting the result of a Query into excel

2010-01-05 Thread Michael Dykman
but for all kinds of trouble shooting in general. - michael dykman On Tue, Jan 5, 2010 at 8:42 AM, ishaq gbola wrote: > Am running windows on my local host and Redhat linux on the remote server, I > have no mysql client on local host. TAC for the NMS using the database > ad

Re: Another Inserting Multiple Values with Set Problem

2010-01-06 Thread Michael Dykman
rs look longish, maybe? - md On Wed, Jan 6, 2010 at 10:53 AM, Victor Subervi wrote: > On Wed, Jan 6, 2010 at 10:56 AM, Michael Dykman wrote: > >> I don't really use sets when I can avoid them (too much special >> wierdness) but from the manual I see this: >> >>

Re: Another Inserting Multiple Values with Set Problem

2010-01-06 Thread Michael Dykman
point of a set identifier to be an easy mnemonic for a particular bit value. Nothing is gained by trying to represent data with the identifier itself. - michael dykman On Wed, Jan 6, 2010 at 1:25 PM, Victor Subervi wrote: > On Wed, Jan 6, 2010 at 2:18 PM, Hassan Schroeder > wrote: >

Re: Binary Logging

2010-01-06 Thread Michael Dykman
ith a snapshot of the current state of the master (excepting the binary logs) and only the binary logs produced by the master from that point forward matter. - michael dykman On Wed, Jan 6, 2010 at 2:43 PM, Steve Staples wrote: > Silly me sees that there is an 'expire_log_days' in

Re: table export in cron

2010-01-06 Thread Michael Dykman
thing like echo "select * from mytable" > mysql -u someone mydb > mytable.tsv which will output tab-delimited records, one per line, suitable for feeding to SQL*Loader. I would put the command into a shell script and have cron call that shell script. - michael dykman On We

Re: parameter being overwritten

2010-01-20 Thread Michael Dykman
bles like server_id is showing "0" > what i had to do is set global parameter in mysqld cli w/c is not a good > thing.. > > > additional info: > > Default options are read from the following files in the given order: > /etc/my.cnf ~/.my.cnf /etc/my.cnf > > >

Re: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction

2010-02-01 Thread Michael Dykman
tween trys. In spite of 1M+ user/day we rarely made it to the third attempt. - michael dykman On Mon, Feb 1, 2010 at 9:33 AM, Dante Lorenso wrote: > All, > > I am trying to create an atomic operation in MySQL that will manage a > "queue".  I want to lock an item from a table

Re: 50 things to know before migrating from Oracle to MySQL

2010-02-01 Thread Michael Dykman
> Oracle will sell it if they can convince the customer. Any one who has had the pleasure of using Oracle Application Server can attest to that. -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.

  1   2   3   4   5   >