This might interest some that Google Cloud SQL is actually a MySQL database
that lives in Google's cloud
Source: https://developers.google.com/cloud-sql/docs/introduction
Thanks, Rick - definitely something to think about. I've been
troubled by the pagination stuff in our code. This looks like
something I can definitely use!
andy
On 9/5/12 2:40 PM, Rick James wrote:
Remember where you "left off".
Your "Next" button now says something like ?page=5&size=50
When y
Remember where you "left off".
Your "Next" button now says something like ?page=5&size=50
When you get there, you are doing something like SELECT ... ORDER BY ... LIMIT
250, 50
Instead...
Make it say ?after_id=12345&size=50
and then do SELECT ... WHERE id > 12345 ORDER BY ... LIMIT 51
With 51,
Hi all,
I am a newbie to work with the settings in mysql although I have used in
very small applications before
I am currently experimenting with very large tables and a few complicated
queries. I am using mysql 5.5. My tables are of size of abt 1 million
tuples. The queries upon these tables ta
Ok, this raises a question for me - what's a better way to do pagination?
On 9/5/12 2:02 PM, Rick James wrote:
* LIMIT 0, 50 -- are you doing "pagination" via OFFSET? Bad idea.
--
Andy Wallace
iHOUSEweb, Inc.
awall...@ihouseweb.com
(866) 645-7700 ext 219
--
"Sometimes it pays to stay in bed
* SHOW VARIABLES LIKE 'innodb%'; -- some of them may be hurting performance.
* More that 20% of the table has bean_type = 'Workflow'? -- if so, it is more
efficient to do a table scan than to use the index.
* KEY `I_WF_1_DTYPE` (`bean_type`), -->
KEY bean_time (`bean_type`, created_time)
"Comp
true Michael, pasting the output :
CREATE TABLE `WF_1` (
`id` varchar(255) NOT NULL,
`app_name` varchar(255) DEFAULT NULL,
`app_path` varchar(255) DEFAULT NULL,
`conf` text,
`group_name` varchar(255) DEFAULT NULL,
`parent_id` varchar(255) DEFAULT NULL,
`run` int(11) DEFAULT NULL,
`
Shaun,
Is this option planned for backport into 5.5.x ?
Cheers
signature.asc
Description: This is a digitally signed message part
I already attached the list.
Attaching one more time & thanks for the interest.
Cheers
On Wed, Sep 5, 2012 at 11:44 AM, Manuel Arostegui wrote:
>
>
> 2012/9/5 Adarsh Sharma
>
>> Actually that query is not my concern :
>>
>> i have a query that is taking so much time :
>> Slow Log Output :
>>
