I know that I should use mysqlbug to report bugs, but my mysqlbug prints
mysqlbug: problem report sent
Description:
When there are rows in mysql.columns_priv table
query flush privileges stalls when query repeatly.
How-To-Repeat:
Insert some rows in mysql.columns_priv table.
Try
I think you are looking for a backup solution.
This script is awesome for automatic
daily/weekly/monthly backups (and compresses them)
http://members.lycos.co.uk/wipe_out/automysqlbackup/
http://sourceforge.net/projects/automysqlbackup/
To recreate the database from a backup: copy the
backup
Hello,
This morning I got a crash from two mysql servers (one master, one
slave). The stack trace is the following on both :
0x8071f44 handle_segfault + 420
0x82a0e38 pthread_sighandler + 184
0x82f09c8 _dl_relocate_object + 1208
0x82d1e4f dl_open_worker + 879
0x82d137a _dl_catch_error + 154
Hi,
have you got a file :
/var/lib/mysql/mysql.sock
if yes and no mysql is running, remove it ?
[EMAIL PROTECTED] wrote:
Hmm...can someone help me on this? Many thanks.
- Forwarded by Joseph S CHUNG/OGCIO/HKSARG on 2004-07-12 09:40 -
Problem solved. Thank you very much.
juhui
Hi All,
I migrated the data from Oracle to MySQL.The following query works fine with Oracle
whereas in MySql its hanging.
SELECT distinct caty.name, caty.c_id, caty.notes, count(distinct segs.in_id) as num
FROM segs, caty, st_mbers, t_mbers, p_mbrs, pr_mbers
where segs.c_id = caty.c_id and
Hi,
It suggests below to bundle transactions into one commit, at what point does
this become unecessary ?
For example I have 2 threads each doing 12,000 inserts in 1 commit each.
Would I really gain any performance if I did these 24,000 inserts in 1
commit only ?
Additionally, what
i am running mysql 4.0 in fedora core2. It is working ok. Now i want to
connect other clients to the same server.
How to this? i read the docs but couldn't make it work.
thanks for any pointers.
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side
Hi,
since I installed mysql server 4.0 i cannot start mysqld daemon. I go to
/usr/bin and execute mysqld, but i get the following message:
[EMAIL PROTECTED] bin]# safe_mysqld
Starting mysqld daemon with databases from /var/lib/mysql
040712 11:33:07 mysqld ended
How can i know what's the
After installing FC2 i realized that the mysql server version installed
was 3.x. I wanted to install version 4.0, so i got the rpm
package from mysql website and i installed it on my system.
Now it seems like mysql server is not running. I get no output for the
command ps -A | grep mysql. Also,
This is an index problem. Your tables don't contain any indices except on
PKs. This can't work, given the number of joins and table sizes. Read the
doc about indices.
Stefan
Am Monday 12 July 2004 09:55 schrieb Jeyabalan Murugesan Sankarasubramanian:
Hi All,
I migrated the data from Oracle to
Hi,
After downgrading to the 4.0.15 provided by Mandrake, we found a more
explicit message : cannot found xxx function, which was one of our UDF.
we recompile the UDF with the extern C (not needed on our dev. server,
which is strange...), and everything is fine now.
When one query :
INSERT INTO
I know the boat has probably sailed by now on this thread, but as far as I
saw nobody has thrown in what I was going to say.
A simple blanket statement like Design for understanding, logic and
maintenance, not performance. is a little too glossy.
You can't put all database usage into the
Hello,
Happen to come accross this articale
http://www.securiteam.com/unixfocus/5BP0420DFQ.html
and was wondering, using 4.0.20, if we need to make some changes or has this
been addressed by MySQL staff ??
TIA,
--
MikemickaloBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet
Using 4.1.3 beta (InnoDB) on XP, via ColdFusion MX
I have a table containing (among other things) a list of dates for soccer
matches to be played. In order to list them correctly, the SQL has been:
SELECT DISTINCT fixturedate,
MONTH(fixturedate) AS CalMonth
FROM Fixtures
ORDER BY
Hi,
We try to upgrade to 4.0.20, but we still have a crash on startup. Is
there any binaries compatibilities regarding the binairies provided by
MySQL ?
Philippe Poelvoorde wrote:
Hi,
After downgrading to the 4.0.15 provided by Mandrake, we found a more
explicit message : cannot found xxx
Hello, I am a programmer in Korea.
I have a problem with MySQL Control Center font script configuration.
In options - fonts - application font, I selected options like below :
Font : gulim (Korean font)
Script : hangul (Korean)
and I clicked 'OK' button.
But when I open 'application font' window
when is mysql 4.1.x going to be released for production?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi all,
I have an audio tracks info table, let's call it Tracks;
every Track can have one or more ' Character' ( it is not a genre, it
is something like 'Italian' or 'International' or '80's' or 'evergreen'
)
so a track can be 'International' and 'Evergreen', or 'Italian' and
'70's')
I have
What about having a column for each genre, so tracks would look like:
id, title, artist, gItalian, gInternational, g80, g70
the genres are of type int so 1 for yes 0 for no.
then just do SELECT * FROM tracks WHERE g80 = 1 AND gItalian = 1
Not the most dynamic of solutions, but as your genre
Hi,
often my slave suddenly stops, reporting these the logs:
040712 12:19:00 Slave I/O thread exiting, read up to log 'db-bin.3323',
position 197564621
040712 12:19:10 Slave I/O thread: connected to master
'[EMAIL PROTECTED]:3306', replication started in log 'db-bin.3323' at
position
On Mon, 12 Jul 2004 12:05:53 +
Ben David, Tomer [EMAIL PROTECTED] wrote:
when is mysql 4.1.x going to be released for production?
When it is ready I'd guess. :)
If history is a predictor though I would expect 4.1.x to go though 5-7 more beta
releases though. Help the developers out by
If what you mean by most recent are the products with the latest
'post_date', try this:
SELECT ID, title, max(s.post_date) as post_date
FROM product p
join e_prod ep on ep.product=p.id
join story s on s.id = ep.story and s.status = 9 and s.type = 14
where p.platform_id = 5 and p.genre_id = 23282
It sounds as though you don't want to see how many rows are returned for
the users column but rather how many distinct names are in that column;
you need a COUNT(DISTINCT). Your GROUP BY clause is also off as it does not
list all of the non-aggregated columns in your SELECT statement. See if
this
Harald Fuchs wrote:
In article [EMAIL PROTECTED],
gerald_clark [EMAIL PROTECTED] writes:
Asif Iqbal wrote:
Jack Coxen wrote:
If you database contains time-based data you could age out old records. I
only need to keep data for 6 months so I run a nightly script to delete any
To debug the problem. Make SHOW SLAVE STATUS in the slave and check for
the error number..
Best Regards,
Cemal Dalar a.k.a Jimmy
System Administrator Web Developer
http://www.gittigidiyor.com http://www.dalar.net
- Original Message -
From: Nico Sabbi [EMAIL PROTECTED]
To: [EMAIL
Dear list,
After posting a question last week from an email address I only use for this list, I
have already started to receive spam and virus reports.
Looking at the archives at lists.mysql.com I notice that the from address is not
shown, just the name.
But...
If someone else quotes your
Ian,
note that the MySQL mailing list is also forwarded to the
mailing.database.myodbc Usenet group, as well as to several mailing list
archiving websites. Spam robots and viruses have plenty of places from which
to harvest your email address if you write to this list.
I personally receive some
Robert,
No problem. I actually considered the PHP option, and usually do since
I use it quite a bit. However, what I was trying to accomplish was only
a one time thing so I just decided to do it all with queries. Thank you
though for your helpfulness, and everyone else too. What did I ever do
Hi,
I use the following query to extract information about a practice in my
database. However if the practice system id hasnt been set then the query
won't work.
SELECT P.*, S.System_Name FROM Practices P, Systems S WHERE P.Practice_ID =
'.$_SESSION['ses_practice_id'].' AND S.System_ID =
If I understand you correctly, you need a query that will return for 1
user's available hours for the next 10 days. (Since you didn't use any of
the new datetime functions that were added recently to MySQL, I assume you
are using a version 4.x)
SELECT User_ID
,
On Mon, Jul 12, 2004 at 05:28:04PM +0300, Heikki Tuuri wrote the following:
Ian,
note that the MySQL mailing list is also forwarded to the
mailing.database.myodbc Usenet group, as well as to several mailing list
archiving websites. Spam robots and viruses have plenty of places from which
to
Ian Gibbons wrote:
If someone else quotes your message in a reply ( which is considered best practice
in all mailing list I have ever been a member of ) email addresses are displayed.
I quote you. Now where is an email address displayed?
I understand that my address could have ( and is
I am an anal single query-oholic. I know I could do this in 2 queries
I have a query involving several related tables and I have attempted
to reduce it down to what causes not what I want results.
I am attempting to fill a summary table.
For each main item in this table I want to count the number
hi,
i have a very serious problem, when i try to
reinitialise the database and start my application.
By reinitilisation i would remove the database i
created along with the UDF functions i created. Then
when i try to start my application, which creates the
database tables and the UDf, MySQL
This sequence causes the same errors:
ALTER TABLE postsearch DISABLE KEYS;
delete from postsearch where postId=65031 limit 1;
ALTER TABLE postsearch ENABLE KEYS;
#1034 - Incorrect key file for table: 'postsearch'. Try to repair it
Could this be a bug, as hinted at here by people using 4.1:
Hi,
I've got approx. the same pb. Try the MySQL package provided by you
favorite distro, recompile, and see if it works. I have no clue where
the problem comes from.
Prem Soman wrote:
hi,
i have a very serious problem, when i try to
reinitialise the database and start my application.
By
I've found a solution so I'm answering to myself, for who can be
interested and for asking if I've done something that could affect on
some way my DB performances.
I've added an index to both the columns that I use for the ON clause of
my left join query, and now it runs at the speed of
Hi Doug,
I looked at it again and noticed a relationship that I missed before. You
*do* have loc_countries_lang associated to the other tables through the
loc_countries table. Sorry I missed it last time.
I also noticed that you wrote this from the bottom up you started with
the most detailed
Do you have all of the right indexes on your tables to assist MySQL in
creating your JOIN? Show us the results of SHOW CREATE TABLE for your 3
tables, please...
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
|-+
| |
David,
I *really* do not like to be critical. However, for the sake of the newer
DBAs out there I feel the need to discourage your suggestion.
Your idea would work but I would not recommend it under most circumstances.
Breaking normalization should only be used as a tool of last resort when
you
Da: [EMAIL PROTECTED]
Oggetto:Re: can you help me optimizing this query?
Data: 12 luglio 2004 19:10:36 CET
A:[EMAIL PROTECTED]
Hi Shawn, this is the last version of my intermediate table.
with this version the query is absolute speedy. I have
Hi All,
I'm currently engaged in a project to implement full text searching
of our product database. The current implementation was written for an
older version of MySQL and doesn't implement BOOLEAN MODE.
Currently, the full text search is against a de-normalised table from
fields icluding the
Hello,
I am a newbie to mysql and have one major task to accomplish in order
perform my duties. I have a few excel files that have a few hundred to a
thousand columns, with each column consisting of a
title/category, and thousands of bits of information (decimals) under each
category. What
You can use a programming language to read the first line of the files and
create a DDL statement for you. But MySQL will not do this natively. I am
not certain but I think you may be able to use Visual Basic and the excel
DOM to perform the entire process. Or you can just export the data into a
brpm -qa|grep mysql/b will show you what mysql
packages you have installed.
You probably have both 3.x and 4.x packages installed
and assuming you don't have a 3.x database you want to
preserve, I would suggest uninstalling the 3.x package
with brpm --erase iname_of_3.x_package/i/b
To determine
Hello , I hope you could help me. I have a small difference in te result of this query
QUERY
SELECT `an0300_polizas_desgloce`.cuenta,
`an0200_polizas`.fecha,
sum(`an0300_polizas_desgloce`.debito),
sum(`an0300_polizas_desgloce`.credito),
Keep in mind that if you create an index on multiple
fields, then all of those fields must be searched at
once. You can't index product_name, product_desc and
product_category for instance, then only search on the
product_name field using MATCHES.
If you want to bypass this (and many other
5-7 more beta releases
How much time is 1 beta release taking (approxiamtly)
Thanks :)
Original Message:
From: Josh Trutwin [EMAIL PROTECTED]
To:
CC: [EMAIL PROTECTED]
Subject: Re: When is mysql 4.1.x , production?
Date: Mon Jul 12 16:41:32 GMT 2004
On Mon, 12 Jul 2004 12:05:53 +
Ben
David,
This sounds vaguely like a normalization issue as well. If your data
consists of one or more identifying columns and the rest the columns
exist data as explanatory data then you should probably think about
scripting an import routine. Do you see repetitive blocks of data in the
(probably)
This query will show you a list of all Vendor, ID combinations, and how
many times they appear if they appear more than once in your data:
SELECT Vendor, ID, Count(1) as dupes
FROM name_of_your_table_goes_here
GROUP BY Vendor, ID
HAVING Count(1) 1
Yours,
Shawn Green
Database Administrator
Thanks for the response
well i guess a backup is just copying the DB records from one pace to another
and is a solution however I need something more precise, could someone point to
a good reference on mapping tables and a good programming language to execute an
updating process please
Andrew
I have 4 servers in my environment:
DEPOT - master server
WWW1 - web server #1
WWW2 - web server #2
WWW3 - web server #3
The web servers record web metrics to local mysql databases. I would like
those local databases to be consolidated onto the DEPOT [as three separate
DBs]. Is
On Mon, Jul 12, 2004 at 03:49:33PM -0400, Marc Knoop wrote:
I have 4 servers in my environment:
DEPOT - master server
WWW1 - web server #1
WWW2 - web server #2
WWW3 - web server #3
The web servers record web metrics to local mysql databases. I would like
those local databases
Could someone who has experience with handling the Unicode character
set in a MySQL database please write to me? In particular, I am trying
to discover how in an ASCII-limited environment one can specify
non-ASCII characters; I do know their Unicode encodings, just not how
to write an INSERT
You need to use 2 LEFT JOINS:
SELECT a.*
FROM tablea a
LEFT JOIN table b
ON a.id = b.a_id
LEFT JOIN table c
ON a.id = c.a_id
WHERE b.id is null
AND c.id is null
and check for both joined tables to return null values.
Yours,
Shawn Green
Database Administrator
Unimin
2004-07-10 08:56
mysqld.log-20040710.gz
-rw-rw1 mysqldaemon237 2004-07-11 11:55
mysqld.log-20040712.gz
-rw-rw1 mysqldaemon 5 2004-07-12 15:58 mysqld.pid
srwxrwxrwx1 mysqldaemon 0 2004-07-12 15:58 mysql.sock
drwx--2 mysqldaemon
You need DISTINCT to make the COUNT() function ignore duplicate values.
SELECT e.e_id
, e.e_code
, COUNT(DISTINCT qxe.q_id) as e_count
, avg(ratings.r_quality) as avqual
FROM e, qxe, ratings
WHERE e.e_id = qxe.e_id
AND ratings.e_id = e.e_id
AND ratings.q_id =
Quoting Marvin Wright [EMAIL PROTECTED]:
Hi,
It suggests below to bundle transactions into one commit, at what point does
this become unecessary ?
For example I have 2 threads each doing 12,000 inserts in 1 commit each.
Would I really gain any performance if I did these 24,000 inserts in 1
A beta takes as long as a beta takes. That is really
the nature of beta testing. As for an approximate
timeline, I've heard various quotes, but most people
seem to think somewhere late third quarter that the
release will be marked stable.
4.1.3 is really quite stable and you should have very
mysqld.log-20040712.gz
-rw-rw1 mysqldaemon 5 2004-07-12 15:58 mysqld.pid
srwxrwxrwx1 mysqldaemon 0 2004-07-12 15:58 mysql.sock
drwx--2 mysqldaemon816 2004-06-28 15:29 phpmyadmin
drwx--2 mysqldaemon 48 2003-11-12 18:13 test
Any
Thanks for the reply Shawn. When I ran your version, I noticed that my
'devices' column was off by a multiplier of 3 (that is, it said 9 rather
than 3, or 15 rather than 5, etc.) Turns out, it just needed another
DISTINCT in there. So, for those playing along at home, here is the final
working
It sounds like you are missing indexes.
Please post the results of -
SHOW CREATE TABLE ImportLiebermansStep3Add;
- and -
SHOW CREATE TABLE ProductsOld;
- and we can tell you if you have enough indexes or not.
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
I've been comparing the performance of 4.1 with the MySQL 3.23.58 that came
with our Rocks cluster software.
I'm finding that 4.1 is running approximately 1/3 slower (e.g. a 0.075
second query goes to 0.100 seconds) than 3.23.58. Size of buffers, etc.
seems to have little effect. The
Keep in mind that a major limitation of the mysql
fulltext engine is that it can't index more than 500
characters which could be a major drawback for your
parametric data.
Just some genral qiuestions,
Does that mean the max. string that can be indexed
and therefore searched on is 500
On Mon, Jul 12, 2004 at 10:14:09AM +0800, Linda wrote:
Hi Jeremy,
I didn't find any resouce limit but the performace is very bad. Do you have
any suggestion how to tune the solaris to provide the better performance for
Solaris?
Well, MySQL doesn't just randomly slow down. There's either a
Does that mean the max. string that can be indexed
and therefore searched on is 500 chars? What exactly
is this limitation?
I may have been wrong on this limit. I know I read
about it somewhere, but I can't seem to find out where
at the moment. Since the fulltext index is maintained
as a
I was wondering if it's possible to create a field in a MySQL Databse
that automatically creates unique field values for use as a password for
example
Michael Mason
Business Support Services
Arras People
Tel: 01706 342310
Mobile: 07793
782287
Fax: 01706 642754
Member of
Please let me show you one (TEXT data-type) item example. You will see
Title_[ ... Author[ ...Resp_Org__[... Obviously, I don't want
those strings searchable, they are headings, but I do want the content
to the right of them indexed and searchable. So looking at it - what
should I put in
Could someone who has experience with handling the Unicode character
set in a MySQL database please write to me? In particular, I am
trying
to discover how in an ASCII-limited environment one can specify
non-ASCII characters; I do know their Unicode encodings, just not how
to write an
If you start if from root, please make sure to use option --user=mysql.
Please check mysqld.log file and see if there is any tips. Good luck.
Check out the manual section about replication.
http://dev.mysql.com/doc/mysql/en/Replication.html
Also read the user comments, sometimes you will find
useful code snippets and URLs.
PHP or perl would be my language of choice. A PHP
solution is mentioned in the user comments of the
above URL.
Hi,
How do we take the backup of Stored Procedures in MySQL?
And, how can we restore them back?
I saw that proc.myd and proc.myi are created within the MySQL Database.
Copying them could be one option. Is there any built-in way to achieve
the same?
Thanks,
Nawal Lodha
73 matches
Mail list logo