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
>>
>>
>
> --
> -
> 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.
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
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:
>&
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
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.
>
> 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
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
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
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, %
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
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
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
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
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
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
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
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
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
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
| smccoy | Computer Software | 15 |
> | smccoy | Networking | 4 |
> | smccoy | New User | 1 |
> | smccoy | Printer | 2 |
> | smccoy | Server | 4 |
> | sokolsky | Computer Software | 1 |
> | sokolsky | Telep
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
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
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
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
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
> 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
>
>
> 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
&
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
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
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
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
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
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
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
*
> *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. *
>
&
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
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'
;
> 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
>
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
>
&
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
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
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
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 `
.
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,
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&
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
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:
&
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
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/
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
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
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
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
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:
>>
>>
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:
>
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
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
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
>
>
>
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
> 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.
en why are you using the lock?
- michael dykman
On Mon, Feb 1, 2010 at 12:29 PM, D. Dante Lorenso wrote:
> Michael Dykman wrote:
>>
>> The query is probably fine.. that is just the lock doing it's job.
>> Take that advice literally.. when you fail with that class of
&
You don't need multiple definers to have multiple users. Why did you
want 2 definers?
- michael dykman
On Mon, Feb 22, 2010 at 8:45 AM, Steven Staples wrote:
> Well... let me finish... LOL (hit send some how...)
>
> I want to be able to have 2 different users access to a st
U+2012 (8210) none‒ or ‒ none
en dash - U+2013 (8211) – – or – -- ALT +
0150
em dash -- U+2014 (8212) — — or — --- ALT +
0151
horizontal bar -- U+2015 (8213) none― or ― none
swung dash ~ U+2053 (8275) none⁓
gt;>
>> After installing MySQL what do I have to do left?
>> Sorry my this is my firt time with MySQL
>>
>> Thanks!
>>
>>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql
work on servers that allow multiple statements.
I haven't been deep in PHP land for a little while, but I think you
will find the default driver/config is expressly preventing you from
doing this.
- michael dykman
On Mon, Apr 12, 2010 at 9:44 AM, Gary wrote:
> Seriously
>
> Y
HP oriented discussion.
>>
>
> Get a room, you two :-)
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>
--
- michael dykman
- mdyk...@gmail.com
May the Source be with you.
--
MyS
to see the core compiled before the
plugins..
If your problems are focussed exclusively on the InnoDB plugin, then
perhaps you want to seek some advice from the InnoDB guys who provide
it.
- michael dykman
On Wed, Apr 28, 2010 at 4:34 PM, Zardosht Kasheff wrote:
> I am using Visual Studio 2008. I
gt; > Thank you
>> >
>> > ---
>> > Weydson Lima
>> > weys...@gmail.com
>> > http://bluetoothmono.weydson.com
>>
>> --
>> The New Busy is not the old busy. Search, chat and e-mail from your inbox.
>> Get
>> started.<http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_3>
>>
>
--
- michael dykman
- mdyk...@gmail.com
May the Source be with you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
bles on the same installation. The only difference that
> I can think of is that they are MyISAM type whereas these two are InnoDB.
> Does the different type require this flag to be set? Or is there be something
> else going on here?
>
> Michael
>
>
>
> On May 17, 2010,
This sounds like a matter to take up with whoever supports the
particular PHP/MySQL interface you are using.
Are you using the mysql, mysqli or dbo? The restriction very likely
originates from that layer.
- michael dykman
On Tue, Jun 1, 2010 at 11:11 AM, memo garcia wrote:
> N
an be used in conjunction with a multitude
of languages and frameworks.
If you are just getting started on this path, you might want to look
at something like python or ruby or PHP, they all can handle HTTP
requests very efficiently and have nice interfaces to MySQL.
Best of Luck.
- michael d
buy-in, it *can* be done but there is
rarely a good reason for it in my experience.
- michael dykman
On Thu, Jun 3, 2010 at 1:12 PM, Guillermo wrote:
>
> Hello,
> I need to get the user and password from the current session. I found the
> user() function, wich gets the userna
plication, kick users of d1 out
> create database d2
> foreach t in d1:
> RENAME TABLE d1.t TO d2.t
> tell user to use d2
>
> ?
>
> tom
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mys
ries
> in the past, so I assume it is possible and I just can't make the documents
> on the MySQL profiler make sense to me.
>
> Thanks for any help anyone could provide on this as I've got people that
> expect miracles in the next 5 minutes here!
>
> Bill
>
>
nlog bin.10001 > /tmp/read_bincontent.log
>
> Cheers,
> Anirudh Sundar
> DataVail Corp
> Mumbai
>
>
> On Wed, Jun 9, 2010 at 6:52 PM, Michael Dykman wrote:
>
>> You have 2 options here. The Mysql General Query Log
>>
>> http://dev.mysql.com/doc/refm
;Binary" logs.
>>
>>But you cannot read the contents of the binlog just like that. You need to
>>convert that to a readable format.
>>
>>mysqlbinlog bin.10001 > /tmp/read_bincontent.log
>>
>>Cheers,
>>Anirudh Sundar
>>DataVail Corp
>&
11 characters of display allow for any int of any size, signed or
unsigned. When you do not specify a length attribute in a
declaration, MySQL uses 11 as the default.
For your application, use what makes sense for your problem's domain.
- michael dykman
On Mon, Jun 14, 2010 at 12:14 PM,
There are binary differences between v4.x and 5.x (5.1.x
recommended).. The cleanest approach would be to do mysqldump on the
old database and inject that into your new server.
- michael dykman
On Tue, Jun 29, 2010 at 4:04 PM, Grant Peel wrote:
> nilnandan,
>
> I meant to say Mys
27;stuff')
the auto-increment will engage on an insert of 0
- michael dykman
On Wed, Jun 30, 2010 at 1:30 PM, David Stoltz wrote:
> Hi All,
>
>
>
> In MS SQL, if the table has an identity field/primary key which is set
> to auto increment, you can leave the value out of an INS
em.. It's more likely a Tomcat/JNDI problem. If you can't
connect via the command line (same client, same host, same
credentials), then we have a MySQL issue we can address as such.
- michael dykman
On Sat, Jul 3, 2010 at 8:08 AM, michel wrote:
> I am setting up the Softslate web
saster..
>From that same command line, what do you get for
$ dig photon
You likely want to make a grant suitable rfor that network address for
the user you are trying to use.
- michael dykman
On Sun, Jul 4, 2010 at 6:38 PM, Michael Satterwhite wrote:
> I've recently reloaded my box (
As you are building from source, whats pre-compile configuration
options are you using? That will have everything to do with the size
of your resulting binaries.
- michael dykman
On Mon, Jul 5, 2010 at 1:53 PM, Nima Mohammadi wrote:
> On Mon, Jul 5, 2010 at 10:11 PM, Rob Wultsch wr
Go through that list of options and exclude anything you don't want or
need. It is a very long list.
- md
On Mon, Jul 5, 2010 at 4:39 PM, Nima Mohammadi wrote:
>
> On Tue, Jul 6, 2010 at 12:54 AM, Michael Dykman wrote:
>>
>> As you are building from source, whats pr
t meant running the command line mysql client:
>> mysql -uuser -ppass -h127.0.0.1 -e 'select "hello world!"'
>>
>>
>> --
>> Rob Wultsch
>> wult...@gmail.com
>>
>> --
>> MySQL General Mailing List
>> For list archives: htt
third line below:
>
>
> $statemente = 'SELECT * FROM notes WHERE call = ? ORDER BY id;';
> $sth = $dbh->prepare($statemente) or die print "Couldn't prepare
> statement:$DBI::errstr; stopped";
> $sth->execute($trackedcall) or d
parse them later. I'm just
> wondering if there's a more elegant way to do this.
> TIA,
> Victor
>
--
- michael dykman
- mdyk...@gmail.com
May the Source be with you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
7;1') related to
> data in another column ('one') in a record. The most elegant way of
> using a database is to use it as it was designed.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mys
owing up in
> there.
>
>
>
> All the queries are showing “sleep”
>
>
>
> Not sure if this means anything
>
>
>
> Machiel Richards
>
> MySQL DBA
>
> Relational Database Consulting
>
>
>
> [image: RDC_Logo]
>
>
>
--
- michael dykman
- mdyk...@gmail.com
May the Source be with you.
, 2010 at 11:44 AM, Machiel Richards wrote:
> I had a look and all of these just say sleep as the command.
>
>
>
> Machiel Richards
>
> MySQL DBA
>
> Relational Database Consulting
>
>
>
> [image: RDC_Logo]
>
>
>
> *From:* Michael Dykman [mailt
gt;
>
> I am trying to find out whether this can be the cause of the problem and if
> o if we can simply kill these processes.
>
>
>
>
>
>
>
> *Machiel Richards*
>
> [image: herbalife_logo]
>
>
>
> *From:* Michael Dykman [mailto:mdyk...@gmail.com]
&
Options such as these are set in my.cnf/my.ini (depending on your host
operating system).
innodb_file_per_table is a very useful option but not neccessarily the
best choice for a novice trying to set up replication.
- michael dykman
On Tue, Jul 13, 2010 at 5:43 AM, lejeczek wrote:
> I&
er of environments/frameworks/languages. Don't limit yourself to
PHP just because it is perceived to be common practice.
- michael dykman
I have used MySQL as a database in a huge variety of environments
On Thu, Jul 15, 2010 at 6:12 PM, Daevid Vincent wrote:
>
>
>> -Origina
.
- md
On Fri, Jul 16, 2010 at 2:38 PM, Daevid Vincent wrote:
>> -Original Message-
>> From: Jay Blanchard [mailto:jblanch...@pocket.com]
>> Sent: Friday, July 16, 2010 5:25 AM
>> To: Michael Dykman; mysql
>> Subject: RE: Why is MySQL always linked to Php?
>&g
+---+-+-+---+
How do we deduce that you would want ID '3' ?
This conversation would be easier if we gave names to those columns..
- michael dykman
On Mon, Jul 19, 2010 at 12:36 PM, Ashley M. Kirchner wrote:
>
> I may be going at this completely wrong but
You might have better results if you use unique identifiers:
Select MyID From Test Where TestID = TestID;
I'm not sure how mysql is supposed to tell the param 'TestID' from the
column name.
- michael dykman
On Mon, Aug 9, 2010 at 3:10 AM, Manasi Save
wrote:
> Dear All,
&g
ad all the MYI files, remove the .MYI from the
>>file name then proceed to deleting whatever indexes it finds? I am doing this
>>to debug a server that seems to be slow and sluggish. After I am done
>>deleting
>>I will review the slow query logs and then re-index to get the best
> performance?
>>
>>TIA...
>>
>>Nunzio
>>
>>
>>
>>
>
>
>
>
--
- michael dykman
- mdyk...@gmail.com
May the Source be with you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
It's not a completely solution and will need some tweaking.. You
might have to run the PRIMARY KEYS distinctly from the rest.
- michael dykman
On Tue, Aug 10, 2010 at 4:43 PM, Nunzio Daveri wrote:
> Hello Michael, thanks for the one liner. I ran it BUT I started to get
> errors
e defined as a key
>
> mysql> ALTER TABLE dbt_Fruit DROP PRIMARY;
> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
> that corresponds to your MySQL server version for the right syntax to use
> near '' at line 1
>
>
> Any ideas??? I am won
The relationship looks righteous enough but I note that you use
'straight join' in your expression, rather than 'straight_join' as
indicated in the manual
(http://dev.mysql.com/doc/refman/5.1/en/join.html).
Perhaps the message is a red herring and your trouble is elsewhere?
201 - 300 of 447 matches
Mail list logo
