text:
Andrew Wiggins finishes official visits to nation's top programs
The past few weeks, Andrew Wiggins has been on a visit spree that would make any college hoops fan drool.
After visiting Florida State earlier in the season, the nation's top player in the class of 2013 took trips to Kentucky, Kansas and North Carolina in just over a week and a half.
The 6-foot-7, five-star wing has never been one to seek publicity, so not a lot of information has leaked out about his visits.
However, Wiggins' coach at Huntington (W.V.) Prep broke down his star player's visits and where he stands in the recruiting process.
First up -- or second if you factor in his previous FSU visit -- was Kentucky, where Wiggins saw the Wildcats host Mississippi State.
"He enjoyed the atmosphere at Rupp," Rob Fulford told Rivals.com. "He saw the North Carolina game there last year so he's seen Rupp at its best in that scenario, so he wasn't overly concerned about who they were playing and the crowd."
For Wiggins, the Kentucky visit was more about getting a feel for the people around the program and seeing how the players respond to the coaches.
"He was just trying to get a feel for the coaches outside of a game and in the gym scenario," Fulford said. "He got a chance to watch a game and to watch practice so it was important to see John Calipari interact with his guys. They've had a down year and Cal has been of of their biggest critics. Andrew understands the magnitude of Big Blue Nation and that anything less than a national championship is a disaster in their eyes."
After tripping to Kentucky, Wiggins made it back to Huntington for a few days before heading back out on the road, this time to Lawrence to see what Bill Self and the Jayhawks would offer.
"It was his first trip there and Phog is one of those venues that is a bucket list venue and everybody knows that," Fulford said. "He really enjoyed the atmosphere as far as the interaction he had with the fans and the players."
It seems that it was his time with the players that stood out during his visit to Lawrence.
"He spoke about being able to spend a little more personal time with the players," Fulford said. "I think he enjoyed the atmosphere there, and I'm not saying he enjoyed the atmosphere there more than others, but he talked about it more than the others."
Bossi: Justise Winslow, Rysheed Jordan highlight weekend visits
Finally, Wiggins spent part of Saturday and Sunday in Chapel Hill as Roy Williams and the Tar Heels hosted Duke.
"He didn't say a whole lot and we were kind of talking about some other things when I picked him up from the airport, so we'll talk more about it (Monday)," Fulford said. "He enjoyed it and obviously it's the Duke game, so the atmosphere is crazy. Carolina made a few runs and but Duke kind of punched them in the mouth."
Even though the game didn't go as Tar Heels fans or coaches would want it to go, Wiggins isn't going to be swayed by a win or a loss.
"He understands that teams don't win every game and it's not ideal to have recruits on campus for a game in that fashion," Fulford said. "But he gets that and he had a really good time. He knows Kennedy Meeks pretty well and talks to him some. he also knows some of those other guys, so he was still able to have a good time."
With the past three visits coming in such a short span, some may be forgetting about Florida State. The Seminoles certainly seemed a little more active earlier, but Wiggins gets that the coaches of his parents' alma mater have a job to do on top of chasing Wiggins around.
"They were in a lot in the early going when they were recruiting Xavier Rathan-Mayes and then after Xavier signed early," said Fulford. "We also played in Florida a couple of times and of course Leonard Hamilton was there to see him and they haven't backed off.
"They are in their season and they have their job so we make sure our guys understand that. Coach Hamilton has a job and chasing down Andrew's every move isn't going to help this year's team, but they've still been there."
So, what does this all mean? When will Wiggins decide?
For now, the only certainty appears to be that Wiggins is done with his official visits. He's slated to play in the McDonald's and Jordan Brand games and they'd both love to have him announce during their games. But nothing like that has been planned.
About the only thing that is certain is that the programs left on his list have a lot to do with the approach of their coaches.
"Each coach that is recruiting him has a little bit of a different style, but I think the thing they all have in common is that they are pretty laid back," Fulford said. "I think Andrew understands that they are all pretty laid-back guys. Andrew is laid back so he gravitates to people who are that way. He's more of an observer."
Though Fulford doesn't yet know where Wiggins will end up, he has been through the experience of recruiting the country's best player. Because of that, he can offer some advice as Wiggins' recruitment winds down.
"I always told people in the recruiting process that I saw him play 24 straight AAU games," Fulford said. "He knew me and I was around all the time and he developed a personal relationship with me. So when the decision had to be made, he knew where he wanted to come and his parents just had to sign off and I don't think this will be any different.
"Fans are important but I don't think they are as important as the people he is going to be associated with on a daily basis. The staff, the administration, the current players and the incoming recruits, he is going to want to feel total comfort with them all."


text:
Take Your Team To The Next Level!—Effective Motorsports Marketing, Part 2
Specialized motorsports marketing agencies and logistics services have helped elevate racing to one of the most sought-after sports venues for corporate advertising dollars. Here's the second part of a two-part series describing how they can help you enhance your image and secure sponsorship opportunities.
By Virginia DeMoss
Sponsorship in racing has evolved to include a company writing a check for a few hundred dollars to help out a local racer up to multi-million dollar, high-profile programs.
In conjunction with the January 2011 issue of Performance Racing Industry, we covered the first part of how to work with sponsors to develop successful partnership programs. Following is more information about how sponsors and race teams can work together to provide a successful marketing and promotion program to meet the needs of each side.
Tailoring To A Sponsor's Needs
General Sports Alliances, Denver, Colorado, is a sports marketing agency that specializes in sponsorship and sales representation for large teams, events, series, and venues in professional sports and entertainment. Most recently, the company was named the exclusive sponsorship sales agency for the inaugural Baltimore Grand Prix, which will be part of the Izod IndyCar Series in 2011."As we approach each project, we utilize the idea that today's environment does not cater to standard, off-the-shelf packages,"
Chris Foy told us. "If you're going to have success in sponsorship, you have to understand what the company you're speaking with wants to achieve and what objectives they would like to see. If you don't address those head-on and do your research, the results are going to be negative."
Foy agreed that many teams could benefit from the know-how a motorsports agency provides. "We're a very solid value proposition when it comes to what we deliver for our clients and the results we achieve," he said. "If they are looking for expertise, not only in terms of connections and a networking standpoint, but also in how they market, how they package, and how they value sponsorship programs, companies like ours would be a suitable option."
The clients at Performance Management & Marketing, Concord, North Carolina, are primarily aftermarket manufacturers, but the company also does sponsor retention for NASCAR series teams and grassroots racers. Todd Luckow told us his youngest driver just turned 10 years old, adding that the company starts working with kids and sponsorships in order to "bring them along the right way in terms of teaching them how to handle sponsors, do interviews, and all of the things they need to know."
Aside from sponsor searches, Performance helps with team management, depending on what stage of the game the team is at. "If it's a start-up team, we usually find ourselves pretty much working with them to set up a good management team with a good marketing strategy," said Luckow.
He also told us the sponsorship market is very encouraging right now. "There are more people willing to look at sponsorship packages this year than there have been in the last five," he said. "We've got companies that are basically looking at first-time ventures into motorsports. There is also a huge barrage of green products that are looking at utilizing motorsports to help get their names in front of a mass of people in a short amount of time. Right now we're dealing with some solar panel manufacturers and a bunch of companies that are using recycled goods—everything from paper and plastic to tires that they grind up and use in asphalt and other surfaces."
Indianapolis, Indiana-based Brand Acceleration is an advertising and PR firm that works primarily in three industries: racing, economic development, and construction. "Sometimes we're fortunate and have clients that overlap in all three," said Jim Walton, pointing to a company they worked with in Charlotte called Motorsport Construction, which specializes in building race shops.
Although it primarily represents industry suppliers, one of Brand Acceleration's current clients is Hendricks County, Indiana, an economic enterprise zone trying to attract racing businesses to the area. Noting that many of the major drag racing teams are based there, Walton said, "We're actively engaged in marketing the county to the racing industry, telling its benefits, relating why you should locate your racing business there. We develop marketing plans for them, including a series of ads targeted to different segments of the industry—drag racing, open wheel, stock car—to build awareness for Hendricks County."
An important part of any race marketing effort is hospitality, and that is one of the specialties of Tysinger Promotions, New Bern, North Carolina, which puts on turnkey events for tracks, teams, and companies. "In reality, we're a marketing and event planning company that can do pretty much anything," said Katie Stewart, who pointed to such services as ad sales, merchandise programs, and data capture for clients like the ADRL.
We asked Stewart why so many racing teams and businesses are turning to experts for their promotional needs. "Mainly because we're good at what we do, and they're good at racing," she answered. "Most teams don't really have the internal infrastructure to pull off events like this. They're busy, they're on the road, they're thinking about racing, not about building their brand or entertaining potential sponsors or managing existing sponsors. That's where we come in."
She said outsourcing those responsibilities also saves on the overhead involved in hiring a staff to do those chores. "It's very efficient," stressed Stewart. "We come in, we work closely with the client so we know exactly what they want, we plan everything from A to Z, so there's no micromanagement needed. When the client shows up, everything is done, and they just enjoy the event and go back to doing what they're good at: racing or putting on a race. We take care of everything and then wrap-up and head out. It's kind of a one-stop shop."
Racers Only
As the name implies, Mackey Motorsports Marketing, Marietta, Georgia, works exclusively in racing, representing the interests of drivers, teams, series, and industry suppliers. "It may be representing a driver in an endorsement opportunity, or helping a vendor produce an ad for a motorsports audience. We just finished producing a catalog for a motorsports apparel brand, and at the same time helped promote a driver at an IndyCar event," offered Brian Mackey.
Mackey agreed that the sponsorship landscape in motorsports has changed dramatically over the past few years, making the services of an agency that specializes in the sport and stays on the cutting-edge of new marketing strategies more a necessity than a luxury today.
"For companies utilizing motorsports as a marketing tool, there is no substitute for experience, and no better way to extract the most benefit from a promotion than using the services of a specialist. We have the experience and the focus to properly sift through the options and help gain the needed perspective to properly align a motorsport theme to a targeted buyer," he stated. "It takes a massive amount of time and research to do the job properly, and few teams, drivers, vendors or even series are properly positioned to do it effectively.
"It used to be much simpler: motorsports marketing was predominantly limited to the passive exposure of branding on the car," Mackey added. "Today, a much more complicated array of marketing strategies is required, which is why we have developed new methods of motorsports marketing and activation and developed partnerships with companies that offer services that have never been tried in racing before. Motorsports marketing has to be much more interactive than in the past; it must communicate with consumers, aka fans, on multiple levels, and must be relevant, attractive and beneficial in order to get them to respond to the promotion."
Race Host, Orlando, Florida, is a full-service marketing/advertising agency that also works exclusively in the motorsports industry. "We work primarily with racing companies, race teams, drivers, and sponsors, using our marketing and communication expertise to help them increase their visibility and brand value by targeting their marketing effort to the racing demographic," said Trey Piccard, who told us the company's clients include TRG Motorsports in NASCAR, PortaTree Racing in NHRA, Big Spot Racing in the NASCAR Nationwide Series, and Riley Technologies and The Racers Group in Grand-Am.
A good example of the kind of marketing savvy required in today's market is the wireless technology that Race Host developed for the TRG team. Explained Piccard, "Team members are able to shoot trackside video and photos then upload them directly to the TRG website, allowing fans to get insider information from TRG in real time. The fans love getting trackside information from the team, and it's a great way to introduce new sponsor products and offerings."
Piccard told us the importance of maximizing visibility, brand recognition, and value has never been greater, yet most teams and companies "simply do not have the personnel in-house to manage marketing at this level. As a result, they hire firms like ours and rely on us to manage their marketing effort. It gives them a distinct advantage over their competition, because they can concentrate on their business, which is racing and winning, and let us handle the marketing."
Growing the Grassroots
Chris Ragle of Tex Motorsports Marketing & Management, Concord, North Carolina, works predominantly in asphalt short track racing. His main objective is helping grassroots racers raise their profiles through publicity and marketing.
"Whether it's a series, a race, or a driver, it's only as big as you make it out to be," he said. "The more you build yourself up and try to make your name known, the easier it will be to attract sponsors and move up to the next level. It's harder to set up a meeting with someone if they don't know anything about you. I'm a big fan of PR campaigns and being involved in anything that's in the public eye, whether it's a show car appearance for a sponsor, a charity event, or any type of promotion that the series does. People know they can call on me and my clients; we're always obliged to do those things."
Ragle provides all of his racers with profiles, promotional videos, and proposals to present to prospective sponsors, and uses his own motorsports photography and video service to get their image out there and get them used to talking on camera.
At the grassroots level, local and regional businesses are ripe for sponsorship opportunities, according to Ragle. "At this level, you're not asking for a lot of money, so you can get some help and promote their product or service. If we go race in Nashville, and there's a business based there, it does no good for them to be represented in Florida. I've built a lot of relationships with companies based in a specific area."
Once a grassroots racer himself, Brian Lillie at eCreative Group, Independence, Iowa, is on a mission to bring higher-level sponsorships into this arena. "That's where it all starts," he said. "Without grassroots racing, there would be no higher levels of racing."
And he makes a compelling case for this market. "When we talk to prospective clients about this, they just don't believe us until we show them the numbers. There are close to 800 dirt tracks in this country, and if you figure 1000 to 1200 fans at least one night a week for 22 to 24 weeks, it's huge. And, demographically, the fan base is very similar, if not better than NASCAR fans in terms of household income and things like that. The bang for the buck is huge."
Among other clients, eCreative has developed the Team Wix program for Wix Filters. "The goal of that program is to directly connect with teams and drivers all over the country in grassroots racing scenarios," explained Lillie. "We sign them up to be part of Team Wix; it's kind of a sponsorship program where they get something for being part of the team—discounts on products and things like that. Our goal is to put the product in front of the people who actually use it."
Lillie had a bit of advice for small teams trying to maximize their own sponsorships. "Put something together that doesn't cost you much that can help your sponsors activate. Go buy a 10x10 canopy, have a banner made, and have your wife sit behind the grandstands and hand out coupons and fliers at five or 10 events throughout the year," he suggested. "It gives your sponsor some ability to track the value and say, 'Oh, look at these coupons we got back from this guy we sponsored.' You have to do something that the fans can actually touch and feel, that will drive them to your sponsor, rather than just expecting the logo on the car to do all the work for you."
Sleek fast cars are indeed a fashion statement of a kind, and the bold marketers at Izod recognized the connection between Indy Cars and the message they want to send to the world about Izod style. In the first season of sponsoring the Indy Car series, Izod executives said the sponsorship was a success and did indeed 'move the needle' when it came to sales, a tribute to both the series the Izod team in charge of activating the sponsorship

