Yes, mysql by default sets the socket file in the below directory
/var/lib/mysql/mysql.sock.
But why does it refer to /tmp/mysql.sock file then, as that was the error
which was given when i tried to login to mysql.
Is that hard-coded for MySQL5.1 source code, which is what i wanted to know
?
Th
Hi Thomas, all!
Thomas van Gulick wrote:
[[...]]
Test:
EXPLAIN SELECT * FROM t WHERE T="x";
Result: key T used
EXPLAIN SELECT * FROM t WHERE T!="x";
Result: key T _unused_
To be expected:
An "unequal" condition will evaluate to "true" for a very large
proportion of the index entries, so th
Hello list!
I've noticed in MySQL 5.0 partial keys on character fields aren't always
used. In 4.1 they were.
They seem not to be used when using inequality comparison.
I'm not sure whether this is a bug or intended (in the latter case I have to
work around it to get the speed I got with 4.1 ba
MySQL5 becomes so slowly when bin log is open.
I used sysbench to test mysql.
MySQL version is mysql-standard-5.0.27-linux-i686-icc-glibc23.tar.gz
OS is RHEL 4.0
my.cnf is :
[mysqld]
#log-bin=icc
max_connections=3000
innodb_log_file_size=50M
max_prepared_stmt_count=32765
#log=Buddha.log
llo !
I need of koha, a software for libraries. It works with mysql 4, but
it's not compatible with mysql5.
How can do this changement with a Debian Etch ? Must I only remove the
one and install the other ?
Thanks for help,
Thibaud.
--
MySQL General Mailing List
For list archives: http:/
At 02:55 PM 1/21/2007, Thibaud Hulin wrote:
Hello !
I need of koha, a software for libraries. It works with mysql 4, but it's
not compatible with mysql5.
How can do this changement with a Debian Etch ? Must I only remove the one
and install the other ?
Thanks for help,
Thibaud.
--
Hello !
I need of koha, a software for libraries. It works with mysql 4, but
it's not compatible with mysql5.
How can do this changement with a Debian Etch ? Must I only remove the
one and install the other ?
Thanks for help,
Thibaud.
--
MySQL General Mailing List
For list archives:
t; FROM
> Table1, Table2
> LEFT JOIN Table3
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 16, 2007 11:06 AM
> To: Chris White
> Cc: mysql@lists.mysql.com
> Subject: Re: query taht works on mysql4 but does
I have not tried, but i think this is what he meant:
FROM
tn t
INNER JOIN bill_info b ON (b.id_b = t.id_t)
LEFT JOIN shipp_info sh ON (b.bill_id=sh.bill_id)
HTH,
On 1/16/07, Chris White <[EMAIL PROTECTED]> wrote:
[EMAIL PROTECTED] wrote:
> FROM ".$tn.", bill_info as b
> LEFT JOIN sh
: query taht works on mysql4 but doesn't on mysql5?
> [EMAIL PROTECTED] wrote:
>> FROM ".$tn.", bill_info as b
>> LEFT JOIN shipp_info as sh ON (b.bill_id=sh.bill_id
>
> That would be the usage of multiple from's combined with a left join.
> Unfortunately with
> [EMAIL PROTECTED] wrote:
>> FROM ".$tn.", bill_info as b
>> LEFT JOIN shipp_info as sh ON (b.bill_id=sh.bill_id
>
> That would be the usage of multiple from's combined with a left join.
> Unfortunately with mysql 5 you can't do this. You're going to have to
> do bill_info as a left/right/inner j
[EMAIL PROTECTED] wrote:
FROM ".$tn.", bill_info as b
LEFT JOIN shipp_info as sh ON (b.bill_id=sh.bill_id
That would be the usage of multiple from's combined with a left join.
Unfortunately with mysql 5 you can't do this. You're going to have to
do bill_info as a left/right/inner join ins
;.$tn."'
AND ".$tn.".registration_status = '".$_SESSION['order_status']."'
ORDER BY ".$tn.".reg_id DESC
($tn is name for selected table)
Now, after I moved to mysql5 based server I'm getting error:
ERROR: Unknown column 'b.bill_id&#
Hi,
I have just upgraded an HPUX 11.00 server to MySQL 5.0.26-pro.
Since the upgrade, the readline seems to be broken. (It was OK on 4.1.18).
We see the problem when we run,
mysql -A -u user -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 34782 to server
joins of the sort you use above. You
need explicit JOIN ... ON | USING syntax to remove referential ambiguities.
PB
-
Jason Chan wrote:
I am going to upgrade my database from version 4 to 5.
However I found some of my web application doesn't work on MySQL5
e.g following statement works
t; <[EMAIL PROTECTED]> escreveu na mensagem
news:[EMAIL PROTECTED]
>I am going to upgrade my database from version 4 to 5.
> However I found some of my web application doesn't work on MySQL5
>
> e.g following statement works in 4 but not 5
>
> SELECT f.*, c.id as cat_id, c
I am going to upgrade my database from version 4 to 5.
However I found some of my web application doesn't work on MySQL5
e.g following statement works in 4 but not 5
SELECT f.*, c.id as cat_id, c.position as cat_position, c.state as
cat_state, c.name as cat_name, c.description as cat
At 12:40 PM 7/30/2006, you wrote:
Hello!
Am 30.07.2006 um 18:40 schrieb mos:
The Cayenne framework is using a a single table to keep the primary
keys (PK) for its objects. The method accessing this table is
surrounded by lock / unlock commands, so no other thread can read the
same PK from the
Hello!
Am 30.07.2006 um 18:40 schrieb mos:
The Cayenne framework is using a a single table to keep the primary
keys (PK) for its objects. The method accessing this table is
surrounded by lock / unlock commands, so no other thread can read the
same PK from the table while another thread is curre
At 05:43 AM 7/29/2006, you wrote:
Dear list,
we are running a Mysql 5.0.22 server that is accessed by a number of
java web applications (jdbc driver 3.1) over the network. The
database layer was realized using the Cayenne framework and InnoDB
was chosen as the table type. All applications share
Dear list,
we are running a Mysql 5.0.22 server that is accessed by a number of
java web applications (jdbc driver 3.1) over the network. The
database layer was realized using the Cayenne framework and InnoDB
was chosen as the table type. All applications share the same
database because t
[snip]
what type of password algorithum does mysql 5.x uses for encrypting
passwords? and how does these algorithum keeps the password in secure.
[/snip]
Here is some helpful info;
http://www.mysql.com/search/?q=password+security&charset=
--
MySQL General Mailing List
For list archives: http://
MySQL, Inc
> -Original Message-
> From: Shivaji S [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 06, 2006 1:30 PM
> To: mysql@lists.mysql.com
> Subject: Passwords in Mysql5.x
>
>
> Hi,
>
> what type of password algorithum does mysql 5.x uses for
> e
Hi,
what type of password algorithum does mysql 5.x uses for encrypting passwords?
and how does these algorithum keeps the password in secure.
Regards,
Shivaji.
In practice they are not.
On Mon, 13 Mar 2006, Alex Moore wrote:
> To: mysql@lists.mysql.com
> From: Alex Moore <[EMAIL PROTECTED]>
> Subject: Re: mysql5 options file location
>
> On Mon, 13 Mar 2006 23:05:30 + (GMT)
> [EMAIL PROTECTED] wrote:
>
> > Exactly
On Mon, 13 Mar 2006 23:05:30 + (GMT)
[EMAIL PROTECTED] wrote:
> Exactly what are the problems you are having with the server
> specific my.cnf file?
Sorry, I thought that I had described the problem. A quick example was
'my_print_defaults mysqld' returning only the options defined in the
gl
mysqltest
#mysqlaccess - .pl safe_mysqld
#
# end of mysql client program configurations
# /etc/my.cnf
Take a look at the man pages for the client programs, as
well as mysqld_safe and mysqld, in /opt/csw/mysql5
erent locations. Specifically check /lib and /usr/lib vs.
/lib64 and /usr/lib64.
Hope that helps
-Sheeri
On 3/5/06, bobgoodwin <[EMAIL PROTECTED]> wrote:
>
> I have two FC4 computers I believe to be set up identically, I installed
> mysql5 in both, the first one made the change wi
I am using a directory structure similar
to /usr/local/mysql5, but it is actually /opt/csw/mysql5.
The server-specific options are read on mysqld_safe at startup, as
evidenced by `mysqladmin variables`.
Without a /etc/my.cnf file, 'my_print_defaults mysqld' prints nothing.
With a /e
same;
In practice they are not.
On Mon, 13 Mar 2006, Alex Moore wrote:
> To: mysql@lists.mysql.com
> From: Alex Moore <[EMAIL PROTECTED]>
> Subject: mysql5 options file location
>
> I am building mysql5 latest from source on Solaris.
>
> The location of the options
I am building mysql5 latest from source on Solaris.
The location of the options file is very confusing and does not work
according to the online documentation. For example, I have --basedir
of /opt/csw/mysql5 and --datadir of /opt/csw/mysql5/var. If I put
my.cnf in datadir or in basedir, the
via an article on the mysql site which
uses the ODBC connector, however it states on the mysql .NET info page
that ODBC is slower than a native provider. My issue is the bytefx
provider has an old client, possibly for Mysql 4.0 so it cant
authenticate properly. Im running Mysql5 , is there a
client, possibly for Mysql 4.0 so it cant authenticate
properly. Im running Mysql5 , is there a version of this that is
compatible with Mysql5 ? let me know thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
I have two FC4 computers I believe to be set up identically, I installed
mysql5 in both, the first one made the change without a hitch but the
second refuses to install with the error message:
"./bin/mysqld: error while loading shared libraries: libstdc++.so.5:
cannot open
shared o
I would think this list is more likely to be able to assist with problems using
the standard installer from MySQL than with some third party installer /
package management system.
I would suggest using Disk Utility to repair permissions on your hard disc
(just in case some relevant directory ca
On Jan 24, 2006, at 5:13 AM, James Harvard wrote:
Is there a reason why you're using Darwin Ports and not the
installer that MySQL offers?
James Harvard
Yes. I tried the installer multiple times and it would not work. I
got so fed up with it that I decided to give DP a chance. So far,
ne
Hello.
> /opt/local/share/mysql5/mysql/mysql.server: line 234: cd: /opt/
> local/libexec/mysqld: No such file or directory
.
> • First of all, I check to see if 'mysqld' existed in /opt/local/
> libexec/ and it does, so I don'
Hi all.
Let me clarify my subject line. I *think* I actually got all the
'MySQL5 +server' files installed correctly using Darwin Ports. The
problem is that I am not able to start my server. I think that
'my.cnf' may also be incorrect. Here's what's happening...
it's
says to upgrade my Client's "Were are the Client Installs in this
ver???") like MySQL 4.0.24 << the best ver in my oppion ,,
Were are the tools? Like MySQLadmin that's Included in MySQL 4.0.24 , And
for god sake what ver of PHP do I have to run with MyS
Inc, www.mysql.com
Houston, TX USA
-Original Message-
From: Brian E Boothe [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 13, 2005 10:30 PM
To: mysql@lists.mysql.com
Subject: MySQL5
I've Installed - uninstalled - reinstalled Mysql-5 Three Times on a extra
machine I had layin
rade my Client's "Were are the Client Installs in this
ver???") like MySQL 4.0.24 << the best ver in my oppion ,,
Were are the tools? Like MySQLadmin that's Included in MySQL 4.0.24 , And
for god sake what ver of PHP do I have to run with MySQL5, geesh what a
pain in the ass,, can someone help me
ali asghar torabi parizy wrote:
hi all
i want to install mysql5 on fc3 but i cant when i trying to implement it by
rpm.
i remove mysql3 with rpm -e directive.
So, now when you do:
rpm -qa |grep -i mysql
You see nothing, right?
who cabn help me?:(
thanks
hi all
i want to install mysql5 on fc3 but i cant when i trying to implement it by
rpm.
i remove mysql3 with rpm -e directive.
who cabn help me?:(
thanks
rpm -ivh MySQL-server-5.0.15-0.i386.rpm
error: MySQL-server-5.0.15-0.i386.rpm: V3 DSA signature
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 29, 2004 3:54 PM
Subject: Re: replication in mysql5 between linux and windows
> Jonas Lind?n <[EMAIL PROTECTED]> wrote:
> > Hello list, I hav
Jonas Lind?n <[EMAIL PROTECTED]> wrote:
> Hello list, I have successfully installed mysql5 on my windows box and my aim is set
> on replicating my mysql5 linux system. I think I am on the right track and the
> systems seem to talk to eachother according to my logs. My problem
Hello list, I have successfully installed mysql5 on my windows box and my aim is set
on replicating my mysql5 linux system. I think I am on the right track and the systems
seem to talk to eachother according to my logs. My problem is that nothing is
replicated in my databases but I think that
D] [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 8:14 AM
To: electroteque; [EMAIL PROTECTED]
Subject: Re: stored procedures in mysql5
"insane"
you mean extremely fast? or easy to use? i'd like to know what those SPs are
good for...
-yves
-Ursprüngliche Nachricht-
Vo
"insane"
you mean extremely fast? or easy to use? i'd like to know what those SPs are good
for...
-yves
-Ursprüngliche Nachricht-
Von: "electroteque" <[EMAIL PROTECTED]>
An: <[EMAIL PROTECTED]>
Gesendet: Montag, 30. Juni 2003 00:09
Betreff: RE: s
thanks this is pretty insane cant wait for its release :D
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 6:07 AM
To: electroteque
Cc: Mysql
Subject: Re: stored procedures in mysql5
On Sun, Jun 29, 2003 at 08:00:29PM +1000, electroteque
On Sun, Jun 29, 2003 at 08:00:29PM +1000, electroteque wrote:
> ok i have a bleeding edge server instance on my server apache2/php5/mysql5
> running alongside the stable server , is stored procedures actually
> functioning in it yet ? is this the correct syntax there is no documentation
ok i have a bleeding edge server instance on my server apache2/php5/mysql5
running alongside the stable server , is stored procedures actually
functioning in it yet ? is this the correct syntax there is no documentation
for it yet.
create procedure test as select * from tablename;
--
MySQL
51 matches
Mail list logo
