Forum for Cloud discussions http://forums.mysql.com/list.php?165 Sat, 25 May 2013 10:45:18 +0000 Phorum 5.2.19 http://forums.mysql.com/read.php?165,576613,576613#msg-576613 http://forums.mysql.com/read.php?165,576613,576613#msg-576613
We will discuss the benefits of leveraging Continuent Tungsten clustering with MySQL, and walk you through the steps to implement a Tungsten cluster in Amazon EC2. We'll cover the prerequisites, installing and configuring Tungsten, and best practices that are part of most production installations and proof-of-concepts.


Course Topics

- Configuring MySQL and the OS for proper installation Installing a cross-site cluster
- Schema upgrade on the master database server with minimal application downtime (switch operation)
- Automated fail over when a MySQL database server crashes
- Recovery of a failed master to a fully operational slave with a single command (recover operation)
- Switching database operations to a remote site (geo-clustering, cross-site 'switch' operation)

We will also discuss and demonstrate basic operations, such as adding and removing a cluster node, basic monitoring and troubleshooting, and discuss the basic failure scenarios.

Join us to learn how to quickly configure and provision highly optimized Continuent Tungsten deployments in the cloud or on-premises! Even if you can't make the live virtual course, it is still worth registering for the course as you will receive a notification when the replay will be available, to study on-demand at your convenience.


Course Dates

- Thursday, January 17th @ 10:00 AM PST/1:00 PM EST(USA & Canada).
Reserve your seat at https://www1.gotomeeting.com/register/868426545
- Tuesday, January 22nd @ 15:00 GMT, 16:00 CET (Europe).
Reserve your seat at https://www1.gotomeeting.com/register/239773856


About Tungsten University

In the Tungsten University (http://www.continuent.com/news/live-webinars), you will learn the important details of clustering that you will need to understand to get started with Continuent Tungsten, how to properly configure and manage the cluster nodes to ensure high availability, how to install the different nodes and provide a better understanding of the internals of the cluster. Training from Tungsten University helps you keep your mission-critical applications and essential services up and running 24x7. Our live virtual courses are online instructor-led trainings that are delivered in real time via Web conferencing and audio, plus interactive enhancements such as live chat, Q&A and simulations.]]> Petri Virsunen MySQL & Clouds Fri, 28 Dec 2012 18:54:07 +0000 http://forums.mysql.com/read.php?165,569942,569942#msg-569942 http://forums.mysql.com/read.php?165,569942,569942#msg-569942 https://www1.gotomeeting.com/register/152529257

Cross-site databases are the next challenge facing today's MySQL-based businesses. Continuent Tungsten provides multiple options for spreading data across sites, including primary/DR, multi-master, and system-of-record approaches. Join us to learn how Continuent Tungsten enables replication, failover, and routing of transactions between sites. We cover the following topics:

- What are the differences between using disaster recovery sites and full multi-master?
- What are some of the key things applications must do in order to prepare for multi-master operation?
- What is system-of-record and how does it work?
- How do you set up multiple site data management with Continuent Tungsten?
- How do you fail over between sites?
- How does Continuent Tungsten route transactions transparently between sites?

Continuent is leading the charge to make multi-site operations work for SQL databases. Learn how Continuent Tungsten together with MySQL can give you the advanced data management capabilities your business needs today!]]> Petri Virsunen MySQL & Clouds Mon, 01 Oct 2012 18:58:57 +0000 http://forums.mysql.com/read.php?165,567521,567521#msg-567521 http://forums.mysql.com/read.php?165,567521,567521#msg-567521
http://img809.imageshack.us/img809/1648/picupload.jpg]]> salman mohd MySQL & Clouds Thu, 06 Sep 2012 10:40:16 +0000 http://forums.mysql.com/read.php?165,566734,566734#msg-566734 http://forums.mysql.com/read.php?165,566734,566734#msg-566734
i am working on a project where i want a result please help me out look the url below, paste the url to the browser

http://img593.imageshack.us/img593/1465/twoimg.jpg

the image have two table User and Upload_from table i need a query to get the results as shown in the url, waiting for the reply.]]> salman mohd MySQL & Clouds Thu, 30 Aug 2012 08:46:08 +0000 http://forums.mysql.com/read.php?165,540973,540973#msg-540973 http://forums.mysql.com/read.php?165,540973,540973#msg-540973
Thursday, May 31st @ 10 am PT/1pm ET
Reserve your seat at https://www1.gotomeeting.com/register/393720952]]> Petri Virsunen MySQL & Clouds Thu, 24 May 2012 22:07:55 +0000 http://forums.mysql.com/read.php?165,521509,521509#msg-521509 http://forums.mysql.com/read.php?165,521509,521509#msg-521509 https://www1.gotomeeting.com/register/429957080

