tag:blogger.com,1999:blog-31421954.post6515162982048621755..comments2023-10-30T08:23:12.960-07:00Comments on mySQL DBA, Architecture, Dev, Scale, HA, Code : x86_64 + INNODB + 4.1 + throwing a server in to live trafficDathan Pattishallhttp://www.blogger.com/profile/00356367514107959723noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-31421954.post-50815605823300881042007-04-24T21:09:00.000-07:002007-04-24T21:09:00.000-07:00Does it really work?mysql> SELECT * FROM thread WH...Does it really work?<BR/><BR/>mysql> SELECT * FROM thread WHERE threadid > 10 million - MAX(threadid);<BR/>ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'million - MAX(threadid)' at line 1<BR/><BR/>mysql> SELECT * FROM thread WHERE threadid > 10000000 - MAX(threadid);<BR/>ERROR 1111 (HY000): Invalid use of group function<BR/>mysql>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-31421954.post-12636227107950790422007-01-30T16:03:00.000-08:002007-01-30T16:03:00.000-08:00Yes that works great. I use that all the time as w...Yes that works great. I use that all the time as well, this is for throwing the server in for 100% capacity at start, ie when the app cannot handle failed connections.Dathan Pattishallhttps://www.blogger.com/profile/00356367514107959723noreply@blogger.comtag:blogger.com,1999:blog-31421954.post-19034798506299598122007-01-25T04:20:00.000-08:002007-01-25T04:20:00.000-08:00How about merging it into production by initially ...How about merging it into production by initially setting the max_connections very low and gradually increasing the value?Unknownhttps://www.blogger.com/profile/17981125283208209979noreply@blogger.com