Hi,
I tried setting 'bind-address' as an option from ~/.my.cnf:
(amit0:~) # cat ~/.my.cnf
[mysqld]
bind-address 127.0.0.1
(amit0:~) # mysqld
061126 16:08:54 [ERROR] mysqld: unknown option '--bind-address 127.0.0.1'
1. Is 'bind-address' then not an 'option'?
2. As 'bind-address' IS
In the last episode (Nov 26), Amit Dor-Shifer said:
Hi,
I tried setting 'bind-address' as an option from ~/.my.cnf:
(amit0:~) # cat ~/.my.cnf
[mysqld]
bind-address 127.0.0.1
(amit0:~) # mysqld
061126 16:08:54 [ERROR] mysqld: unknown option '--bind-address 127.0.0.1'
Try
Thanks a lot for your help.
The query should and only does return 1-6 rows depending on the id.
Never more then that. Here are the comperative EXPLAINs:
mysql EXPLAIN SELECT * FROM purchased_services WHERE id = 1000;
The application is not in production yet but when it will go in
production the server will be considerably faster and have much more
RAM. But before I put the app in production I want to make sure it is
working properly. 500K rows does not sounds like that much in this
day in age. If I
In the last episode (Nov 26), John Kopanas said:
Thanks a lot for your help.
The query should and only does return 1-6 rows depending on the id.
Never more then that. Here are the comperative EXPLAINs:
mysql EXPLAIN SELECT * FROM purchased_services WHERE id = 1000;
When I did a:
SELECT * FROM purchased_services WHERE company_id = 1000;
It took me 7 seconds. This is driving me crazy!
I am going to have to try this on another computer and see if I am
going to get the same results on another system. Argh...
On 11/26/06, Dan Nelson [EMAIL PROTECTED]
In the last episode (Nov 26), John Kopanas said:
On 11/26/06, Dan Nelson [EMAIL PROTECTED] wrote:
In the last episode (Nov 26), John Kopanas said:
Thanks a lot for your help.
The query should and only does return 1-6 rows depending on the id.
Never more then that. Here are the
Yes... with FORCE INDEX it still takes 7 seconds.
On 11/26/06, Dan Nelson [EMAIL PROTECTED] wrote:
In the last episode (Nov 26), John Kopanas said:
On 11/26/06, Dan Nelson [EMAIL PROTECTED] wrote:
In the last episode (Nov 26), John Kopanas said:
Thanks a lot for your help.
The query
Hi Guys,
I have an easy doubt..
Table A consist of field Item and Table B consist of field Price. Table A
consists of Items which has price aswell the items which doesnt have price.
But In Table B,I have kept only the item which has price . Now, I want to
subtract the total items in Table A
Hi Guys,
I have an easy doubt..
Table A consist of field Item and Table B consist of field Price. Table A
consists of Items which has price aswell the items which doesnt have
price. But In Table B,I have kept only the item which has price . Now, I
want to subtract the total items in
At 08:31 PM 11/26/2006, John Kopanas wrote:
When I did a:
SELECT * FROM purchased_services WHERE company_id = 1000;
It took me 7 seconds. This is driving me crazy!
I am going to have to try this on another computer and see if I am
going to get the same results on another system. Argh...
Hi Renish,
Here's the answer for your query.
mysql select * from a;
++
| item |
++
| book |
| pencil |
| table |
| chair |
++
mysql select * from b;
++---+
| item | price |
++---+
| pencil | 11 dollar |
| book | 12 dollar |
Hi,
Hope, a string constant can be searched against a column; Most of the
string function including find_in_set, allows us to display only the table
values and not the string constants passed.
Try it with 2 tables; or some userdefined functions.
Thanks
ViSolve DB Team.
- Original
Hi,
Obviously True.
Try mysql show table status like 'tablename';
Check for Data_length Max_Data_Length values which speaks about the used
memory size and allowed maximum size.
The max_heap_table_size system global variable impose the maximum size of the
memory table.
Try with
mysql set
Thanks if in case if we dont have the Item field in the Table B. wat to do..I
know the primary key to connect both the tables/
- Original Message -
From: ViSolve DB Team
To: Renish ; mysql@lists.mysql.com
Sent: Monday, November 27, 2006 12:48 PM
Subject: Re: MySql doubt.
15 matches
Mail list logo