Tuesday, 4/3 @ 9 am ET/15:00 CEST/14:00 BST/16:00 EEST
https://www1.gotomeeting.com/register/118613520

Your company has built a great new app and launched it in the cloud. And now you are seeing what many wish for: an exponential adoption of your app. But is your database tier really up to the job?

- What happens if your MySQL server fails?
- Can you fail over to a replica quickly?
- Do you even have a replica to fail over to?
- Can you keep your app available even as you upgrade your database schema or add additional or more powerful database servers?
- Can you easily scale read operations by load balancing them across a set of replicas?
- Do you have a way to maintain a set of data that is globally accessible, across Amazon EC2 regions in the USA, Europe, APAC, Japan etc., and that allows app users to get to and update their data with minimal latency, no matter where they are located?
- How do you make sure that an update made in a database in Japan gets propagated to databases in Europe, USA, APAC etc. with minimal latency?

This webinar focuses on the ways that Tungsten Enterprise can help you to solve these issues by combining local MySQL clusters, for high-availability and scalability, with cross-region, multi-master replication to maintain a globally distributed database.]]> Petri Virsunen MySQL & Clouds Fri, 23 Mar 2012 22:32:12 +0000 http://forums.mysql.com/read.php?165,517135,517135#msg-517135 http://forums.mysql.com/read.php?165,517135,517135#msg-517135 https://www1.gotomeeting.com/register/597680512, and
Tuesday 3/6/12 @ 15:00 CET/14:00 GMT
https://www1.gotomeeting.com/register/860877873

Learn how the next version of Tungsten Enterprise will help you push the envelope in multi-master, multi-site MySQL database clusters. We will be introducing the following features:

- Setting up MySQL clusters with a single installation command
- Automatic master failover without data loss
- Building disaster recovery sites quickly
- Automated failover between sites
- Building multi-master MySQL clusters that cross multiple worldwide sites, in the cloud.

Tungsten Enterprise is setting the standard for helping business build highly available and fast database systems using any MySQL version (MySQL Community 5.x, MySQL Enterprise 5.x, MariaDB, XtraDB). Our customers include Constant Contact, F-Secure, Hearst Magazines UK, Marketo, Norwegian Broadcasting Corporation, Sony Music Entertainment, Thomson Reuters and Zappos.com.

Join us to learn how Tungsten Enterprise 1.5 helps you in managing your data worldwide! Register at http://www.continuent.com/news/webinars!]]> Petri Virsunen MySQL & Clouds Fri, 24 Feb 2012 23:29:47 +0000 http://forums.mysql.com/read.php?165,508983,508983#msg-508983 http://forums.mysql.com/read.php?165,508983,508983#msg-508983
The new ClouSE storage engine for MySQL provides fully functional, transactional and ACID-compliant relational data management on top of cloud storage such as Amazon S3.

Designed and optimized for cloud storage from ground up ClouSE uses strict consistency enforcement, compression and caching techniques to smooth out cloud storage adoption bumps such as non-strict data consistency, high-latency storage access, and higher storage access failure rate due to network failures. ClouSE implements data encryption to provide full data confidentiality in the cloud, so cloud storage can be “plugged into” MySQL in a seamless and secure manner.

For more info please see http://www.oblaksoft.com or just download ClouSE v1.0 Beta for free at http://www.oblaksoft.com/downloads :-)

Thanks!

Sincerely,
Artem Livshits]]> Artem Livshits MySQL & Clouds Fri, 09 Mar 2012 20:54:47 +0000 http://forums.mysql.com/read.php?165,435575,435575#msg-435575 http://forums.mysql.com/read.php?165,435575,435575#msg-435575
It should be possible to connect to mySQL on AWS via SQL Workbench installed on my Windows PC -- shouldn't it? I want to be able to design the database on AWS mySQL through SQL Workbench.

Of course, this will require using SSH. SQL Workbench is pointing to the key file created on AWS. And, I have entered the ID/pwd for the AWS mySQL.

However, when I try to connect, I get the following error:

