hould be used
instead.
Is that true? Am I doing something wrong?
Thanks,
-Travis
set time_zone='Europe/Kiev';
-Original Message-
From: Andre Polykanine [mailto:an...@oire.org]
Sent: Thursday, February 24, 2011 10:23 AM
To: mysql@lists.mysql.com
Subject: Changing the timezone
Hi everyone,
since I'm using the shared hosting, I can't change the default
timezone
on to
use a database connection pool.
-Travis
-Original Message-
From: Madan Thapa [mailto:madan.feedb...@gmail.com]
Sent: Wednesday, February 16, 2011 3:35 PM
To: mysql@lists.mysql.com
Subject: mysql TIME_WAIT
Hi,
When i do a netstat and grep port 3306 , i can see lots of TIME_WAIT.
Here's one option to "pivot" your results:
select
record_id
,max(soi) as soi
,max(heading) as heading
,max(description) as description
,max(relloc) as relloc
from
(select
record_id
,if(field_name = 'SOI', field_value, '') as soi
,if(field_name = 'Heading', field_va
Maybe some sort of logarithmic expression?
select no_of_jobs, 10 * log(10, no_of_jobs) as job_weight
from data;
Of course, you'd have to tweak your coefficients to match the weighting
system you want to use.
-Travis
-Original Message-
From: Richard Reina [mailto:gatorre...@gmai
What columns do you have indexed on your event_log table? Can you post the
output from SHOW CREATE TABLE? How long does the query run for?
-Original Message-
From: Andy Wallace [mailto:awall...@ihouseweb.com]
Sent: Friday, February 04, 2011 10:29 AM
To: mysql list
Subject: Table/select p
user_id, last_changed
from data) s1
where s1.user_id = 3
group by team_id, user_id;
-Travis
-Original Message-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Thursday, February 03, 2011 6:34 AM
To: [MySQL]
Subject: SELECT Help
Hi,
I've the following list of sample
You might check here: http://www.census.gov/geo/www/tiger/
-Travis
-Original Message-
From: viraj [mailto:kali...@gmail.com]
Sent: Wednesday, February 02, 2011 3:31 AM
To: mysql@lists.mysql.com
Subject: map polygon data for popular us cities
dear list,
where can i find a list of map
my_table
where sex_id = @sex
or country_id = @country
or education_id = @education
order by num_matches desc;
-Travis
-Original Message-
From: Ali A.F.N [mailto:alio...@yahoo.com]
Sent: Thursday, October 21, 2010 7:58 AM
To: mysql@lists.mysql.com
Subject: Percent of match in condition
join, indexing that column may not be a benefit. Running
EXPLAIN will tell you whether or not the index you anticipate is actually
being used for your query.
-Travis
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Friday, October 15, 2010 3:43 AM
To: [MySQL]; Travis Ard
Subje
and add to
your storage requirements.
-Travis
-Original Message-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Wednesday, October 13, 2010 8:37 AM
To: [MySQL]
Subject: Primary key not unique on InnoDB table
I've the following table. But why isn't the pri
Sorry, try changing the column mappings.ip to use the table aliases (m.ip
and m2.ip).
-Travis
From: Paul Halliday [mailto:paul.halli...@gmail.com]
Sent: Tuesday, October 12, 2010 11:37 AM
To: Travis Ard
Cc: mysql@lists.mysql.com
Subject: Re: Can this query be done w/o adding another
d, ip_proto
ORDER BY maxTime DESC
LIMIT 10;
-Travis
-Original Message-
From: Paul Halliday [mailto:paul.halli...@gmail.com]
Sent: Tuesday, October 12, 2010 10:49 AM
To: mysql@lists.mysql.com
Subject: Can this query be done w/o adding another column?
Geez, really taking advantage of the list tod
2301055
AND m.src_ip IS NULL;
-Travis
-Original Message-
From: Paul Halliday [mailto:paul.halli...@gmail.com]
Sent: Tuesday, October 12, 2010 10:08 AM
To: Johnny Withers
Cc: mysql@lists.mysql.com
Subject: Re: Can this be done with a single query?
On Tue, Oct 12, 2010 at 11:14 AM, Johnny
Maybe you could use something like the following to truncate your times to
10 minute increments before doing your GROUP BY and COUNT():
select concat(date_format(timestamp_col, '%Y-%m-%d %H:'),
truncate(minute(timestamp_col) / 10, 0), '0') from y
SERT
trigger on your stats table so your application wouldn't need to worry about
it.
-Travis
-Original Message-
From: Jake Peavy [mailto:djstu...@gmail.com]
Sent: Tuesday, October 05, 2010 10:34 AM
To: MySQL General Mailing List
Subject: Re: Add "record number" to timesta
I don't believe it's possible to do what you're suggesting. At least,
according to the second example on this page:
http://dev.mysql.com/doc/refman/5.1/en/subquery-errors.html.
-Travis
-Original Message-
From: Ramsey, Robert L [mailto:robert-ram...@uiowa.edu]
Sent: Mo
Try using the IS NULL operator instead of !
-Travis
-Original Message-
From: Andy Wallace [mailto:awall...@ihouseweb.com]
Sent: Thursday, September 16, 2010 10:47 AM
To: mysql@lists.mysql.com
Subject: Update query problem
So I'm having a problem with an update query. I have
You could try
SELECT ... INTO OUTFILE ...
Also, if you just want to look at the data a page at a time, try setting
your pager variable to your favorite pager program.
mysql> pager /usr/bin/less
and unset it with \n
mysql> \n
-Travis
-
When the explain output says "Using filesort", it doesn't necessarily mean
it is sorting on disk. It could still be sorting in memory and, thus, be
reasonably fast. You might check the value of Created_tmp_disk_tables
before and after your query to see for sure.
-Travis
-O
n_remaining = 0
order by players.teams_id, players_master.rating desc) s1
where rank <= 11
group by teams_id;
-Travis
-Original Message-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Thursday, September 09, 2010 1:58 AM
To: [MySQL]
Subject: Fwd: Query SUM help
Any
Does this work?
select *
from t1
join t2 on (t1.datum = t2.sdat or dayname(t1.datum) = t2.tag);
-Travis
-Original Message-
From: mysql [mailto:my...@ayni.com]
Sent: Tuesday, September 07, 2010 1:43 AM
To: mysql@lists.mysql.com
Subject: Conditional join of tow tables
Hi listers
mysql
Have you considered adding a secondary index on the units column for your
delete queries?
DELETE FROM clientinfo WHERE units='155618918';
-Original Message-
From: Alexandre Vieira [mailto:nul...@gmail.com]
Sent: Thursday, September 02, 2010 8:46 AM
To: John Daisley; joh...@pixelated.net
r:
select distinct a.val
from tablec c
inner join tableb b on b.id = c.id
inner join tablea a on a.num = b.num
where c.state = 'Yes';
-Travis
-Original Message-
From: Michael Stroh [mailto:st...@astroh.org]
Sent: Monday, August 30, 2010 4:39 PM
To: MySql
Subject: Nested jo
it is too awkward to
query this table twice and union the results, then you might want to add a
summary table.
-Travis
-Original Message-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Wednesday, August 25, 2010 2:06 PM
To: Travis Ard
Cc: [MySQL]
Subject: Re: Calcula
I think your match table has all the information necessary to display the
results you want. Since each record contains data for two teams (home and
away), you'd probably need to select each separately and union the results
together before summarizing. Your query might look something like the
foll
You could try doing a multi-master configuration by setting up mysql proxy
to receive changes from 1, 2, and 3 and replicate to 4.
-Travis
-Original Message-
From: Nunzio Daveri [mailto:nunziodav...@yahoo.com]
Sent: Monday, August 23, 2010 3:28 PM
To: mysql@lists.mysql.com
Subject
Something like this might work:
insert into domains
select a.accountid, reverse(a.domainid), a.mailname
from domains a
left outer join domains b on b.domainid = reverse(a.domainid) and
b.accountid = a.accountid and b.mailname = a.mailname
where b.domainid is null;
-Travis
move older data,
it will be very easy to simply drop the partition(s) you no longer need.
-Travis
-Original Message-
From: Guillaume Blanc [mailto:guillaume.b.bl...@gmail.com]
Sent: Friday, August 20, 2010 8:55 AM
To: mysql@lists.mysql.com
Subject: Limit the size of a database. Rotate the
What are you using as your primary key on this table? Is an auto_increment
field or something non-sequential? Do you have your secondary indexes in
place while you load the table or are you explicitly disabling them and
re-enabling them afterward?
-Travis
-Original Message-
From: Xn
Maybe something like this:
select
user_id
,max(if(meta_key = 'zip_code', meta_value, null)) as zip_code
,max(if(meta_key = 'first_name', meta_value, null)) as first_name
,max(if(meta_key = 'last_name', meta_value, null)) as last_name
from wp_userm
Can you create a second, indexed column in your feed_new temp table that
includes the title without the year appended? That might allow you to get
by with a single pass through the larger prod table and avoid reading rows
from the feed_new table.
-Travis
-Original Message-
From: Jerry
Sorry, I am not aware of a windows-specific version. You might check with the
script author, or you may be able to get this to work on windows by installing
cygwin and using a bash shell.
-Travis
> Date: Mon, 2 Aug 2010 12:20:57 +0100
> Subje
> (step.n - 5) and calls.queue_seconds
<= step.n
group by n;
+---+---+
| calls | queue_seconds |
+---+---+
| 250 | 0 |
| 168 | 5 |
| 268 | 10 |
| 0 | 15 |
+---+---+
4 rows in set (0.00 sec)
-
Something like this mysql-summary script might be useful:
http://code.google.com/p/aspersa/wiki/mysql_summary
-Travis
> Date: Fri, 30 Jul 2010 12:19:07 +0100
> Subject: script of mysql
> From: pratikshadjayswa...@gmail.com
> To: mysql@lis
You could try it inside a "here" document:
mysql < Date: Thu, 29 Jul 2010 14:29:55 -0500
> From: todd_...@ssiresults.com
> To: mysql@lists.mysql.com
> Subject: Variable Expansion Using MySQL Client and .sql Files
>
> Hey all,
>
> I've found many packages that sit on top of MySQL for various clien
With some databases such as MySQL, subqueries have to be explicitly named. For
example
select * from (select * from (select * from table) sub1) sub2;
If not, you will see an error like: "ERROR 1248 (42000): Every derived table
must have its own alias"
If
I understand your problem correctly,
fine, but I want to make sure
that mysqld is taking advantage of my multiple processors. Has the
htreading model changed and now MYSQL will only run one mysqld OR have
I missed something and need to enable it?
Am I getting the best bang for my buck by haveing just one mysqld running?
Travis
ual Basic, MyODBC or MySQL itself. I don't know what to
try next.
As always, any help is greatly appreciated.
Thanks again,
Travis Eland
-Original Message-
From: sheeri kritzer [mailto:[EMAIL PROTECTED]
Sent: Fri 5/12/2006 10:01 AM
To: Eland, Travis M.
Cc: mysql@lists.mysql.com
Sub
ut is greatly appreciated.
Thanks,
Travis Eland
From: sheeri kritzer [mailto:[EMAIL PROTECTED]
Sent: Thu 5/4/2006 4:15 PM
To: Eland, Travis M.
Cc: mysql@lists.mysql.com
Subject: Re: ORDER BY making recordset non-updatable
Maybe I'm thick
You have a view
Heya.
I am in the process of modifying a program to access data from a MySQL database
instead of a SQL Server database. I have a view that is referenced as follows
(through use of a data environment command):
Select * from vwMyView where id = ?
If I run this command, I get the data that I
+++ sql/item_timefunc.ccSun Jul 3 16:26:19 2005
@@ -2686,7 +2686,7 @@
month_end--;
months= 12*diff_years;
-while (month_beg != month_end)
+while (month_beg != month_end || year != year_end)
{
uint m_days= (uint) days_in_month[month_beg];
if (month_beg ==
update gci_copy,dis set
gci_copy.products_description=concat_ws('',gci_copy.products_description,dis.products_model,dis.products_description)
where gci_copy.products_image=dis.products_image
only able to caoncat one match
possiable work arounds.
__
We have started using http://www.datahive.ca/ and they've been great and
can't beat the prices.
Travis
EP wrote:
is it just me, or do hosts underestimate how much data we might want
to put in a MySQL database? For instance, 250MB, the largest plan
from that host would not com
I have a brand new fresh install of SUSE 9, 64 bit and am trying to
install mysql 64 bit, but I get the following output: I've bolded the
important lines (or at least what i think is important). Has anybody
experienced this?
linux:~ # rpm -i --force MySQL-server-4.0.17-0.x86_64.rpm
warning: M
Very much so. That's why I'm trying to get as much juice out of the cpu
as possible.
Travis
Dan Nelson wrote:
In the last episode (Jan 05), Travis Reeder said:
I'm sure this has been asked before, but I cannot find solid evidence
as to whether switching would provide us wi
s wouldn't be locking)?
And if so, would it be enough to justify the extra space required for
innodb?
Regards,
Travis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Here's a little how to on using cron and scp to do automated backups of
your data:
http://www.spaceprogram.com/knowledge/cron_scp.html
Only thing you need to add is the a mysqldump line to your cron script
before calling the scp.
Travis
A. Clausen wrote:
avenger wrote:
but if my tab
out how to best handle it.
> Any idea why? Are you doing too many table scans? Too much
> computation in the queries? Lots of LIKE "%foo%" queries?
There is maybe 1 LIKE query and I'm sure that's not causing any issues.
Travis
Jeremy Zawodny wrote:
On Tue, Oct 21
I'm sure this has been asked before, but after seeing some benchmarks,
it looks like using innodb is a no brainer. Just want to know why you
wouldn't use innodb?
Travis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists
Would innodb tables help?
Travis
Daniel Kasak wrote:
Travis Reeder wrote:
It seems mostly to be mysql pinned, not the app. like 99% mysql until
all data is processed and keeps going up when data coming in is more
than can be processed.
What could I change in my.cnf to get better
It seems mostly to be mysql pinned, not the app. like 99% mysql until
all data is processed and keeps going up when data coming in is more
than can be processed.
What could I change in my.cnf to get better performance? I just have a
default mysql install (4.0).
Travis
Daniel Kasak wrote
h mysql on it, a second one to handle application
(collecting and reporting on data)
Which do you think would be better?
Travis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Are there any gurus out there that can help with optimizing queries /
mysql database, little freelance work? Maybe if I can get the
processing time down, this won't be as much of an issue.
Travis
David Brodbeck wrote:
-Original Message-
From: Travis Reeder [mailto:[EMAIL PROT
It's running on Redhat 9.
Travis
Jeremy Zawodny wrote:
On Thu, Oct 16, 2003 at 02:45:26PM -0600, Travis Reeder wrote:
Is there a way to give mysql a lower priority? I have an app that is
constantly using the database and it is pinning the processor constantly
which makes it hard for
Is there a way to give mysql a lower priority? I have an app that is
constantly using the database and it is pinning the processor constantly
which makes it hard for other applications to run.
Travis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
exact opposite, so 2 entreies in table1 on the same day, i'm not
too worried about this at this at the moment.
So how can I ensure to only get one of each? Distinct does not work.
Travis
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
n all Rows, same behaviour - 1000 rows outputted
only. When
I select Return Limit, and enter a very large number, I then get the all of
the rows retrieved and
displayed ...
Is this a bug ?
Thanks,
Travis Weir
Cognos Inc.
Join us at Cognos' biggest event of the year Enterprise 2003,
Thanks for the response..it was helpful.
The information I was missing was that numeric values appear in MYSQL_ROW
arrays as null-terminated strings, not as binary data.
Travis
On 2003.02.26 00:58 Bernhard Döbler wrote:
> Hi Travis,
>
> so far I see, you cannot simply interpret &#
OW, and is there a usual way to
extract these data into regular C datatypes?
Thanks,
Travis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
configured with --with-embedded-server but, as far as I can tell, the
embedded server was added with the 4.0 release.
Anyway, binaries for the 4.0 embedded server are available for download.
---
Travis McLeskey - [EMAIL PROTECTED]
-
Interesting, some of the databases were owned by root.
I chainged ownership back to mysql and now they all work. Even the one i had
trouble with after recovering from mysqlhotcopy.
Thanks much,
~Travis
>Error 13 is permission denied.
>
>chown -R mysql:mysql /var/lib/mysql ( or
e
server machine but not always.
Quick help would be very much appreciated, as this seems to have gone from
bad to worse.
Thanks in advance,
~Travis
PS - I have just finished backing up all the databases using mysqldump as
well as mysqlhotcopy (a little redundant but I don
If it's not too much trouble this is slightly urgent.
~Travis
>I have the database files, now how do I put them back into mysql?
>
>Restore table doesn't seem to work.
>
>Thanks in advance,
>~Travis
_
I have the database files, now how do I put them back into mysql?
Restore table doesn't seem to work.
Thanks in advance,
~Travis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
ports that stuff.
Travis Reeder
Chief Software Architect
ThinkVirtual
Original Message
From: Ghetalion <[EMAIL PROTECTED]>
Sent: 2001-04-04 23:33:37.0
To: [EMAIL PROTECTED]
Subject: SELECT and ORDER OPTIONS
I figure since there are various ways to sort information in SQL, there m
How do you update the contents of a specific field in a database? Say I
have a column named Name in a table, and a row has the contents of that
column set to "Jhon". Now, the user accidently spelled John wrong and would
like to update it, how can I do that?
er or characters in the
story, not set aside that many bytes.
Thanks very much. If anyone could suggest a good website for this kind of thing,
other than the MySQL homepage, or even a good book. Thanks very much.
Travis Gant
---
[EMAIL PROTECTED]
http://slardy.yi.org/nu-vision/
68 matches
Mail list logo
