Hi,
SQL like
select *,(select f1 from (select f1,date from table1 t1 where
t1.f1=table1.f1 order by date desc limit 1 ) t2 ) lastf1
from table1
shows table1.f1 not found, mysql 5.0.37 .
Thanks!
Shuming Wang
wang shuming wrote:
Hi,
SQL like
select *,(select f1 from (select f1,date from table1 t1 where
t1.f1=table1.f1 order by date desc limit 1 ) t2 ) lastf1
from table1
shows table1.f1 not found, mysql 5.0.37 .
Break up your query and work out which table1 it's talking about,
Hi List,
We have a mysql-Server with 8G of Ram. But mysql doesn't use this ram.
But we get following error:
May 14 22:56:11 sql mysqld[5875]: 070514 22:56:10 [ERROR] /usr/sbin/mysqld: Got
error 12 from storage engine
May 14 22:56:11 sql mysqld[5875]: 070514 22:56:10 [ERROR] /usr/sbin/mysqld:
On Tuesday 15 May 2007 02:56, Dan Buettner wrote:
Hi JM -
Can you send us a few things?
1 - the exact error message you get
the error code it produced is (110) which according to perror is connection
time out..
2 - the output of SHOW VARIABLES; from a mysql session
Ratheesh K J wrote:
Hello all,
I have a requirement of maintaining some secret information in the database.
And this information should not be visible/accessible to any other person but
the owner of the data.
Whilst I know that encryption/decryption is the solution for this, are there
any
Ok.. Will it be secure if the data is encrypted. mysqldump will show
encrypted data right.
Actually I want to know what is the best practice for such applications. Can
I say that encryption alone is sufficient to secure my data. Or is there any
other strategy used for data protection?
-
Well,
you can save all data encoded in the database:
http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html#function_encode
- Mike
Chris schreef:
Ratheesh K J wrote:
Hello all,
I have a requirement of maintaining some secret information in the
database. And this information
Ratheesh K J wrote:
Ok.. Will it be secure if the data is encrypted. mysqldump will show
encrypted data right.
mysqldump will show whatever the database table does - it just grabs
that info and puts it into a file. If it's encrypted in the table,
that's what mysqldump will show.
Actually I
check if you are seeing any access denied errors in the mysql error log.
~Alex
On 5/14/07, richard [EMAIL PROTECTED] wrote:
Ian P. Christian wrote:
richard wrote:
as far as I can see, these commands select which db's to replicate on
the slave that currently exist on the master server.
Hello,
I got a problem with the redo log from mysql.
my /var/log/mysql fills up with mysql-bin.0# files and a few moments ago it
was about 10Gb in size (after 2 weeks in production), so I decide to delete al
the files.
What can I do to stop this kind of behavior? and is its safe to delete
What can I do to stop this kind of behavior? and is
its safe to delete all the files with a cronjob? and witch files are
recommend to delete if so?
just commet log-bin option of [mysqld] section in your my.cnf file
(/etc/my.cnf)
you can also remove these files manually -- it will not affect
What can I do to stop this kind of behavior? and is
its safe to delete all the files with a cronjob? and witch files are
recommend to delete if so?
just commet log-bin option of [mysqld] section in your my.cnf file
(/etc/my.cnf)
you can also remove these files manually -- it will not affect
One question about this, is it safe to turn of log_bin?
i think, you can. the log is necessary for data replication and sometimes for
data recovery.
you can read about it here:
http://dev.mysql.com/doc/refman/5.0/en/binary-log.html
Or can you tweak it somehow so that it won't' take some much
the ask lies in expire_logs_days. If you set this to optimal number of days,
logs older than the configured days will get purged.
~Alex
On 5/15/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
One question about this, is it safe to turn of log_bin?
i think, you can. the log is necessary for
On Tue, May 15, 2007 11:12, Chris wrote:
Ratheesh K J wrote:
Hello all,
I have a requirement of maintaining some secret information in the
database. And this information should not be visible/accessible to any
other person but the owner of the data.
Whilst I know that encryption/decryption
I am not sure if you can restore just one table from a dump with the mysql
client, you could however just copy the table entries out of you dump into a
new file and restore that
On 5/15/07 12:28 AM, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi All,
I have take a mysqldump of my entire database,
Christoph Klünter a écrit :
Hi List,
We have a mysql-Server with 8G of Ram. But mysql doesn't use this ram.
But we get following error:
May 14 22:56:11 sql mysqld[5875]: 070514 22:56:10 [ERROR] /usr/sbin/mysqld:
Got error 12 from storage engine
May 14 22:56:11 sql mysqld[5875]: 070514
Hi All,
The table is close to 5 GB in size.
regards
anandkl
On 5/15/07, Olaf Stein [EMAIL PROTECTED] wrote:
I am not sure if you can restore just one table from a dump with the mysql
client, you could however just copy the table entries out of you dump into
a
new file and restore that
On
The only way to keep the data secure so ONLY the user can see it, is to have the user come up with a pass phrase that is used to
encrypt the data. That pass phrase should not be stored in the database or on any of your systems. For them to see the data, they
need to enter the proper pass phrase.
On 5/15/07, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi All,
I have take a mysqldump of my entire database, is it possible to restore
just one table from this mysqldump.
Yes thats possible.
cat your-dump-filename | grep tablename u want to restore mysql -u
user -ppassword should do it.
On 5/15/07, Christoph Klünter [EMAIL PROTECTED] wrote:
I have set the sort_buffer_size to 1G but even this doesn't help.
Any hints ? Should we try a 64Bit-OS ?
setting sort_buffer_size to 1GB is not recommended. it is a thread specific
configuration parameter which means each thread will
Hi Alex,
Thanks for the info,
For the second question, do you mean i should restore the entire backup or
just that one file from my backup.
regards
anandkl
On 5/15/07, Alex Arul Lurthu [EMAIL PROTECTED] wrote:
On 5/15/07, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi All,
I have take a
On 5/15/07, Ratheesh K J [EMAIL PROTECTED] wrote:
Hello all,
I have a requirement of maintaining some secret information in the
database. And this information should not be visible/accessible to any other
person but the owner of the data.
Whilst I know that encryption/decryption is the
On 5/15/07, Mathieu Bruneau [EMAIL PROTECTED] wrote:
Hi, yeah, apparenlty you're running into the 32 bits memory liimt. Note
thta some memory is allocated for the OS so you don't even have the full
4GB of ram you can technically adressesed.
The 64 bits os would increase this limit to 64gb++
On 5/15/07, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi Alex,
Thanks for the info,
For the second question, do you mean i should restore the entire backup or
just that one file from my backup.
All the files should be from the same backup. AFAIK, MySQL doesnt have an
option to recover only one
Hi.
Today I found postgresql's neat feature, inet operators,
which allows you to do
inet '192.168.1/24' inet '192.168.1.5'
http://www.postgresql.org/docs/current/static/functions-net.html
Is there anyway to do this using MySQL?
--
MySQL General Mailing List
For list archives:
Hello,
js wrote:
Hi.
Today I found postgresql's neat feature, inet operators,
which allows you to do
inet '192.168.1/24' inet '192.168.1.5'
http://www.postgresql.org/docs/current/static/functions-net.html
Is there anyway to do this using MySQL?
Yes. Have a look at the inet_ntoa() and
-Original Message-
From: js [mailto:[EMAIL PROTECTED]
Sent: 15 May 2007 15:31
To: MySQL List
Subject: Network address functions in MySQL?
Hi.
Today I found postgresql's neat feature, inet operators,
which allows you to do
inet '192.168.1/24' inet '192.168.1.5'
Hi,
js wrote:
Hi Baron.
Thanks for reply.
If I understand correctly,
inet_ntoa() and inet_aton() are not capable of handling CIDR notation.
Very true, I didn't quite understand the syntax you were using. But you can still use
bitwise arithmetic to work around this. Scott Noyes wrote a
Hi Baron.
Thanks for reply.
If I understand correctly,
inet_ntoa() and inet_aton() are not capable of handling CIDR notation.
On 5/15/07, Baron Schwartz [EMAIL PROTECTED] wrote:
Hello,
js wrote:
Hi.
Today I found postgresql's neat feature, inet operators,
which allows you to do
inet
I think you may be able to get around this by using multiple key
buffers? (MySQL 4.1 or later)
-Micah
On 05/15/2007 01:24 AM, Christoph Klünter wrote:
Hi List,
We have a mysql-Server with 8G of Ram. But mysql doesn't use this ram.
But we get following error:
May 14 22:56:11 sql
Thanks Jerome.
With the high number of aborted_clients, it seems like you might have
networking issues:
http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html
Dan
Hi Guys,
we have a MySQL server acting as a backend for a VoIP provider.
We're using this MySQL server to collect CDRs and to extract some easy
reports from them (including web access to CDRs for customers)
CDRs are inserted directly from Asterisk switches when a call ends.
We're
Hi Edoardo -
I think you've been misinformed; MyISAM tables do not support simultaneous
read and write operations. MyISAM is a multiple reader/single writer, table
locking design. You may want to switch to InnoDB tables for that
functionality.
In the last episode (May 15), Dan Buettner said:
Hi Edoardo -
I think you've been misinformed; MyISAM tables do not support
simultaneous read and write operations. MyISAM is a multiple
reader/single writer, table locking design. You may want to switch
to InnoDB tables for that
I suggest you simplify and use distinct aliases within your queries.
- michael
On 5/15/07, Chris [EMAIL PROTECTED] wrote:
wang shuming wrote:
Hi,
SQL like
select *,(select f1 from (select f1,date from table1 t1 where
t1.f1=table1.f1 order by date desc limit 1 ) t2 ) lastf1
If there are no holes in the data structure storing the MyISAM data,
this concurrency is possible but as soon as any real-world maintenance
kicks in, those holes will exists and the rules kick in:
on MyISAM you may have 1 writer OR many readers.
a write operation will wait for ongoing read
Hello, I'm wondering if this is the most effective way of doing an
outer join with 'extra criteria' (I don't feel like it's the best way):
SELECT e.EventID, ue.Contact, ut.Discount
FROM Event e
LEFT OUTER JOIN
(SELECT EventID, Contact FROM UserEvent WHERE UserId = 10) ue
using (EventID)
Dear MySQL users,
We are proud to present to you the MySQL Server 5.1.18 Beta
release, a new Beta version of the popular open source database.
Bear in mind that this is a beta release, and as any other
pre-production release, caution should be taken when installing on
production level systems
Folks,
Here's an interesting problem for you. I found a problem that did not
make any sense, and in diagnosing the problem I found an issue with
InnoDB vs MyISAM, so I wrote a short script to test it. The test case
is a simple Open, Insert, Close series repeated 5 times with both
engines.
Hi Kenneth -
it appears that you need to use an explicit 'commit' command when using
InnoDB tables and Python.
Something like this:
try:
cursor.execute(INSERT INTO Test1 (s1, i1) VALUES ('Now is the
time', 5))
db.commit()
Found this on http://www.serpia.org/mysql
Thanks for the tip, that worked.
Sounds like InnoDB is still borked though. You should not have to use a
commit unless you have started a transaction, as I understand it. The
semantics for non-transaction access should be identical.
...Ken
Dan Buettner wrote:
Hi Kenneth -
it appears
Kenneth Loafman [EMAIL PROTECTED] wrote:
Sounds like InnoDB is still borked though. You should not have to use a
commit unless you have started a transaction, as I understand it. The
semantics for non-transaction access should be identical.
Are you explicitly telling Python not to use
Ofer Inbar wrote:
Kenneth Loafman [EMAIL PROTECTED] wrote:
Sounds like InnoDB is still borked though. You should not have to use a
commit unless you have started a transaction, as I understand it. The
semantics for non-transaction access should be identical.
Are you explicitly telling
On Tue, May 15, 2007 at 04:13:33PM -0500, Kenneth Loafman wrote:
Can't tell. The docs are somewhat lacking in detail, however, if I do a
db.autocommit(True) it works as it should.
Will have to dig into the API code and see if that is where the semantic
discontinuity lies.
The
Jon Ribbens wrote:
On Tue, May 15, 2007 at 04:13:33PM -0500, Kenneth Loafman wrote:
Can't tell. The docs are somewhat lacking in detail, however, if I do a
db.autocommit(True) it works as it should.
Will have to dig into the API code and see if that is where the semantic
discontinuity lies.
On Tue, May 15, 2007 at 06:39:21PM -0500, Kenneth Loafman wrote:
Interesting... guess the intent was a disconnect that would break code
trying to work on MySQL, regardless of engine selected. That decision
makes it two products, MySQL/MyISAM and MySQL/InnoDB with different
semantics. Yes,
Hi Folks,
I have a database running on Window XP, that I want to disable network
connections to and enable 'named pipes'. I am running MySQL 5.0.27
and my.ini looks like...
[client]
#password= your_password
port= 3306
socket= /tmp/mysql.sock
[mysqld]
#port=
On 5/15/07, Micah Stevens [EMAIL PROTECTED] wrote:
I think you may be able to get around this by using multiple key
buffers? (MySQL 4.1 or later)
key buffers caches only index data and they dont help with sorting like
sort_buffer. they dont impact innodb engine. even while using multiple key
If your client has the bucks and you need the speed, why not use a MySQL
cluster which has row locks and transactions?
Mike
At 11:39 AM 5/15/2007, you wrote:
If there are no holes in the data structure storing the MyISAM data,
this concurrency is possible but as soon as any real-world
Ed Since schrieb:
Hello, I'm wondering if this is the most effective way of doing an outer
join with 'extra criteria' (I don't feel like it's the best way):
SELECT e.EventID, ue.Contact, ut.Discount
FROM Event e
LEFT OUTER JOIN
(SELECT EventID, Contact FROM UserEvent WHERE UserId = 10)
John Comerford schrieb:
Hi Folks,
I have a database running on Window XP, that I want to disable network
connections to and enable 'named pipes'. I am running MySQL 5.0.27
and my.ini looks like...
[...]
I can connect to the DB using the GUI tools if I set my pipe name to
52 matches
Mail list logo