Error connecting SSH Tunnel: Could not open socket to 127.0.0.1

Clearly, SQL Workbench is not even getting to AWS. It fails at opening the SSH tunnel on my local PC.

By the way, what is the SSH ID/pwd on my local PC? How do I configure it?

FYI -- the web app is written in python/django.]]> Tanuja Prasad MySQL & Clouds Sat, 24 Sep 2011 03:02:45 +0000 http://forums.mysql.com/read.php?165,425962,425962#msg-425962 http://forums.mysql.com/read.php?165,425962,425962#msg-425962
i installed a mysql cluster on an AMI. (2 datanodes)
I can log to the machine and to the database and make anything i like,..

now im trying to write a small java client to connect to the database.. and im
getting this error:

null, message from server: "Host 'dslb-188-108-096-220.pools.arcor-ip.net' is not allowed to connect to this MySQL server"

i made sure all the ports are there and oppened...

what is going wrong? any Idea?

Regards,

vinzy]]> Raoul Wanga MySQL & Clouds Mon, 18 Jul 2011 06:48:07 +0000 http://forums.mysql.com/read.php?165,423807,423807#msg-423807 http://forums.mysql.com/read.php?165,423807,423807#msg-423807 CJ Clater MySQL & Clouds Thu, 16 Jun 2011 19:27:46 +0000 http://forums.mysql.com/read.php?165,409501,409501#msg-409501 http://forums.mysql.com/read.php?165,409501,409501#msg-409501
Some examples:
- perform periodic snapshot of DB and restore DB from EC2 snapshot
- backup, compress and copy DB data over WAN from one region to another
- add VNC service

I'd prefer to pay by the piece instead of hourly. That way someone who already knows this stuff inside and out can do it in minutes and get paid for their knowledge; or a newbie can dive in and take days but get paid to learn and figure it out.

Please don't post your contact info back to the forum -- send me email directly at jobs@gyregroup.com. I'm not a recruiter and I won't share your information with other companies.]]> Jonathan Newbrough MySQL & Clouds Fri, 25 Feb 2011 22:27:19 +0000 http://forums.mysql.com/read.php?165,406503,406503#msg-406503 http://forums.mysql.com/read.php?165,406503,406503#msg-406503
We are using Amazon RDS and would like to know (if even possible) if we can setup several slave databases to have different master databases? For example:

Slave #1 will have his master slave as Master #1 When needed we can change the master slave for Slave #1 to be Master #2 instead.

Thanks.]]> vadim gavrilov MySQL & Clouds Mon, 07 Feb 2011 10:40:19 +0000 http://forums.mysql.com/read.php?165,402357,402357#msg-402357 http://forums.mysql.com/read.php?165,402357,402357#msg-402357
Yesterday when I was trying to add another table to my database I got an error code 28. So I researched and found out it was a disk full error message. So I went into my AWS and created a new volume attached it and did all the other jazz needed for that to work. Went back into my Workbench, tried to create the table and got the same error message. Do I went and looked and noted that Im only using 63% of the volume my database is on. Im confused here, what am I missing? Could my database size be set?]]> Tommy Ready MySQL & Clouds Mon, 10 Jan 2011 17:55:43 +0000 http://forums.mysql.com/read.php?165,400212,400212#msg-400212 http://forums.mysql.com/read.php?165,400212,400212#msg-400212
I have recently faced mysqld_safe issue.When i issued top command in my server it showed me that the mysqld_safe consumed 40 % of the cpu process..So I had to kill the mysqld_safe process and things came back to normal. This happened when I used lighttpd web server. When I browsed through many of the forums they suggest that mysqld_safe script has to be modified.

Earlier I was using apache webserver where in I never faced a issue like this. I just want to know if I need to do any additional configuration on lighttpd to work with mysql server? Can some one tell me why the mysqld_safe consumed high amount of cpu process??

Thanks in advance]]> karthick balaraman MySQL & Clouds Thu, 23 Dec 2010 13:18:54 +0000 http://forums.mysql.com/read.php?165,394642,394642#msg-394642 http://forums.mysql.com/read.php?165,394642,394642#msg-394642
http://ibaonline.webs.com/apps/webstore/products/show/1811186]]> naveed ali MySQL & Clouds Mon, 15 Nov 2010 11:09:57 +0000 http://forums.mysql.com/read.php?165,393765,393765#msg-393765 http://forums.mysql.com/read.php?165,393765,393765#msg-393765
The message similar to below was sent to oraclehelp_ww@oracle.com few days ago, but there is no reply, so I post the inquiry here:

