Mysqldump error 1017: errno: 24 - help?
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 error: 1017: Can't find file: './usr_web22_1/invoices_va.frm' (errno: 24) when using LOCK TABLES On different runs, it reports different files, even right after restarting mysqld. I've looked at the mysql documentation for this error; it's at http://dev.mysql.com/doc/mysql/en/Not_enough_file_handles.html I've looked at the startup script, put in '--open-files-limit=1024', restarted mysql, and the error is the same. I've looked at the table_cache and max_connections system variables, which are 64 and 100, respectively. My question is: what should I do now? Since table_cache and max_connections are far less than 1024, do I reduce them even further? Is there something else I should be looking at? This is mysql-3.23.52-106 on SuSE Linux 8.1, running on a dual PIII 866Mhz system, with 512M of ram and 1G of swap, on a RAID-1 pair of 17G hard drives. Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysqldump error 1017: errno: 24 - help?
Yep, that seems to have done it, at least when I'm testing it. I'm pretty sure the problem is fixed, but the next couple of days of automated backups will tell. Thanks! On Tue, 2005-01-11 at 00:43, Gleb Paharenko wrote: > Hello. > > Try '--open-files-limit=8192' at 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 PROTECTED]> wrote: > > 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 error: 1017: Can't find file: > > './usr_web22_1/invoices_va.frm' (errno: 24) when using LOCK TABLES > > > > On different runs, it reports different files, even right after > > restarting mysqld. > > > > I've looked at the mysql documentation for this error; it's at > > http://dev.mysql.com/doc/mysql/en/Not_enough_file_handles.html > > > > I've looked at the startup script, put in '--open-files-limit=1024', > > restarted mysql, and the error is the same. > > > > I've looked at the table_cache and max_connections system variables, > > which are 64 and 100, respectively. > > > > My question is: what should I do now? > > > > Since table_cache and max_connections are far less than 1024, do I > > reduce them even further? > > Is there something else I should be looking at? > > > > This is mysql-3.23.52-106 on SuSE Linux 8.1, running on a dual PIII > > 866Mhz system, with 512M of ram and 1G of swap, on a RAID-1 pair of 17G > > hard drives. > > > > Thanks! > > > > > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.NET http://www.ensita.net/ >__ ___ ___ __ > / |/ /_ __/ __/ __ \/ /Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ><___/ www.mysql.com > -- Mysql user <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Question on adding values together
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 two has three different players and they may score 3 goal and three assists for a total of 18. Then team 3, 4, 5, etc. I have three tables, one with the teams (I call it manager) and one for the players (called roster). I have a reference table that links the manger and roster tables together to determine what players are on what teams. Any help is appreciated. CR
Re: MySQL+Apache Optimization
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 Mysql , I mean is there something know as Questions in Mysql, I got a Script in PHP called as testload.php and it shows me this output : total processes are 55 Mysql Status is Uptime: 1839 Threads: 55 Questions: 175421 ==> What does this Stands For ??? Slow queries: 0 Opens: 142 Flush tables: 1 Open tables: 136 Queries per second avg: 95.389 Any comments will appreciated. Thank you, Vishal. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, January 07, 2004 2:35 PM Subject: Re: MySQL+Apache Optimization > Hello, > > Thank you for the Reply, I'll follow you suggestions and will post the > results here, Also I use connect only and not aothers. > > Thank you again. ;) > Vishal. > > - Original Message - > From: "my5ql _" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, January 07, 2004 2:06 PM > Subject: MySQL+Apache Optimization > > > > >Can Anyone please tell me why I am not able to get the Load Down and the > > >site Load Faster.The server load is always above 5.00 > > > > > >Thanks in Advance. > > > > > >Vishal. > > > > Try the following changes: > > > > Apache: Turn KeepAlives off + increase your MaxRequestsPerChild. Apache is > > probably spending too much time recreating httpd processes. (I presume > > Apache & MySQL are running on the same box). Also are your using > > mysql_connect() or pconnects? > > > > MySQL: Try increasing your table cache. Does your thread cache need to be > > that high? Maybe you should increase the thread concurrency first. > According > > to the my.cnf, you can increase this based on the amount of CPUs, you > start > > off by setting it to 24-32? > > > > Your max_connections settings is high and that will take up a fair amount > of > > file descriptors. I suspect your table cache isn't big enough (try 2048 as > a > > starting point, see http://www.mysql.com/doc/en/Table_cache.html for more > > info) > > > > (Not intending to hijack this thread), but I'm going through a similar > issue > > with my Dual Xeon, 6GB RAM and RAID5 SCSI, but I'm running out of > > file-descriptors and max_connections=520 > > > > I hope my suggestions are useful and it'll be interesting to see whether > > they help... > > > > httpd.conf > > === > > KeepAlive Off > > MaxRequestsPerChild 9000 > > > > my.cnf > > == > > [mysqld] > > table_cache = 2048 > > thread_cache_size = 256 > > thread_concurrency= 32 > > > > _ > > It's fast, it's easy and it's free. Get MSN Messenger today! > > http://www.msn.co.uk/messenger > > > > > > -- > > 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] > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
(SQL Question) WHERE NOT IN A LIST
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 query that says: WHERE id != 'item1' AND id != 'item2' AND id != 'item3'... etc but I was wondering if there is an easier/more effecient way? Thanks! -Tom -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
EXPLAIN - Question..
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 the the seventh has 190892916 effected. +---++--+-+-+--+---+-+ | table | type | possible_keys| key | key_len | ref | rows | Extra | +---++--+-+-+--+---+-+ | bl| ALL| PRIMARY,receiver | NULL|NULL | NULL | 190892916 | where used; Using temporary; Using filesort | | bm| eq_ref | PRIMARY,sender | PRIMARY | 4 | bl.id | 1 | | | m | eq_ref | PRIMARY,account_login_last_index | PRIMARY | 15 | bl.receiver | 1 | where used | | mi| eq_ref | PRIMARY | PRIMARY | 15 | m.nick | 1 | | | be| eq_ref | PRIMARY | PRIMARY | 15 | m.nick | 1 | where used; Using index; Not exists | | ms| eq_ref | PRIMARY | PRIMARY | 15 | bm.sender | 1 | | | si| eq_ref | PRIMARY | PRIMARY | 15 | ms.nick | 1 | | | z | eq_ref | PRIMARY | PRIMARY | 10 | m.zip,ms.zip | 1 | | +---++--+-+-+--+---+-+
Using Temporary
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_last desc limit 0, 21 +---++---+-+-+-++--- --+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---++---+-+-+-++--- --+ | mi| ALL| PRIMARY | NULL|NULL | NULL| 740053 | Using temporary; Using filesort | | m | eq_ref | PRIMARY | PRIMARY | 15 | mi.nick | 1 | where used | +---++---+-+-+-++--- --+ 2nd query seems alot fasteer. select m.* from members m where m.nick like '%bigsh523%' order by nick desc, account_login_last desc limit 0, 21 +---+--+---+--+-+--++--- -+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+--+---+--+-+--++--- -+ | m | ALL | NULL | NULL |NULL | NULL | 736939 | where used; Using filesort | +---+--+---+--+-+--++--- -+ Any ideas why? What is the difference between Using Temporary and where used? Thanks! TOM -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SELECT SPEEDS......
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)
Column Types Changing
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 are the circumstances that would cause MySQL to alter the table structure on its own? This doesn't really make sense to me. -Tom -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Cluster Software
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? Will the MySQL branded one be better? Thanks! Tom ONeill InfoWorld Article http://www.infoworld.com/article/04/03/12/HNmysqlcluster_1.html
