t least. Check the real value of
> open_file_limits with such statement:
> show variables like '%open_f%';
>
> You can find some recommendations for SuSe Linux at:
> http://dev.mysql.com/doc/mysql/en/Linux-post-install.html
>
> Mysql user <[EMAIL PROTEC
Hi..
I've got an ISP, and all of our customers have databases in our mysql
system.
My backup command is:
mysqldump --force --opt -A -p' | gzip -c >
/var/sqlbackup/mysqldump-`date +\%A`.sql.gz
This has worked fine for some time.
Now, however, I get an error message:
mysqldump: Got
Hi
I have a hockey pool database and I want to be able to add each weeks
totals (goals, assists, etc.) for the players on each team.
Example:
Team 1 may have Hossa, Redden, and Forsberg. If each of them scored 2 goals
and 2 assists for week one, I want to be able to get the total of 12. Team
tw
I recently saw and article that says MySQL will be shipping its cluster software
starting April 14th during the Users Conference & Expo this year. Does anyone have
any information about this? My company is considering using the Emic clustering
software. Has anyone had experience with that? W
Questions - Number of queries sent to the server.
See http://www.mysql.com/doc/en/SHOW_STATUS.html for more info
MySQL user
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Re: MySQL+Apache Optimization
Date: Wed, 7 Jan 2004 15:12:19 +0530
Hello ,
What are Questions in My
Someone told me that it is possible that MySQL will automatically change
column types in certain situations. For example the a table with a char(5)
type field might dynamically change to a varchar(5) type field. So a static
length column to a variable length column. Is this possible? If so what a
Is there any difference in speed between the following select statements?
SELECT yada,yda FROM test WHERE id IN(1,2,3)
OR
SELECT yada,yda FROM test WHERE (id =1 or id = 2 or id =3)
Could anyone tell me the difference between the following two explains? It
seems the first takes longer to execute.
This first query is like so...
select m.*, mi.age from members m, members_addtl_info mi where m.nick
like '%anynickname%' AND m.nick = mi.nick order by nick desc,
account_login_las
Hello everyone. I have copied the results from and explain on a query that I want to
use. And I am wondering if anyone could tell me if these results are bad or good?
If everything below is coming up garbled for you I will basically I am using 7 tables
and the rows for 6 of the seven are 1 and t
Hi,
Is there a way I can run a query that will delete all items that are not in
a list? For example I have a bunch of records in a table and I want to
remove all of them that are not in a comma delimited list that I have
recieved from another application. I was thinking that I could create a
que
10 matches
Mail list logo