Our company plan to build a commercial Software as Service (SaaS) application using MySQL database to be hosted in Amazon EC2 platform. May I know whether our company must pay for licensing cost of MySQL database to legally use it for commercial application hosted in Amazon EC2 platform? If the answer is yes, may I know how much?

Also, the "Subscribe to MySQL Enterprise on Amazon EC2" link http://www.mysql.com/products/enterprise/ec2.html is broken.


Please advice.

Regards,
Chee Kin]]> Chee Kin Lim MySQL & Clouds Tue, 09 Nov 2010 05:46:46 +0000 http://forums.mysql.com/read.php?165,391851,391851#msg-391851 http://forums.mysql.com/read.php?165,391851,391851#msg-391851 i want to display all the category in Ascending order.
i am using this query

select * from tbl_category order by c_name asc

in category table i'm having the catagory name Others.
it will display on last.


Records now display:
Art
Basket
car
Drive
other
silver
i want to display like
Art
Basket
car
Drive
silver
other

Please help me...............
Thanks & Regards
Dharma]]> dharma raj MySQL & Clouds Wed, 27 Oct 2010 07:01:15 +0000 http://forums.mysql.com/read.php?165,378393,378393#msg-378393 http://forums.mysql.com/read.php?165,378393,378393#msg-378393
The MySQL datadir is on a separate device (600GB EBS mounted at /ebs ), so it's definitely not MySQL data. And /tmp doesn't have anything visible going on; certainly not something that would take up the 9gb that are normally free.

I suspect that something is not releasing file handlers correctly. For all I know this could be happening with all programs, but MySQL is the only thing running that would use enough temp space to be noticed. Each server has some applications that happen on it uniquely, but since it's happening on all of them I figure it's the common elements that count. The servers are a clean install, running Apache2 (PHP 5.2), MySQL, and SSHD. All three servers were installed from the official AMI.]]> Campbell Vertesi MySQL & Clouds Wed, 01 Sep 2010 03:46:49 +0000 http://forums.mysql.com/read.php?165,362987,362987#msg-362987 http://forums.mysql.com/read.php?165,362987,362987#msg-362987
I am having a difficult problem with Amazon EC2 and our database.

We would like to redimension the partition of the virtual Operating System from 4GB to 10GB at least without losing all our data/scripts. At the moment our 4GB is not sufficient.

Another option it seems to be using a HD Virtual (EBS* - elastic block store) of 10GB as an instance of our previously installed Operating System.

A final option we believe would be to have a AMI with 10GB OS space + 10GB for storage.

We need help with a step-by-step guide for beginners in getting a solution set up urgently so we can have our server up and running, this is absolutely critical as the site is just waiting for this to be able to be launched. I have already tried posting in the Amazon forum but obtained no reply and cant find a contact number: http://developer.amazonwebservices.com/connect/thread.jspa?threadID=44927


Your help is much appreciated, if possible please reply to: bookess@gmail.com

Kind regards

Bernardo Carvalho
Bookess]]> Bernardo Carvalho MySQL & Clouds Tue, 13 Apr 2010 16:56:08 +0000 http://forums.mysql.com/read.php?165,289316,289316#msg-289316 http://forums.mysql.com/read.php?165,289316,289316#msg-289316
I do plan on scaling in the future though, so I have made some DNS A records and CNAME anticipating some horizontal scaling.

One thing I'm having trouble with though is mysql access control.

For example, I'd like to create a user in MySQL that can only connect from localhost and from my web server. My webserver has an A record in my DNS (dynDNS) pweb1.mydomain.com , and a CNAME to it of pweb.mydomain.com.

I'd like to setup the access record in MySQL to allow the db user (from my web application) to connect from 'pweb.mydomain.com', but I always get an error like:

Access denied for user 'myuser'@'174.129.34.65'.

So obviously it's an issue with MYSQL being very strict about the access control. Is there a way I can tell it to accept a CNAME alias, or do some sort of loose IP checking?]]> Clifford Meece MySQL & Clouds Tue, 03 Nov 2009 17:28:55 +0000 http://forums.mysql.com/read.php?165,288181,288181#msg-288181 http://forums.mysql.com/read.php?165,288181,288181#msg-288181
Tungsten has a wide range of features designed to make cloud operation efficient and easy. We will show you how to:

