Need MySQL help with tables and records
Hi, I need a little help as I am a beginner with db things. I'm building a database for technicians and help-desk problems where technical problem tickets are stored in one table, and technicians in another. Really I have two main questions. First, each problem may have more than one technician assigned. In the problems table were I have a technician column, should I build an array that holds all the primary keys for each technician assigned or should I build a third table that links multiple technicians to a single problem? And my second question is this, I select the technicians based on alphabetical order out of a list. Each time there is an occurrance of a problem,I go to the next tech in alpha order. How can I do this with MySQL? Or would I have to organize in alpha order using PHP and select my next record? I'd like to go with whatever doesn't absorb system resources too badly and it just seems like having 3 to 5 users accessing this system and having PHP alpha order the database over and over would do that for each occurrance. And how could I flag a record so that I would know where to get the next record once I have it in alpha order? Thanks, David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Basilix and MySQLhelp
I need a little help getting Basilix to run. The one part I can't get is the db connection. Somehow username and password are placed in the basilix.sql file with the command mysql -u username -p password /usr/local/basilix/db/mysql/basilix.sql This command (I assume) works fine IF both servers are running on the same machine. I, however, run MySQL on a seperate machine. Could someone please help me and tell me how I could modify this command to fit my situation? Thanks, David. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with MySQL and SMP?
[EMAIL PROTECTED] wrote: I am having a problem with MySQL that I believe is related to SMP. I have a machine that is an exact copy of another machine, only difference is that this one is Dual processor, and the other one is single. The single one has had no problems for the last 6 months the dual dies every 2 days This is the 2nd SMP server that I have had (i thought it was the mobo or something) both produce the same results. I get no output to logs, machine just goes black (and hangs). Any input? This is on RedHat 7.2 linux with the 2.4.17 kernel and MySQL 3.23.47 Gavin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Perhaps your problem lies in the IDE controller. For some reason, my friend and I have been through several dual (MSI Tyan) motherboards over the past few months that have almost always had IDE controller problems where they wouldn't work at all, or would lock up after using them for 20 to 30 minutes. If you're using IDE on the dual, try SCSI. Or perhaps the chipset? Did you use the same motherboard in both SMP servers? If so, perhaps there was a chipset problem in that brand, and you may have to check with the manufacturer. I'm just taking shots in the dark here, but there's no reason why the SQL server should keep crashing ONLY because the difference is single processor kernel, or smp kernel. I would assume that any good SQL server is designed with SMP kernel in mind for database apps that would require a lot of processing power. Try eliminating the possibilities of hardware problems first. David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL and RAID question
Just one quick question... I've heard that running a database in a system using RAID isn't a good idea on RAID 5, but works fine with mirroring (0, 0/1, 0/5). Does anyone out there have experience with MySQL on RAID 5, or know how MySQL performs in a RAID 5 environment? My concern is loss of data due to a drive going bad. At least that what I've heard could happen. Thanks, David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php