subset: commoncrawl


text:
Image from ChicagoNow.com
Effective today, November 17, 2013, Little Merry Sunshine has joined ChicagoNow, the blogging platform of the Chicago Tribune Media Group.
Writer Jessica Gardner describes this move as an enormous honor and opportunity. "It has always been my dream to become a published writer and this opportunity to partner with ChicagoNow is the first step towards making that dream a reality. I am thrilled and honored to be associated with such a notable publication. Little Merry Sunshine will be exposed to a much wider audience and that presents endless opportunities."
As you may recall, Little Merry Sunshine has previously been recognized by the Chicago Tribune. In March 2009, LMS was named one of Chicago's Best Blogs and then appeared on the front page of the Tribune online on April 17, 2009.
The original Little Merry Sunshine site will not disappear. The articles and all of your comments will continue on into perpetuity. New Little Merry Sunshine blog posts will appear at ChicagoNow.com/Little-Merry-Sunshine. Please bookmark the new site.
This will be the last post on the original Little Merry Sunshine blog. The first Little Merry Sunshine post on ChicagoNOW will appear on Monday, November 18th.
What does this mean for current Little Merry Sunshine readers?
- If you receive LMS via email, your subscription has been moved to the new blog on ChicagoNOW. You don't need to take any action.
- If you read LMS via a reader, you'll need to grab a new feed. You can do that by visiting the new site here.
- If you read LMS on the website, please update your bookmarks and visit the new site.
- If you link to LMS on your website or blog, please update your links to direct readers to the new Little Merry Sunshine.
- And if you haven't done so already, please like Little Merry Sunshine on Facebook.
What does this mean for Little Merry Sunshine and me?
- I still own all of my content. It will simply live on the ChicagoNOW site.
- Being part of the ChicagoNow network means that I will be exposed to many more readers.
I make this promise to you: You've been a loyal reader since I began blogging on July 1, 2007. You've stuck with me during my down periods and times when I had no idea if I could write anymore. You have always come back. That means the world to me and I'm grateful for each and every one of you. I will not forget you and I will not let you down.
Little Merry Sunshine will continue to be all the things you love. I'll talk about my 100 New Experiences, what inspires and/or amuses me, politics, sports, dreams, Sammy and Zoey, and much more. Hopefully, I'll continue to be funny sometimes. At least for a little while, however, I'll probably cut back on some of the more personal things I've written about here. At least until I get my footing.
I hope you'll follow me over to ChicagoNOW and continue the conversation.
BTW, that's 73 of 100 New Experiences completed!


text:
Tavares scores SO winner, Islanders top Jets 5-4
Recommended Video:
WINNIPEG, Manitoba (AP) -- John Tavares scored the winning goal in a shootout on Saturday to give the New York Islanders a 5-4 win over Winnipeg and put a dent in the Jets' playoff drive.
Bryan Little tied the game for Winnipeg 4-4 at 17:59 of the third period, just seven seconds after Isles defenseman Lubomir Visnovsky was called for interference. A rebound sent the puck at Little's left skate and he kicked it over to his stick before beating Evgeni Nabokov.
Tavares and Brad Boyes both beat Jets goalie Ondrej Pavelec in the shootout, while Winnipeg captain Andrew Ladd scored against New York's Nabokov.
The win gave the Islanders 53 points and tied them with Toronto for fifth in the Eastern Conference. The Maple Leafs played Ottawa (52 points) later Saturday night.
The Jets have 49 points and are 1 back of the eighth-place New York Rangers. Nabokov made 24 saves in the win, while Pavelec stopped 29.
Michael Grabner put the Islanders up 4-3 at 9:13 of the third period after Andrew McDonald sent him a pass from the corner. Grabner stood at the edge of the crease and redirected the puck by Pavelec.
The Islanders got a goal and assist from both Frans Nielsen and Josh Bailey, while Matt Martin also scored. Kyle Okposo and Visnovsky each added a pair of assists. Kyle Wellwood scored a pair of goals for Winnipeg and Zach Bogosian added the other.
The Islanders led 2-1 after the first period and it was tied 3-3 heading into the third.


text:
Need Help?
Click here for help with
the STITCHES Online
Registration System.
Registration is closed for this event...
Saturday 04/13/2013, 8:30 am - 11:30 am
Skill LevelIntermediate
Class Hours3
TeacherBrooke Nico
View Brooke's profile
Around the World: Estonian and Shetland Lace with Brooke NicoLace motifs and stitch patterns from different regions of the world share many aesthetic qualities, yet each region has its own special focus. Look at Shetland and Estonian lace and receive tips and tricks to help in knitting nupps and gathered stitches so predominant in Estonian Lace. Leave class with great swatches and ideas for several projects.
Note: Students must be comfortable with lace knitting.
SuppliesSmooth, light-colored wool #1 (fingering) or #2 (sport) wool; 3.75, 4, or 4.5mm/US 5, 6, or 7 needles; stitch markers, pencil, paper.
Sharp scissors, notebook, pen or pencil with an eraser, stitch markers, blunt tapestry needles (large and small), flexible tape measure, small calculator, and needles & crochet hooks of various sizes.


text:
2625 South Harbor Loop Drive
Bellingham, WA 98225
Beginner Learn to Sail
Note: This is a full-day class, 5 days: Monday – Friday. (Ages 8-12 years)
No sailing experience is required for the beginning sailing classes! On-the-water instruction takes place in Optimist dinghies. Students successfully completing Beginner Learn to Sail should be able to rig and launch a dinghy sailboat, self-rescue a capsized sailboat, understand the three points of sail (beating, reaching and running), and tack and jibe a dinghy sailboat in fair weather conditions with proper supervision.
All lessons are taught by at least one instructor in a coach boat with other instructors nearby to help. If you are 8-18 years old and would like to learn how to sail, please get in touch and we will help find the best option for you.


