Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 61 to 70 of 33877 10 Older Entries
Django with time zone support and MySQL
+0 Vote Up -0Vote Down

This is yet another story of Django web-framework with time zone support and pain dealing with python datetimes and MySQL on the backend. In other words, offset-naive vs offset-aware datetimes.

Shortly, more about the problem. After reading the official documentation about the time zones, it makes clear that in order to reflect python datetime in the necessary time zone you need to make it tz-aware first and than show in that time zone.

Here is the first issue: tz-aware in what time …

  [Read more...]
Using Perl to send tweets stored in a MySQL database to twitter
+3 Vote Up -2Vote Down

Twitter is not my favorite social media site. Using twitter is like driving downtown, screaming what you want to say out the window, and hoping someone hears you. There might be tens of thousands of people downtown, but your message will only be heard by a few. Your best bet is to repeat your message as often as possible.

However, twitter is free and if you want to reach as many people (theoretically) as possible, you might as well use it. But sending tweets on a scheduled basis can be a pain. There are client programs available which allow you to schedule your tweets (Hootsuite is one I have used in the …

  [Read more...]
When ONLY_FULL_GROUP_BY Won’t See the Query Is Deterministic…
Employee_Team +1 Vote Up -0Vote Down

This is a follow-up post to my recent announcement of only_full_group_by improvements in 5.7, where I’d like to address some tricky corner cases where GROUP BY contains non-column expressions (functions).

In the SQL standard, GROUP BY should contain only table columns and never expressions. So this example query where we want to count how many people have the same name is illegal in the SQL2011 standard because the GROUP BY clause contains a function:

  [Read more...]
Understanding reservations, concurrency, and locking in Nova
+0 Vote Up -0Vote Down

Imagine that two colleagues, Alice and Bob, issue a command to launch a new virtual machine at approximately the same moment in time. Both Alice’s and Bob’s virtual machines must be given an IP address within the range of IP addresses granted to their project. Let’s say that range is 192.168.20.0/28, which would allow for a total of 16 IP addresses for virtual machines [1]. At some point during the launch sequence of these instances, Nova must assign one of those addresses to each virtual machine.

How do we prevent Nova from assigning the same …

  [Read more...]
Can we improve the current state of benchmarketing?
+0 Vote Up -0Vote Down

I'm starting off 2015 with the following New Year's Resolution, to improve the state of benchmarking. About a month ago I noticed the following tweet:
Hey @tokutek, please look at this: http://stssoft.com/products/stsdb-4-0/benchmark …. Are the benchmarks rigged or correctly done? I'm curious to know!While I've never met Ian Campbell (@iamic) he certainly knew how to call me to action. I immediately checked out the …

  [Read more...]
Getting mutex information from MySQL’s performance_schema
+1 Vote Up -0Vote Down

We have been using SHOW ENGINE INNODB MUTEX command for years. It shows us mutex and rw-lock information that could be useful during service troubleshooting in case of performance problems. As Morgan Tocker announced in his blog post the command will be removed from MySQL 5.7 and we have to use performance_schema to get that info.

The documentation of MySQL also says that most of the command output has been removed from 5.6 and that we can find similar info in performance_schema. It doesn’t show any …

  [Read more...]
StackScope Webinar Series: Industry Roundtable
+0 Vote Up -0Vote Down

It’s a new year, and that means there are new challenges in the ever shifting technology landscape. Begin 2015 ahead of the curve. On January 22nd, StackScope will host its first webinar, an industry roundtable. Four industry leaders will discuss topics including the Cloud, Big Data, Microservices, Continuous Delivery, Containerization, and the Internet of Things. They will address questions from the future of DevOps to the impact of Amazon Aurora and everything in between. You do not want to miss the opportunity to participate …

  [Read more...]
#DBHangOps 01/08/15 -- More Compression!
+0 Vote Up -0Vote Down

#DBHangOps 01/08/15 -- More Compression!

Hello everybody!

Join in #DBHangOps this Thursday, January, 08, 2015 at 11:00am pacific (18:00 GMT), to participate in the discussion about:

  • More compression!
  • MySQL Event Scheduler
  • What is everyone's understanding of innodb_io_capacity?

You can check out the event page at https://plus.google.com/events/cb7pdn3egenc6c79lc4bc74kr04 on Thursday to participate.

As always, you can still watch the …

  [Read more...]
Different SSL setups for MySQL
+0 Vote Up -0Vote Down

In this blog post I will describe different ways of using SSL with the MySQL database server.

What does SSL give you?

You might use MySQL replication over the internet or connect to MySQL over the internet.

Another posibility is that you connect over an enterprise network to which just too many people have access. This is especially an issue if you use an BYOD network.

SSL helps here by encrypting the network traffic to prevent against evesdropping. It also validates …

  [Read more...]
Heads up: Going 100% GitHub at the End of January
Employee_Team +3 Vote Up -0Vote Down

Hi, all. Just a quick note to let you all know that we completed the move of MySQL Server development from Bazaar to Git some time ago. This means that as of the upcoming, end of January batch of Server releases (5.6.23 and 5.5.42), our official source code hosting moves from Launchpad to GitHub. The […]

10 Newer Entries Showing entries 61 to 70 of 33877 10 Older Entries

Planet MySQL © 1995, 2015, 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.