Surge 2010 Early Registration ends Tuesday!
Early Bird Registration for Surge Scalability Conference 2010 ends next Tuesday, August 31. We have a killer lineup of speakers and architects from across the Internet. Listen to experts talk about the newest methods and technologies for scaling your Web presence. http://omniti.com/surge/2010/register This year's event is all about the challenges faced (and overcome) in real-life production architectures. Meet the engineering talent from some of the best and brightest throughout the Internet: John Allspaw, Etsy Theo Schlossnagle, OmniTI Bryan Cantrill, Joyent Rasmus Lerdorf, creator of PHP Tom Cook, Facebook Benjamin Black, fast_ip Christopher Brown, Opscode Artur Bergman, Wikia Baron Schwartz, Percona Paul Querna, Cloudkick Surge 2010 takes place at the Tremont Grand Historic Venue on Sept 30 and Oct 1, 2010 in Baltimore, MD. Register NOW for the Early Bird discount and guarantee your seat to this year's event! -- Jason Dixon OmniTI Computer Consulting, Inc. jdi...@omniti.com 443.325.1357 x.241 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Register now for Surge 2010
Registration for Surge Scalability Conference 2010 is open for all attendees! We have an awesome lineup of leaders from across the various communities that support highly scalable architectures, as well as the companies that implement them. Here's a small sampling from our list of speakers: John Allspaw, Etsy Theo Schlossnagle, OmniTI Rasmus Lerdorf, creator of PHP Tom Cook, Facebook Benjamin Black, fast_ip Artur Bergman, Wikia Christopher Brown, Opscode Bryan Cantrill, Joyent Baron Schwartz, Percona Paul Querna, Cloudkick Surge 2010 focuses on real case studies from production environments; the lessons learned from failure and how to re-engineer your way to a successful, highly scalable Internet architecture. The conference takes place at the Tremont Grand Historic Venue on Sept 30 and Oct 1, 2010 in Baltimore, MD. Register now to enjoy the Early Bird discount and guarantee your seat to this year's event! http://omniti.com/surge/2010/register Thanks, -- Jason Dixon OmniTI Computer Consulting, Inc. jdi...@omniti.com 443.325.1357 x.241 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Last day to submit your Surge 2010 CFP!
Today is your last chance to submit a CFP abstract for the 2010 Surge Scalability Conference. The event is taking place on Sept 30 and Oct 1, 2010 in Baltimore, MD. Surge focuses on case studies that address production failures and the re-engineering efforts that led to victory in Web Applications or Internet Architectures. You can find more information, including suggested topics and our current list of speakers, online: http://omniti.com/surge/2010 The final lineup should be available on the conference website next week. If you have questions about the CFP, attending Surge, or having your business sponsor/exhibit at Surge 2010, please contact us at su...@omniti.com. Thanks! -- Jason Dixon OmniTI Computer Consulting, Inc. jdi...@omniti.com 443.325.1357 x.241 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
CFP for Surge Scalability Conference 2010
A quick reminder that there's one week left to submit your abstract for this year's Surge Scalability Conference. The event is taking place on Sept 30 and Oct 1, 2010 in Baltimore, MD. Surge focuses on case studies that address production failures and the re-engineering efforts that led to victory in Web Applications or Internet Architectures. Our Keynote speakers include John Allspaw and Theo Schlossnagle. We are currently accepting submissions for the Call For Papers through July 9th. You can find more information, including suggested topics and our current list of speakers, online: http://omniti.com/surge/2010 I'd also like to urge folks who are planning to attend, to get your session passes sooner rather than later. We have limited seating and we are on track to sell out early. For more information, including the CFP, sponsorship of the event, or participating as an exhibitor, please visit the Surge website or contact us at su...@omniti.com. Thanks, -- Jason Dixon OmniTI Computer Consulting, Inc. jdi...@omniti.com 443.325.1357 x.241 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
CFP for Surge Scalability Conference 2010
We're excited to announce Surge, the Scalability and Performance Conference, to be held in Baltimore on Sept 30 and Oct 1, 2010. The event focuses on case studies that demonstrate successes (and failures) in Web applications and Internet architectures. Our Keynote speakers include John Allspaw and Theo Schlossnagle. We are currently accepting submissions for the Call For Papers through July 9th. You can find more information, including our current list of speakers, online: http://omniti.com/surge/2010 If you've been to Velocity, or wanted to but couldn't afford it, then Surge is just what you've been waiting for. For more information, including CFP, sponsorship of the event, or participating as an exhibitor, please contact us at su...@omniti.com. Thanks, -- Jason Dixon OmniTI Computer Consulting, Inc. jdi...@omniti.com 443.325.1357 x.241 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: RENAME TABLE with CONCAT string fails
On May 28, 2005, at 8:51 AM, Paul DuBois wrote: At 8:12 -0400 5/28/05, Jason Dixon wrote: I'm trying to rename some tables for archival, but the table renaming is failing when I use CONCAT() to form the table string name: CONCAT() produces a string, not an identifier. Fine. Is there any way to do this in MySQL or do I need to fall back on my Perl? It's not a big deal, I'm just curious now. Thanks, -- Jason Dixon DixonGroup Consulting http://www.dixongroup.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RENAME TABLE with CONCAT string fails
I'm trying to rename some tables for archival, but the table renaming
is failing when I use CONCAT() to form the table string name:
mysql> RENAME TABLE flows TO flows_tmp, flows_new TO flows, flows_tmp
TO CONCAT("flows_", DATE_SUB(CURDATE(), interval 1 day));
ERROR 1064: You have an error in your SQL syntax near 'CONCAT("flows_",
DATE_SUB(CURDATE(), interval 1 day))' at line 1
If I run the CONCAT() command by itself, everything works as expected:
++
| CONCAT("flows_", DATE_SUB(CURDATE(), interval 1 day)) |
++
| flows_2005-05-27 |
++
1 row in set (0.00 sec)
Is there some magic pixie dust I need to throw around the CONCAT() to
have it interpolate into the RENAME TABLE command correctly? This is
on mysql-server 3.23.58 on a RHEL 3 clone.
Thanks,
--
Jason Dixon
DixonGroup Consulting
http://www.dixongroup.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Table is full [SOLVED]
On Apr 19, 2005, at 1:35 PM, Jason Dixon wrote: I'm trying to do an update to one of my tables, but I'm getting the "table is full" error. I've reviewed the manual (http://dev.mysql.com/doc/mysql/en/full-table.html), but nothing seems to apply. I looked at the output of myisamchk, and everything looks fine. The table file is only ~100M, and the partition has almost 4G of free space. The proposed update would only add approx 1byte per row, so I just don't see how this query can cause a full table. Can someone clue me in here? This turned out to not be a problem with a full table at all. I found that I was able to update rows at chunks of ~70 rows at a time. Anything larger than ~80 would result in the full table error. I found the following bug which apparently was fixed in 4.0.13 (I am using 4.0.11): http://bugs.mysql.com/bug.php?id=230 -- Jason Dixon DixonGroup Consulting http://www.dixongroup.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Table is full
I'm trying to do an update to one of my tables, but I'm getting the "table is full" error. I've reviewed the manual (http://dev.mysql.com/doc/mysql/en/full-table.html), but nothing seems to apply. I looked at the output of myisamchk, and everything looks fine. The table file is only ~100M, and the partition has almost 4G of free space. The proposed update would only add approx 1byte per row, so I just don't see how this query can cause a full table. Can someone clue me in here? [EMAIL PROTECTED] root]# myisamchk -dv /var/db/mysql/pflabel/statstest.MYI MyISAM file: /var/db/mysql/pflabel/statstest.MYI Record format: Packed Character set: latin1 (8) File-version:1 Creation time: 2005-04-19 12:00:51 Recover time:2005-04-19 12:03:44 Status: checked,analyzed Auto increment key: 1 Last value: 2022514 Data records: 1911283 Deleted blocks: 0 Datafile parts:1911283 Deleted data: 0 Datafile pointer (bytes):4 Keyfile pointer (bytes):4 Datafile length: 104946052 Keyfile length: 74199040 Max datafile length:4294967294 Max keyfile length: 4398046510079 Recordlength: 550 table description: Key Start Len Index Type Rec/key Root Blocksize 1 1 4 unique unsigned long 1 5110784 1024 2 260 255 multip. char packed stripped 12574 27400192 2048 3 535 8 multip. ulonglong 16 50799616 1024 4 543 8 multip. ulonglong186 74198016 1024 Thanks, -- Jason Dixon DixonGroup Consulting http://www.dixongroup.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Group by datetime [SUMMARY]
On Mar 29, 2005, at 10:38 PM, Jason Dixon wrote:
Anyways, I have a simple schema that stores some IP accounting data.
I'm attempting to extract the data, grouping by the service type
("label"), and also grouping by each 24-hour window/day from the
datetime column ("timestamp"). I'm not sure how to accomplish this
type of query, but I'm hoping someone here will help me do this in SQL
and avoid having to do it in my Perl code. Thanks in advance!
I finally managed to grind out what I'm looking for. This is primarily
for the archives...
mysql> SELECT label, SUM(bytes) as bytes, SUM(packets) as packets,
SUM(evals) as evals, DATE_FORMAT(timestamp, '%Y-%m-%d') as date from
stats GROUP BY label, date ORDER BY date asc, bytes desc;
++-+-+---++
| label| bytes | packets | evals | date
|
++-+-+---++
| other-outbound | 630864 |1104 | 149 | 2005-03-27 |
| other-inbound | 583571 |5748 | 149 | 2005-03-27 |
| site1-inbound-ssh | 112657 | 756 |16 | 2005-03-27 |
| site1-inbound-http | 38700 | 165 |16 | 2005-03-27 |
| site1-inbound-default | 0 | 0 | 149 | 2005-03-27 |
| site1-outbound-default | 0 | 0 | 149 | 2005-03-27 |
| site1-outbound-ssh | 0 | 0 | 0 | 2005-03-27 |
| site1-outbound-http| 0 | 0 | 0 | 2005-03-27 |
| site2-inbound | 0 | 0 | 149 | 2005-03-27 |
| site2-outbound | 0 | 0 | 149 | 2005-03-27 |
| other-outbound | 637008 |1148 | 151 | 2005-03-28 |
| other-inbound | 591209 |5792 | 151 | 2005-03-28 |
| site1-inbound-ssh | 112657 | 756 |16 | 2005-03-28 |
| site5-inbound |1900 | 23 | 149 | 2005-03-28 |
| site3-inbound | 0 | 0 | 149 | 2005-03-28 |
| site3-outbound | 0 | 0 | 149 | 2005-03-28 |
| site4-inbound | 0 | 0 | 149 | 2005-03-28 |
| site4-outbound | 0 | 0 | 149 | 2005-03-28 |
| site5-outbound | 0 | 0 | 149 | 2005-03-28 |
| site1-inbound-default | 0 | 0 | 151 | 2005-03-28 |
| other-inbound | 1561931 | 11173 | 895 | 2005-03-29 |
| site1-inbound-http | 77400 | 330 |31 | 2005-03-29 |
| other-outbound | 46024 | 330 | 895 | 2005-03-29 |
| site5-inbound |1900 | 23 | 1046 | 2005-03-29 |
| site1-outbound-default | 0 | 0 | 1046 | 2005-03-29 |
| site1-outbound-ssh | 0 | 0 | 0 | 2005-03-29 |
| site1-outbound-http| 0 | 0 | 0 | 2005-03-29 |
| site2-inbound | 0 | 0 | 1046 | 2005-03-29 |
| site2-outbound | 0 | 0 | 1046 | 2005-03-29 |
| site3-inbound | 0 | 0 | 1046 | 2005-03-29 |
| site3-outbound | 0 | 0 | 1046 | 2005-03-29 |
| site4-inbound | 0 | 0 | 1046 | 2005-03-29 |
| site4-outbound | 0 | 0 | 1046 | 2005-03-29 |
| site5-outbound | 0 | 0 | 1046 | 2005-03-29 |
| site1-inbound-default | 0 | 0 | 895 | 2005-03-29 |
| site1-inbound-ssh | 0 | 0 |15 | 2005-03-29 |
++-+-+---+----+
36 rows in set (0.01 sec)
--
Jason Dixon
DixonGroup Consulting
http://www.dixongroup.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Group by datetime
Hi folks-
This is my first post to any MySQL lists, so be gentle. If I'm posting
SQL queries to the wrong forum, please direct me to the proper
resources.
Anyways, I have a simple schema that stores some IP accounting data.
I'm attempting to extract the data, grouping by the service type
("label"), and also grouping by each 24-hour window/day from the
datetime column ("timestamp"). I'm not sure how to accomplish this
type of query, but I'm hoping someone here will help me do this in SQL
and avoid having to do it in my Perl code. Thanks in advance!
CREATE TABLE stats (
id int(10) unsigned NOT NULL auto_increment,
host varchar(255) NOT NULL default '',
label varchar(255) NOT NULL default '',
evals bigint(20) unsigned NOT NULL default '0',
packets bigint(20) unsigned NOT NULL default '0',
bytes bigint(20) unsigned NOT NULL default '0',
date datetime NOT NULL default '-00-00 00:00:00',
PRIMARY KEY (id)
) TYPE=MyISAM;
mysql> select * from stats limit 2\G;
*** 1. row ***
id: 1
host: test2
label: http-inbound
evals: 149
packets: 5748
bytes: 583571
date: 2005-03-27 22:23:45
*** 2. row ***
id: 2
host: test2
label: ssh-inbound
evals: 149
packets: 1104
bytes: 630864
date: 2005-03-27 23:40:09
2 rows in set (0.00 sec)
--
Jason Dixon
DixonGroup Consulting
http://www.dixongroup.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
