On Tue, Feb 23, 2016 at 7:07 AM, Larry Martell wrote:
> On Tue, Feb 23, 2016 at 6:16 AM, Reindl Harald wrote:
>>
>>
>> Am 23.02.2016 um 04:47 schrieb Larry Martell:
>>>
>>> I am trying to install the mysql devel libs (so I can build MySQLdb).
>>>
On Tue, Feb 23, 2016 at 6:16 AM, Reindl Harald wrote:
>
>
> Am 23.02.2016 um 04:47 schrieb Larry Martell:
>>
>> I am trying to install the mysql devel libs (so I can build MySQLdb).
>> This is on RHEL 6. It's failing as shown below. Can anyone help with
>&g
I am trying to install the mysql devel libs (so I can build MySQLdb).
This is on RHEL 6. It's failing as shown below. Can anyone help with
this?
# yum install mysql-devel
Loaded plugins: dellsysid, product-id, refresh-packagekit, security,
subscription-manager
Setting up Install Process
Package my
On Fri, Jan 29, 2016 at 11:15 AM, shawn l.green
wrote:
>
>
> On 1/28/2016 6:30 PM, Larry Martell wrote:
>>
>> On Thu, Jan 28, 2016 at 5:45 PM, shawn l.green
>> wrote:
>>>
>>>
>>>
>>> On 1/28/2016 3:32 PM, Larry Martell wrote
On Thu, Jan 28, 2016 at 5:45 PM, shawn l.green wrote:
>
>
> On 1/28/2016 3:32 PM, Larry Martell wrote:
>>
>> On Thu, Jan 28, 2016 at 2:13 PM, shawn l.green
>> wrote:
>>>
>>>
>>>
>>> On 1/28/2016 1:14 PM, Larry Martell wrote:
>&
On Thu, Jan 28, 2016 at 2:13 PM, shawn l.green wrote:
>
>
> On 1/28/2016 1:14 PM, Larry Martell wrote:
>>
>> On Tue, Jan 26, 2016 at 8:40 AM, Hal.sz S.ndor wrote:
>>>
>>> 2016/01/25 19:16 ... Larry Martell:
>>>>
>>>>
On Tue, Jan 26, 2016 at 8:40 AM, Hal.sz S.ndor wrote:
> 2016/01/25 19:16 ... Larry Martell:
>>
>> SELECT IFNULL(f_tag_bottom,
>> IFNULL(f_tag_bottom_major_axis,
>> IFNULL(f_tag_bottom_minor_axis,
>>
ly 1 of the 5 will be populated and the other 4 will be
null. But still, I said I have to code for the case where that is not
true. So then I was told to use the first one I find that is not null,
looking in the order I had in my original post.
> On Mon, Jan 25, 2016 at 6:16 PM, Larry Mar
On Mon, Jan 25, 2016 at 8:01 PM, Rebecca Love wrote:
> Have you tried using a select case statement for ftag?
How would that help? Unless I'm missing something, I'd still have to
have a reference to the column alias in the where clause.
>> On Jan 25, 2016, at 6:39 PM, L
On Mon, Jan 25, 2016 at 7:27 PM, Reindl Harald wrote:
>
>
> Am 26.01.2016 um 01:16 schrieb Larry Martell:
>>
>> I know I cannot use an alias in a where clause, but I am trying to
>> figure out how to achieve what I need.
>>
>> If I could have an alias in a w
I know I cannot use an alias in a where clause, but I am trying to
figure out how to achieve what I need.
If I could have an alias in a where clause my sql would look like this:
SELECT IFNULL(f_tag_bottom,
IFNULL(f_tag_bottom_major_axis,
IFNULL(f_tag_bottom_minor_
On Fri, Jan 1, 2016 at 9:31 PM, Peter Brawley
wrote:
> On 1/1/2016 19:24, Larry Martell wrote:
>>
>> On Fri, Jan 1, 2016 at 2:12 PM, Peter Brawley
>> wrote:
>>>
>>> On 12/31/2015 0:51, Larry Martell wrote:
>>>>
>>>> I need to count t
On Fri, Jan 1, 2016 at 2:12 PM, Peter Brawley
wrote:
> On 12/31/2015 0:51, Larry Martell wrote:
>>
>> I need to count the number of rows in a table that are grouped by a
>> list of columns, but I also need to exclude rows that have more then
>> some count when gr
I need to count the number of rows in a table that are grouped by a
list of columns, but I also need to exclude rows that have more then
some count when grouped by a different set of columns. Conceptually,
this is not hard, but I am having trouble doing this efficiently.
My first counting query wo
I have a very large table (~50GB) and periodically rows are purged
from it and I want to run OPTIMIZE TABLE to recover the space. But I
do not have enough space to run it. If I do run it the server hangs
and must be killed and restarted and the table is damaged and must be
repaired. I do this with
On Fri, May 15, 2015 at 8:27 PM, Reindl Harald wrote:
>
> Am 15.05.2015 um 23:27 schrieb Larry Martell:
>>
>> I am upgrading my server from 5.5 to 5.6. This is on CentOS 6.5. I
>> removed 5.5 like this:
>>
>> yum remove mysql-libs MySQL-client MySQL-devel My
I am upgrading my server from 5.5 to 5.6. This is on CentOS 6.5. I
removed 5.5 like this:
yum remove mysql-libs MySQL-client MySQL-devel MySQL-shared
and I installed 5.6 from
MySQL-5.6.24-1.linux_glibc2.5.x86_64.rpm-bundle.tar with:
rpm -i MySQL-client-5.6.24-1.linux_glibc2.5.x86_64.rpm
rp
I just upgraded a server from 5.1 to 5.5. Our tables are all MyISAM. I
have a python script that inserts rows to a table, in 5.1 it worked
fine. In 5.5 it's failing with 'Lock wait timeout exceeded'. I google
this, and it seems that all the cases of people getting that were with
InnoDB tables, and
types.
I did do that before I posted, but it wasn't really clear to me, but I
think I need to use a DATETIME instead of a TIMESTAMP. Correct?
>
> On 31 Mar 2015 05:43, "Larry Martell" wrote:
>>
>> I have a column that was a timestamp type. I was inserting rows
I have a column that was a timestamp type. I was inserting rows using
NOW(). When we switched to DST and the hour from 2am to 3am was
non-existent I of course had no data for that hour. For reasons I
don't need to go into, that missing hour caused problems downstream.
To prevent this from happening
On Wed, Feb 4, 2015 at 3:25 PM, shawn l.green wrote:
> Hi Larry,
>
>
> On 2/4/2015 3:18 PM, Larry Martell wrote:
>>
>> On Wed, Feb 4, 2015 at 2:56 PM, shawn l.green
>> wrote:
>>>
>>> Hi Larry,
>>>
>>>
>>> On 2/1/2015
On Wed, Feb 4, 2015 at 2:56 PM, shawn l.green wrote:
> Hi Larry,
>
>
> On 2/1/2015 4:49 PM, Larry Martell wrote:
>>
>> I have 2 queries. One takes 4 hours to run and returns 21 rows, and
>> the other, which has 1 additional where clause, takes 3 minutes and
>
I have 2 queries. One takes 4 hours to run and returns 21 rows, and
the other, which has 1 additional where clause, takes 3 minutes and
returns 20 rows. The main table being selected from is largish
(37,247,884 rows with 282 columns). Caching is off for my testing, so
it's not related to that. To s
On Fri, Dec 12, 2014 at 8:31 PM, Sayth Renshaw wrote:
> And does that then lead you to use Fabric?
>
> http://de.slideshare.net/mobile/nixnutz/mysql-57-fabric-high-availability-and-sharding
No, I've never used that. I just process the the data in python.
> On Sat, 13 Dec 2
On Fri, Dec 12, 2014 at 4:52 PM, Sayth Renshaw wrote:
> So it is definitely achievable, I see other db's converting xml2json etc to
> get it in.
I use this https://github.com/hay/xml2json
> Sends odd that xml had done great document qualities but as a data format
> it seems rather hard to work w
Please reply to the list and not to me directly
On Thu, Dec 11, 2014 at 5:10 PM, Trianon 33 wrote:
>
> Larry Martell schreef op 11-12-14 om 23:04:
>>
>> On Thu, Dec 11, 2014 at 4:58 PM, Trianon 33 wrote:
>>>
>>> Larry Martell schreef op 11-12-14 om 22:43:
&g
On Thu, Dec 11, 2014 at 4:34 PM, Trianon 33 wrote:
> Hi all,
>
> It seems like a simple question, however I'm not able to find the
> answer.
>
> Let me explain. I have a DB with lots of columns, one is labeled as
> 'kenteken' and it is also the primary key in the DB. I poke into this DB
> with
Does anyone know of any debuggers for stored procs that run on Mac and/or Linux?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On Wed, May 21, 2014 at 4:50 AM, Hartmut Holzgraefe wrote:
> On 05/21/2014 08:14 AM, Johan De Meersman wrote:
>
>>> ALTER TABLE `my_table` DEFAULT CHARACTER SET latin1 COLLATE
>>> latin1_general_ci;
>>
>> Purely from memory, doesn't that change the table but add the old setting to
>> individual t
On Tue, May 20, 2014 at 5:52 PM, Hartmut Holzgraefe wrote:
> On 05/20/2014 11:10 PM, Larry Martell wrote:
>
>> 5.5 server:
>>
>> mysql> select distinct(pnlCurrency) from PnLDetail;
>> +-+
>> | pnlCurrency |
>>
On Tue, May 20, 2014 at 9:38 AM, Hartmut Holzgraefe wrote:
> On 05/20/2014 03:26 PM, Larry Martell wrote:
>> Yet the 5.5.25a server is case sensitive as you would expect, but the
>> 5.0.77 is not. How can I make the 5.0.77 server case sensitive?
>>
>
> please provi
I have 2 servers, one is running 5.5.25a and the other 5.0.77.
They both have the same collation and character set:
mysql> SELECT COLLATION(VERSION());
+--+
| COLLATION(VERSION()) |
+--+
| utf8_general_ci |
+--+
1 row in set (0.00 s
On Thu, May 15, 2014 at 11:01 AM, Johan De Meersman wrote:
> - Original Message -
>> From: "Larry Martell"
>> Subject: Re: Performance boost by splitting up large table?
>>
>> This table is queried based on requests from the users. There are 10
On Thu, May 15, 2014 at 4:14 AM, Johan De Meersman wrote:
>
> You've already had some good advice, but there's something much more simpler
> that will also give you a significant boost: a covering index.
>
> Simply put, the engine is smart enough to not bother with row lookups if
> everything yo
We have a table with 254 columns in it. 80% of the time, a very small
subset of these columns are queried. The other columns are rarely, if
ever, queried. (But they could be at any time, so we do need to
maintain them.). Would I expect to get a marked performance boost if I
split my table up into 2
On Tue, Apr 8, 2014 at 4:15 PM, bars0.bars0.bars0
wrote:
> Hi all.
>
> I have standard select statement and on one column I want to run function,
> that will connect to another database (same server).
> Is this possible?
>
> High level example:
>
> SELECT db1.clients.client_id, getTurnover(db1.cli
On Wed, Feb 12, 2014 at 5:35 PM, wrote:
>>>>> 2014/02/11 18:14 -0500, Larry Martell >>>>
> set LIMIT = sign(LIMIT) * 100 * floor(0.01 + (sign(LIMIT) * LIMIT
> * ratio/100)
> <<<<<<<<
> The function TRUNCATE can be useful here:
&g
On Wed, Feb 12, 2014 at 7:35 PM, Jennifer wrote:
> Hello,
>
> I have the following SQL statement that I'd like to add to. It's
> used to create a report that's emailed to me showing hits to our site that
> didn't provide a referrer. However, I only want to report on multiple hits
> fr
Is there some way I can have a conditional in an update?
I have this update sql (paraphrased):
update LMPROC_LIMITS
set LIMIT = sign(LIMIT) * 100 * floor(0.01 + (sign(LIMIT) * LIMIT
* ratio/100)
where SYMBOL_ID = symbolId
and CLASSTYPE = LimitType
and TYPE_ in ('minClusterPosition', 'maxClust
On Wed, Jan 15, 2014 at 4:06 PM, shawn l.green wrote:
> Hello Larry,
>
>
> On 1/13/2014 2:43 AM, Peter Brawley wrote:
>>
>>
>> On 2014-01-12 9:13 PM, Larry Martell wrote:
>>>
>>> On Sun, Jan 12, 2014 at 2:47 PM, Peter Brawley
>>> wr
On Mon, Jan 13, 2014 at 2:43 AM, Peter Brawley
wrote:
>
> On 2014-01-12 9:13 PM, Larry Martell wrote:
>>
>> On Sun, Jan 12, 2014 at 2:47 PM, Peter Brawley
>> wrote:
>>>
>>> On 2014-01-12 1:17 PM, Larry Martell wrote:
>>>>
>>>>
On Sun, Jan 12, 2014 at 2:47 PM, Peter Brawley
wrote:
> On 2014-01-12 1:17 PM, Larry Martell wrote:
>>
>> I've been asked to do something that I do not think is possible in SQL.
>>
>> I have a query that has this basic form:
>>
>> SELECT a, b, c, d, AV
I've been asked to do something that I do not think is possible in SQL.
I have a query that has this basic form:
SELECT a, b, c, d, AVG(e), STD(e), CONCAT(x, ',', y) as f
FROM t
GROUP BY a, b, c, d, f
x and y are numbers (378.18, 2213.797 or 378.218, 2213.949 or
10053.490, 2542.094).
The busine
On Tue, Jan 7, 2014 at 12:33 PM, Michael Dykman wrote:
> I think you just have a misplaced parenthesis. try:
> SELECT IF(r REGEXP '^ED[HMUZ][0-9]$', 'yes', 'no') FROM s;
Yes, thanks!
>
>
>
> On Tue, Jan 7, 2014 at 2:22 PM, Larry Martell
On Tue, Jan 7, 2014 at 12:31 PM, Peter Brawley
wrote:
>
> On 2014-01-07 1:22 PM, Larry Martell wrote:
>>
>> Can I use an regexp in a conditional? I need to do something like this:
>>
>> SELECT (IF r REGEXP '^ED[HMUZ][0-9]$', 'yes', 'no')
Can I use an regexp in a conditional? I need to do something like this:
SELECT (IF r REGEXP '^ED[HMUZ][0-9]$', 'yes', 'no') FROM s;
I'm getting an error from that. Is there some way to do this?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
are children at each turn; or pick up the
>> child and go back up until parent_id is NULL.
>>
>> Depending on what you want/need, you could also add a depth field, so you
>> don't have to loop to figure out where you are in the tree, etc.
>>
>> Storing node
self joins on large tables. I think I will end up going with using
x/y/z.
>
> - Original Message -
> > From: "Larry Martell"
> > To: "Steven Siebert"
> > Cc: "mysql mailing list"
> > Sent: Friday, 22 November, 2013 3:17:44 PM
&g
which is a child of x in 3 different tables or
rows.
On Nov 22, 2013 7:24 AM, "Larry Martell" wrote:
>
>> I have a need to store data that comes in an XML file in MySQL. I don't
>> want to store the entire file as a CBLOB, and it doesn't lend itself to
>> l
I have a need to store data that comes in an XML file in MySQL. I don't
want to store the entire file as a CBLOB, and it doesn't lend itself to
loading with Load XML. I am looking for tools that will help me create the
schema and parse and load the data. I have googled for this and I've found
many
On Tue, Sep 24, 2013 at 9:05 AM, shawn green wrote:
> Hello Larry,
>
>
> On 9/23/2013 6:22 PM, Larry Martell wrote:
>
>> On Mon, Sep 23, 2013 at 3:15 PM, shawn green **
>> wrote:
>>
>> Hi Larry,
>>>
>>>
>>> On 9/23/2013 3:58
25 minutes and isn't done yet. That will be unacceptable to my
users.
> On Mon, Sep 23, 2013 at 3:58 PM, Larry Martell wrote:
>
>> On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula <
>> narula...@gmail.com> wrote:
>>
>>> Hi,
>>>
>>>
On Mon, Sep 23, 2013 at 3:15 PM, shawn green wrote:
> Hi Larry,
>
>
> On 9/23/2013 3:58 PM, Larry Martell wrote:
>
>> On Mon, Sep 23, 2013 at 1:51 PM, Sukhjinder K. Narula
>> wrote:
>>
>> Hi,
>>>
>>> In your second query, you seem to have
t the same results regardless of if I have
MIN or MAX - I get the id of the max, but the date_time of the min.
> On Mon, Sep 23, 2013 at 3:35 PM, Larry Martell wrote:
>
>> I want to find the rows from a table that have the max date_time for each
>> recipe. I know I've done
I want to find the rows from a table that have the max date_time for each
recipe. I know I've done this before with group by and having, but I can't
seem to get it to work now. I get the correct row id, but not the correct
date_time. I'm sure I'm missing something simple.
For purposes of showing a
On Wed, Jul 3, 2013 at 9:51 AM, shawn green wrote:
> Hello Larry,
>
>
> On 7/3/2013 11:27 AM, Larry Martell wrote:
>>
>> We recently changed from in memory files to InnoDB files. Today we
>> noticed that in every server's data dir there is file called '1&
We recently changed from in memory files to InnoDB files. Today we
noticed that in every server's data dir there is file called '1' that
seems to get updated every time the iddata1 file gets updated. On some
servers it's comparable in size to the iddata1 file, on other servers
it's 10-15x larger, a
On Wed, Jul 3, 2013 at 11:34 AM, Peterson, Timothy R
wrote:
>
>
>> -Original Message-----
>> From: Larry Martell [mailto:larry.mart...@gmail.com]
>> Sent: Wednesday, July 03, 2013 11:29 AM
>> To: shawn green
>> Cc: mysql@lists.mysql.com
>> Subject: Re
ta1 grows (never shrinks) when data is added, ALTER is done, etc. It
> will reuse free space within itself.
>
> innodb_file_per_table=1 is recommended
>
> Having an explicit PRIMARY KEY on InnoDB tables is recommended. (MEMORY did
> not care much.)
>
>> -Original Me
I changed it to delete one row at a time and it's taking 3 minutes.
On Wed, Apr 24, 2013 at 6:52 PM, Larry Martell wrote:
> That is the entire sql statement - I didn't think I needed to list the
> 1500 ints that are in the in clause.
>
> Also want to mention that I ran ex
hole sql statement but often 'in' clauses can
> be refactored into equivalent joins which tend to improve performance
> tremendously.
>
> - michael dykman
>
>
> On Wed, Apr 24, 2013 at 8:19 PM, Larry Martell
> wrote:
>>
>> I have a table that has 2.5 milli
On Fri, Apr 19, 2013 at 8:24 AM, Richard Reina wrote:
> Hello All,
>
> Happy Friday! I know how to do the following query:
>
>>select count(*) from sales where WEEK(sale_date)=15 AND
> YEAR(sale_date)=2013;
>
> But can someone tell me I can do a query that will give me:
>
> the count(*) for each w
We use host aliases to connect to MySQL all the time, never had an
issue before. Today we added a new alias, and we cannot connect to the
server using that one alias but only when we are on the local machine.
Here is the NIS entry for this host:
# ypmatch -k ubshp2 hosts
ubshp2 192.132.2.143u
Found the problem. There was cached DNS info on the host. Restarted
nscd and then it worked.
On Thu, Apr 18, 2013 at 10:59 AM, Larry Martell wrote:
> We use host aliases to connect to MySQL all the time, never had an
> issue before. Today we added a new alias, and we cannot connect
On Wed, Apr 17, 2013 at 8:32 AM, Reindl Harald wrote:
>
>
> Am 17.04.2013 15:32, schrieb Larry Martell:
>> On Tue, Apr 16, 2013 at 11:31 AM, Reindl Harald
>> wrote:
>>> Am 16.04.2013 18:34, schrieb Larry Martell:
>>>> I just set up mysql on M
On Tue, Apr 16, 2013 at 11:31 AM, Reindl Harald wrote:
> Am 16.04.2013 18:34, schrieb Larry Martell:
>> I just set up mysql on Mac OS 10.8. Each time after the machine is
>> rebooted the server fails to start with:
>>
>> 2013-04-13 14:09:54 1 [ERROR] /usr/lo
time it turn out to be Time
> Machine. Ask around on those lists.
I'm not running time machine on this box. I realize it's Mac specific,
I just thought someone here might have experienced and solved this.
Thanks for the reply.
> On Tue, Apr 16, 2013 at 12:34 PM, Larry Martell
>
On Tue, Apr 2, 2013 at 11:30 AM, Richard Reina wrote:
> use DBI;
> my $dbh = DBI->connect( "DBI:mysql:rushload;192.168.0.1", $usrr, $passw, {
> RaiseError => 3 } );
> my $dbs = $dbh->selectcol_arrayref("show databases");
>
> #my $dsn = "dbi:mysql:information_schema:192.168.0.1:3306";
> #my $dbh =
On Sun, Feb 3, 2013 at 7:23 AM, walter harms wrote:
>
>
> Am 02.02.2013 01:34, schrieb Larry Martell:
>> On Mon, Jan 28, 2013 at 5:01 AM, walter harms wrote:
>>> hi list,
>>>
>>> i am using mysql 5.1.53.
>>> after a crash i have the follwi
On Mon, Jan 28, 2013 at 5:01 AM, walter harms wrote:
> hi list,
>
> i am using mysql 5.1.53.
> after a crash i have the follwing error in my log:
>
> 130128 10:45:25 InnoDB: Error: page 61 log sequence number 0 2871649158
> InnoDB: is in the future! Current system log sequence number 0 2494349480
a.date_time = grouped.MaxDateTime
> WHERE data_cstmeta.ppl_id = data_ppl.id
> AND data_cstmeta.recipe_id = data_recipe.id
> AND data_cstmeta.tool_id = data_tool.id
> ORDER BY data_cstmeta.date_time desc;
>
> And now it fails with:
>
> ERROR 1054 (42S22): Unknown column 'dat
On Mon, Jan 28, 2013 at 8:56 AM, Shawn Green wrote:
> Hello Larry,
>
>
> On 1/28/2013 10:42 AM, Larry Martell wrote:
>>
>> I have a query that works fine:
>>
>>
>> SELECT data_ppl.name as 'P/P/L', data_recipe.name as Recipe,
>> data_cst
va,
> etc) to do "presentation" type stuff.
>
> Yes, it could be done is SQL, but my brain might explode if I try to conjure
> up such.
>
>> -Original Message-
>> From: Larry Martell [mailto:larry.mart...@gmail.com]
>> Sent: Monday, December 17, 2012 5
On Tue, Dec 11, 2012 at 7:22 PM, wrote:
>>>>> 2012/12/11 16:19 -0500, Larry Martell >>>>
> I have this query:
>
> SELECT data_target.name, ep, wafer_id, lot_id,
>date_time, data_file_id, data_cstimage.name,
>bottom, wf_file_pa
d is NULL I don't get that data_cst row. But
I changed the RIGHT JOIN to a LEFT JOIN and then it was doing exactly
what I wanted. Thanks for all the help!
> On 2012-12-11 5:11 PM, Larry Martell wrote:
>
> SELECT data_target.name, ep, wafer_id, lot_id,
>>
>>date_time,
On Wed, Dec 12, 2012 at 8:25 AM, Shawn Green wrote:
> On 12/11/2012 7:22 PM, h...@tbbs.net wrote:
>>
>> ... (Are all the distinct "id"s really needed? When one joins on a
>>
>> field with the same name in both tables, one may use 'USING', and
>> only the common field, with neither NULL, shows up i
On Tue, Dec 11, 2012 at 5:12 PM, Peter Brawley
wrote:
>
> On 2012-12-11 3:19 PM, Larry Martell wrote:
>
> I have this query:
>
> SELECT data_target.name, ep, wafer_id, lot_id,
>date_time, data_file_id, data_cstimage.name,
>bottom, wf_file_path_
On Tue, Nov 13, 2012 at 9:56 PM, sagar bs wrote:
> Hi,
>
> As i have the data with some 25 variables in csv file and i need to import
> to mysql.
> The issue is that the date format in csv file is dd/mm/ and mysql takes
> the date format like /mm/dd.
> The number of variables in the csv f
On Mon, Nov 12, 2012 at 2:11 PM, Tianyin Xu wrote:
> Hi, guys,
>
> I'm new to MySQL. I installed MySQL step-by-step according to the manual
> from source code. The version is mysql-5.5.28.
>
> When I start the server using:
> #bin/mysqld_safe --user=mysql
>
> The server failed to start with the fo
ses.
It finally finished after 55 hours.
> On Fri, Sep 28, 2012 at 2:22 AM, Larry Martell
> wrote:
>>
>> On Thu, Sep 27, 2012 at 2:37 PM, Akshay Suryavanshi
>> wrote:
>> > Hi,
>> >
>> > The alter taking such a long time, could be due to composi
up the alter, but what I was really
looking for here was a way to monitor its progress.
> On Fri, Sep 28, 2012 at 2:22 AM, Larry Martell
> wrote:
>>
>> On Thu, Sep 27, 2012 at 2:37 PM, Akshay Suryavanshi
>> wrote:
>> > Hi,
>> >
>> > The alte
ote:
>>
>> Isn't ALTER a DDL, not DML? So I don't think you would find anything in
>> undo logs.
>>
>> > -Original Message-
>> > From: Larry Martell [mailto:larry.mart...@gmail.com]
>> > Sent: Thursday, September 27, 2012 1:20 PM
&
gt; -Original Message-----
>> From: Larry Martell [mailto:larry.mart...@gmail.com]
>> Sent: Thursday, September 27, 2012 1:20 PM
>> To: Rick James
>> Cc: mysql mailing list
>> Subject: checking progress of alter table on an InnoDB table (Was: Re:
>> checking progress of
e sizes would be optimistic.
>
>> -Original Message-
>> From: Larry Martell [mailto:larry.mart...@gmail.com]
>> Sent: Wednesday, September 26, 2012 8:52 AM
>> To: mysql mailing list
>> Subject: checking progress of alter table on a MyISAM table
>>
>> Is
Is there any way to check on the progress of a long running alter
table on a MyISAM table? I know it can be done with an InnoDB table,
but I haven't found a way to do it on with a MyISAM table.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:/
lr.ep = q1.ep
In fact I had to do this for all the joins.
Thanks again for all your help!
>
>> -Original Message-
>> From: Larry Martell [mailto:larry.mart...@gmail.com]
>> Sent: Wednesday, September 19, 2012 3:22 PM
>> To: Rick James
>> Cc: peter.braw...
78, 779,
780, 45, 44, 116, 117, 118, 119, 120, 121)
AND cm.date_time BETWEEN '2010-03-04 00:00:00' AND
'2010-03-04 23:59:59' ,
data_target
WHERE data_target.id = q1.target_name_id
GROUP BY q1.target_name_id, q1.ep
to ensure I'm getting the correct rows back.
Thanks for all the help!
On Wed, Sep 19, 2012 at 10:07 AM, Larry Martell wrote:
> On Tue, Sep 18, 2012 at 7:41 PM, Rick James wrote:
>> SELECT ((the appropriate id)) -- <--
>> FROM data_cst, rollup, data_target
>&g
On Wed, Sep 19, 2012 at 10:26 AM, Larry Martell wrote:
> On Wed, Sep 19, 2012 at 12:04 AM, wrote:
>>>>>> 2012/09/18 06:53 -0400, Larry Martell >>>>
>> This works fine. But now I need to get a certain column
>> (image_measurer_id) with each row ret
On Wed, Sep 19, 2012 at 12:04 AM, wrote:
>>>>> 2012/09/18 06:53 -0400, Larry Martell >>>>
> This works fine. But now I need to get a certain column
> (image_measurer_id) with each row returned that corresponds to the row
> from the group that has botto
On Wed, Sep 19, 2012 at 12:04 AM, wrote:
>>>>> 2012/09/18 06:53 -0400, Larry Martell >>>>
> This works fine. But now I need to get a certain column
> (image_measurer_id) with each row returned that corresponds to the row
> from the group that has botto
9) q1
join data_cst mn ON mn.bottom = q1.minbottom
join data_cst mx on mx.bottom = q1.maxbottom
join data_cst lr on lr.date_time = q1.LastRun,
data_target
WHERE data_target.id = q1.target_name_id
GROUP BY q1.target_name_id, q1.ep;
>
>> -Original Message-
>> From: Larry M
tom`);
Any way to work that into another join?
Thanks!
>
>> -Original Message-
>> From: Larry Martell [mailto:larry.mart...@gmail.com]
>> Sent: Tuesday, September 18, 2012 12:54 PM
>> To: Rick James
>> Cc: peter.braw...@earthlink.net; mysql@lists.mysql.com
>&
to parse the data and stuff it into the context that will be
picked up by the browser yourself. The single query class does that
for you. I may yet go that way, but I'm trying to avoid a big rewrite
if I can.
>> -Original Message-
>> From: Larry Martell [mailto:larry.mart...@gm
On Tue, Sep 18, 2012 at 7:56 AM, Larry Martell wrote:
> On Tue, Sep 18, 2012 at 7:52 AM, Peter Brawley
> wrote:
>> On 2012-09-18 5:53 AM, Larry Martell wrote:
>>>
>>> I have this query:
>>>
>>> SELECT data_target.name as Target,
>>
On Tue, Sep 18, 2012 at 7:52 AM, Peter Brawley
wrote:
> On 2012-09-18 5:53 AM, Larry Martell wrote:
>>
>> I have this query:
>>
>> SELECT data_target.name as Target,
>> q1.ep as EP,
>> COUNT(*) as Wafers,
>> Lots,
>>
I have this query:
SELECT data_target.name as Target,
q1.ep as EP,
COUNT(*) as Wafers,
Lots,
SUM(numonep)/(COUNT(*)+SUM(CASE WHEN reruns > 0 THEN reruns
ELSE 0 END)) as 'Sites/Wafer',
MAX(LastRun) as "Last Run",
SUM(CASE WHEN reruns > 0 THEN reruns ELSE 0
On Thu, Aug 23, 2012 at 8:08 AM, Larry Martell wrote:
> On Tue, Aug 21, 2012 at 8:26 PM, Larry Martell
> wrote:
>> On Tue, Aug 21, 2012 at 8:07 PM, wrote:
>>>>>>> 2012/08/21 16:35 -0600, Larry Martell >>>>
>>> I am trying to write a query
On Tue, Aug 21, 2012 at 8:26 PM, Larry Martell wrote:
> On Tue, Aug 21, 2012 at 8:07 PM, wrote:
>>>>>> 2012/08/21 16:35 -0600, Larry Martell >>>>
>> I am trying to write a query that selects from both a correlated
>> subquery and a table in the m
On Tue, Aug 21, 2012 at 8:07 PM, wrote:
>>>>> 2012/08/21 16:35 -0600, Larry Martell >>>>
> I am trying to write a query that selects from both a correlated
> subquery and a table in the main query, and I'm having a lot of
> trouble getting the prope
1 - 100 of 126 matches
Mail list logo
