Re: Book recomendations

Joe Celko's SQL for Smarties: Advanced SQL Programming . A great book .You know sql-> you know MySql :) . - Original Message - From: "Jerry M. Howell II" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, January 09, 2003 6:57 AM Subject: Re: Book recomendations > On Wed, Jan 08

Re: question about query log

A little complicated solution is to create the log in a file then setup a php/perl program that reads that file continously and insert/process that data . - Original Message - From: "Natale Babbo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 08, 2003 12:25 PM Subjec

thread_cache . what is it ? (no newbie question) .

Hi . Simple but still tricky question : what mean 'thread' in mysql's server point of view ? I've set the thread_cache_size=30 in my.cnf . I use Mysql with Php and my aplication's behaviour is like this : connect -> select update insert select etc..

Re: question!!

[root@www tmp]# perror 28 Error code 28: No space left on device You don't have any more space avaiable on your hdd . - Original Message - From: "Touria Zaddaoui" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, December 16, 2002 1:49 PM Subject: question!! > > hi everybody! >

Re: sleeping threads problem

tent open links are automatically closed at the end of the script's execution' - Original Message - From: "Dan Nelson" <[EMAIL PROTECTED]> To: "cristian ditoiu" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, December 03, 2002 7:27 P

sleeping threads problem

Hello , i use MySql 3.23.49-log with Php 4.2.1on RH 7.2 . The problem is that i got many many (16-30) sleeping threads almost all the time . The code is pretty clean , and i suspect that those threads are sleaping beacuse of some strange ascii characters (like CR) . Is any intelegent way to find o

Re: show processlist ? - sleep .

f the script ends, unless it's closed earlier by explicitly calling mysql_close(). ) - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "cristian ditoiu" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, October 22, 2002 12:

Re: using php to connect to a 2nd mySQL server

mysql_connect("localhost:3306", "mysql_user", "mysql_password"); - Original Message - From: "Webmaster" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 09, 2002 5:57 PM Subject: using php to connect to a 2nd mySQL server > Hello all, > > I am new to this list ... an

what is thread cache ?

Hello Mysql . I saw the using show status smth like Threads_cached . I searched the mysql site with no luck , finding just a simple explanation like : Number of threads in the thread cache. That wasn't very .. explainng , so searching further i found how to enable the thread cache , using set-vari

Re: mysql primary key question!

IMHO you can INCREMENT only numbers . :) . Why only three numbers ? Anyway i'd see a solution like this : table : idfield [1..n] Select (@max_number:=max(id)) from table; Insert into table(id,field1,fieldn) values (@max+0.1,'xxx','xxx'); that's kindof solution . - Original Message

Re: Moving a DB from one Server to another

yap . you can coopy the database file although i'd say do dump of the database (with mysqldump) . eventuly to make things faster drop the indexes and recreate them on the target machine - Original Message - From: "Todd Cary" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 08

advice on porting using same databse on windows and linux

Hello . situation : mysql server on RH 7.2 (don't know what version - realy doesn't matter) mysql server on windows 98 (don't know what version - realy doesn't matter) three partitions : p1 -> fat32 p2 ->fat32 p3->linux . I want to share the database(s) between mysql on windows and mysql on lin

mysql full text bug/problem ?

Hi . One table with three filed full-text indexed : titlu,continut,descriere qry : SELECT autori.nume as autor, ref_data.id as id_ref, ref_data.marime as marime, ref_data.clasa as clasa_ref, ref_data.titlu, ref_data.nota as nota ,materii.*,MATCH (titlu,continut,descriere) AGAINST ('conceptia') as

Re: php+mysql+multiple lines qry

can't insert into questions( ) select from questions . the error is : not unique table or alias . tried with insert into ... select a.field1 , a.filed2 from questions as a . not working ;) - Original Message - From: "Brent Baisley" <[EMAIL PROTECTED]> To: &quo

php+mysql+multiple lines qry

hello . i use php 4.12 + mysql 3.23.49 on linux . i've developed a online testing(quiz) -aplication that now is expected to behave somehow different from what i've had in mind at the begining . More exactly : i have 3 tables (MyIsam): 1. tests (id,name,desc) 2. questions (id,id_test_fk,

problem

hi , i have a little mysql problem . : got 2 servers .. 1 got a dump from server1 via myadmin , but when trying to insert the data into server 2 i got a strange errror and i got disconected from server2 . any ideeas ? -- Your MySQL connection id is 752533 to server version: 3.23.

group by timestamp field

I have MySql database containing a table mad by several fields among wich : Field1 (varchar) , Field 2 (timestamp) . I want to do : select count(*) , field1 , group by field1 . That's ok , but i'd like to get results like : 2002-01-01 3 2002-01-02 4 . How can i do that considering the timest