Re: Mysql and disk space left
On 4/19/07, Manuel Vacelet <[EMAIL PROTECTED]> wrote: Hi all, I wonder what is the impact of the disk space left for a mysql DB (MyIsam, Linux 2.6, Ext3, RAID5). I mean, I there a kind of limit to not cross to limit the performances impact ? Hi everybody, Nobody can answer my question ? Or does it mean that I can go up to 99% of disk used on my data partition w/o seeing any impact on my database ? Cheers, Manuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How could write this sum string like SQL?
Hi, I want select item detials(date and qty) sum(qty) 'a01', '2007.01.01: 10/2007.02.03: 10',20 'a02', ' 2007.01.10: 20/2007.02.12: 30',50 'a03', ' 2007.01.18: 20', 20 from table2 date,item,qty 2007.01.01, 'a01', 10 2007.01.10, 'a02', 20 2007.01.18, 'a03, 20 2007.02.03, 'a01', 10 2007.02.12, 'a02', 30 group by item Thanks ! Shuming Wang
Event Log Error
I'm running MySQL version 5.0.22-community-nt on a Windows 2003 server. I a noticing A LOT of errors in there like the following: C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\nfcamp\societies.frm' This spans multiple databases and tables. I am using replication, but I thought that I was replication only one of the databases. It could be that it's attempting to replicate these other databases that I don't want replicated. It's been a while since I set up the replication, so I don't remember where I need to look for this. Does anyone have any pointers? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Query question
Guys, I have the following table that contains some information about a cars. I'm trying to write a query to determine: the number of make(name of car), number of models per make(name of car) and the average number of models/make(name of car) sold in a particular period. The two queries below can provide me with what I need, but am stumped on how to combine the results. Any help would be greatly appreciated. table name cars: columns: make model sold_date select make,count(make) from cars where make in(Nissan, Toyota, Honda) group by make select model,count(model) from cars where make in(Nissan, Toyota, Honda) group by model -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Trouble connecting to server
I have a mysql v 5.0 server running on Suse Linux 10.1. It has been running steadily and properly for several months now. However, when I came in this morning, my network card in the machine was bad. I replaced the card and reconfigured the network, but ever since then, I can only connect to mysql by using localhost. If I try to connect using the IP address, it simply hangs. If I do a netstat -aln | grep '3306', it shows mysql listening on all IP addresses, and it shows the connection to itself with the flag SYN_SENT. But that's as far as it goes. I've restarted the machine several times in vain hopes that it might kickstart something. I've also tried connecting from other machines, which seems to work perfectly. Any suggestions on how to proceed troubleshooting this? Thanks, Drew Burchett United Systems & Software Ph:(270)527-3293 Fax: (270)527-3132 -- CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. -- This message has been scanned for viruses and dangerous content by MailScanner and is believed to be clean.
Re: What is the equivalent of the minus function?
I would think that: SELECT email FROM participants WHERE email NOT IN (SELECT email FROM excluded) would do the trick andy > I am trying to do something like this > > select email from participants > minus > select email from excluded > > It seems there is no minus function in MySQL. I tried goofing around with > intersects and union, but can't seem to make it work. > > > > Is there a better way to achieve the same thing? > > > > Thanks in advance for your help! > > > > -Brian Menke > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Trouble connecting to server
At 11:36 AM 4/23/2007, Drew Burchett wrote: I have a mysql v 5.0 server running on Suse Linux 10.1. It has been running steadily and properly for several months now. However, when I came in this morning, my network card in the machine was bad. I replaced the card and reconfigured the network, but ever since then, I can only connect to mysql by using localhost. If I try to connect using the IP address, it simply hangs. If I do a netstat -aln | grep '3306', it shows mysql listening on all IP addresses, and it shows the connection to itself with the flag SYN_SENT. But that's as far as it goes. I've restarted the machine several times in vain hopes that it might kickstart something. I've also tried connecting from other machines, which seems to work perfectly. Any suggestions on how to proceed troubleshooting this? Reconfigured the network. . .Is it possible that the old IP address is no longer the one assigned to the machine? DHCP? Just a thought. Barry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Trouble connecting to server
Thanks for the idea, but I did get the right IP address on it. No DHCP. Drew Burchett United Systems & Software Ph:(270)527-3293 Fax: (270)527-3132 -Original Message- From: Barry Newton [mailto:[EMAIL PROTECTED] Sent: Monday, April 23, 2007 11:17 AM To: Drew Burchett Cc: mysql@lists.mysql.com Subject: Re: Trouble connecting to server At 11:36 AM 4/23/2007, Drew Burchett wrote: >I have a mysql v 5.0 server running on Suse Linux 10.1. It has been >running steadily and properly for several months now. However, when I >came in this morning, my network card in the machine was bad. I >replaced the card and reconfigured the network, but ever since then, I >can only connect to mysql by using localhost. If I try to connect using >the IP address, it simply hangs. If I do a netstat -aln | grep '3306', >it shows mysql listening on all IP addresses, and it shows the >connection to itself with the flag SYN_SENT. But that's as far as it >goes. I've restarted the machine several times in vain hopes that it >might kickstart something. I've also tried connecting from other >machines, which seems to work perfectly. Any suggestions on how to >proceed troubleshooting this? Reconfigured the network. . .Is it possible that the old IP address is no longer the one assigned to the machine? DHCP? Just a thought. Barry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. -- This message has been scanned for viruses and dangerous content by MailScanner and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
what kind of indices to set up
I have a table which will be searched via some of the fields in the column. An example of the list of searcheable columns: make model body_color tire_type hub_caps_type The thing is that people might do a search using one or many of the fields as criteria. For example someone might search for : body_color = 1 AND tire_type = 11 or just model = 22 I read that MySQL only uses one index when it performs a query. I did an EXPLAIN and it appears that only one of the indices is used. What is the proper way to setup indices in this case? Shoud I add an Index for each of these fields OR create a multicolumn index using all of these fields? -James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: what kind of indices to set up
James, A lot depends on how many rows you are searching on. If you only have a couple thousand rows, then a table scan will still be fast. If you are searching more rows, say more than 10,000, then using the proper index will speed things up. Using a compound index is only useful if the user is searching on at least the first field of the index. For now, your best bet is to build an index on each of the commonly searched columns and MySQL will choose the best index for the search. Mike At 11:16 AM 4/23/2007, James Tu wrote: I have a table which will be searched via some of the fields in the column. An example of the list of searcheable columns: make model body_color tire_type hub_caps_type The thing is that people might do a search using one or many of the fields as criteria. For example someone might search for : body_color = 1 AND tire_type = 11 or just model = 22 I read that MySQL only uses one index when it performs a query. I did an EXPLAIN and it appears that only one of the indices is used. What is the proper way to setup indices in this case? Shoud I add an Index for each of these fields OR create a multicolumn index using all of these fields? -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]
Re: advice for blob tables?
I don't feel the implementation direction this article takes is good. It uses single row binary storage, which anyone who has had to deal with large files knows is a definate issue. On Sat, 21 Apr 2007, Kevin Waterson wrote: > This one time, at band camp, "Michael Higgins" <[EMAIL PROTECTED]> wrote: > > > > So before I just jump in and go like I usually do, does anyone have any > > quick advice, things to consider, links, must-RTFMs or the like to help a > > newbie out? > > > This tutorial deals with images and BLOBs. It should get you on the > right path. > > http://www.phpro.org/tutorials/Storing-Images-in-MySQL-with-PHP.html > > Kevin > > -- > "Democracy is two wolves and a lamb voting on what to have for lunch. > Liberty is a well-armed lamb contesting the vote." > > -- > 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]
RE: advice for blob tables?
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > > I don't feel the implementation direction this article takes > is good. It uses single row binary storage, which anyone who > has had to deal with large files knows is a definate issue. > > Just wanted to thank you all for your input thus far. I'm proceeding with caution, but with heightened confidence that I'll be moving forward with a bit of a clue. Cheers, -- Michael Higgins -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
View with Subselect for User ID
Hello MySQL experts, I am trying to create a view whose access is based on a User ID that need to be looked up in a different table. Here is an example of what I'm trying to do: CREATE OR REPLACE ALGORITHM=UNDEFINED [EMAIL PROTECTED] SQL SECURITY DEFINER VIEW `shared_v` AS select `Shared`.`ID` AS `ID`,`Shared`.`RawID` AS `RawID` FROM `Shared` WHERE (`Shared`.`UserID` = (SELECT UserID FROM Users WHERE Login = convert(substring_index(user(),_utf8'@',1) using latin1)); However, MySQL doesn't gulp the subquery for the ID. I don't want to have a VARCHAR column with the user name in this table, because it can easily grow very large. Would JOINS be the way to go? If so, could anyone please give me an example of how to accomplish this with joins? I would appreciate any tip. Thank you in advance, -Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How could write this sum string like SQL?
Mysql 4.1 also support this group_concat(). Thank you ! Shuming Wang
Symbol resolution failed for /usr/local/lib/libz.so.
Hi, Warm Greetings! I am using C & mysql for my program In AIX and while compiling I am getting the following error. exec(): 0509-036 Cannot load program /az/smsbbs/bin/wittservw because of the following errors: 0509-130 Symbol resolution failed for /usr/local/lib/libz.so because: 0509-136 Symbol _GLOBAL__F__Unwind_GetLanguageSpecificData (number 23) is not exported from dependent module libgcc_s.a(shr.o). 0509-192 Examine .loader section symbols with the 'dump -Tv' command. Please guide me to resolve this issue. Thanks In Advance Suresh. - Check out what you're missing if you're not on Yahoo! Messenger