Re: subquery error with no result
Would this work for you? SELECT msgdata FROM sent_sms WHERE momt = 'MT' AND binfo IN (SELECT binfo FROM sent_sms WHERE momt = 'DLR') David On 5/21/08 10:30 PM, sangprabv [EMAIL PROTECTED] wrote: Hi, I tried to look for records from a table with this query: SELECT msgdata FROM sent_sms WHERE momt = 'MT'AND binfo = ( SELECT binfo FROM sent_sms WHERE momt = 'DLR' ) But MySQL returns this error: #1242 - Subquery returns more than 1 row I tried also with ANY, IN, EXISTS. And modified the query into: SELECT t1.msgdata FROM (SELECT binfo FROM sent_sms WHERE momt = 'DLR') AS t1 WHERE momt = 'MT'. But none works. What I want to view is, all records which has momt = 'MT' and binfo from the same table where has momt = 'DLR' and has the same binfo. TIA Regards, Willy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
DB - Data update for Dev server
Hello all, I think I saw this on an earlier post but I can't find it now. What I need to do: 1 - update data nightly into Dev Server 2 - only copy Data do not overwrite structure 3 - only update specific tables Any advice is greatly appreciated. David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Windows Server Configuration
Thanx again. For the time being, we will keep 4 drives with Dan's suggestion. OS and MySQL running from there. On 8/25/06 11:03 AM, Dan Buettner [EMAIL PROTECTED] wrote: James, with just 4 drives, you can set up one big RAID 10 disk (usually called a logical disk, with Dell PERCs I think it's a container), and then partition it for your different needs. If you have 4 73 GB disks, you probably have around 135 GB formatted capacity with RAID 10; I'd do something like this for my own MySQL server in that situation: 20 GB C partition for OS and software binaries 10 GB D partition for MySQL temp space 20-40 GB E partition for MySQL binary logs (if you're using them) remainder F partiition for MySQL data directory Your needs will vary depending on whether this server does only MySQL or other serving as well, how big your databases are, whether you want to keep binary logs for some period of time, and how large those binary logs are. I agree with David's response that you want redundancy for the OS as well. Drives fail, plain and simple. The single best thing you can do with servers is plan for hardware failure. Having your data on redundant disks is great, but if your OS is on a single drive, when (not if, when) that one fails, your data is redundant but still unavailable. You may pay a small performance penalty having the OS on the same physical drives with your MySQL, but I'd make that sacrifice for the redundancy, no question. On the other hand if you want to add a couple of drives and make a separate RAID 1 pair for the OS, go for it. Best, Dan On 8/25/06, JamesDR [EMAIL PROTECTED] wrote: -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Installing MySQL on Windows Server 2003 Standard x64 Edition
I'm having problems with MySQLInstanceConfig.exe - Unable To Locate Component This application has failed to start because LIBMYSQL.dll was not found. Re-installing the application may fix this problem I have tried to re-install, but I get the same message. I read the following related threads but didn't help. http://lists.mysql.com/win32/14799 http://lists.mysql.com/mysql/167676 I looked for the file and it exists in: /mysql/bin/ /mysql/lib/debug/ /mysql/lib/opt/ This is the download I'm using for the installation: Windows Server 2003 (AMD64 / Intel EM64T)5.0.24 Please advise. David. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installing MySQL on Windows Server 2003 Standard x64 Edition
I didn't add it anywhere because the file exists in mysql/bin folder c:/program files/mysql/bin Does it need to be somewhere else?? On 8/25/06 5:03 PM, João Cândido de Souza Neto [EMAIL PROTECTED] wrote: It could seems stupid, but you tried to put this file on c:\windows\system32 or the similar folder of your system? David Lazo [EMAIL PROTECTED] escreveu na mensagem news:[EMAIL PROTECTED] I'm having problems with MySQLInstanceConfig.exe - Unable To Locate Component This application has failed to start because LIBMYSQL.dll was not found. Re-installing the application may fix this problem I have tried to re-install, but I get the same message. I read the following related threads but didn't help. http://lists.mysql.com/win32/14799 http://lists.mysql.com/mysql/167676 I looked for the file and it exists in: /mysql/bin/ /mysql/lib/debug/ /mysql/lib/opt/ This is the download I'm using for the installation: Windows Server 2003 (AMD64 / Intel EM64T)5.0.24 Please advise. David. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Installing MySQL on Windows Server 2003 Standard x64 Edition
I still get the same error. Not sure what I'm doing wrong. On 8/25/06 5:49 PM, Greg Joss [EMAIL PROTECTED] wrote: Go to Control PanelSystemAdvanced. Click Environmental Variables and Find the PATH variable under System Variables and add the full path, i.e. c:\Program Files\...\mysql\bin to the variable. -Original Message- From: David Lazo [mailto:[EMAIL PROTECTED] Sent: Friday, August 25, 2006 2:54 PM To: mysql@lists.mysql.com Subject: Installing MySQL on Windows Server 2003 Standard x64 Edition I'm having problems with MySQLInstanceConfig.exe - Unable To Locate Component This application has failed to start because LIBMYSQL.dll was not found. Re-installing the application may fix this problem I have tried to re-install, but I get the same message. I read the following related threads but didn't help. http://lists.mysql.com/win32/14799 http://lists.mysql.com/mysql/167676 I looked for the file and it exists in: /mysql/bin/ /mysql/lib/debug/ /mysql/lib/opt/ This is the download I'm using for the installation: Windows Server 2003 (AMD64 / Intel EM64T)5.0.24 Please advise. David. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Windows Server Configuration
We want to get: Windows Server 2003 R2, Standard x64 Edition 2- Dual Core Intel Xeon 5080, 2x2MB Cache, 3.73GHz, 1066MHz FSB 8GB 533MHz (8x1GB), Dual Ranked DIMMs 3- 146GB, SAS, 3.5-inch, 15K RPM Hard Drives What would be the recommended RAID configuration settings for a dedicated MySQL db running on this system? Also, what is the general advice for separating MySQL and the MySQL/Data on different disks? I'm sorry if this sort of question has already been answered. Any help would be appreciated. David. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Windows Server Configuration
Thanks for all the recommendations. On 8/22/06 1:11 PM, Dan Buettner [EMAIL PROTECTED] wrote: I second what James recommends re: spindles and RAID 10. Better than RAID 5 for live data in my opinion; RAID 5 is decent for archival storage. You've got a pretty decent setup there otherwise - 4 CPU cores, 8 GB RAM - and you want to make sure your disks can keep things fed. As far as splitting things up: a general recommendation is to put logging (replication logging that is, not the error log necessarily) onto its own partition, ideally its own disks. Also consider putting MySQL's temp space on its own partition, ideally its own disks. Of course suddenly you're looking at a lot of disks if you really go whole-hog... The optimization section in the online manual is pretty decent, though some of the numbers are a bit dated (I saw one note this morning that said if you have at least 256 MB RAM...) Also Jeremy Zawodny's book High Performance MySQL is a good read, both in terms of optimizing your SQL/data strcuture and in choosing abnd setting up your hardware. (Third time today I've plugged that book - I don't own stock or anything, really) Dan On 8/22/06, JamesDR [EMAIL PROTECTED] wrote: David Lazo wrote: We want to get: Windows Server 2003 R2, Standard x64 Edition 2- Dual Core Intel Xeon 5080, 2x2MB Cache, 3.73GHz, 1066MHz FSB 8GB 533MHz (8x1GB), Dual Ranked DIMMs 3- 146GB, SAS, 3.5-inch, 15K RPM Hard Drives What would be the recommended RAID configuration settings for a dedicated MySQL db running on this system? Also, what is the general advice for separating MySQL and the MySQL/Data on different disks? I'm sorry if this sort of question has already been answered. Any help would be appreciated. David. We built one pretty close to this recently. You definitely want to go with raid10, make sure the controller is hardware and not software raid (uses the CPU for everything, opposed to having a dedicated on board CPU) The more spindles the better, in order to use RAID10 you need an even set of disks, min 4. Raid10 gives you the best performance while keeping data redundancy. I would set it up like this: Raid1 -- OS (you could use slower/smaller drives here) Raid10 -- all of the mysql data -- as many spindles as you can afford. If you have to swap out 73GB drives for for the 146's to get more spindles, I would do that (that would increase cost a bit, but the disk sub system here would be the bottle neck, so you want to have it as fast as you can get it -- and still be affordable) This all depends on what your data environment looks like as well. -- Thanks, James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]