text:
Why I Think Fascinating Diamonds is Wonderful Best Diamond Eternity Rings
I had such a hard time look for a diamond ring for my involvement. I tried my nearest jewelry store and merchant, but I just couldn't find the ideal ring. It was all gorgeous, but none of them felt just right for me. Imagine me looking for months…only for one ring!
It was not until a friend phoned me and asked me to try out fascinatingdiamonds.com. She explained the site did custom made rings and was much cheaper in comparison to other jewelry stores. I found that Fascinating Diamonds is a jewellery shop based in nyc. They have a small part of their store where they let the clients design and bedazzle their rings for them. At first, I really thought the whole thing was a scam. I had over $4000 dollars to invest and I was not willing to lose that much money. But I have been searching for months, so I decided to give this one a try. Best Diamond Eternity Rings
The Website Really Lets You Customize Your Ring
Initially, I was very skeptical of companies that sell customized products online because:
- I believed the entire thing was a scam; and
- Even if they weren't, I felt like they've limited templates.
But this website had far more templates than I thought. Their website has a huge variety of things to choose from. I got to choose my own ring design, my own metal band, and my own diamonds! I even got to choose the colors, which was really remarkable. I originally wanted a silver solitaire ring with a good emerald cut. While I was tinkering around with the choices a bit, I decided to change my mind and go with a round cut and a bronze group instead. It was easy to do that here and play around with the diamond shapes, colours, and styles until I got what I wanted. Plus, their site is really simple to use! I found it tricky at first since I am not very comfortable with customizing products. But really, it's like playing a video game of SIMS in which you make your own character. In cases like this, I made my own ring. Best Diamond Eternity Rings
The Diamonds Are GIA Certified
I did a bit of research on diamonds before I decided to tackle this online shop. I found that it was best that my diamond ring was GIA certified to guarantee that it will shine the brightest and last the longest. This actually caused a lot of worry on my part since I had been buying online. I mean I knew so little about online shops, much less ones that allow you to customize your ring. I was very worried because I thought that the diamonds were fake. Butearly on, I had been informed that all of the diamonds there are real and GIA certified. And it really showed when I received my custom ring, all shiny and gorgeous .
You Can Measure How Much You Spend
Their custom ring really saved me a few thousand dollars. I believe their rings price a general average of $2000 at most. For rings with round diamonds at the least. I still think it's a huge saving considering that other retail shops ask for more than that sometimes. At least here, you have a concrete reason as to why your ring costs how it does. The purchase price of a ring depends a lot on the kind of metal the ring is, the diamond's shape (or diamonds if you plan on using more than one gem in your ring), and the 4Cs of the diamond itself: carat weight, cut, color and clarity.
Unlike retail stores, Fascinating Diamonds actually enables you to look at the costs of the diamond gem, the ring, and the overall style while you're building the ring. This can let you make affordable choices without sacrificing the quality you desire. By way of instance, I wanted to get a ring with a round diamond that has an superb cut. But a round diamond with an excellent cut can easily cost from $600 to $1000. That's just 1 part of the ring. Best Diamond Eternity Rings
How did I decide? The website tells me that a round excellent cut diamond with 0.35 carats, an E color grade, and a clarity grade of VS1 can cost you $1007. Meanwhile, another exceptional cut diamond with 0.4 carats, a color grade of I, and an SI1 clarity grade cost you $603. The artists behind the site ensured that nobody would see the difference. The choice became so easy for me. If it sounds too technical for you, do not worry. The staff is very accommodating; they will actually give you a rundown on what you will need to know in case you ever get stuck.
Their Service is Remarkable!
The jewellery artists supporting Fascinating Diamonds are amazing! They had been so meticulous in the way they handled my requests, big or small. At times, they would even throw in their own suggestions and pick the style that will fit me best. This was unlike any experience I had with retail stores. They handled all my questions so well.
It was understandable that they do, though, considering that they customize your ring to meet your needs. They also ship out of New York, too! Since the shop's established in New York and I'm not, I was hoping the shipping might last longer than usual. But the whole interaction was really smooth and I was really pleased with my ring as it came. Best Diamond Eternity Rings
What You Will Need To Know First Best Diamond Eternity Rings
I believe it's best if you do a bit of research on rings prior to customizing your own. There's a lot that you will need to know about jewelry first before getting into this, particularly once you want to look into how much you are spending.
While the artists were accommodating, I honestly feel that this can't be for someone who's has not done their research on diamond rings beforehand. It's also a lot simpler if you already have a specific style in mind. But then again, it was fun playing around with the styles and the colors it was easy to change my mind.
Conclusion Best Diamond Eternity Rings
For someone who knows what they want but can not really find it anywhere, fascinatingdiamonds.com is the perfect place for you.
But if you're a bit indecisive about what you really want, it is also the perfect place to explore what you like and what you do not like.
It's really like one of those video games where you select exactly what you get. It was an great experience for me and I couldn't be happier with the results.


text:
1 Vehicle For Sale
1 Vehicle For Sale
We want to thank our patrons for continuing to do business with us during this period.
Even though our showrooms are not open to public – yet, we continue to consign and sell classic and exotic
cars and trucks.
Please contact us via e-mail, chat or phone call if you wish to purchase a classic.
WE ARE ALWAYS LOOKING FOR QUALITY CONSIGNMENTS. Please call us at (866) 383-1416, if you have one to sell.
Prodigious Green 1950 Packard Deluxe 8 For Sale boasts a 288 Cubic Inch Flathead 8 engine with 3 Speed Automatic transmission ~ Listed at $19,000 is a real head turner ~ Read More...
Turning the key and feeling the engine roar to life is what motivates classic car buyers all over the world. At Gateway Classic Cars of Orlando we have 1 amazing vehicles which are sure to take your breath away. Whether it's a hot rod or maybe something from the roaring 20's, Gateway Classic Cars has the classic or exotic car for you. Contact one of our inventory specialists today! Financing available for all qualified buyers.
Our vehicles are published on several websites including ~ Autotrader Classics ~ Hemmings ~ ClassicCars ~ Carsforsale ~ AllCollectorCars ~ eBay ~ Facebook ~ YouTube
© Copyright 2020, Gateway Classic Cars | All Rights Reserved
Gateway Classic Cars
1237 Central Park Dr. O'Fallon, IL. 62269 | 618.271.3000 | 800.231.3616
3,296 Classic and Exotics For Sale Today
Our vehicles were viewed 3,245,918 times in Apr 2020


text:
Posts Tagged 'Jeff Crawford'
Max Indian at The Pinhook, Oct. 1
Experience one of Chapel Hill's infant bands at Durham venue The Pinhook this Thursday, Oct. 1. However, don't expect novice musicianship as members, like so many in the incestuous local music scene, dip their toes in multiple projects like Luego, Roman Candle, The Tomahawks and Mount Moriah, to name a select few.
Recent music fixture Max Indian (Nick Jarger, Carter Gaj, Jeff Crawford, James Wallace, Jamie McFarlane) combines the retro with current indie rock and catchy, not kitschy elements of pop-rock. OK and maybe a little bit of folk rock.
Check out a video of the band performing "Free as the Wind" from their "You Can Go Anywhere, Do Anything" release show at Local 506 last year.
Floridians Lighthouse Music open at 9 p.m. with the headliner at 10 p.m. Check out The Pinhook's music calendar and blog. [map]


text:
See how Toyota vehicles compare against the competition. Start by choosing your Toyota vehicle and a competitor to learn more on how they stack up.
Get your family to those hard-to-reach destinations with Sequoia's powerful 5.7L V8 engine and available Multi-Mode 4WD system. With its spacious interior, reclining third-row seat and available multi-functional center console, Sequoia is as accommodating to passengers as it is to cargo. Toyota Safety Sense™ P (TSS-P)sup class="color-red footnote">24, which comes standard on the Sequoia, helps provide peace of mind.Learn more about TSS.
See how the 2018 Toyota Sequoia compares against the 2018 GMC Yukon SLE 4WD. If cost is important, Comparably Equipped Price on Sequoia SR5 4X4 is $555 less than the Yukon SLE 4WD. For power and performance, horsepower on Sequoia SR5 4X4 is 381@5600 while 355@5600 on Yukon SLE 4WD, while torque on Sequoia SR5 4X4 is 401@3600 while 383@4100 on Yukon SLE 4WD. Additionally, Sequoia SR5 4X4 has 800 more pounds of standard towing capacity than Yukon SLE 4WD. Those interested in technology will like that a navigational system is optional on the Sequoia SR5 4X4 while not available on the Yukon SLE 4WD. Finally, a skid plate or underbody protection is standard on Sequoia SR5 4X4 but not available on Yukon SLE 4WD.


text:
This new year my intention is to cultivate more Sattva (equanimity) in my life. Sattva is one of the three gunas (qualities) that together create the essential aspects of all nature—energy, matter and consciousness. Sattva is a state of harmony, balance, joy and intelligence. One of the primary goals of yoga is cultivate Sattva while reducing the other two gunas: tamas (darkness) and rajas (activity).
Premium Content
Please login as a premium member to view the additional content on this page. If you are not a premium member you can upgrade your basic account or sign up for a premium membership to access this page and receive all of the benefits of supporting our site.
- Please contact customer service if you are having trouble viewing premium content.
- Login Sign Up!


text:
AA-Marketing necesitaba un nuevo diseño de impreso o envases y lanzó un concurso de diseño en 99designs.
Un ganador ha sido elegido entre 20 diseños de 6 diseñadores freelance.
Absolute Analysis
We design networking test equipment for both the commercial and military market. Our products are sold only to corporations. The brand image we like to convey is reliability, uniqueness, engineering superiority, and also understanding of our customers' headaches.
The target audience is an engineer or engineering manager, frustrated that they can't get their design to work. They usually are at a critical time in their design cycle, ready to release their product, but can't because it doesn't work properly. (They often call their problem an "integration" problem.) We offer a solution to help them debug their design and find out exactly where the problem is, so they can fix it.
The engineer works on chips and boards, and uses cables to connect their design to other "boxes." The market is an existing market, and closely resembles the IT market.
The engineers are logical, geeky, analytical, probably male, probably socially inept.
The ad design specifications are:
Size: Width 3.5" x Height 4.75"
Content should have ¼" spacing from edge
The attached PPT file shows the copy. We want the order of the copy to flow as shown, and the sizing of the font should generally follow. But we are not married to much else, so please show your graphical talent!
The ad should interrupt the reader, especially the one who has this problem of integration. We want them to call us, which is the call-to-action on the attached PPT.
The first suggested image to ad is one of a frustrated businessman or IT dude. This image should be provided by the designer.
The second is an image of the product, attached. The 3rd image is an award recently received, also attached.
Finally, our corporate logo is attached, and should appear somewhere on the ad, but having it small is fine.
The ad will run in the COTS Journal, and you can see their latest magazine online at http://www.cotsjournalonline.com/digital.
You are free to design the fonts, font color, background, border, as well as choose the photos that seem appropriate for the first photo.


