Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 9

Displaying posts with tag: comments (reset)

MySQL and InnoDB comments…
+0 Vote Up -0Vote Down
Hello everyone, here we go for a new blog post and now treating about InnoDB inside MySQL 5.5 and as you should now, this new version uses InnoDB Plugin version 1.1 which one has a lot of new adjustable resources. What most caught my attention was the impressed way that users could adjust it to have [...]
mk-query-digest, query comments and the query cache
+1 Vote Up -0Vote Down

I very much like the fact that MySQL allows you to embed comments into SQL statements. These comments are extremely convenient, because they are written into MySQL log files as part of the query. This includes the general log, the binary log and the slow query log. Maatkit includes tools which interact with these logs, including mk-query-digest. This tool, in particular, has a very nice option called --embedded-attributes which can process data embedded in query comments.

The support for embedded attributes makes some cool tricks possible. Peter and I co-presented a talk at this past MySQL Conference and Expo. In this talk I presented my

  [Read more...]
SQL syntax with /*! c-style comments in MySQLdump
+1 Vote Up -0Vote Down
In mysql we have — , /* and /*! comments.  This post is mainly about very basic c-style comments. /*! : C-Style comments in MySQL We normally see comments in MySQLdump as follows: /*!40000 ALTER TABLE `a` DISABLE KEYS */; Or /*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */ These are actually C-Style comments which has embeded […]
"How to find the source of queries in MySQL Query Analyzer" or "SQL comments in Query Analyzer"
Employee +0 Vote Up -0Vote Down

MySQL Enterprise Monitor offers a tool called "Query Analyzer" (QuAn). QuAn sits between any client app and the MySQL server and logs every query and its runtime statistics. A very cool tool for analyzing your SQL. More information is available here (http://www.mysql.com/products/enterprise/query.html).If you identify a query, that needs some improvement, sometimes it is hard to identify the source of that query as well. With hundreds of different PHP scripts for example it is not easy to know, which one issued the query, that you want to modify.A good way to achieve this is adding C-style SQL comments. Let's look at an example: SELECT * FROM mytable
  [Read more...]
Comment Search
+0 Vote Up -0Vote Down

You guys are generating an amazing amount of feedback on your blogs. Matt mentioned in the April Wrap-Up that there were 8.6 million comments! Comments are flying in every second of the day.

And have you ever had one of those blog posts that was good, but the real action was in the comments? The blog post is only half the story, it’s the feedback from everyone else that fills in the rest. To make it easier to find the second half of these stories we’ve added comment search to WordPress.com search.

Select the comments options from the WordPress.com search page and we’ll hunt through the millions of comments that have been added to WordPress.com blogs to find what you are looking


  [Read more...]
Add YouTube and Polls to Comments
+0 Vote Up -0Vote Down

Some of you may have noticed we’ve been experimenting with a new feature in comments here on WordPress.com, namely that you can now embed YouTube videos and PollDaddy polls directly in a comment.

Although shortcodes are great and we’ll continue to support and encourage them for comments the simplest possible interface seemed to be just a URL.

The URL is all you’ll need to include a YouTube video or PollDaddy poll. To try it out copy and paste the permalink for a video or a poll on PollDaddy Answers and put it on its own line in a comment, like enter enter http://answers.polldaddy.com/poll/1598108/ enter enter. You’ll now have a poll embedded in the comment just like this:

View Poll

(By


  [Read more...]
Query cache and comments
Employee +0 Vote Up -0Vote Down

Update

Ok, as Morgan quickly found out: I'm incredibly stupid. Read his comment and you'll know why. Ok, you'll not know why but you'll know that I am.

Really cool to see Chris taking up blogging as well

He has written nice little example about inserting comments into queries to distinguish the client’s IP when they are funneled through the proxy. Reading the comments about this little trick making the query cache not work, I couldn’t help thinking that those are wrong. I vaguely remembered that in some recent version this shortcoming was fixed, so I decided to run a little test on 5.1.30 to verify:

mysql> select
  [Read more...]
Query cache and comments
Employee +0 Vote Up -0Vote Down

Update

Ok, as Morgan quickly found out: I'm incredibly stupid. Read his comment and you'll know why. Ok, you'll not know why but you'll know that I am.

Really cool to see Chris taking up blogging as well

He has written nice little example about inserting comments into queries to distinguish the client’s IP when they are funneled through the proxy. Reading the comments about this little trick making the query cache not work, I couldn’t help thinking that those are wrong. I vaguely remembered that in some recent version this shortcoming was fixed, so I decided to run a little test on 5.1.30 to verify:

mysql>
  [Read more...]
Query cache and comments
Employee +0 Vote Up -0Vote Down

Update

Ok, as Morgan quickly found out: I'm incredibly stupid. Read his comment and you'll know why. Ok, you'll not know why but you'll know that I am.

Really cool to see Chris taking up blogging as well

He has written nice little example about inserting comments into queries to distinguish the client’s IP when they are funneled through the proxy. Reading the comments about this little trick making the query cache not work, I couldn’t help thinking that those are wrong. I vaguely remembered that in some recent version this shortcoming was fixed, so I decided to run a little test on 5.1.30 to verify:

mysql>
  [Read more...]
Showing entries 1 to 9

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.