On 7/13/06, Jim Winstead [EMAIL PROTECTED] wrote:
Sounds like the well-known problem with Debian stable's glibc on x86_64:
http://hashmysql.org/index.php?title=Opteron_HOWTO#pthread_rwlock_wrlock_hang_with_nptl
Any other ideas or suggestions?
We've upgraded to libc 2.3.6 from etch, and we're
Hello,
Nearly once or twice a day the mysql daemon on our FreeBSD server has to
be restarted since it is taking up most of the processor.
One of the entries in our slow_queries log looks like this;
# Query_time: 14074 Lock_time: 0 Rows_sent: 11 Rows_examined:
1020472928
SELECT pp.art_num,
Hello again
Finaly looking in the old doc, I saw that mysql was compiled on Solaris 2.6 and
I have the following track for the configure step at that time:
checking for CFLAGS value to request large file support... -D_LARGEFILE_SOURCE -
D_FILE_OFFSET_BITS=64
checking for LDFLAGS value to
At 09:15 AM 7/14/2006, Jeremiah Foster wrote:
Hello,
Nearly once or twice a day the mysql daemon on our FreeBSD server has to
be restarted since it is taking up most of the processor.
One of the entries in our slow_queries log looks like this;
# Query_time: 14074 Lock_time: 0 Rows_sent: 11
Aaaah the joys of importing data from FileMaker. Repeating fields, gr.
You need to do an ASCII/CHAR conversion since vertical tab is a non-printable
character.
select *
from accounts
where billing_address_street LIKE CONCAT(%,CHAR(11),%)
Since this is problem a one shot deal and you are
Most of the queries you listed below probably aren't taking advantage of the full text index. MySQL doesn't consider song.mp3 or
document.pdf words, they would be considered two words because the period is considered a word separator. Keep in mind MySQL indexes
words not character strings.
We're using Opterons, Linux 2.6.x, and a SiL (Silicon Image) SATA
chipset whose particular model number I don't have in front of me.
After MUCH MUCH MUCH trial and error we've discovered that:
1) 2.6.16 substantially alleviates the problem but doesn't eliminate it.
2) There is a 3Ware card
Brent,
Both worked like a charm. Thank you so much.
I kicked myself for not thinking of CONCAT.
Yes, Filemaker joy. Actually I have another word in mind. But with
you help and expertise we are slowly walking away from Filemaker.
Erik
On Jul 14, 2006, at 7:02 AM, Brent Baisley
Let me ask the following (Chris):
Is it wise to partition things such that /data and /binlogs are on two
different partitions? That way, the binary log(s) can't fill up the /data
drive. If so, is there a guideline for how much space to save for binary
logs? Or do you just keep both the DBs and
Hello,
My mysql server sometime just slows responding to database queriesIt
is as slow as less than 1 per sec.
But it speeds up by itself after some time , I have noticed that when it
speeds up there are lot more MYsql thread than just one thread when it
is slow.
Here is the top output
Hello everyone,
I would like to inform y'all that we have launched a carnival of the
vanities for the DBA world. We are hosting the first one but we would love
to call for volunteers to:
1) submit articles for next week's, which we will probably host as well, and
2) volunteer to host a future
It was my impression, from the information we've collected that our
problem is very specific to Opteron. It's possible that your problem
is actually unrelated. :(
-JF
On Jul 14, 2006, at 7:24 AM, living liquid|Christian Meisinger wrote:
We're using Opterons, Linux 2.6.x, and a SiL
I've found something that works (in MySQL 5, anyway), but I don't
know whether it's accepted practice.
If I want to find all records with a date in, say, March 2006, it
works if I use datefield like '2006-03%' because it's a string.
This seems kind of obvious and a lot tidier than doing
I've found something that works (in MySQL 5, anyway), but I don't know
whether it's accepted practice.
If I want to find all records with a date in, say, March 2006, it works if I
use datefield like '2006-03%' because it's a string.
This seems kind of obvious and a lot tidier than doing
Hi,
Recently, I built mysql5.0 on Solaris 10 amd64, but when running make
test, the bundled sp test failed
with the following error:
mysqltest: At line 1527: query 'call fib(20)' failed: 1436: Thread stack
overrun: 186944 bytes used of a 262144 byte stack, and 81920 bytes
needed. Use 'mysqld
Hi -
I was wondering if there was a way to have a less verbose --log. All I
want to see is connects, disconnects, and if they're successful or not.
The reason I ask is because this server runs thousands of queries a
minute, and I'd rather not log *all* data for reasons of performance
Hi Jenny
Jenny Chen wrote:
Hi,
Recently, I built mysql5.0 on Solaris 10 amd64, but when running make
test, the bundled sp test failed
with the following error:
mysqltest: At line 1527: query 'call fib(20)' failed: 1436: Thread stack
overrun: 186944 bytes used of a 262144 byte stack, and
Hi People
I want make a partition using a Lineas Hash, but i need use mu personal
function how hash key, show my function and my create table and error
--- Function ---
CREATE FUNCTION Get_Client_Creative (creative INT) RETURNS INT
BEGIN
DECLARE client INT;
SELECT P.client_id into client FROM
It may not be odd to many but I can't seem to think of how to do this
I have 2 queries below that give me exactly what I want each to do but
now I want to combing them is such a way that in the second query I have
one additional column that gives me a 1 on a row where the PID would be
in
Chris W wrote:
It may not be odd to many but I can't seem to think of how to do this
I have 2 queries below that give me exactly what I want each to do but
now I want to combing them is such a way that in the second query I
have one additional column that gives me a 1 on a row where the
MySQL List,
This is an issue that I am also pursuing on the PHP list, but since it
involved my MySQL my.cnf file, and also use of MySQL sockets, I'm
posting here in hopes of finding additional assistance.
To make a long story short, while installing Zend Studio (a PHP IDE), I
was getting
21 matches
Mail list logo