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 err
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 PI
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 f
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
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
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
degrad
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 'mysq
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 "da
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 "da
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 (Silic
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 o
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 ta
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
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 wrote:
> 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
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. Punc
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 a
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
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 request
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, pp
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'r
21 matches
Mail list logo
