Hi Joerg,
Thanks a lot for the info.
regards
anandkl
On 7/23/08, Joerg Bruehe <[EMAIL PROTECTED]> wrote:
>
> Hi !
>
>
> Ananda Kumar wrote:
>
>> Hi All,
>> I have setup slave db. The machine configuration details of this slave is
>> same as master.
>>
>> OS=redhat
>> 8 cpu
>> 16GB RAM
>>
>> key_
mysql> show global status like '%stmt%';
+-+-+
| Variable_name | Value |
+-+-+
| Com_stmt_close | 4875504 |
| Com_stmt_execute| 4875504 |
| Com_stmt_fetch | 0 |
| Com_stmt_prepare| 48
Hi
I am using Disk Based MySql Cluster 6.2.15 . I would like to know one
important thing regarding MySQL cluster.
I am using two servers with 1.8 TB each. What will be the maximum space
available for Data Storage when both machines are in cluster?
Suppose if i add one more machine with 1.8T
I recently installed 2 instances of mysql on the same server, using port
3307 for the second server, the normal 3306 for the first server. I found
that while logged onto that box I could communicate to the 3307 instances
using the socket parameter. Using the port parameter (--port=3307) didn't
wo
Hi there
I am going to make 2 Webserver at my work going to handle 50 mil hits per
month... They are using Linux already. But being a FreeBSD fan, I have
proposed MySQL and FreeBSD to my Boss convincing him that MySQL and FreeBSD
is more Fast and Secure solution for his needs... And now I want to
Hi !
Ananda Kumar wrote:
Hi All,
I have setup slave db. The machine configuration details of this slave is
same as master.
OS=redhat
8 cpu
16GB RAM
key_buffer_size=3000M
innodb_buffer_pool_size=1M.
But when i do top, in the master db
Cpu(s): 0.5%us, 0.3%sy, 0.0%ni, 87.2%id, 11.9%wa,
Hi all,
i am
installing a library automation software called koha which uses
mysql-server. i initially installed version5.0 and later uninstalled
it because the system was giving me some errors. i install
On 21.07.2008 22:52 CE(S)T, Benjamin Wiechman wrote:
With 5.1 you have more control over general query log and the slow query log
- enable or disable at runtime, output to file or DB table.
Okay, now that sounds a lot better. Waiting for 5.1 GA then. Although it
only provides the very basics.
Thanks a lot all of you, Thank u very much.
regards
anandkl
On 7/22/08, Amit Sharma <[EMAIL PROTECTED]> wrote:
>
> Example:
>
> mysql> select * from tableA;
> +---+--+
> | name | age |
> +---+--+
> | Amit | 27 |
> | Sumit | 31 |
> | Anand | 29 |
> | Parry | 32 |
> +---
Example:
mysql> select * from tableA;
+---+--+
| name | age |
+---+--+
| Amit | 27 |
| Sumit | 31 |
| Anand | 29 |
| Parry | 32 |
+---+--+
mysql> select * from tableB;
+---++
| name | Salary |
+---++
| Amit | 5 |
| Sumit | 6
At 09:05 AM 7/22/2008, you wrote:
Hi All,
Can u please let me know when should i use LEFT JOIN and when should i going
for a RIGHT JOIN. Please let me know some examples.
regards
anandkl
anandkl,
Take a look at the tutorial at
http://www.keithjbrown.co.uk/vworks/mysql/mysql_p5.php
Mike
Hi All,
Can u please let me know when should i use LEFT JOIN and when should i going
for a RIGHT JOIN. Please let me know some examples.
regards
anandkl
Thanks, but I guess I wasn't clear. I meant the MySQL command line client.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
>-Origi
That was it. Once I removed PASSWORD, it went through, and I'm able to restart
MySQL now.
Thanks for your help.
Jesse
- Original Message -
From: Ian Simpson
To: Jesse
Cc: MySQL List
Sent: Tuesday, July 22, 2008 4:48 AM
Subject: Re: Access denied for user 'debian-sys-main
Hi Jesse,
If you're specifying the password in plain text, you shouldn't put the
PASSWORD directive in there; you only use PASSWORD if you're using the
hashed password that MySQL will actually store.
GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED
BY 'LongPasswordHere' W
15 matches
Mail list logo