text:
A user account is required in order to edit this wiki, but we've had to disable public user registrations due to spam.
To request an account, ask an autoconfirmed user on IRC (such as one of these permanent autoconfirmed members).
Difference between revisions of "Use cases for API-level access to timed tracks"
SamJohnston (talk | contribs)
(→Timed Annotations: +floating name tags)
|Line 43:
|Line 43:
== Linking ==
== Linking ==
* Linking entire frame to a URL
* Linking entire frame to a URL
Revision as of 22:09, 22 April 2010
This page contains examples of features that it is not expected we will require user agents to natively render in the first version, though it's likely that we will provide APIs sufficient to implement these features in JS.
Return to timed tracks home page.
Chapter Markers
Timed Annotations
- Floating "name tags" following a timed path (e.g. a person moving around on the screen)
Linguistic Markup
Features for which we need examples of real-world usage:
- Linking entire frame to a URL
- Linking rendered text to a URL
- Linking overlaid graphics to a URL
- Linking defined regions to a URL


text:
One scary dude. (photo courtesy of hockeyschedule)
The Jets are on an incredible roll right now. Since Paul Maurice took over the bench a little more than two weeks ago, they've won six of their last seven games, grinding out victories against some of the league's best in Anaheim and Chicago. Goals are coming easy, Pavelec's numbers have improved, and fan optimism is at a season high.
I wrote in my review of the Chicago game that Winnipeg didn't deserve to win, lucky to leave with two points after only playing one period of NHL calibre hockey. This was in stark contrast to the majority of Jets media, who saw their team rope-a-dope the 'Hawks with a mixture of tenacity and resilience.
So let's look at the positives.
By seizing 12 out of a possible 14 points during Maurice's tenure, the Jets managed to climb out of the Central Division basement – past tonight's opponents, the Nashville Predators – and launch themselves back into playoff talk. With 55 points, the Jets are now nipping at the heels of the 56-point Stars and the 58-point Coyotes.
Unfortunately, the Western Conference contains the toughest competition in the league, and even with their recent winning ways, the Jets haven't made up much ground in the point race. Vancouver and Minnesota currently occupy the two Wild Card spots in the West, with 63 and 62 points respectively. This is, however, a step-by-step process, and if Maurice truly has impacted this club as much as we all hope, the Jets are only a good 10 game stretch away from catching their Conference rivals.
Tonight will be the fourth of five contests between the Jets and the Preds this season. When you look at their respective line-ups, it's hard to believe Winnipeg sports a 1-1-1 record against Nashville this year. The Preds historically play one of the most restrictive systems in the NHL (mostly out of necessity due to their inability to attract marquee players), but the Jets have the scoring punch to overcome that. We saw proof of this the last time these two teams met back in November, when almost every Jets line scored a goal on the back of a 5-0 Pavelec shutout.
The Predators have been up and down lately. The Jets have everything going for them right now. If they bring the passion they've brought lately paired with the patience it takes to play against the Preds, it's hard to imagine the Jets not improving to 7-1 under Paul Maurice.
- Ladd – Little – Frolik
- Kane – Scheifele – Wheeler
- Setoguchi – Jokinen – Byfuglien
- Thorburn – O'Dell – Peluso
The Preds are one of the few teams in the NHL outmatched by Winnipeg's depth. San Jose, Chicago, and Anaheim all exposed the drop off in skating ability we see after Winnipeg's top six, but that shouldn't be much of an issue against Nashville.
Maurice will keep his controversial third line together. This line plays best when they have a bit more time to think, and they'll likely get it tonight. Byfuglien can board battle with the best of them, and when you add Setoguchi's scoring touch and Jokinen's…moustache?….this line could have their best game in a long while.
Ladd and Little have had their way with the Preds all season. The addition of Frolik's Renaissance Man style of play has made them maybe even more dangerous than they were with Wheeler. This is beneficial, because Wheeler and Kane play great together, and both bring the best out of young Scheifele.
Under Maurice, the Jets have gone from having a strong top six to a strong top nine.
- Bogosian – Enstrom
- Stuart – Trouba
- Pardy – Ellerby
- Pavelec
- Montoya
The defence should hopefully be on more of an even keel against Nashville. Bogosian and Enstrom logged huge minutes last week, matching up against formidable duos like Getzlaf/Perry and Thornton/Marleau. The Preds do not boast nearly as deep of a roster, so Pardy and Ellerby should see some more ice time.
It's tough to say who should get the start in goal. Pavelec almost certainly will, but is that the best decision? Other than an early soft goal, Montoya played a magnificient game against the 'Hawks. Pavelec's been racking up the wins lately, but has left a lot of holes in the net while doing it.
- Beck – Fisher – Hornqvist
- Spaling – Legwand – Smith
- Bourque – Gaustad – Nystrom
- Clune – Aronson – Wilson
Injuries to Matt Cullen and Viktor Stalberg thin out an already thin forward corps, although neither are having great seasons anyway (especially Stalberg).
Fisher, and lifelong Preds Hornqvist, Legwand, and Smith remain Nashville's prime scoring threats, but none of them have reached the 40 point plateau yet in the team's 54 games.
The Preds recently sent Matt Hendricks to Edmonton for goalie Devan Dubnyk and scored four goals against the Flames last week in two events that should have no impact on this game whatsoever.
- Josi – Weber
- Del Zotto – Jones
- Bartley – Ellis
- Hutton
- Dubnyk
The Preds exchanged stay-at-home defenceman Kevin Klein for offensively-inclined D-man Michael Del Zotto with the Rangers last week, but it's too early to tell what kind of impact this will have. Del Zotto underperfomed in New York under new coach Alain Vigneault, but if he can find his previous form, Nashville's top four could generate more offense than their forwards (they already kind of do).
Hutton and Dubnyk traded starts the past two games, but it is yet unknown if GM David Poile and Head Coach Barry Trotz see this as a 1A/1B situation, or if Dubnyk will be relegated to the back-up role. The Jets wouldn't mind facing either goalie, as neither have been good.
The Jets have a relatively easy schedule before the Olympic break, facing only two teams who have shown any life lately in the Blues and Hurricanes. After the Olympic break is another story, however. The Jets can and need to beat teams like the Predators, with one eye always looking forward to the post-season.


text:
Bontrager Evoke R Saddle
If you're looking for a comfy saddle to handle serious mountain biking, look no further than Bontrager's Evoke R. It's optimized for the dirt with a narrower, rounded tail to make slipping off the back easier, a wider nose that you can grip with your thighs to help steer the bike through technical sections and abrasion-resistant sides for when things don't go quite as planned. It's got some of the most advanced comfort and support features, too. The size-specific curvature and Bontrager's Contour Relief Zones with medium-weight padding ensure excellent support and no pressure on sensitive areas. Plus, it's available in 3 widths for a custom fit.
Bontrager inForm saddles feature a size specific curvature to properly support a rider's skeletal structure for excellent comfort and proper support
This saddle is available in three widths: 128mm, 138mm and 148mm. Please visit the store to be measured if you're not sure which width is right for you. We're here to help!


text:
We are just 11 days away from the release of Madden 07, and the fine folks at IGN, for the real diehards out there, have released the rosters and player ratings of everyone in the game. Looking at our Buzzsaw, we see, as usual, two of the three best players are the kicker and the punter.
Anyway, yeah: Just 11 days now.
Madden NFL 07: Rosters and Ratings [IGN]


text:
Flag has been in use since Revolutionary War
Adan Salazar
Prison Planet.com
August 4, 2013
A group of veterans have filed a federal lawsuit against the city of New Rochelle, New York, its mayor and a few of the city's councilmen after a vote was passed to take down a yellow Gadsden flag they had hoisted over the city's former armory earlier this year."The United Veterans Memorial & Patriotic Association of New Rochelle and its president, Peter Parente, are suing the city, Mayor Noam Bramson, the city manager and four City Council members," reported the Journal News.
In efforts to "honor the veterans who have served and died for our country," the group is suing the city claiming it "violated its free-speech rights and the state's Open Meetings Law," not to mention the Constitution, when it wrongly assumed the flag implied an association between the armory and the Tea Party political group, of which the veterans say none are members.
"Contrary to defendants' unfounded, subjective (and incorrect) belief, plaintiffs' intended purpose in flying the Gadsden flag below the Stars and Stripes at the armory was and is not to make a statement in support of the Tea Party," the lawsuit reportedly says.
As the all-too-familiar flag, emblazoned with the image of a coiled rattlesnake ready to strike and the words "Don't tread on me," has become a staple at Tea Party rallies, the city council voted to have it removed late last March on the grounds that it was making a political statement.
The flag actually dates back to the colonial period and has significant historical value.
"That flag is the first flag of the Continental Navy," Parente told WNBC in March. "Before the red, white and blue stripes of America, that was our American flag," he said. "That was the flag we fought under in the Revolutionary War to have the America we are today."
Former New York assemblyman and retired Veterans Affairs commissioner, Ron Tocci, told The Journal News, "It's a slap in the face, an insult to any veteran that they would try to identify that flag with anything other than what it should be — honoring the service of our people."
A lawsuit was filed at the Hon. Charles L. Brieant Jr. Federal Building in White Plains on July 26 seeking "nominal and compensatory damages" as well as a court order permitting the flag be flown.
You can pick up a Gadsden flag at the Infowars store and help spread the message of liberty.
This article was posted: Sunday, August 4, 2013 at 12:04 pm
Tags: constitution, domestic news


text:
Vogue and Paramount Pictures have teamed up to have Derek Zoolander grace the February cover of Vogue. Zoolander will not only be on the cover, but he will be interviewed in Vogues iconic 73 questions. The magazine article also features co-star Penelope Cruz in photographs taken by the famous Annie …Read More »
Home | Tag Archives: stuart cornfeld


text:
Heads up, coin collectors! The U.S. Mint has unveiled its
final design for the Boy Scouts of America's Centennial Silver Dollar.
The obverse (heads) side shows a Cub Scout, Boy Scout, and
Venturer, and the reverse (tails) side depicts the BSA's iconic fleur-de-lis emblem. Some of the inscriptions are ones you're used
to seeing on a coin: "In God We Trust," "Liberty," and "E Pluribus Unum."
The rest of the text is unique to Scouting: "Be Prepared"
and "Continuing the Journey." The former, of course, is the Scout Motto, and
the latter is a nod to the BSA's 100th Anniversary slogan: "Celebrating the
Adventure, Continuing the Journey."
The Mint's first run will produce just 350,000 of these commemorative
coins. So don't delay getting your hands on one when they're released in March.
At that time, you can place an order through the U.S. Mint's Web site or by calling its toll-free number: 800-USA-MINT. Just don't
expect to find one among the change you get from your Starbucks latte. They
will only be available in proof and uncirculated versions.
Need another excuse to order one? Consider this: The
surcharges collected from the sale of each coin will go to the Boy Scouts of
America National Foundation, which helps bring Scouting to underserved
communities. That's $3.5 million to a very worthy cause.
The commemorative coin represents just the latest in a
growing list of 100th Anniversary keepsakes. It joins the "Celebrate Scouting"
stamp, due out in July, and the apparel and souvenir items
available now through the BSA Supply Group.


