the FieldName2 field if the value of MyVariable is
NOT NULL ?
Thanks
Neil
--
Andy Wallace
iHOUSEweb, Inc.
awall...@ihouseweb.com
(866) 645-7700 ext 219
--
Sometimes it pays to stay in bed on Monday, rather than spending the rest of the
week debugging Monday's code.
- Christopher Thompson
innodb_log_file_size=100M
innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
innodb_lock_wait_timeout=50
innodb=on
--
Andy Wallace
iHOUSEweb, Inc.
awall...@ihouseweb.com
(866) 645-7700 ext 219
--
Sometimes it pays to stay in bed on Monday, rather than spending
On 8/14/13 10:46 AM, Manuel Arostegui wrote:
2013/8/14 Andy Wallace awall...@ihouseweb.com mailto:awall...@ihouseweb.com
Hey all -
We have been focusing on performance in our systems a lot lately, and have
made some pretty
good progress. Upgrading the mySQL engine from 5.1 to 5.5
of other fields
PRIMARY KEY (`acnt`),
KEY `parent_acnt` (`parent_acnt`),
KEY `status` (`status`),
KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
--
Andy Wallace
iHOUSEweb, Inc.
awall...@ihouseweb.com
(866) 645-7700 ext 219
--
Sometimes it pays to stay in bed on Monday, rather
wrote:
Am 02.07.2013 23:28, schrieb Andy Wallace:
mysql update agent set number_of_emails = 5 where acnt = 'AR287416';
Query OK, 1 row affected (36.35 sec)
Rows matched: 1 Changed: 1 Warnings: 0
36 seconds to update one table? The primary key is `acnt`. If I run the same
(basic
variables like 'timestamp';
+---++
| Variable_name | Value |
+---++
| timestamp | 1372404371 |
+---++
1 row in set (0.00 sec)
re,
wh
Am 27.06.2013 20:19, schrieb Andy Wallace:
Benjamin -
Unfortunately:
mysql show
(0.00 sec)
On Wed, Jun 26, 2013 at 4:18 PM, John Meyer
johnme...@pueblocomputing.com wrote:
Well, if you want to get unstuck in time, maybe you need to call Billy
Pilgrim ;-)
Andy Wallace wrote:
We've been having some issues with one of our MySQL servers lately, and
currently
the dang thing
() |
+-+-+
| 2013-06-27 13:21:34 | 2013-06-27 13:21:34 |
+-+-+
1 row in set (0.00 sec)
Cliff's notes: set timestamp = 0;
On 6/26/13 6:10 PM, Andy Wallace awall...@ihouseweb.com wrote:
We've been having some issues with one of our MySQL servers
27, 2013 at 11:19 AM, Andy Wallace awall...@ihouseweb.com wrote:
Benjamin -
Unfortunately:
mysql show global variables like 'timestamp';
+---++
| Variable_name | Value |
+---++
| timestamp | 1372238834 |
+---++
1
. If this does fix your problem, and if
you're using replication, you may have an issue with your replicated data.
Replication uses timestamp extensively.
On 6/27/13 1:44 PM, Andy Wallace awall...@ihouseweb.com wrote:
But the question is how. I have nothing in the code that does
:22 PM, Claudio Nanni wrote:
Hi,
On 06/27/2013 08:19 PM, Andy Wallace wrote:
Benjamin -
Unfortunately:
mysql show global variables like 'timestamp';
+---++
| Variable_name | Value |
+---++
| timestamp | 1372238834
it
N.
--
Andy Wallace
iHOUSEweb, Inc.
awall...@ihouseweb.com
(866) 645-7700 ext 219
--
Sometimes it pays to stay in bed on Monday, rather than spending the rest of the
week debugging Monday's code.
- Christopher Thompson
--
MySQL General Mailing List
For list archives: http
Wed Jun 26 15:08:56 PDT 2013
This is MySQL 5.1.46 running on solaris2.10.
Any ideas short of restarting the MySQL engine? I'm willing to do that, but
would much
rather wait and not do it in the middle of the day.
Thanks,
Andy
--
Andy Wallace
iHOUSEweb, Inc.
awall...@ihouseweb.com
(866) 645-7700
Ok, this raises a question for me - what's a better way to do pagination?
On 9/5/12 2:02 PM, Rick James wrote:
* LIMIT 0, 50 -- are you doing pagination via OFFSET? Bad idea.
--
Andy Wallace
iHOUSEweb, Inc.
awall...@ihouseweb.com
(866) 645-7700 ext 219
--
Sometimes it pays to stay in bed
) for a complete scan.
N is the number of pages. Some implementations have more than 10,000 pages.
10,000 * 10,000 = 100 million !
-Original Message-
From: Andy Wallace [mailto:awall...@ihouseweb.com]
Sent: Wednesday, September 05, 2012 2:05 PM
To: mysql@lists.mysql.com
Subject: Re
--
Andy Wallace
iHOUSEweb, Inc.
awall...@ihouseweb.com
(866) 645-7700 ext 219
--
There are two ways to build software:
Make it so simple that there are obviously no bugs,
or make it so complex that there are no obvious bugs.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
,
andy
--
Andy Wallace
iHOUSEweb, Inc.
awall...@ihouseweb.com
(866) 645-7700 ext 219
--
There are two ways to build software:
Make it so simple that there are obviously no bugs,
or make it so complex that there are no obvious bugs.
--
MySQL General Mailing List
For list archives: http
;-)
[1]
http://stackoverflow.com/questions/8663454/why-does-basic-mysqldump-on-db-table-fail-with-permission-denied
Thanks
-Govinda
--
Andy Wallace
iHOUSEweb, Inc.
awall...@ihouseweb.com
(866) 645-7700 ext 219
--
There are two ways to build software:
Make it so simple that there are obviously
Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=anan...@gmail.com
--
Andy Wallace
iHOUSEweb, Inc.
awall...@ihouseweb.com
(866) 645-7700 ext 219
--
There are two ways to build software:
Make it so simple that there are obviously
value:
DELETE FROM my_big_table WHERE id 5000;
DELETE FROM my_big_table WHERE id 4000;
etc
-- Derek
On Nov 4, 2011, at 12:47 PM, Andy Wallace wrote:
I've had some luck in the past under similar restrictions deleting in
chunks:
delete from my_big_table where id 2474 limit 1000
But really
)
This last one can be HUGE. I tracked a big performance issue to this exact
problem - the columns used in the join had the same name, but different
data types. Correcting to be the same type (both ints) made a terrific
performance increase.
--
Andy Wallace
iHOUSEweb, Inc.
awall...@ihouseweb.com
select_type: SIMPLE
table: E
type: eq_ref
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: idx_acnt.EL.enduser_acnt
rows: 1
Extra: Using where
3 rows in set (0.00 sec)
--
Andy Wallace
iHOUSEweb, Inc.
awall...@ihouseweb.com
(866) 645-7700 ext
it just puts an empty string into the required column.
Is there a setting for mysql to return errors in these cases? It seems silly to
set
up an enum column, or a not null column, and not have the possible values
enforced?
thanks,
andy
--
Andy Wallace
iHOUSEweb, Inc.
awall...@ihouseweb.com
into the required column.
Is there a setting for mysql to return errors in these cases? It seems silly to
set
up an enum column, or a not null column, and not have the possible values
enforced?
thanks,
andy
--
Andy Wallace
iHOUSEweb, Inc.
awall...@ihouseweb.com
(866) 645-7700 ext 219
--
There are two ways
to extract what you need; in the
former case you're gonna have to try attaching them to a new
instance - good luck with that.
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
--
Andy Wallace
iHOUSEweb, Inc.
awall...@ihouseweb.com
(866
,
ansdy
--
Andy Wallace
iHOUSEweb, Inc.
awall...@ihouseweb.com
(866) 645-7700 ext 219
--
There are two ways to build software:
Make it so simple that there are obviously no bugs,
or make it so complex that there are no obvious bugs.
--
MySQL General Mailing List
For list archives: http
!= ''), A.domain, M.domain)
Any thoughts?
THanks,
andy
--
Andy Wallace
iHOUSEweb, Inc.
awall...@ihouseweb.com
(866) 645-7700 ext 219
--
There are two ways to build software:
Make it so simple that there are obviously no bugs,
or make it so complex that there are no obvious bugs.
--
MySQL General
Jigal van Hemert wrote:
Daevid Vincent wrote:
We currently have some tables that are approaching 1 BILLION rows (real
Billion, with nine zeros, not that silly six zero version). Trying to
do an
ALTER on them to add a column can sometimes take hours.
--
Andy Wallace
iHOUSEweb, Inc.
awall
://pastie.org/1066140
thanks for any insight.
--
Andy Wallace
iHOUSEweb, Inc.
awall...@ihouseweb.com
(866) 645-7700 ext 219
--
There are two ways to build software:
Make it so simple that there are obviously no bugs,
or make it so complex that there are no obvious bugs.
--
MySQL General Mailing
A couple of thoughts - it's not no quotes on integers, but
no quotes around column references. When you use 'mappings.end_ip',
you are saying the string mappings.end_ip, and not referring to
a column in the mappings table. It just becomes a constant at that
point.
As for the performance, you
I've run into similar situations w/regard to Mac vs PC CSV files,
it usually has to do with the EOL character sequence. Macs use
LF (chr(10)), while PCs use CRLF (chr(13)chr(10)).
andy
Patrice Olivier-Wilson wrote:
In case anyone might find this of the least interest, probably not, but
I
ggghh
mich...@j3ksolutions.com wrote:
On Fri, 13 Mar 2009, mich...@j3ksolutions.com wrote:
Explanation(5): The more you understand how the database is to be used,
and the more complexity and thought you put into your database design,
the
less
how.
Thanks,
- Jake
--
Andy Wallace - CISData - IDX Slave
AIM: acmwallace [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
on the event_log table, which can be
very bad if it is large. You can work around this by compiling groups
of users at a time. This will require querying the users and for the
group of users and joining on the event_log table.
Brent Baisley
Systems Architect
On Thu, May 8, 2008 at 12:26 AM, Andy Wallace
int
table enduser
enduser_acnt int
last_visit datetime
Any help appreciated. Thanks...
andy
--
Andy Wallace - CISData - IDX Slave
AIM: acmwallace [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
= E.enduser_acnt
group by EL.enduser_acnt);
but it updated the last_visit field to the default value if it found
no matching event_log row... which I don't want to happen.
thanks,
andy
Andy Wallace wrote:
Hey all -
I have two tables - an event_log table, and a user table
in UPDATE
statement?
M
- Original Message - From: Andy Wallace [EMAIL PROTECTED]
To: mysql list mysql@lists.mysql.com
Sent: Wednesday, May 07, 2008 1:07 PM
Subject: Re: question about update/join query
Clarification: I DON'T want to update the last_visit field if there
is no matching event
by EL.event_time);
// group by EL.enduser_acnt);
HTH
Martin
- Original Message - From: Andy Wallace [EMAIL PROTECTED]
To: Martin [EMAIL PROTECTED]
Cc: mysql list mysql@lists.mysql.com
Sent: Wednesday, May 07, 2008 6:21 PM
Subject: Re: question about update/join query
I want
by EL.event_time);
// group by EL.enduser_acnt);
HTH
Martin
- Original Message - From: Andy Wallace [EMAIL PROTECTED]
To: Martin [EMAIL PROTECTED]
Cc: mysql list mysql@lists.mysql.com
Sent: Wednesday, May 07, 2008 6:21 PM
Subject: Re: question about update/join query
I want
General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
.:: Rafael Barbolo Lopes ::.
http://barbolo.polinvencao.com/
--
Andy Wallace - CISData - IDX Slave
AIM: acmwallace [EMAIL PROTECTED]
--
MySQL
fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping
--
Andy Wallace - CISData - IDX Slave
AIM: acmwallace [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
of the SELECT.
Any help would be appreciated.
Warm regards,
Mário Gamito
--
Andy Wallace - CISData - IDX Slave
AIM: acmwallace [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
2nd trial:
select idd,concat(first, ,last),submitted_by from idea,employee where
iid=1 and completed_by=eid;
i got:
1 | betty smith | 10
now, instead of 10 for the submitted_by column, how do i get sun mcnab?
thanks,
T. Hiep
--
Andy Wallace - CISData - IDX Slave
AIM: acmwallace [EMAIL
43 matches
Mail list logo