MySQL HA on cloud

anything else by which I can achieve my goal? Thank You. Regards, Yogesh

Query on wait_timeout

ideal and waiting for each other. Thanks, Yogesh

Re: Can't read dir of '.' (errno: 13)

Check owner of the MySQL data directory. 2011/1/19 Pintér Tibor > > mysql> show databases ; > > ERROR 1018 (HY000): Can't read dir of '.' (errno: 13) > > mysql> show databases; > > ERROR 1018 (HY000): Can't read dir of '.' (errno: 13) > > mysql> > > $ perror 13 > OS error code 13: Permission d

Query is not using Index

Hi, I am firing following query SELECT 'Sales' as transaction_type, CONCAT('$', SUM(CASE DATE(px_orders.sales_orders.order_completed_date) WHEN CURDATE() THEN px_orders.sales_order_products.paid_amount ELSE 0 END)) AS today, CONCAT('$', SUM(CASE WEEK(px_orders.sales_orders.order_c

Re: ERROR 1 (HY000): Can't create/write to file '/var/lib/mysql/#sql_9e1_0.MYI' (Errcode: 13)

May be db files are not as MySQL user. Check owner ship for the files of the table. It should be mysql user ownership. On Tue, Jan 18, 2011 at 6:36 AM, Peng Yu wrote: > Hi, > > I run the following command. But I got the following error. I'm not > sure what causes the problem. I have seen the sam

Re: Rewrite SQL to stop table scan

Hey, Try making `id` as primary key. That will keep data in sorted manner and scan will look only the data required in-spite of full table scan. On Fri, Jan 14, 2011 at 4:22 PM, Bruce Ferrell wrote: > How would you rewrite the following SQL so that is doesn't do a full > table scan. It does in

Re: Rewrite SQL to stop table scan

can you send DDL of the table? On Fri, Jan 14, 2011 at 4:22 PM, Bruce Ferrell wrote: > How would you rewrite the following SQL so that is doesn't do a full > table scan. It does in fact do a full scan in spite of the time > clause. It's been > making me nuts for months. > > select count(*) as

Re: Large table

What is the table type for Table? Firstly check with queries and index if required. Check if queries using this table can be fine tuned. Check if table getting locked. If size of table is problem and if the table type is innodb check for innodb_file_per_table options. Also have a look for portion

Re: export result from select statement

#mysql -username -p -e "select * from table_name where id=123" > '/home/me/test/test.txt' On Mon, Jan 10, 2011 at 8:15 AM, LAMP wrote: > maybe it's "clear" to other but it's pretty unclear. > #mysql -username -p "select * from table_name where id=123" > > '/home/me/test/test.txt' > actually do

Re: problem open a innodb table

Dont you have mysql dump file for those table? It is best way to restore InnoDB tables. 2011/1/7 Elim PDT > I messed up the ibdata1,ib_logfile1,0 files and encounter the problems of > openning innodb tables even after I copied the back-up files of few months > ago. I don't have many innodb tabl

unauthenticated user | while load testing

Hi, What is unauthenticated user seen in mysql processlist ? I am doing load testing and at a single time more than 1000 users are coming to mysql server. Do any one have idea about it?

MySQL charset

I don't know of any way to change it. Our version is MySQL 4.0.24 Is it possible to change charset fo a database in this version? Regards Yogesh

mysql-4.0.1-alpha (Official MySQL RPM) installtion problem

.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash. 020604 14:40:39 mysqld ended -- -yogesh -- -yogesh -- -yogesh -- -yogesh - Before posting, please check:

mysql-4.0.1 installtion problem on redhat

.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash. 020604 14:40:39 mysqld ended -- -yogesh -- -yogesh - Before posting, please check: http://www.mysql.com/ma

query

Hello Sir, I am using mysql version 3.22(windows based). I wanted to know whether there is any tool to convert database of above version to the linux based mysql database. If so plz tell me where should I find such a tool. Thanking you waiting for reply Yogesh Deshmukh