text:
Piscium Wireless FF916 Finder
Product Detail
Product Tags
FF916 Wide detection 90°
Depth Capability up to 45m
Stable signal reception
For android & ios app
Smartphone & tablet supported
Tie your fish reel line to the front hole in the Wifi transducer and cast it into the water, then you can open your app and enter the operation mode, the water depth, water temperature, bottom contour and fish information can be constantly obtained from WIFI transducer.
Selectable sensitivity, zoom, units, depth range, shallow alarm, fish icon fish alarm, chart speed setting.
Fish alarm Adjustable sensitivity Shallow alarm Wide application Easy to operate Clear fish ID
Transducer frequency 125KHZ
Transducer coverage 90degrees
Depth capacity 1M-45M(2Feet-135Feet)
Transducer power 3.7rechargeable lithium battery
Charger 5V, 1A
WIFI range 70m
WIFI frequency 2.4GHz
Charging indicator red light
Working indicator blue light
1.Water depth 8.Battery strength indicator
2.Water temperature 9.Wireless Signal
3.Upper zoom range 10.Small fish icon with depth
4.Middle Fish icon with depth
5.Large fish icon with depth
6.Water bottom contour
7.Lower zoom range
Wifi fish finder*1pcs
Charger *1pcs
Vehicle charger*1pcs
Cap*2pcs(1pcs forday,1pcs for night)
1) Compatible with Android/IOS system
2) Depth capacity:135feet(45m)
3) Transducer frequency:125KHz
4) Transducer coverage:90 degrees
5) WIFI operating range:70M
6) WIFI frequency:2.4GHz
7) Power:3.7V rechargeable lithium battery
8) Charger:5V,1A
9) Charging indicator:red light
10) Working indicator:blue light
11) Working hours:5 hours fully charging


text:
No matter the woes of Peugeot, the company seems to be ignoring them with their latest concept car. The Onyx, set to debut in a few weeks at the Paris Motor Show. An all-wheel drive plug-in hybrid hooked up to a 256hp 1.6L four-banger and 120hp electric motor– that's 376hp total.
Looks like all eyes will be on Paris this year as with this latest concept example many companies are swinging for the fences.


text:
Gray matter: A's make smart move with rookie
Oakland's decision to go with young right-hander turns out to be no-brainer
OAKLAND -- The decision by the A's baseball people to start rookie right-hander Sonny Gray against the Tigers in Game 2 of their American League Division Series on Saturday night was certainly a prescient one.
It was made collectively and executed to perfection by manager Bob Melvin as almost all baseball decisions are determined in an organization now famous for its use of analytics.
But metrics were not the determining factor, Melvin said after Gray matched Justin Verlander pitch for pitch and put the A's in position for a walk-off 1-0 win at delirious O.co Coliseum to tie the best-of-five series at a game apiece.
"I don't think it had anything to do with numbers," Melvin said of the decision to start Gray, 23, on Saturday night and then Jarrod Parker, 24, on Monday at Comerica Park in Game 3. "We just wanted Sonny pitching in a place he was comfortable in and had pitched before.
"And Jarrod had started the first game [of the ALDS] last year in Detroit. It was as simple as that."
Gray, making only his 11th big league start since being called up from Triple-A Sacramento on Aug. 10, looked like he had pitched in the postseason forever, even outlasting Verlander, the former AL Cy Young Award winner. Verlander left the scoreless tie after seven innings and Gray was removed after eight and 111 pitches, having allowed only four hits, while walking two and striking out nine.
"For a 23-year-old kid on the stage he was on tonight, you can't say enough about the job he did," said catcher Stephen Vogt, who caught Gray in the Minors and drove home the game winner with a bases-loaded, ninth-inning base hit. "It's just a testament to the kid he is. I've had the joy to catch him during the year at Triple-A and in the big leagues and he's been the same kid every day.
"Today we were joking around like we always do. You could tell down in the bullpen he was going to have a great night. He didn't change anything he was. He didn't change anything about him. He just went out there on this stage and stayed Sonny Gray."
Gray, who pitched two years ago for Vanderbilt, losing an elimination game in the College World Series, was unflappable.
In the third inning, when he came in high and tight on Torii Hunter, backing him off the plate, the Tigers' right fielder pointed at him and chirped: "Stay away from my head," Vogt said.
"I don't mind being pitched inside, but don't throw at somebody's head," Hunter said afterward. "You go hit and let me throw at your face. Why would you do that?"
Gray came back and struck out Hunter swinging. Heading back across the plate to the Tigers' dugout, Hunter gave a quick glare over his shoulder at Gray, who continued to pitch harder and harder, hitting the 96-mph mark four times in his next series of pitches.
"He's known as a great guy," Gray said about Hunter. "I remember two years ago during my first Spring Training, facing him when he was with the Angels. He hit a line drive up the middle and nearly took my head off. But [tonight] it really got me fired up a little bit. After that, I had a little extra adrenaline."
As if Gray needed anymore motivation. Showing the composure of a veteran, he wound up whiffing the side with another swinging strikeout of Miguel Cabrera.
"His composure is excitement," Melvin said. "He loves to pitch. He's into it. He's into every pitch and you can tell he enjoys doing it."
Gray took it another step higher in the fifth inning. With runners on first and third, Gray struck out Austin Jackson swinging and gave Vogt enough time to nail Jose Iglesias trying to steal second for a big double play. It was Detroit's last real threat of the game.
Vogt has a vague resemblance to actor Russell Crowe and Gray looks like a 16-year-old. The fact that they are so familiar with each other was crucial to the execution of that play.
"I had a feeling [Iglesias] was going to go on 3-1 or 3-2," Vogt said. "With him going on 3-2, [Gray] made a great pitch on the outside corner that cut away from Austin's bat, and I was able to put the throw on the money. That was a huge play for us in a lot of ways."
It was an elbow injury to A.J. Griffin, taking him out of the playoff mix, that necessitated the A's shuffling their rotation. The numbers may not have been the difference, but they certainly told the tale. Not only had Gray never pitched at Comerica Park, his ERA was about two runs higher on the road than at home.
The decision to throw him at the Coliseum turned out to be a no-brainer and now gives the A's a chance to win this series.
"It was very exciting and I was very glad to get the opportunity," Gray said. "I knew there was going to be a lot of adrenaline and how I harnessed that adrenaline was going to be a big factor in the game. Coming out early, I wasn't as nervous, I wasn't as amped up as I thought I would be.
"You work hard for something like this. I knew I would be here. It was awesome."


text:
Ben Brewer
Campus Involvement
- Major: Economics
- Minor: Mathematics
- Longboarding Club
- Math tutor
- Omicron Delta Epsilon
- Peer Mentor
Hometown? Derry NH
High School? Pinkerton Academy Prep School Bridgton Academy
Favorite Class at WC? Calculus - who doesn't like calculus
Recommended Professor? Prof. Daniels
Most Memorable Experience as a First-Year Student? Stargazing at night on the campus green
If I Could be an Animal, I'd Be? an Otter
One Thing You Shouldn't Forget to Pack? A positive attitude!


text:
I was an old casual DRG player in Lakshmi (quit in 2005, "Nettie" @Lv59). I am back because I m bored to the WoW and looking forward to meet friends (mainly for social and casual lvling ATM).
Is there any Linkshell for English player in Asia timezone? My main up time will be mainly on 5:00-6:00/15:00-18:00GMT (13:00-14:00/23:00-2:00HKG or 0:00-1:00/10:00-13:00EST)
BTW, my current character is "Nethomas" and I just hit the first Limit Break (Lv50).
Edited, Feb 14th 2012 4:21am by CatmanNethomas


text:
Skip navigation
Dear visitor, welcome to WesWorld. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.
Friday, January 6th 2012, 11:28pm
Friday, January 6th 2012, 11:34pm
Ex chaos ordo
Friday, January 6th 2012, 11:39pm
Saturday, January 7th 2012, 12:48am
Mad Scientist at Work
Saturday, January 7th 2012, 3:18am
Old-School Heel
Saturday, January 7th 2012, 3:44am
Saturday, January 7th 2012, 7:12am
QuotedOriginally posted by ShinRa_Inc
WW Hood's already had her refit; she got it around when R&R did, due to the pile-up I arranged in one of the Fleet Problems.
Or are you referring to some of the more historical proposals?
Sunday, January 8th 2012, 5:16pm
Monday, January 9th 2012, 10:58pm
Monday, January 9th 2012, 11:02pm
Tuesday, January 10th 2012, 8:43pm
Tuesday, January 10th 2012, 8:46pm
QuotedOriginally posted by exigeant
I have read on another forum that her cancelled sisters would have been marginally better looking, but as always beauty is in the eyes of the beholder.
Tuesday, January 10th 2012, 9:26pm
Tuesday, January 10th 2012, 9:34pm
QuotedOriginally posted by exigeant
...all of which i believe improved the appearance.
Saturday, January 21st 2012, 1:30pm
Saturday, January 21st 2012, 11:18pm
Sunday, January 22nd 2012, 12:28pm
Monday, January 23rd 2012, 10:29am
Mad Scientist at Work
Monday, January 23rd 2012, 6:03pm
Tuesday, January 24th 2012, 2:33pm
Forum Software: Burning Board® Lite 2.1.2 pl 1, developed by WoltLab® GmbH