- Create fast and simple batch installations for new machine instances
- Configure networking for operation in cloud environments
- Handle failover and recovery using software only
- Add and remove nodes efficiently
- Use switch operations to scale instance capacity up and down easily.

DATE: November 19, 2009
TIME: 10 am PT/ 1 pm ET/ 19:00 CET
REGISTER AT: http://continuent.webex.com]]> Petri Virsunen MySQL & Clouds Tue, 27 Oct 2009 22:30:42 +0000 http://forums.mysql.com/read.php?165,279195,279195#msg-279195 http://forums.mysql.com/read.php?165,279195,279195#msg-279195
Continuent today announced Tungsten 1.1. With Continuent’s Tungsten solutions you can improve your existing database with:
• Automatic Failover with no data loss: maintain extra replicas of data in a case the master database fails, with automatic master failover by promoting one of the slaves as a new master
• Performance: use multiple database replicas to scale database performance
• Backup and Disaster Recovery: copy data on multiple databases, local or remote, for backup and disaster recovery
• Real-time Data Integration: replicate from MySQL to Oracle and vice versa
• Real-time Data Warehousing: copy data in real-time from a production database into a data warehouse for analysis and reporting.

Continuent Tungsten Enterprise 1.1 introduces the following new core features:
• One-step installation and configuration process
• Fully automated database failover using sophisticated production rules
• Integrated, easy to use backup solution
• Unique session-consistency load balancing model
• Comprehensive database cluster management for database administration
• Ability to control operating system services from the cluster management console program.

Continuent Tungsten runs on all Linux™ and Solaris® platforms. The Continuent Tungsten Cloud Edition also runs in the Amazon EC2™ cloud through integration with RightScale®.

"Continuent Tungsten allows us to work with our customers to improve our
product, instead of managing the infrastructure that it runs on. With a
database cluster that works together and manages itself, I know that it will
handle our availability and scalability requirements", said Jeff Mace, team
leader at AetherQuest Solutions.

Continuent Tungsten Enterprise is available today for MySQL and MariaDB, and for PostgreSQL in September. Continuent Tungsten Enterprise is available for Oracle in Q4’09. For more information, visit http://www.continuent.com.]]> Ona Teerikorpi MySQL & Clouds Tue, 01 Sep 2009 18:51:41 +0000 http://forums.mysql.com/read.php?165,279084,279084#msg-279084 http://forums.mysql.com/read.php?165,279084,279084#msg-279084
Can any one help me out how to write mysql script to text file

Best Regards

Peter]]> Peter Taban MySQL & Clouds Tue, 01 Sep 2009 08:32:40 +0000 http://forums.mysql.com/read.php?165,276383,276383#msg-276383 http://forums.mysql.com/read.php?165,276383,276383#msg-276383
We have serious stability issues with mysqld running on Linux hosts in EC2, with all of its data and log files stored on an EBS volume. We keep a slave purely for hot backup and failover, and when the master goes down, we can usually bring up the slave as a master without any issues, and then create a new slave.

But it's *very* problematic that our master will just go down. The master host keeps running fine, but mysqld won't respond to anything, and can't even be killed with kill -9. The 'mysql' and 'mysqladmin' clients just freeze and can't be caught with ^C or ^Z. The jobs that take EBS snapshots every 15 minutes also pile up in ps, never going away, but never completing either.

This happens in both our production and staging environments, which are similar, but production runs on large instances (with Centos 5.2 x86_64) and staging on medium instances (with Centos 5.2 i686). mysql-5.0.45 in all cases.

Has anybody experienced similar mysqld stability problems in EC2, and if so, how did they deal with them?

Thanks in advance.]]> Max Newell MySQL & Clouds Tue, 10 Nov 2009 15:52:30 +0000 http://forums.mysql.com/read.php?165,275152,275152#msg-275152 http://forums.mysql.com/read.php?165,275152,275152#msg-275152
I basically followed the directions in Eric Hammonds MySQL EC2 tutorial:
"http://developer.amazonwebservices.com/connect/entry.jspa?categoryID=100&externalID=1663";

and everything went pretty well - I was able to create a database, create tables, add data, and query the database.

Next, I installed Java and uploaded a Java application that processes text files. The Java application creates a new database and populates several tables.

The Java application completed without error and all of the log files look great. If I look in the ../lib/mysql directory the database directory exists and includes all of the database table and index files.

