php - mysql tandem and multi core performance

answer, Giulio Giulio Mastrosanti giu...@cantoberon.it -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

RE: Building MySql 5.0.45 on Solaris 6

it and it seems to work. We're having some issues on upgrading to Solaris 8, that's why we still have Solaris 6. I hope the pre-build package for Solaris 8 will work without any intervention. But if it won't and I'll need to build it I'll remember the issue you told me about. Thanks for you help Giulio

Building MySql 5.0.45 on Solaris 6

on 3.22.32) because the new server (5.0.27) uses privileges that my client does not support. Please help. Giulio Linedata Services (UK) Ltd Registered Office: Bishopsgate Court, 4-12 Norton Folgate, London, E1 6DB Registered in England and Wales No 3027851 VAT Reg No 778499447 -- MySQL

Error compiling on Solaris 6

urgent. PLEASE reply to me as well as to the list because I am not subscribed. Many thanks Giulio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Error compiling on Solaris 6

in England and Wales No 3027851 VAT Reg No 778499447 -Original Message- From: mysql [mailto:[EMAIL PROTECTED] Sent: 26 July 2007 13:24 To: Giulio Troccoli Cc: mysql@lists.mysql.com Subject: Re: Error compiling on Solaris 6 Giulio did you take into consideration

A database design question

of the fields from tables B and C with added a fileld rec_type to handle different fields depending on the record type ( this seems to me to be the simplest solution, although not the best in term of normalization rules ) Hope it was all clear, thanx in advance, Giulio -- MySQL General Mailing

Re: A database design question

solutions are to merge the two table type on one table type, or keep them separated, perform two different separate joins and then merge them by code... thank you, Giulio How do you expect to get results from a SELECT which returns hits in both the B and C tables? If you expect to do

Re: Select Question

If your MySQL version is 4.1 or later, you could try GROUP_CONCAT the query should be ( not tested ): select id,GROUP_CONCAT(f2) from tablename group by id regards, Giulio Il giorno 05/ott/04, alle 17:20, Feghhi, Jalil ha scritto: Is there a way to convert the following result set: id

intermediate table question

, but some of them could belong to more categories not specified in the query, and I would like to have also them in the result... Hope this was clear... thank you Giulio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Another order by question

HI, I have a table, let's call it item, which has a field containing a comma separated list of IDs of related items ( same table ). I know, this is far away from a correctly normalized structure and this stuff should be handled using another table for the link, but I'm working on a

query for room reservations question

) to list all the rooms reserved on a given date interval, but I can't figure out the query to list all the rooms of a given type (room_type) that results FREE ( not reserved ) on the given date interval. thanx for your help, Giulio -- MySQL General Mailing List For list archives: http

Re: query for room reservations question

Brilliant ! thank you so much! only one more question: INNER JOIN is not a good choose because it lists only the record with a matching ON clause, and this is the only difference between LEFT and INNER, correct? thanks again, Giulio Il giorno 29/lug/04, alle 16:03, [EMAIL PROTECTED] ha

Re: i cant connect to mysql from other machine

I believe you shoul comment out the bind_address option on config file... Hope this helps, Giulio Il giorno 19/lug/04, alle 11:27, [EMAIL PROTECTED] ha scritto: hello people.. i have a curious problem with mysql. i configure root user acount to enable access from other machines but i

can you help me optimizing this query?

track_character record. It can last up to 120 seconds if I leave the title blank, resulting on all tracks listed. Any Idea on how could I optimize this? Thanx in advance, Giulio Cantoberon Multimedia srl http://www.cantoberon.it Tel. 06 39737052 -- MySQL General Mailing List For list archives: http

Re: can you help me optimizing this query?

of thought! can I be happy with this result, or there's something I have not considered? Giulio Il giorno 12/lug/04, alle 14:50, Giulio ha scritto: Hi all, I have an audio tracks info table, let's call it Tracks; every Track can have one or more ' Character' ( it is not a genre, it is something like

mysql@lists.mysql.com

|-+ | | Giulio | | | [EMAIL PROTECTED]| | | n.it| | || | | 07/12/2004 08:50 | | | AM

Re: This thing called MOD

Hi, I use mod a lot simply for fast checking if a number is a multiple of another number if mod(number1,number2) = 0 then number1 is a multiple of number2 Il giorno 09/mag/04, alle 18:44, Robert Reed ha scritto: Thomas MOD is a way to get the remainder from a division problem. It does not

Re: ADO driver?

on some applications on VB 6, without problems. Thanks for the message... but, I'm not using VB... Can this project be used in place of an ADO driver? I guess not, right? Well, I think yes, It should follow quite well standard ADO methods and functions, You must test it. anyway... regards, Giulio

accessing MySQL from VB6 application ( without ODBC )

. the operations i need to perform are quite basic ( simple queries to a server ), any advice on some dll out here ? thank you, Giulio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

accessing MySQL from VB6 application ( without ODBC )

. the operations i need to perform are quite basic ( simple queries to a server ), any advice on some dll out here ? thank you, Giulio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Spanish Accents

htmlspecialchars, that converts a string containing special characters on the appropriate string for html visualization. I'm quite sure ASP has an equivalent function. Hasta siempre, Giulio Il giorno 09/mar/04, alle 12:57, Brand, Troy Anthony ha scritto: Hello, I am building a web page

Re: Join sintax question

Il giorno 04/gen/04, alle 17:34, Douglas Sims ha scritto: Hi Giulio Hi Doug, I think you could do this by repeatedly left-joining the categories table as in this: SELECT AudioTrack.* FROM AudioTrack A LEFT JOIN AudioTracks_Categories C1 ON A.AudioTrack_id=C1.AudioTrack_id LEFT JOIN

Join sintax question

the question was clear... :) thanks in advance for your answer, Giulio

myODBC error 2019

happens also using Access to connect via ODBC, and the connection to the old database keeps working fine. Any Idea? Thanks for your help, Giulio -- Sharemusic - Distribuzione Musicale Shareware Cantoberon - 00192 Roma - Via A. Doria, 57 tel. +39/0639737052 - fax +39/0639889820 http

Can't create a new thread (errno 12).

After some hour my Database return this error message: Warning: MySQL Connection Failed: Can't create a new thread (errno 12). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug in conn.php3 on line 7 At conn.php3