text:
|« Previous MessageNext Message »
|Bjorn Munch
|September 21 2013 4:07pm
|MySQL Community Server 5.7.2 has been released (part 2 of 4)
|View as plain text
Functionality Added or Changed * Performance; InnoDB: Memory for transaction instances (trx_t) is now allocated in configurable sized blocks that are a multiple of transaction instance size. Transaction instances are also placed in a priority queue and ordered by their address in memory so that when instances are allocated from the pool, they are close together. This enhancement reduces the cost incurred by iterating over transactions instances when allocating instances from the pool. * Performance; InnoDB: Internal B-tree index operations have been optimized to reduce index locking contention. * Performance; InnoDB: Multi-version concurrency control (MVCC (http://dev.mysql.com/doc/refman/5.7/en/glossary.html#glos_mvc c)) in InnoDB requires that each transaction using MVCC (http://dev.mysql.com/doc/refman/5.7/en/glossary.html#glos_mvc c) be assigned a read view. To improve InnoDB read-only and read-write performance, read view creation has been optimized by reducing mutex contention. * Performance: Previously, the main loop responsible for accepting client connections also performed initialization of data structures related to each connection. These initialization tasks now are delegated to worker threads to minimize work done by the accept loop and maximize connection acceptance rate. (Bug #62288, Bug #12951536, Bug #62284, Bug #12951595, Bug #62283, Bug #12951605) * Incompatible Change: The bind_address, thread_cache_size, and thread_handling system variables as well as the Slow_launch_threads and Thread_cached status variables are not meaningful in the embedded server. These variables are no longer visible within the embedded server and embedded applications that rely on these variables should be should be modified accordingly. (Bug #62288, Bug #12951536, Bug #62284, Bug #12951595, Bug #62283, Bug #12951605) * Incompatible Change: The unused --basedir and --datadir options for mysql_upgrade have been removed. * Important Change; Replication: By default, when promoting integers from a smaller type on the master to a larger type on the slave (for example, from a SMALLINT column on the master to a BIGINT column on the slave), the promoted values are treated as though they are signed. Now in such cases it is possible to modify or override this behavior using one or both of ALL_SIGNED, ALL_UNSIGNED in the set of values specified for the slave_type_conversions server system variable. For more information, see Row-based replication: attribute promotion and demotion (http://dev.mysql.com/doc/refman/5.7/en/replication-features-d iffering-tables.html#replication-features-attribute-promotion) , as well as the description of the variable. (Bug #15831300) * InnoDB: innochecksum functionality has been enhanced with new options and extended capabilities. See innochecksum --- Offline InnoDB File Checksum Utility (http://dev.mysql.com/doc/refman/5.7/en/innochecksum.html). (Bug #16945722) * InnoDB: A new CMake option, WITH_INNODB_EXTRA_DEBUG, has been added that enables additional InnoDB debug checks. WITH_INNODB_EXTRA_DEBUG can only be enabled when the WITH_DEBUG option is also enabled. (Bug #16821155) * InnoDB: A number of internal debug flags in the InnoDB code could only be set at compilation time or from a debugger. As a result, a significant amount of diagnostic information was unused. This enhancement replaces internal debug flags with DBUG labels so that the DBUG package (http://dev.mysql.com/doc/refman/5.7/en/dbug-package.html) can be used and printouts from various InnoDB subsystems can be enabled using the mysqld --debug command line option. See the Debugging a MySQL Server (http://dev.mysql.com/doc/refman/5.7/en/debugging-server.html) section for information about configuring MySQL for debugging, creating trace files, and using the mysqld --debug option. * InnoDB: The process for converting a transaction's implicit lock to an explicit lock has been optimized to improve performance. The optimization reduces lock_sys_t::mutex contention. * InnoDB: Beginning with MySQL 5.7.2, UPDATE_TIME displays a timestamp value for the last UPDATE, INSERT, or DELETE performed on InnoDB tables. Previously, UPDATE_TIME displayed a NULL value for InnoDB tables. For MVCC, the timestamp value reflects the COMMIT time, which is considered the last update time. Timestamps are not persisted when the server is restarted or when the table is evicted from the InnoDB data dictionary cache. * InnoDB: For SELECT COUNT (*) queries, where a table's committed record count is changed by transaction deltas, there is now a single handler call to the storage engine to return the record count to the optimizer instead of one call for each record. This change generally improves SELECT COUNT (*) query performance and reduces in-memory table scan cost, as each record is no longer returned to the optimizer. In some instances, however, where there is a large clustered index and a very small secondary index, performance may not be improved. Previously, the optimizer would choose to traverse the smaller secondary index instead of the larger clustered index. The smaller secondary index could, in this case, offer better performance than a clustered index with a single handler call to the storage engine. However, there may be no performance benefit if the secondary index is often updated. When a secondary index page is modified by a transaction that is more recent than the COUNT(*) transaction, InnoDB must read the clustered index to determine if the record is visible. In this case, InnoDB would read both the secondary and clustered index, which is costlier than reading only the clustered index. * InnoDB: Read-only transactions will no longer be assigned a transaction ID. Conversely, an ID will only be assigned if a transaction is explicitly tagged as "read-write", if a transaction has acquired an X or IX lock on a table, or if a transaction is a read-only transaction writing to a temporary table. All other transactions are considered "read-only" and are not assigned an ID. Furthermore, read-only transactions are not tagged as "read-only" unless they are explicitly started with START TRANSACTION READ ONLY. For transactions without transaction IDs, SHOW ENGINE INNODB STATUS prints an identifier that is unique but only within the context of the SHOW ENGINE INNODB STATUS invocation. * InnoDB: MySQL 5.7.2 introduces a new type of undo log for both normal and compressed temporary tables and related objects. The new type of undo log is not a redo log, as temporary tables are not recovered during crash recovery and do not require redo logs. The new undo log (http://dev.mysql.com/doc/refman/5.7/en/glossary.html#glos_und o_log) resides in the temporary tablespace. The default temporary tablespace file, ibtmp1, is located in the data directory by default and is always recreated on server startup. A user defined location for the temporary tablespace file can be specified by setting innodb_temp_data_file_path. For more information, see InnoDB Temporary Table Undo Logs (http://dev.mysql.com/doc/refman/5.7/en/innodb-temporary-table -undo-logs.html). * InnoDB: The limit on concurrent data-modifying transactions (http://dev.mysql.com/doc/refman/5.7/en/glossary.html#glos_tra nsaction) is now 96 * 1023 transactions that generate undo records (http://dev.mysql.com/doc/refman/5.7/en/glossary.html#glos_und o_log). As of MySQL 5.7.2, 32 of 128 rollback segments (http://dev.mysql.com/doc/refman/5.7/en/glossary.html#glos_rol lback_segment) are allocated to non-redo logs for transactions that modify temporary tables and related objects. This reduces the maximum number of concurrent data-modifying transactions from 128K to 96K. The 96K limit assumes that transactions do not modify temporary tables. If all data-modifying transactions also modify temporary tables, the limit would be 32K concurrent transactions. * InnoDB: DML operations (INSERT, UPDATE, DELETE) for temporary tables have been optimized by turning off redo logging, locking, and change buffering that is not required for temporary tables. Turning off these functions optimizes temporary table DML operations by reducing associated I/O. * InnoDB: InnoDB buffer pool dump and load operations have been enhanced. A new system variable, innodb_buffer_pool_dump_pct, allows you to specify the percentage of most recently used pages in each buffer pool to read out and dump. When there is other I/O activity being performed by InnoDB background tasks, InnoDB attempts to limit the number of buffer pool load operations per second using the innodb_io_capacity setting. * InnoDB: Buffer pool list scans and related batch processing have been optimized to reduce scan complexity and the number of pages scanned. For more information, see Buffer Pool List Scan and Batch Processing Optimization (http://dev.mysql.com/doc/refman/5.7/en/innodb-performance.htm l#innodb-performance-buffer-pool-scan-optimization). * InnoDB: Refactored mutex code makes selecting the appropriate mutex easier and allows multiple mutex types to be combined in the same instance. The refactored code also removes the distinction between fast_mutex_t and home brew ib_mutex_t types, implements a common interface for both mutex types, and allows new mutex types to be added in the future. Additionally, mutex code is decoupled from InnoDB code so that it can be used as a library, and a "PolicyMutex" interface has been introduced. The new interface uses static inheritance (templates) for mutex implementation making it easier to define policies and customize mutex behavior. * Partitioning: The following operations are now supported for individual subpartitions as well as partitions: ANALYZE, CHECK, OPTIMIZE, REBUILD, REPAIR, and TRUNCATE (see ALTER TABLE Partition Operations (http://dev.mysql.com/doc/refman/5.7/en/alter-table-partition- operations.html)). (Bug #14028340, Bug #65184) * Replication: Previously, transactions could be applied in parallel only if they did not touch the same database. However, the MySQL Server uses a lock-based scheduler, which means that it should be possible to execute in parallel all uncommitted replication threads already in the prepare phase, without violating consistency. Such parallel execution can now be enabled on the slave by starting the slave mysqld with --slave-parallel-type=LOGICAL_CLOCK or, if mysqld is already started, by setting the value of the global system variable slave_parallel_type to 'LOGICAL_CLOCK' on a stopped slave. When this feature is enabled, each transaction is marked with a logical timestamp. This timestamp identifies the last transaction committed at the time that the current transaction entered the prepare stage, and all transactions having the same timestamp can execute in parallel. To disable this feature without restarting, stop the slave using STOP SLAVE (if it is running as a slave), issue SET @global-slave_parallel_type='DATABASE', then issue START SLAVE when you want the slave to resume. You can also disable the feature by restarting the slave mysqld without the --slave-parallel-type option, or by setting it explicitly to DATABASE. When parallel execution of preapred transactions is disabled, the slave follows the old behavior and applies in parallel only those transactions that do not cause changes in the same database. * Support for LinuxThreads has been removed from the source code. LinuxThreads was superseded by NPTL in Linux 2.6. (Bug #17007529) * Support for building Apple universal binaries to support PowerPC has been removed from the source code. (Bug #16959103) * CMake no longer checks for memmove() or memcpy() because they are standard C library functions. Also, implementation of the bmove_upp() function was replaced with calls to memmove(), which may have positive performance implications. (Bug #16839824) * The C API libmysqlclient shared-library .so files now have version 18.1.0 (up from version 18.0.0 used in MySQL 5.5). 18.1.0 can be used as a replacement for 18.0.0. (Bug #16809055) * Use of DYNAMIC_ARRAY was reduced, which improves performance of certain range queries by 3-4%. (Bug #16736776, Bug #17030235) * mysql_upgrade now verifies that the server version matches the version against which it was compiled, and exits if there is a mismatch. In addiion, a --version-check option permits specifying whether to enable version checking (the default), or disable checking if given as --skip-version-checking. (Bug #16500013) * mysqladmin now supports a --show-warnings option to display warnings resulting from execution of statements sent to the server. (Bug #16517756) * The following items are deprecated and will be removed in a future MySQL release. Where alternatives are shown, applications should be updated to use them. + The ENCODE() and DECODE() functions. Use AES_ENCRYPT() and AES_DECRYPT() instead. + The INFORMATION_SCHEMA.PROFILING table. Use the Performance Schema instead; see MySQL Performance Schema (http://dev.mysql.com/doc/refman/5.7/en/performance-schem a.html). (Bug #16463921) * Invoking CMake with -DWITH_AUTHENTICATION_PAM=1 now causes the build to fail (rather than issue only a warning) if the PAM plugin cannot be built. (Bug #14554639) * In batch mode, mysql formatted result status messages such as ""Query OK, 1 row affected"" but did not print them. Now these messages are not formatted. (Bug #69486, Bug #16971432) * Several inefficiencies were corrected: + A loop in Item_in_subselect::single_value_transformer() could execute too many times. + The myisamchk(), my_test_if_sort_rep(), and recreate_table() functions in MyISAM code could execute too many times. Thanks to Po-Chun Chang for the patches to correct these issues. (Bug #69138, Bug #16764131, Bug #69117, Bug #16751784, Bug #69561, Bug #17007268, Bug #69553, Bug #17001703) * Plugins can now define and expose floating-point system variables of type double using the MYSQL_SYSVAR_DOUBLE() and MYSQL_THDVAR_DOUBLE() accessor macros. See Client Plugin Descriptors (http://dev.mysql.com/doc/refman/5.7/en/plugin-data-structures .html#client-plugin-descriptors). (Bug #68121, Bug #16194302) * Semi-join LooseScan strategy now can use ref access and applies to a wider range of queries. * EXPLAIN can now be used to obtain the execution plan for an explainable statement executing in a named connection: EXPLAIN [options] FOR CONNECTION connection_id; For example, if you are running a statement in one session that is taking a long time to complete, using EXPLAIN FOR CONNECTION in another session may yield useful information about the cause of the delay and help you optimize the statement. connection_id is the connection identifier, as obtained from the INFORMATION_SCHEMA PROCESSLIST table or the SHOW PROCESSLIST statement. If you have the PROCESS privilege, you can specify the identifier for any connection. Otherwise, you can specify the identifier only for your own connections. Changes in EXPLAIN output: + In the output from EXPLAIN FOR CONNECTION, an Extra value of Plan isn't ready yet means that the optimizer has not finished creating the execution plan for the statement executing in the named connection. (For JSON-format output, this is indicated by planned: false.) + In the output from any EXPLAIN used to obtain the execution plan for non-SELECT statements, the select_type value displays the statement type for affected tables. For example, select_type is DELETE for DELETE statements. For more information, see EXPLAIN Syntax (http://dev.mysql.com/doc/refman/5.7/en/explain.html). * To make it easier to see the difference between good and bad execution plans, JSON-format EXPLAIN output now includes this additional cost information: + query_cost: The total cost of a query block, whether a top-level query or subquery. For a top-level SELECT, this should be equal to the Last_query_cost status variable. + sort_cost: The cost of the first sorting operation (GROUP BY or ORDER BY) where and if filesort is used. + read_cost: The cost of reading data from each table used in the query block (that is, access method cost). + eval_cost: The cost of condition evaluation for each table in the query block. + prefix_cost: The cost of executing prefix join in the query block; that is, the cost of joining tables of the query block from the first one to the one (and including it) for which the value is given. + data_read_per_join: The estimated amount of data processed by the handler interface per query or subquery execution. This is essentially record width * number of read records. + rows_produced_per_join/ rows_examined_per_join: The estimated number of records from the table (per table from the query block) produced or examined per single query block execution. + used_columns: The list of columns from the table (per each table in the query block) used for either read or write in the query. This cost information is not displayed for INFORMATION_SCHEMA tables. * MySQL supports the use of client-side plugins that implement a trace of communication between a client and the server that takes place using the client/server protocol. Protocol trace plugins use the client plugin API (see Writing Plugins (http://dev.mysql.com/doc/refman/5.7/en/writing-plugins.html)) . In MySQL source distributions, a test protocol trace plugin is implemented in the test_trace_plugin.cc file in the libmysql directory. This can be examined as a guide to writing other protocol trace plugins. Bugs Fixed * Performance; Important Change; InnoDB: InnoDB would fail to open a tablespace that has multiple data files. This removes the known limitation that was in MySQL Server 5.6.12. (Bug #17033706, Bug #69623) * Performance; InnoDB: A code regression introduced in MySQL 5.6 negatively impacted DROP TABLE and ALTER TABLE performance. This could cause a performance drop between MySQL Server 5.5.x and 5.6.x. (Bug #16864741, Bug #69316) * Performance; InnoDB: When innodb_thread_concurrency is set to a non-zero value, there was a possibility that all innodb_concurrency_tickets would be released after each row was read, resulting in a concurrency check after each read. This could impact performance of all queries. One symptom could be higher system CPU usage. We strongly recommend that you upgrade to MySQL Server 5.6.13 if you use this setting. This could cause a performance drop between MySQL Server 5.5.x and 5.6.x. (Bug #68869, Bug #16622478) * Incompatible Change: When used for an existing MySQL account, the GRANT statement could produce unexpected reults if it included an IDENTIFIED WITH clause that named an authentication plug differing from the plugin named in the corresponding mysql.user table row. Because IDENTIFIED WITH is intended for GRANT statements that create a new user, it is now prohibited if the named account already exists. (Bug #16083276) * Incompatible Change: It is possible for a column DEFAULT value to be valid for the sql_mode value at table-creation time but invalid for the sql_mode value when rows are inserted or updated. Example: SET sql_mode = ''; CREATE TABLE t (d DATE DEFAULT 0); SET sql_mode = 'NO_ZERO_DATE,STRICT_ALL_TABLES'; INSERT INTO t (d) VALUES(DEFAULT); In this case, 0 should be accepted for the CREATE TABLE but rejected for the INSERT. However, the server did not evaluate DEFAULT values used for inserts or updates against the current sql_mode. In the example, the INSERT succeeds and inserts '0000-00-00' into the DATE column. The server now applies the proper sql_mode checks to generate a warning or error at insert or update time. A resulting incompatibility for replication if you use statement-based logging (binlog_format=STATEMENT) is that if a slave is upgraded, a nonupgraded master will execute the preceding example without error, whereas the INSERT will fail on the slave and replication will stop. To deal with this, stop all new statements on the master and wait until the slaves catch up. Then upgrade the slaves followed by the master. Alternatively, if you cannot stop new statements, temporarily change to row-based logging on the master (binlog_format=ROW) and wait until all slaves have processed all binary logs produced up to the point of this change. Then upgrade the slaves followed by the master and change the master back to statement-based logging. (Bug #68041, Bug #16078943) * Important Change; Replication: When the server was running with --binlog-ignore-db and SELECT DATABASE() returned NULL (that is, there was no currently selected database), statements using fully qualified table names in dbname.tblname format were not written to the binary log. This was because the lack of a currently selected database in such cases was treated as a match for any possible ignore option rather than for no such option; this meant that these statements were always ignored. Now, if there is no current database, a statement using fully qualified table names is always written to the binary log. (Bug #11829838, Bug #60188) * InnoDB; Partitioning: Following any query on the INFORMATION_SCHEMA.PARTITIONS table, InnoDB index statistics as shown in the output of statements such as SHOW INDEX were updated, even with innodb_stats_on_metadata=OFF. (Bug #16860588) * InnoDB; Partitioning: Joins involving partitioned InnoDB tables having one or more BLOB columns were not always handled correctly. The BLOB column or columns were not required to be join columns, or otherwise to be named or referenced in the statement containing the join, for this issue to occur. (Bug #16367691) * InnoDB; Replication: Trying to update a column, previously set to NULL, of an InnoDB table with no primary key caused replication to fail on the slave with Can't find record in 'table'. Note This issue was inadvertently reintroduced in MySQL 5.6.6, and fixed again in MySQL 5.6.12. (Bug #11766865, Bug #60091) References: See also Bug #16566658. * InnoDB: When logging the delete-marking of a record during online ALTER TABLE...ADD PRIMARY KEY, InnoDB writes the transaction ID to the log as it was before the deletion or delete-marking of the record. When doing this, InnoDB would overwrite the DB_TRX_ID field in the original table, which could result in locking issues. (Bug #17316731) * InnoDB: The row_sel_sec_rec_is_for_clust_rec function would incorrectly prepare to compare a NULL column prefix in a secondary index with a non-NULL column in a clustered index. (Bug #17312846) * InnoDB: An incorrect purge would occur when rolling back an update to a delete-marked record. (Bug #17302896) * InnoDB: An assertion failure would occur while searching an index tree and traversing multiple levels where a block is accessed or pinned at each level. (Bug #17315967) * InnoDB: In Windows 64-bit debug builds, read view COPY_TRX_IDS would report a "vector subscript out of range" error to standard error output. (Bug #17320056) * InnoDB: The assertion ut_ad(oldest_lsn <= cur_lsn) in file buf0flu.cc would fail because the current max LSN would be retrieved from the buffer pool before the oldest LSN. (Bug #17252421) * InnoDB: InnoDB memcached add and set operations would perform more slowly than SQL INSERT operations. (Bug #17214191) * InnoDB: As commented in log0log.h, old_lsn and old_buf_free should only be compiled when UNIV_LOG_DEBUG is enabled. (Bug #17160270, Bug #69724) * InnoDB: Before dropping an index, a check is performed to ensure the index root page is free. If the index root page is free, dropping activity is avoided. A transaction would be initialized before the check is performed. If the check evaluated to true, the initialized transaction would be left in a dangling state. (Bug #17076822) * InnoDB: InnoDB would rename a user-defined foreign key constraint containing the string "_ibfk_" in its name, resulting in a duplicate constraint. (Bug #17076737, Bug #69693, Bug #17076718, Bug #69707) * InnoDB: When started in ready-only mode, InnoDB would assert on a SAVEPOINT. (Bug #17086428) * InnoDB: In debug builds, the trx_sys->rw_max_trx_id variable would sometimes be reversed resulting in an inconsistent CLUST_INDEX_SIZE value. (Bug #17026780) * InnoDB: An InnoDB monitor test would raise an assertion in ha_innodb.cc due to a mutex conflict. (Bug #17027249) * InnoDB: A regression introduced in the fix for Bug #14606334 would cause crashes on startup during crash recovery. (Bug #16996584) * InnoDB: Rolling back an INSERT after a failed BLOB write would result in an assertion failure. The assertion has been modified to allow NULL BLOB pointers if an error occurs during a BLOB write. (Bug #16971045) * InnoDB: The ha_innobase::clone function would incorrectly assert that a thread cannot clone a table handler that is used by another thread, and that the original table handler and the cloned table handler must belong to the same transaction. The incorrect assertions have been removed. (Bug #17001980) * InnoDB: To avoid namespace clashes, usage of 'using namespace std' has been removed from InnoDB. (Bug #16899560) * InnoDB: Optimized explicit record locking routines. (Bug #16880127) * InnoDB: The server would crash during a memcached set operation. The failure was due to a padded length value for a utf8 char column. During a memcached update operation, a field from an old tuple would be copied with a data length that was less than the padded utf8 char column value. This fix ensures that old tuples are not copied. Instead, a new tuple is created each time. (Bug #16875543) * InnoDB: When CHECK TABLE found a secondary index that contained the wrong number of entries, it would report an error but not mark the index as corrupt. CHECK TABLE now marks the index as corrupt when this error is encountered, but only the index is marked as corrupt, not the table. As a result, only the index becomes unusable until it is dropped and rebuilt. The table is unaffected. (Bug #16914007) * InnoDB: InnoDB would attempt to gather statistics on partially created indexes. (Bug #16907783) * InnoDB: A full-text search using the IN BOOLEAN MODE (http://dev.mysql.com/doc/refman/5.7/en/fulltext-boolean.html) modifier would result in an assertion failure. (Bug #16927092) References: This bug is a regression of Bug #16516193. * InnoDB: SHOW ENGINE INNODB STATUS output would reference a thread in hex format (example: thread handle 0x880) while the same thread would be referenced in the SHOW ENGINE INNODB STATUS transaction list using a decimal format (example: thread id 2176). (Bug #16934269, Bug #69437) * InnoDB: When dropping all indexes on a column with multiple indexes, InnoDB would fail to block a DROP INDEX operation when a foreign key constraint requires an index. (Bug #16896810) * InnoDB: The two INFORMATION_SCHEMA tables for the InnoDB buffer pool could show an invalid page type for read-fixed blocks. This fix will show the unknown page type for blocks that are I/O-fixed for reading. (Bug #16859867) * InnoDB: InnoDB record comparison functions have been simplified and optimized. (Bug #16852278) * InnoDB: innochecksum would ignore the return value of fwrite which could result in an error or generate warnings and compilation errors when WITH_INNODB_EXTRA_DEBUG CMake is enabled. (Bug #16872677) * InnoDB: An assertion in row0mysql.cc, which ensures that the dictionary operation lock is not taken recursively, would fail. (Bug #16862290) * InnoDB: An assertion failure would occur in file row0log.cc on ROW_FORMAT=REDUNDANT tables that contained an unexpected but valid data directory flag. (Bug #16863098) * InnoDB: Removed invalid compilation warning messages that appeared when compiling the InnoDB memcached plugin. (Bug #16816824) * InnoDB: The page_zip_validate() debug function, which is enabled when UNIV_ZIP_DEBUG is defined at compilation time, invokes page_zip_decompress(), which in turn would update some compression statistics. This would cause some mysql-test-run tests to fail. (Bug #16759605) * InnoDB: Valgrind testing returned memory leak errors which resulted from a regression introduced by the fix for Bug #11753153. The dict_create_add_foreign_to_dictionary function would call pars_info_create but failed to call pars_info_free. (Bug #16754901) * InnoDB: In debug builds, an online ALTER TABLE operation that performed a full table copy would raise an assertion. The assertion was due to a race condition that would occur during BLOB retrieval, when applying the table modification log to any log block except for the very last one. This fix modifies row_log_table_apply_convert_mrec() to ensure that an index B-tree lock is acquired to protect the access to log->blobs and the BLOB page. (Bug #16774118) * InnoDB: When the function trx_rollback_or_clean_recovered() rolls back or cleans up transactions during a crash recovery, it removes the trx objects from the trx_sys list without freeing up the memory used by those objects. To prevent a memory leak, this fix adds trx_free_for_background() calls to trx_rollback_resurrected(), the function that removes the trx objects. (Bug #16754776) * InnoDB: During an insert buffer merge, InnoDB would invoke lock_rec_restore_from_page_infimum() on a potentially invalid record pointer. (Bug #16806366) * InnoDB: This patch removes the UNIV_INTERN function, which was introduced in MySQL 5.1 to help replace static linking in InnoDB with the shared object plugin. UNIV_INTERN is no longer required. (Bug #16781511) * InnoDB: The innodb_rwlock_x_spin_waits item in the INFORMATION_SCHEMA.INNODB_METRICS table would show the same value as the innodb_rwlock_x_os_waits item. (Bug #16798175) * InnoDB: In debug builds, an assertion could occur in OPT_CHECK_ORDER_BY when using binary directly in a search string, as binary may include NULL bytes and other non-meaningful characters. This fix will remove non-meaningful characters before the search is run. (Bug #16766016) * InnoDB: The trx_tables_locked counter in INFORMATION_SCHEMA.INNODB_TRX would not account for all tables with locks. (Bug #16793724) * InnoDB: A missing comma in SHOW STATUS output would break MySQL Enterprise Monitor parsing. (Bug #16723686) * InnoDB: After a clean shutdown, InnoDB does not check .ibd file headers at startup. As a result, in a crash recovery scenario, InnoDB could load a corrupted tablespace file. This fix implements consistency and status checks to avoid loading corrupted files. (Bug #16720368) * InnoDB: A memory leak would occur in dict_check_tablespaces_and_store_max_id() when space_id is equal to zero. (Bug #16737332) * InnoDB: Some characters in the identifier for a foreign key constraint (http://dev.mysql.com/doc/refman/5.7/en/glossary.html#glos_for eign_key_constraint) are modified during table exports. (Bug #16722314, Bug #69062) * InnoDB: The page_zip_validate() consistency check would fail after compressing a page, in page_zip_compress(). This problem was caused by page_zip_decompress(), which would fail to set heap_no correctly when a record contained no user data bytes. A record with no user data bytes occurs when, for example, a primary key is an empty string and all secondary index fields are NULL or an empty string. (Bug #16736929) * InnoDB: This patch is a code cleanup which may provide a minor performance improvement when keys are not used on columns and when using the default latin1_swedish_ci collation. (Bug #16723431) * InnoDB: A regression introduced with the fix for Bug #11762038 would cause InnoDB to raise an incorrect error message. The message stated that, "InnoDB cannot delete/update rows with cascading foreign key constraints that exceed max depth of 20". The error message would occur when killing connections reading from InnoDB tables that did not have foreign key constraints. (Bug #16710923) * InnoDB: In debug builds, an assertion failure would occur if innodb_log_group_home_dir does not exist. Instead of an assertion, InnoDB now aborts with an error message if innodb_log_group_home_dir does not exist. (Bug #16691130, Bug #69000) * InnoDB: Stale InnoDB memcached connections would result in a memory leak. (Bug #16707516, Bug #68530) * InnoDB: An INSERT into a temporary table resulted in the following assert: ASSERT ID > 0 IN TRX_WRITE_TRX_ID(). This fix corrects conditions for moving a transaction from a read-only list to a read-write list when the server is running in read-only mode. (Bug #16660575) * InnoDB: A race condition would occur between ALTER TABLE ... ADD KEY and INSERT statements, resulting in an "Unable to Purge a Record" error. (Bug #16628233) * InnoDB: Shutting down and restarting InnoDB with --innodb-force-recovery set to 3 or greater (4, 5, or 6) and attempting to drop a table would result in a crash. With innodb_force_recovery mode set to 3 or greater DML operations should be blocked and DDL operations allowed. This fix ensures that DDL operations are allowed. (Bug #16631778) * InnoDB: A full-text search that returns large result sets would consume an excessive amount of memory due to use of a red-black tree for holding full-text search results. This fix reduces and imposes a limit on memory consumption. If the limit is exceeded, a message is returned indicating that the full-text search query exceeds the maximum allowed memory. (Bug #16625973) * InnoDB: An existing full-text index would become invalid after running ALTER TABLE ADD FULLTEXT due to an unsynchronized full-text cache. (Bug #16662990, Bug #17373659) * InnoDB: When ADD PRIMARY KEY columns are reordered in an ALTER TABLE statement (for example: ALTER TABLE t1 ADD PRIMARY KEY(a,b), CHANGE a a INT AFTER b), the log apply for UPDATE operations would fail to find rows. (Bug #16586355) * InnoDB: DML operations on compressed temporary tables would result in a Valgrind error in the buffer manager stack. (Bug #16593331) * InnoDB: In debug builds, the assert_trx_in_list() assert would fail, causing a race condition. This fix removes the assert. The same assert is verified in the caller and existing checks are sufficient. (Bug #16567258) * InnoDB: A code regression resulted in a record lock wait in a dictionary operation. A code modification made to avoid starting a transaction on a temporary table failed to reset the state back to init upon completion of the operation. If a transaction is started, the state is usually reset by trx_commit. To catch similar problems in the future, this fix adds asserts to innobase_commit(), innobase_rollback(), and ha_innobase::update_thd() that trigger when trx->dict_operation and trx->dict_operation_lock_mode are not set. (Bug #16575799) * InnoDB: This fix addresses a race condition that would occur between the rollback of a recovered transaction and creation of a secondary index in a locked operation. The race condition would corrupt the secondary index. (Bug #16593427) * InnoDB: The MySQL printf facility (my_vsnprintf) did not understand the Microsoft I32 and I64 integer format width specifiers, such as %I64u for printing a 64-bit unsigned integer. As a result, DBUG_PRINT could not be used with the InnoDB UINT64PF format, which is defined as %I64u on Windows. This fix replaces the non-standard "I64" and "I32" length modifiers on Windows with "ll" and "l" so that they will be understood by both my_snprintf() and ut_snprintf(). (Bug #16559119) * InnoDB: ALTER TABLE operations on InnoDB tables that added a PRIMARY KEY using a column prefix could produce an incorrect result. (Bug #16544336) * InnoDB: For ALTER TABLE operations on InnoDB tables that required a table-copying operation, other transactions on the table might fail during the copy. However, if such a transaction issued a partial rollback, the rollback was treated as a full rollback. (Bug #16544143) * InnoDB: Under certain circumstances, LRU flushing would take a long time possibly affecting all flushing activity and causing a shutdown timeout. (Bug #16500209) * InnoDB: The recv_writer thread would only start after all redo log scans finished. In the case of multiple redo log scans, accumulated redo records would be applied after each scan and before processing the next scan. The absence of the recv_writer thread to help with flushing would slow recovery or result in a server startup timeout. This fix ensures that the recv_writer thread starts before the first scan batch is processed. (Bug #16501172)
|• MySQL Community Server 5.7.2 has been released (part 2 of 4)
|Bjorn Munch
|22 Sep