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 3

Displaying posts with tag: slow (reset)

Stock Centos6 Ruby and a MySQL database far away
+0 Vote Up -0Vote Down
I wanted to share a recent issue with stock Ruby on Centos6.

We run a Rails application that connects to a MySQL datastore. We're in a datacenter transformation and we deployed the application to our new datacenter though the MySQL datastore is at the other datacenter. As you can see there is about a 35ms distance between the application and the MySQL instance.



[root@host]# ping 172.x.y.19
PING 172.x.y.19 (172.x.y.19) 56(84) bytes of data.
64 bytes from 172.x.y.19: icmp_seq=1 ttl=253 time=32.6 ms
64 bytes from 172.x.y.19: icmp_seq=2 ttl=253 time=38.1 ms
64 bytes from 172.x.y.19: icmp_seq=3 ttl=253 time=36.0 ms
^C
--- 172.x.y.19 ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2751ms
rtt min/avg/max/mdev = 32.656/35.600/38.101/2.250 ms


We started the Rails
















  [Read more...]
Canada’s Version of the Ant and Grasshopper
+0 Vote Up -0Vote Down

Background Knowledge


It appears this depiction of the Canadian political left and right originated as far as I can tell by johnnyslow [at] gmail [period] com around the end of the 2005. I recently heard the below of what I’m reposting on Charles Adler radio show.

I was so impressed by this analogy I had to post it for others that may have not read it yet.

Classic Version


The ant works hard in the withering heat all summer long, building his house and laying up supplies for the winter. The grasshopper thinks he’s a fool, and laughs and dances and plays the summer away.

Come winter, the ant is warm and well fed. The shivering grasshopper has no food or
shelter, so he dies out in the cold.

THE END

The Canadian Version



  [Read more...]
Q&A on MySQL 5.1
+0 Vote Up -0Vote Down
Listening to Sheeri's presentation on MySQL 5.1, I saw that there are a few questions left unanswered. I am listing here some of the questions that I found interesting, plus a few from an early webinar on the same topic.

Q: does Partitioning physically split data?A: No. Some engines (MyISAM, Archive) do a physical split, but this is not necessary, as you see if you apply partitioning to a InnoDB table. Partitioning is a logical split of data, for easy retrieval. It is completely transparent to the user.Q: Can you set partitions to different servers?A: No. Partitions are logical parts of one table within one server. Partitioning through the Federated engine is not supported.Q: How efficient are Row-Based Replication operations compared to Statement based

  [Read more...]
Showing entries 1 to 3

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.