If I issue "show databases" the new database "trec_query" exists.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test |
| trec_query |
+--------------------+
4 rows in set (0.00 sec)

*** However, if I try to connect to the database I get ERROR 1049 (42000) unknown database. Note: I can connect to the mysql and test databases, just not the database created with the Java program. The same Java program runs fine on my laptop. I've also used the same user and password for creating all databases.

mysql> connect treq_query;
ERROR 1049 (42000): Unknown database 'treq_query'

I'm perplexed, any ideas would be appreciated.

Thanks,
Jay Urbain]]> Jay Urbain MySQL & Clouds Fri, 07 Aug 2009 22:39:20 +0000 http://forums.mysql.com/read.php?165,274998,274998#msg-274998 http://forums.mysql.com/read.php?165,274998,274998#msg-274998 I think this would be a common issue but i have searched the forums and searched google for going on 3 hours now and havent found anyone with my exact issue.

Please dont flame until you see the full issue.

I did a fresh mysql install on a Fedora Core 8 box.

I started myql, tested it, and stopped it.

I created a new formated mounted volume (/ebs)
I went to /var/lib/ and typed: mv /var/lib/mysql/* /ebs/mysql/
I edited my.cnf and changed all the locations.

Being that it is fedora, and there are some known bugs with the user and pinging
I did the following: vi /etc/init.d/mysqld
And i changed the line which mysql uses to ping itself to verify it is installed

When i try to restart it: /etc/init.d/mysqld start
it says: "Timeout error occurred trying to start MySQL Daemon."

Looking further into it, I tried: mysqladmin -uroot ping
"error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!"




I have checked both /etc/init.d/mysqld & /etc/my.cnf and neither of them have anything pointing to /var/lib/mysql/mysql.sock

I specifically set the socket file to be /ebs/mysql/mysql.sock

Also it does start the server (ps -a|grep "mysql") does show it running,

if i try mysql -u root
"ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)"


Does anyone know why there is something still pointing to the old directory???

Please help me, this issue has been plaguing me on all of my server installs recently, and i need to find a solution

Thanks
Matt]]> Matt Gardner MySQL & Clouds Thu, 06 Aug 2009 23:46:12 +0000 http://forums.mysql.com/read.php?165,272082,272082#msg-272082 http://forums.mysql.com/read.php?165,272082,272082#msg-272082
Learn how to
- Connect your cloud web and application servers with customized dedicated database servers and take advantage of the elasticity of cloud for spikes in web traffic while getting the high I/O performance of dedicated servers.
- Load balance to increase system performance and redundancy so that you can seamlessly handle spikes in traffic while achieving around-the-clock availability.
- Improve overall high scalability, redundancy, performance and reliability
- Meet On-Demand server needs
- Achieve low maintenance & support costs and no capital expenditures.

Date: August 6, 2009 at 1 pm ET/ 10 am PT
Register: http://continuent.webex.com]]> Petri Virsunen MySQL & Clouds Thu, 16 Jul 2009 19:38:24 +0000 http://forums.mysql.com/read.php?165,271910,271910#msg-271910 http://forums.mysql.com/read.php?165,271910,271910#msg-271910
We have recently shown that one can score MySQL data on the Amazon Cloud using the ADAPA scoring engine. If your data already resides on the cloud, that may be an advantage.

If you would like to find out how we do it, please see our blog on the Smart Data Collective website:

http://smartdatacollective.com/Home/20124]]> Alex Guazzelli MySQL & Clouds Wed, 15 Jul 2009 21:32:13 +0000 http://forums.mysql.com/read.php?165,271612,271612#msg-271612 http://forums.mysql.com/read.php?165,271612,271612#msg-271612 I have a query that runs on a somewhat huge table.

I have set the query_cache_size to zero as I need to see the effect of "table warming up" when i execute the same query many times repeatedly.

My problem however is that I would actually expect that the time it takes to run the query would decrease as i run the query many times - sort of like 1 min, 50 secs, 40 secs, 25 secs etc...

This doesn't happen and sometimes successive queries take longer that the first time. Below is an excerpt of the results I get:

8min 12 sec;1 min 39.73 sec;10min 15.08 sec;6min 45.15sec;7min 48.33sec

Can someone explain why i would get such results? Is there something I need to check on say my config?]]> Irungu Kamau MySQL & Clouds Tue, 14 Jul 2009 09:55:46 +0000