Saqib Ali wrote:
Hello All,
What are best practices for deleting records in a DB. We need the
ability to restore the records.
Two obvious choices are:
1) Flag them deleted or undeleted
2) Move the deleted records to seperate table for deleted records.
We have a complex schema. However the t
Joeffrey Betita wrote:
hello
i just installed mysql-standard-4.1.13-pc-linux-gnu-i686.tar.gz,
httpd-2.0.54.tar.gz, php-5.0.4.tar.gz etc. on a Intel(R) Pentium(R) 4 CPU
2.40GHz with 1GB RAM this is just a temporary until we buy a new high end
server. my-large.cnf is the configuration in the /
hello
i just installed mysql-standard-4.1.13-pc-linux-gnu-i686.tar.gz,
httpd-2.0.54.tar.gz, php-5.0.4.tar.gz etc. on a Intel(R) Pentium(R) 4 CPU
2.40GHz with 1GB RAM this is just a temporary until we buy a new high end
server. my-large.cnf is the configuration in the /etc/my.cnf CentOS release
Hello.
Maybe. Use --skip-extended-insert in this case.
Sid Lane <[EMAIL PROTECTED]> wrote:
> I think I've foind the culprit:
>
> a problem (logical, not physical) had been discovered with a couple of
> tables which were fixed by truncating them in the production
> replication master and
Jeff Lacki wrote:
Ok I appear to have narrowed down the issue.
it appears to be the last table I had listed
named 'user_account1':
mysql> describe user_account1;
+-+--+--+-++---+
| Field | Type | Null | Key | Default| Ext
Sebastian <[EMAIL PROTECTED]> wrote on 08/11/2005 01:19:30 PM:
> well i managed to solve the problem myself, and im no sql genius...
> i thought i had an index on maps_rating.map which i didn't.. adding an
> index on it improved the query.
>
> i think that is about all the improvement i can get.
Ok I appear to have narrowed down the issue.
it appears to be the last table I had listed
named 'user_account1':
mysql> describe user_account1;
+-+--+--+-++---+
| Field | Type | Null | Key | Default| Extra |
+--
In the transaction isolation level,Database send some "duplicate entry"
message to me.
Why?
_
与联机的朋友进行交流,请使用 MSN Messenger: http://messenger.msn.com/cn
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/my
I am hosting on a RaQ4 which is terribly underpowered. Within a
minute of a reboot it's CPU and RAM are both red in the admin screen.
The app is optimized as much as possible but it just gets too much
traffic, too many MySQL connections. It's maxed out at 512K RAM.
I have a generic 2.5GHz P
Hi all ,
I have been experiencing intermittent locking issues with MYSQL. It
appears that sometimes a query will lock reliease its lock, and is
causing other queries to wait and wait until the connection limit is
reached and i am locked out of the database. Has anyone ever had
anything like t
C.F. Scheidecker Antunes wrote:
I will have the password stored in the database with MD5.
What I actually need is a manual way to get the password back, that is
decoding it.
The whole point of MD5 is that you cannot decode it once encoded.
When someone enters their password, just MD5 what th
C.F. Scheidecker Antunes wrote:
I am sorry. I meant another thing and wrote something else.
If I issue: INSERT INTO table1 values ('username',MD5('password'))
I will have the password stored in the database with MD5.
What I actually need is a manual way to get the password back, that is
dec
I am sorry. I meant another thing and wrote something else.
If I issue: INSERT INTO table1 values ('username',MD5('password'))
I will have the password stored in the database with MD5.
What I actually need is a manual way to get the password back, that is
decoding it.
By using a software th
MySQL actually has an MD5() function:
mysql> select MD5('password');
+--+
| MD5('password') |
+--+
| 5f4dcc3b5aa765d61d8327deb882cf99 |
+--+
1 row in set (0.18 sec)
Partha
--
Partha
Hello all,
Is there any function that I could use on a SQL statement to store a
password on a table manually using an algorithm like MD5?
Thanks,
C.F.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Im running a 2.8Ghz celeron P4, 1Gbyte RAM on
a 160Gb HD (IDE).
mysql> show variables;
+-++
| Variable_name | Value
|
+--
Am I doing something wrong, or does the innodb engine design preclude
loading a server with a readonly database snapshot?
I'm talking about 4.1.x (or maybe 4.x) and linux lvm snapshots (lvm2)
specifically about MySQL-4.1.12 (mysql-4.1.12-2.FC4.1.x86_64.rpm)
tested on an AMD-64 + FC4 (lin
Hello.
Maybe you had configuration file with different
settings. Nevertheless, send the information about
your RAM size, the output of SHOW VARIABLES,
configuration file, table definitions (use SHOW CREATE
TABLE), EXPLAIN output for your query, and list should
help you.
Jeff Lacki <[EM
Hello.
> i thought i had an index on maps_rating.map which i didn't.. adding an
> index on it improved the query.
Have a look here:
http://dev.mysql.com/doc/mysql/en/order-by-optimization.html
http://dev.mysql.com/doc/mysql/en/group-by-optimization.html
Sebastian <[EMAIL
Hello.
Maybe you have old includes too, use -I to specify the location of
4.1.13 includes.
Sujay Koduri <[EMAIL PROTECTED]> wrote:
>
> Hi gleb,
>
> I am including the packages which I tried to install along with the program
> and the error I am getting when I tried running it.
>
>
Hello.
You don't have enough free blocks in cache, and I guess it
has a big fragmentation. Follow recommendations from:
http://dev.mysql.com/doc/mysql/en/query-cache-configuration.html
Decrease the value of query_cache_min_res_unit and run
FLUSH QUERY CACHE from time to time.
"P
Hello.
Your program works for me. Try to explicitly specify the location
of libmysql using -L command line option for gcc. This link might
be helpful:
http://dev.mysql.com/doc/mysql/en/debugging-client.html
Sujay Koduri <[EMAIL PROTECTED]> wrote:
>
> Hi gleb,
>
> I am including
Hello.
[EMAIL PROTECTED] gleb]$ perror 2
OS error code 2: No such file or directory
Karam Chand <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I am running MySQL on a WinXP box. I am getting the
> following error:
>
> Error no: 12
> can't read dir of './tablename/' (errorcode: 2)
>
Hi,
I remembered something when playing wiht BLOB. It looks that the select
statement does not
work well with BLOB. It always add or modify the BLOB a little bit.
Later I found out that
the client programming interfaces, perl,C++ etc tend to do well on BLOB
and files.
Kemin
Gleb Paharenk
Good afternoon,
Our /var partition crashed last night, and as a result, several MySQL
tables were corrupted. After cleaning up the partition, we repaired
those tables via mysqlcheck.
When we started using the webapp built on top of those tables today,
we noticed that rows were missing from some
I use the -l to mysqld and I get
/usr/libexec/mysqld, Version: 3.23.58-log, started with:
Tcp port: 3306 Unix socket: /var/lib/mysql/mysql.sock
Time Id CommandArgument
050811 14:49:34 1 Connect Access denied for user: '[EMAIL PROTECTED]'
(Using password: YES)
05081
Sebastian wrote:
well i managed to solve the problem myself, and im no sql genius...
i thought i had an index on maps_rating.map which i didn't.. adding an
index on it improved the query.
i think that is about all the improvement i can get.. but if there is
still room for more speed i'd like
2005/8/11, Eric Jensen <[EMAIL PROTECTED]>:
> I am looking into using the FULLTEXT search features for our FAQ
> system. Problem is the 50% limitation. We aren't going to have
> thousands of questions or articles, so the odds of most of the
> questions/articles matching is high and a desireable e
I am looking into using the FULLTEXT search features for our FAQ
system. Problem is the 50% limitation. We aren't going to have
thousands of questions or articles, so the odds of most of the
questions/articles matching is high and a desireable effect for us. Is
there a away to disable this requi
Saqib Ali wrote:
Hello All,
What are best practices for deleting records in a DB. We need the
ability to restore the records.
Two obvious choices are:
1) Flag them deleted or undeleted
2) Move the deleted records to seperate table for deleted records.
The first is what I like more.
While in
Paco Martinez Rodriguez wrote:
Hi..
I'm using "cache queries" with MySQL 4.0.13 during three days and I get
a little better speed.
Value of Query_cache_size = 20 Mb.
This is 20 Mega Bits. I suppose you meant to mean 20 MegaBytes (20MB),
or even 20 Mibibytes (20MiB).
I have two questions.
Hello All,
What are best practices for deleting records in a DB. We need the
ability to restore the records.
Two obvious choices are:
1) Flag them deleted or undeleted
2) Move the deleted records to seperate table for deleted records.
We have a complex schema. However the the records that need
well i managed to solve the problem myself, and im no sql genius...
i thought i had an index on maps_rating.map which i didn't.. adding an
index on it improved the query.
i think that is about all the improvement i can get.. but if there is
still room for more speed i'd like to know..
Sebast
Hello-
I have a user list of about 200 entries
My original config was Fedora Core 3, Mysql 3.23
I upgraded today to Fedora Core 4 which comes with
MySQL 4.12. AFter updating all the packages etc
and setting up the website I run again, I notice
that I had slow query's during searches.
More in
Hello,
I am running MySQL on a WinXP box. I am getting the
following error:
Error no: 12
can't read dir of './tablename/' (errorcode: 2)
What does this error mean?
Karam
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection a
Jigal van Hemert wrote:
Sebastian wrote:
this query runs slow because AVG and COUNT on maps_rating table i think.
can anything be done to improve?
You may want to include:
- table definitions (output of SHOW CREATE TABLE )
- output of EXPLAIN
sorry for the lack of info.
there are a coupl
I think I've foind the culprit:
a problem (logical, not physical) had been discovered with a couple of
tables which were fixed by truncating them in the production
replication master and reloading them from a mysqldump of the
corrected tables from the qc/dev database. the dump was done w/the -e
(
Hi..
I'm using "cache queries" with MySQL 4.0.13 during three days and I get
a little better speed.
Value of Query_cache_size = 20 Mb.
I have two questions.
1.- Is there any way to see which queries are being stored ??
2.- How can I delay "qcache_lowmen_pruenes" ?? In three day values of it
i
Ok ,thanks.
I did notice that it effectively 'ignored' vendor and brought back a random
vendor. In this case it ignored b and returned a but still used b's price
in the total. Just something for me to remember I guess. Thanks for the
response.
-Original Message-
From: Scott Noyes [mai
Scott Noyes wrote:
It appears that you don't need to
specify in the Group By clause all the columns that are referenced without
an aggregate function
True.
For example this query would be invalid in MSSQL but
valid in MySQL:
select id, vendor, sum(price)
from p
group by id
In this cas
> It appears that you don't need to
> specify in the Group By clause all the columns that are referenced without
> an aggregate function
True.
> For example this query would be invalid in MSSQL but
> valid in MySQL:
>
> select id, vendor, sum(price)
> from p
> group by id
In this case, `vendor
Can I just ask a quick question about this one, mainly about the Group By
statement and how its used in MySQL. It appears that you don't need to
specify in the Group By clause all the columns that are referenced without
an aggregate function i.e vendor is missed out from: GROUP BY p3.id,
p3.price.
Never mind. I figured it out. I had to run the install_db script as
mysql user.
Gobi wrote:
I find that I can start mysqld by using the "--skip-grant-tables"
option but as soon as I run mysqld without that option, it dies
again. I did try running "mysql_install_db --user=mysql" but when I
I find that I can start mysqld by using the "--skip-grant-tables" option
but as soon as I run mysqld without that option, it dies again. I did
try running "mysql_install_db --user=mysql" but when I did "mysqlshow
mysql", it was empty.
Any ideas on how to proceed?
Thanks,
Michael.
Gleb Paha
Hi gleb,
I am including the packages which I tried to install along with the program
and the error I am getting when I tried running it.
Packages
MySQL-client-4.1.13-0.i386.rpm
MySQL-server-4.1.13-0.i386.rpm
MySQL-devel-4.1.13-0.i386.rpm
MySQL-shared-standard-4.1.13-0.rhel3.i386.rpm
The error
Hello.
Use DUMPFILE instead of OUTFILE. See:
http://dev.mysql.com/doc/mysql/en/select.html
jose nuno neto <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm trying to use MySQL Blob columns to store files (docs,gifs,pdf.) but
> I'm getting corrupted files from the DB.
>
> the applicat
Is there any way to have MySQL generate a log of successful/failed login
attempts? Or even better: have this information sent to syslog?
(using mysql 4.1)
signature.asc
Description: OpenPGP digital signature
Hello.
Check that mysql_install_db filled mysql database in the same directory
as your datadir. See:
http://dev.mysql.com/doc/mysql/en/unix-post-installation.html
Gobi <[EMAIL PROTECTED]> wrote:
> Thanks for your reply. I confirmed that user and group, mysql, exists
> and performe
Hello.
I've created tables similar to your and the query runs fast enough
on my test data (maybe I have good indexes). Please, provide the
EXPLAIN output for your query and exact definitions of your tables
(use SHOW CREATE TABLE).
Sebastian <[EMAIL PROTECTED]> wrote:
> this query runs
Hello.
I'm not sure about the speed of this query, but it seems to work:
mysql> source g.sql
+---+---++
| id| price | vendor |
+---+---++
| OG012 |20 | b |
| OG013 |40 | c |
+---+---++
[EMAIL PROTECTED] mysql-deb
Hello.
I guess you have rpm installation, rpm -e should help you in this case.
Find installed mysql packets with `rpm -qa |grep -i mysql` command.
If you have troubles with making a choice, send the list of packets
which you got to the list.
Sujay Koduri <[EMAIL PROTECTED]> wrote:
>
>
Hello.
In my opinion, it means that user [EMAIL PROTECTED]
is able to create table address in your current
database (SHOW GRANTS shows that the name of the
database is implicitly added to the table name).
"Martijn Tonies" <[EMAIL PROTECTED]> wrote:
> Hi there,
>
> What is the purpose
Hello.
Comments to this bug might be interesting for you:
http://bugs.mysql.com/bug.php?id=9056
Karam Chand <[EMAIL PROTECTED]> wrote:
> I plan to modify mysqldump and mysql import utility to
> support SP, Triggers etc and plan to send a patch to
> the MySQL development tree.
>
> Thu
Hi,
I'm trying to use MySQL Blob columns to store files (docs,gifs,pdf.) but
I'm getting corrupted files from the DB.
the applications runs php, loading file content with addslashes but in order
to spot the error i've tried it with mysql only like this:
column file is a MEDIUMBLOB
INSERT IN
Sorry , I didn't send this in person to you intentionally.
sujay
-Original Message-
From: Martijn Tonies [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 11, 2005 2:42 PM
To: Sujay Koduri
Subject: Re: Uninstalling the MySQL cleanly.
.
>
> OS is RH9 and kernel is 2.4.20
I suggest you
> Can any one list the steps or give me any pointers how to cleanly
uninstall
> an upper version of MySQL,
> so that after wards if we install lower version it should not be affected
by
> any left overs of the previous installation.
What OS?
With regards,
Martijn Tonies
Database Workbench - too
hi,
Can any one list the steps or give me any pointers how to cleanly uninstall
an upper version of MySQL,
so that after wards if we install lower version it should not be affected by
any left overs of the previous installation.
Thank you
sujay
Hello Ben!
I am in no ways a socket expert, so I can only provide a general remark
and pass on what I got from hearsay (below):
When pursuing such things, please provide information about the
operating systems used, client/server assignment etc.
Gleb Paharenko wrote:
Hello.
MySQL usually
Hi,
I imagine there should be an option to disable yaSSL.
if you use ./configure you have to explicitely add --with-yassl to
enable it (which is not what you want I presume).
HIMH
Karam Chand wrote:
I plan to modify mysqldump and mysql import utility to
support SP, Triggers etc and plan to se
Sujay Koduri wrote:
I was connecting to MySQL 5.0.4 through the C API and it was workign fine.
But when I downgraded to MYSQL 4.1.13, the same code is giving the following
error.
Try rebuilding your program against the v4.1 APIs.
--
MySQL General Mailing List
For list archives: http://lists.
Marco wrote:
So how can I do that?
There's nothing special you need to do with MySQL itself. Somehow your
program obtains UTF-8 data. Insert said data into database. That's it.
Perhaps you should read up on UTF-8, to see why this is so.
Again, don't expect the database server to be able
Thanks a lot guys. I tried my insert using MYSQL Query Browser and
manage to insert the syslog. Remo, you're correct, the Windows Command
prompt limitation is the cause since i'm using windows xp cmd.exe.
I'll try to do import as you've suggested.
What a relief, i can proceed in building my syslog
Have you adjusted your queries? MSSQL uses a different dialect (T-SQL),
then MySQL uses. There are quite some difference, although some queries
still might work.
Arjan.
-Original Message-
From: John c [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 10, 2005 08:12 PM
To: mysql@li
I think it's not fair to expect the list to reply with the kind of
information you have provided.
Are these tables indexed et all? What indices are you using? Have you tried
to see what "explain" tell you about the plan the optimizer will use to
execute the query?
Rest assured, you surely stand a
Sebastian wrote:
this query runs slow because AVG and COUNT on maps_rating table i think.
can anything be done to improve?
You may want to include:
- table definitions (output of SHOW CREATE TABLE )
- output of EXPLAIN
This way the list members can make better suggestions.
Regards, Jigal.
-
65 matches
Mail list logo