Have a query that consists of 10 unions. For a period of time it will
constantly return with an error 12. Moments later it might actually
work once or twice. I can find nothing in any logs or whatever. The
odd thing is that when it isn't working, simply reducing the unions to 8
or less returns
the query?
Cliff
Donny Simonton <[EMAIL PROTECTED]> writes:
> Use insert delayed, and you will cut your time in half. At least with my
> experience. But also how long does it actually take to run the query
> itself. Giving a summary explain doesn't help much. You really nee
ink.
2) I already have that index. It's a Primary Key(month_day, src,
bucket). I'm still confused on how the index will speed it up
on the source table side.
We are NOT I/O bound. Looks more like cpu bound to me. Mysql uses 25%
cpu on the solaris which is 1 entire cpu on a 4 processor mac
Chris Nolan" <[EMAIL PROTECTED]>
To: "Sasha Pachev" <[EMAIL PROTECTED]>
Cc: "Cliff" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, March 09, 2004 7:14 PM
Subject: Re: InnoDB tables using 90% cpu
> Sasha Pachev wrote:
>
> > Cliff
this been resolved or is should I recompile? I am using native freebsd
threads.
- Original Message -
From: "Sasha Pachev" <[EMAIL PROTECTED]>
To: "Cliff" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, March 08, 2004 9:18 AM
Subject: Re:
Hi, I have a whole database I wanted to convert to InnoDB from MyISAM, but
do not want to use alter table because of the problems I had last time. I
made a whole dump of the table using mysqldump and changed all of the table
create definitions from MyISAM to InnoDB. Theoretically this should be jus
Thanks to everyone who helped. It turned out that we added an index to the
table that was not in the frm file. This apparently causes innodb tables to
have weird behavior, but nonetheless it is solved. Thanks!
- Original Message -
From: "Sasha Pachev" <[EMAIL PROTECTED
: Thursday, March 04, 2004 1:24 PM
Subject: Re: Major problem converting MyISAM to InnoDB
> Cliff,
>
> - Original Message -
> From: ""Cliff"" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.myodbc
> Sent: Thursday, March 04, 2004 7:07 PM
&g
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 04, 2004 1:24 PM
Subject: Re: Major problem converting MyISAM to InnoDB
> Cliff,
>
> - Original Message -
> From: "&q
nal Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 04, 2004 12:36 AM
Subject: Re: Major problem converting MyISAM to InnoDB
> Cliff,
>
> please run
>
> CHECK TABLE ...
>
> on your table and look if mysql
Recently I tried to convert our largest table from MyISAM to InnoDB. During
the process I believe there was a problem where something was corrupt along
the way. It was stupid, but I did not verify that our backup system was
working correctly, since I assumed it had been running as usual. It was not
into it's own little program, it
works fine. i.e. I build a C program whose main does nothing but call the
connect function. Compiles/runs with no coredump.
Cliff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
his code works fine on the old
system. If I pull it out into it's own little test program on the new
server, it also works fine. But when I put it in with the analog source
code, it compiles fine but the mysql_real_connect causes a core dump when
run.
Running 4.0.17 on FreeBSD 4.9R
Any
Hi, I am running 4.0.14 on a FreeBSD 4.8-STABLE machine (upgraded to CVS
from last week) and I am having a problem. We run a fairly large website
using PHP so there is always many connections to the database. On 4.0.12
the cpu usage never shot to over 20% and ran extremely fast. After
upgrading to
Ok, I added IN BOOLEAN MODE and now it somewhat works...It is just a matter
of optimizing it now. Thanks.
- Original Message -
From: "Cliff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 27, 2003 8:13 AM
Subject: Problem with FULLTEXT searches
&g
I am trying to get the fulltext search working properly as described in the
manual but some queries do not seem to be working correctly. When I run this
query:
SELECT allusa.name,title,full_text,match(title,full_text) against ('chicken
soup lemon') from recipes, bb.allusa where innid = bb.allusa.i
nished
Slave shutdown finished
-- CUT --
>Fix:
>Submitter-Id:
>Originator:Cliff Stanford
>Organization:
>MySQL support: none
>Synopsis: ./mysql-test-run --local create fails
>Severity: serious
>Priority: high
>Category:
That is weird, I just created the same tables with the same data and it
returns 49 rows containing this:
| 8647 | FULL | 24 Henry Guesthouse| San Francisco | USA | San
Francisco | CA| CA| http://www.24Henry.com
| FULL | | 65.00 | 109.00 |1 |
That is a problem with a php script you are running, it is not passing the
expected data as an argument.
- Original Message -
From: "Sandra" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 09, 2002 4:41 PM
Subject: can't use the table. What happen, please!!
> Hi
ly built in 1869, the inn has recently been
completely renovated into a cozy B&B offering 9 distinctive suites artfully
decorated. Just 5 minutes north of the Golden Gate Bridge.
child: yes
pets: no
wc: yes
id: 12884
historic: y
skii
R country LIKE
'%francisco%' OR name LIKE '%francisco%')ORDER BY state,city,name ) LIMIT 15,15
produces the city "San Francisco" twice in the listing.
>How-To-Repeat:
<http://www.lanierbb.com/search/search.php?pt=bb&q=san+francisco&start
all of the files are chown -R mysql in that directory. Any other ideas?
- Original Message -
From: "Gerald Clark" <[EMAIL PROTECTED]>
To: "Cliff" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, August 01, 2002 7:05 AM
Subject: Re:
Hi, I am trying to upgrade to 4.02 from 3.23.47 on FreeBSD 4.6. The mysql
database does not want to work for some reason, when I move my old mysql
database over the new one, it does not start up, giving an error about
permissions even though the permissions of that directory are 770
mysql.mysql. I
y));
The %s format string is not a part of the C language proper, but rather a part
of several of the C library functions (printf, fprintf, sprintf, etc).
The reason to use snprintf versus sprintf is to avoid overwriting memory if the
query string becomes too long. If
On Tue, 18 Jun 2002 20:04:54 -0300
César Aracena wrote:
> Hi all.
>
>
>
> Is there any possible way for me to arrange a SELECT query made to MySQL
> in to orders? Like __. ORDER BY lastname THEN BY firstname?
SELECT * FROM tablename ORDER BY lastname, firstname;
--
Cli
eradict the machine gets... Interactive typing even starts
to pause when you see the idle near zero, it's like something is thrashing
in the kernel but top yields no clues.
Cliff
-
Before posting, please check:
http:/
I have one query, that basically reads from one table of 13 million rows,
groups it by two fields, and inserts into a rollup table. The result set
ends up being about 31,000 rows. This runs in about 2 minutes which is
acceptable. However, I add an additional group by field, which will probably
Short and simple, is it possible to escape by two different parameters? This
used to work:
SELECT * from allusa WHERE (updated_by='I' or updated_by='A' or
updated_by='L') AND (id<9) AND last_updated > '2002020100' ORDER BY
last_updated INTO OUTFILE
'/home/www/site/admin/admin/dbdump/bb200
rt_sigaction(SIGALRM, {0x4002fa10, [ALRM], SA_RESTART|0x400}, {SIG_IGN}, 8) = 0
sigreturn() = ? (mask now [])
read(3, 0x814a6b0, 4) = ? ERESTARTSYS (To be restarted)
--- SIGALRM (Alarm clock) ---
Cliff
-
other than root you must
> specfy your user name,host name and password by using the following command
> mysql -h localhost -u user -p mypass
> I hope this helps,please let me know as i am new to mysql too(1 week)
>
> --
> Atoyebi Abdulhakeem (M
Thanks. This works when I use any other user besides root without a
password. Guess the problem is that there is a password for root and I
don't know what it is.
Thanks again for getting me over the first mindless hurtle.
Regards,
Cliff Austin
"Brian P. Austin" wrote:
>
s which doesn't seem to do anything.
What does the "Password No" mean? How do I correct it short of
reinstallation? Well, I don't know maybe I need to start over yet
again.
Thanks very much for any help,
Cliff
--
possible OS-dependent bug
It's probably happend to some folks using irix befor so I'm hoping that there
is a solution to it.
Thanks,
Cliff
--
Cliff Liu SAIC
email: [EMAIL PROTECTED]
Phone: 301-614-5062
x27; CFLAGS='' CXX='gcc' CXXFLAGS=''
LDFLAGS=''
LIBC:
-rw-r--r-- 1 bin bin 1696732 May 22 2000 /lib/libc.a
lrwxrwxrwx 1 root root 11 Jan 19 2000 /lib/libc.so ->
./libc.so.1
Cliff Kilpatrick, Software Engineer
Cambridge Scien
Still doesn't work, I've even tried:
HAVING
( Avg_Xmit = 12345 ) AND ( Samples >= 25 )
19000 rows returned, none equalling 12345, but all have Samples >= 25.
It's almost as if this became an OR.
Cliff
Gerald Clark <[EMAIL PROTECTED]> writes:
as ACHT,
COUNT(*) as Samples
FROM
tbl_data_call_detail
WHERE
Acct_Session_Time > 0
GROUP BY
NAS_Identifier,
NAS_DS1
HAVING
Avg_Xmit < 28800
AND Samples >= 10
OR
36 matches
Mail list logo