Re: Problem with symbolic link
Hello. Sorry for a such delayed reply. Very often similar errors are caused by low value of open_files_limit system variable. Increase it as much as possible and if the problem disappears, decrease it gradually. If this doesn't help, check if the problem remains on the latest release. Vlad Shalne wrote: > Hi all > > Problem description > > OS: Solaris 9 > > Mysql: 4.1.8 > > I have two configuration database for my application and I need to have > some tables with same data and some tables with different data. I solve > this problem with symbolic linked tables (for MYI and MYD files). > Periodically I get error message "File '../conf/xxx.MYD' not found > (Errcode: 2)" for tables that are > symbolic link to tables on different configuration database (on the same > file system). Error disappears after executing "flush tables". > > > If someone solve this problem let me know please. > > Thanks for any help > -- 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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with symbolic link
Hello. Sorry for a such delayed reply. Very often similar errors are caused by low value of open_files_limit system variable. Increase it as much as possible and if the problem disappears, decrease it gradually. If this doesn't help, check if the problem remains on the latest release. Vlad Shalne wrote: > Hi all > > Problem description > > OS: Solaris 9 > > Mysql: 4.1.8 > > I have two configuration database for my application and I need to have > some tables with same data and some tables with different data. I solve > this problem with symbolic linked tables (for MYI and MYD files). > Periodically I get error message "File '../conf/xxx.MYD' not found > (Errcode: 2)" for tables that are > symbolic link to tables on different configuration database (on the same > file system). Error disappears after executing "flush tables". > > > If someone solve this problem let me know please. > > Thanks for any help > -- 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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with symbolic link
Hi all Problem description OS: Solaris 9 Mysql: 4.1.8 I have two configuration database for my application and I need to have some tables with same data and some tables with different data. I solve this problem with symbolic linked tables (for MYI and MYD files). Periodically I get error message "File '../conf/xxx.MYD' not found (Errcode: 2)" for tables that are symbolic link to tables on different configuration database (on the same file system). Error disappears after executing "flush tables". If someone solve this problem let me know please. Thanks for any help -- Vlad A. Shalnev E-mail: [EMAIL PROTECTED] "Gravity can't be blamed for someone falling in love" ( Albert Einstein ) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with symbolic link
Privet! Usually there is a number in the brackets after an error message. What is this number? Vlad Shalnev <[EMAIL PROTECTED]> wrote: > Hi all > > Problem description > > OS: Solaris 9 > > Mysql: 4.1.8 > > Periodically I get error message "can't get stat of xxx.MYD" for tables that > are > symbolic link to tables on different database on the same file system. Error > disappear after executing "flush tables". > > If someone solve this problem let me know please. > > Thanks for any help > -- 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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with symbolic link
Jasper Bryant-Greene wrote: Vlad Shalnev wrote: Periodically I get error message "can't get stat of xxx.MYD" for tables that are symbolic link to tables on different database on the same file system. Error disappear after executing "flush tables". Why are you doing this? You can access tables in other databases in your SQL queries so what is the point of making symbolic links to tables in other databases? Is it even supported? Vlad Shalnev wrote: I have two configuration database for my application and I need to have some tables with same data and some tables with different data. So why not just reference the tables that need to be the same with a fully-qualified name? Like: SELECT * FROM databasename.tablename WHERE a=439 LIMIT 1 or whatever. There's no need to do symbolic links for that... -- Jasper Bryant-Greene Freelance web developer http://jasper.bryant-greene.name/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with symbolic link
I have two configuration database for my application and I need to have some tables with same data and some tables with different data. Jasper Bryant-Greene wrote: Vlad Shalnev wrote: Periodically I get error message "can't get stat of xxx.MYD" for tables that are symbolic link to tables on different database on the same file system. Error disappear after executing "flush tables". Why are you doing this? You can access tables in other databases in your SQL queries so what is the point of making symbolic links to tables in other databases? Is it even supported? -- Vlad A. Shalnev E-mail: [EMAIL PROTECTED] "Gravity can't be blamed for someone falling in love" ( Albert Einstein ) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with symbolic link
Vlad Shalnev wrote: Periodically I get error message "can't get stat of xxx.MYD" for tables that are symbolic link to tables on different database on the same file system. Error disappear after executing "flush tables". Why are you doing this? You can access tables in other databases in your SQL queries so what is the point of making symbolic links to tables in other databases? Is it even supported? -- Jasper Bryant-Greene Freelance web developer http://jasper.bryant-greene.name/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with symbolic link
Hi all Problem description OS: Solaris 9 Mysql: 4.1.8 Periodically I get error message "can't get stat of xxx.MYD" for tables that are symbolic link to tables on different database on the same file system. Error disappear after executing "flush tables". If someone solve this problem let me know please. Thanks for any help -- Vlad A. Shalnev E-mail: [EMAIL PROTECTED] "Gravity can't be blamed for someone falling in love" ( Albert Einstein ) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]