tag:blogger.com,1999:blog-8575059197193667898.comments2023-08-20T03:33:44.741-07:00Dave's StuffDave Stokeshttp://www.blogger.com/profile/16737653465494764723noreply@blogger.comBlogger291125tag:blogger.com,1999:blog-8575059197193667898.post-39590137678810553342012-08-25T19:15:20.839-07:002012-08-25T19:15:20.839-07:00Hi Anonymous -- no, the MySQL do not expire.Hi Anonymous -- no, the MySQL do not expire.Dave Stokeshttps://www.blogger.com/profile/16737653465494764723noreply@blogger.comtag:blogger.com,1999:blog-8575059197193667898.post-58685254958199360762012-08-25T17:02:10.841-07:002012-08-25T17:02:10.841-07:00Hi Dave,
I have noticed some forms of accreditati...Hi Dave,<br /><br />I have noticed some forms of accreditation (such as A+ and N+) now have time-outs so they cease to be recognised after 3 years or so. Is this the case with SQL certification such as MySQL Associate?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8575059197193667898.post-78276908034265382382012-07-09T05:16:31.990-07:002012-07-09T05:16:31.990-07:00The 3rd big search engine is Yahoo, keep writing t...The 3rd big search engine is Yahoo, keep writing this kind of great stuff thanks for sharing..<br /><br /><br /><b><a href="http://www.fmeextensions.com" rel="nofollow">Magento Services</a></b>Magento Moduleshttps://www.blogger.com/profile/09924662114979739023noreply@blogger.comtag:blogger.com,1999:blog-8575059197193667898.post-79307004794957581192012-02-28T06:26:50.436-08:002012-02-28T06:26:50.436-08:00Dave, what happens if I want to use WordPress on a...Dave, what happens if I want to use WordPress on a <a href="http://xeround.com/" rel="nofollow">cloud database</a> other than MySQL? Assuming I want to use WordPress, are there any significant dis/advantages to sticking to MySQL?ValerieSnoreply@blogger.comtag:blogger.com,1999:blog-8575059197193667898.post-37041077165845564362012-02-05T13:39:55.732-08:002012-02-05T13:39:55.732-08:00Great post. Here’s a tool to use to create and pub...Great post. Here’s a tool to use to create and publish your report online in minutes, without coding. You can create different graphs and layoutshttp://www.caspio.com/online-database/features/reports.aspxScott Levyhttps://www.blogger.com/profile/15982269383206033516noreply@blogger.comtag:blogger.com,1999:blog-8575059197193667898.post-50809379201101978682012-01-09T07:31:45.581-08:002012-01-09T07:31:45.581-08:00After a few years, the questions became dated and ...After a few years, the questions became dated and the Oracle Certification folks reorganized the web pages. For now use the MySQL 5.0 Certification Guide for sample questions.Dave Stokeshttps://www.blogger.com/profile/16737653465494764723noreply@blogger.comtag:blogger.com,1999:blog-8575059197193667898.post-36053566283712549452012-01-07T16:46:06.382-08:002012-01-07T16:46:06.382-08:00Where are these questions? unvisible mysql.Where are these questions? unvisible mysql.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8575059197193667898.post-4756680633256453702011-11-22T08:26:50.847-08:002011-11-22T08:26:50.847-08:00Many legacy open source applications have kept bac...Many legacy open source applications have kept backward compatibility, which I think is a mistake for the fast paced technology world.<br /><br />Several more immediate things struck me with using WordPress. If you want convert tables to InnoDB (i.e. have a crash save DB), then you need look at all indexes. The wp.posts.type_status_date is an example of an optimization in InnoDB of removing the PK from the index.<br /><br />Uniqueness is also managed by the code, for example wp_users.user_login (which should be a unique key) is not.<br /><br />Finally, I like consistency and standards. While this does not affect performance, consistency in naming standards for columns, especially primary keys is a long overdue need for updating.Ronald Bradfordhttp://ronaldbradford.comnoreply@blogger.comtag:blogger.com,1999:blog-8575059197193667898.post-8544494650484479492011-11-21T13:16:50.713-08:002011-11-21T13:16:50.713-08:00This blog entry has consumed more resources than I...This blog entry has consumed more resources than INT/BIGINT difference on all the wordpress instances...Domas Mituzashttps://www.blogger.com/profile/00843761075650946974noreply@blogger.comtag:blogger.com,1999:blog-8575059197193667898.post-43174390848642156222011-11-19T17:23:24.647-08:002011-11-19T17:23:24.647-08:00GeekTony, working for a hosting company, I can ass...GeekTony, working for a hosting company, I can assure you that we love nothing but to upgrade customer's MySQL servers. From a support/maintenance point of view, there's nothing as frustrating as old MySQL instances with its limited performance, backup strategies and default values etc.<br /><br />I would agree with your point, but looking at it from another point of view, maybe it's a good thing? It reins developers in a bit. The flip side of the coin you describe is a huge jungle of various versions of various software all trying to somehow work together, work around each others bugs, speak the same protocols and so on. <br /><br />Slow and natural growth is maybe the best middle ground, the lesser of all evils?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8575059197193667898.post-8884781814659965502011-11-19T02:00:23.527-08:002011-11-19T02:00:23.527-08:00Your posting struck a chord with me. This is one o...Your posting struck a chord with me. This is one of the things on my to-do list that never seems to quite make it to the top. It's a very chicken and egg thing, but I frequently find myself wanting to refactor some of the "old baggage" from a DBA perspective, with the php apps that have their roots in MySQL 3.23 or 4.x.<br /><br />The problem I always hit is the app devs always resist, because they feel a need to code to the lowest common denominator (due to people using shared hosting etc), which is frustrating because resisting progress, is the antithesis to our industry. <br /><br />Hosting companies will never upgrade their MySQL offerings if the customers don't demand it; and the customers will never demand it, as long as apps are coded to MySQL 3.23 standards and never evolve to their full potential by using the DB to full effect. Why cascade on delete in the PHP code and risk orphan records, when you can do it in DB more quickly, easily and safely in the DB?<br /><br />I've noticed a few projects starting to push the bounds, Drupal, Magento etc, but sadly they are the minority. Oh well, it's on the list.@GeekTonyhttp://twitter.com/#!/GeekTonynoreply@blogger.comtag:blogger.com,1999:blog-8575059197193667898.post-59119739906514860782011-11-18T17:11:48.608-08:002011-11-18T17:11:48.608-08:00There doesn't seem to be any appropriate way o...There doesn't seem to be any appropriate way of getting in contact with MySQL devs, I'm hoping you're a reasonable contact. It's been 6 years and a 'trivial' bug to do with miliseconds is still not fixed in MySQL. Other forks like MariaDB, Drizzle etc have fixes for it in place already: http://bugs.mysql.com/bug.php?id=8523<br /><br />People are even offering to put money in to support it being fixed. It's almost like MySQL devs are just sweeping that one under the carpet and pretending they didn't notice.Garphttps://www.blogger.com/profile/14295116150678730079noreply@blogger.comtag:blogger.com,1999:blog-8575059197193667898.post-59319896343546069682011-09-28T08:53:31.500-07:002011-09-28T08:53:31.500-07:005.0 only for now -- Sorry!5.0 only for now -- Sorry!Dave Stokeshttps://www.blogger.com/profile/16737653465494764723noreply@blogger.comtag:blogger.com,1999:blog-8575059197193667898.post-90851650024777704392011-09-28T08:39:27.542-07:002011-09-28T08:39:27.542-07:00Hi Dave
I am planning to give the MySQL DBA cert...Hi Dave <br /><br />I am planning to give the MySQL DBA certification exam in November 2011 . <br />Is the new 5.1 exam available now ? On the oracle site, I can see only 5.0 is available . I am not sure if i should wait for the new version to come if its not already there .And if yes , then how long ?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8575059197193667898.post-29461287377842431312011-07-28T12:31:10.897-07:002011-07-28T12:31:10.897-07:00Peter -- congrats -- pretty much the same format! ...Peter -- congrats -- pretty much the same format! Good luck!!Dave Stokeshttps://www.blogger.com/profile/16737653465494764723noreply@blogger.comtag:blogger.com,1999:blog-8575059197193667898.post-60103357869100636442011-07-28T11:35:10.198-07:002011-07-28T11:35:10.198-07:00Hi Dave I just passed the CMA and it was multiple ...Hi Dave I just passed the CMA and it was multiple choice. I wan't to do the OCMDBA next month and was wondering if the format will be the same?<br /><br />Cheers from the UKpeterandrewshttps://www.blogger.com/profile/17336029949402371137noreply@blogger.comtag:blogger.com,1999:blog-8575059197193667898.post-15543087015246691792011-04-26T13:38:27.192-07:002011-04-26T13:38:27.192-07:00Sadly I'll be in Italy as that is 3 days befor...Sadly I'll be in Italy as that is 3 days before OpenDB camp -- www.opendbcamp.orgAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8575059197193667898.post-22161847298394876522011-04-18T12:01:16.383-07:002011-04-18T12:01:16.383-07:00Tomas and Dups' keynote: http://www.youtube.co...Tomas and Dups' keynote: http://www.youtube.com/watch?v=L1V5T5rknq0Matthew Montgomeryhttps://www.blogger.com/profile/04421029174237420523noreply@blogger.comtag:blogger.com,1999:blog-8575059197193667898.post-49475910744510919842011-04-01T05:51:09.953-07:002011-04-01T05:51:09.953-07:00Where are these questions?Where are these questions?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8575059197193667898.post-30747974088524368752011-03-03T16:19:54.200-08:002011-03-03T16:19:54.200-08:00This is a great illustration of the prompt command...This is a great illustration of the prompt command. (in fact Sarah and I put neat tips like this every week in our podcast, and "prompt" was covered in episode 33 - http://bit.ly/oursql033 - and I wrote about not being able to change the 2nd line of the command prompt at http://www.pythian.com/news/1798/the-little-things/ )<br /><br />---<br /><br />But as a fix to that specific issue....If you're like me, you've already started the statement and waited 10 minutes...<br /><br />So in the same command window that you have open, type:<br /><br />SELECT NOW();<br /><br />(and make sure to hit enter)<br /><br />And after the query finishes, the current time will be displayed. I do this ALL the time.Sheeri K. Cabralhttps://www.blogger.com/profile/13990877688502800403noreply@blogger.comtag:blogger.com,1999:blog-8575059197193667898.post-30533044267947012011-03-03T11:23:31.852-08:002011-03-03T11:23:31.852-08:00Personally I use `prompt mysql \D > ` which hel...Personally I use `prompt mysql \D > ` which helps me know when certain queries were executed and at what time (if you store the new line after the query finished. The reason? I like to be able to know compare queries when testing and knowing what changes were done when you can easily go back in time to remember what you had done.Darren Cassarhttps://www.blogger.com/profile/07815278684274897873noreply@blogger.comtag:blogger.com,1999:blog-8575059197193667898.post-45412111788147297702011-03-03T07:19:44.853-08:002011-03-03T07:19:44.853-08:00Depending on the statement, the first time may scr...Depending on the statement, the first time may scroll off. But i have used that in the past.Dave Stokeshttps://www.blogger.com/profile/16737653465494764723noreply@blogger.comtag:blogger.com,1999:blog-8575059197193667898.post-1328841470786951002011-03-03T07:10:19.739-08:002011-03-03T07:10:19.739-08:00Hi, you don't need to edit your config file, t...Hi, you don't need to edit your config file, that should do the trick:<br />root@mysql-5.1.51> select NOW();YOUR_STATEMENT;select NOW();Benjamin CHERYhttps://www.blogger.com/profile/11135290785259000944noreply@blogger.comtag:blogger.com,1999:blog-8575059197193667898.post-13486484051069719012011-03-03T07:08:55.374-08:002011-03-03T07:08:55.374-08:00Hi, you don't need to edit your config file, t...Hi, you don't need to edit your config file, that should do the trick:<br />root@mysql-5.1.51> select NOW();YOUR_STATEMENT;select NOW();Benjamin CHERYhttps://www.blogger.com/profile/11135290785259000944noreply@blogger.comtag:blogger.com,1999:blog-8575059197193667898.post-76246419660400630372011-03-03T06:04:37.981-08:002011-03-03T06:04:37.981-08:00Aha! I should have said wall clock time and not e...Aha! I should have said wall clock time and not execution time. And yes you can add the two together but in this case we wanted to know if the job finished before noon or not.Dave Stokeshttps://www.blogger.com/profile/16737653465494764723noreply@blogger.com