Can you show us the proper view of your sql statement by adding \G.
On Sat, Jun 21, 2008 at 1:57 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> The below query performance in 10 sec when there are no other activity on
> db
> , but when any insert or LOAD DATA Index creation happens it takes close
Leant from this post.Thanks.
On Sat, Jun 21, 2008 at 9:35 PM, <[EMAIL PROTECTED]> wrote:
> I found the bug report at
> http://bugs.mysql.com/bug.php?id=26026
>
> Adding --lock-all-tables as in
> mysqldump --lock-all-tables --no-data etc.
> solved the problem.
>
>
> - Original Message -
>
I don't know whether I got your mean or not.
I advise that you should take a look at this url.
http://www.day32.com/MySQL/
On Sun, Jun 22, 2008 at 12:41 AM, Atle Veka <[EMAIL PROTECTED]> wrote:
> I don't think anyone answered your actual question, so here's my attempt..
>
> http://dev.mysql.com
Maybe you shoul write your insert statement like this.
insert into LogTable set SQL='select ''abc'' from table';
On Sun, Jun 22, 2008 at 3:46 AM, mos <[EMAIL PROTECTED]> wrote:
> I have my own log table which contains a Text column that is suppose to
> store SQL statements that fail to execute pr
I have my own log table which contains a Text column that is suppose to
store SQL statements that fail to execute properly. My problem is when I
use an
Insert into LogTable set SQL='select 'abc' from table;-- this comment
screw's things up;#13#10update table x set v='ddd';...'
I get all sort
I don't think anyone answered your actual question, so here's my attempt..
http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html
"Many status variables are reset to 0 by the FLUSH STATUS
statement."
Atle
On Fri, 20 Jun 2008, Venu Madhav Padakanti wrote:
I am us
This is because only one cpu is enough for your concurrent.
On Sun, Jun 22, 2008 at 12:14 AM, Per Jessen <[EMAIL PROTECTED]> wrote:
> Eber Duarte wrote:
>
> > I noticed that I always have 2 processes runing on Linux doesn't
> > matter the amount of concurrent connections that is running on MySQL.
Eber Duarte wrote:
> I noticed that I always have 2 processes runing on Linux doesn't
> matter the amount of concurrent connections that is running on MySQL.
> Due to that, MySQL is using only 1 CPU instead of using 8 CPUs that
> exist on this machine:
Do you have enough concurrent load to occupy
On Sat, Jun 21, 2008 at 8:34 AM, Joe Pearl <[EMAIL PROTECTED]> wrote:
> Thanks, but this is not the result I want.
I really think it is. You seem to be misunderstanding how GROUP BY
works. In any other database than MySQL, the SQL you wrote would
simply give an error. In MySQL, it gives you ran
The official table's data.
++---+-+
| id | title | body|
++---+-+
| 1 | MySQL Tutorial| DBMS stands for DataBase ...
Your query is just grabbing the max date within the group, but you are
not specifying which record you should be pulling for the location, so
it's using an arbitrary one within the group. In your query, there is
not relation between max date and location.
What you need to do is find out wha
I found the bug report at
http://bugs.mysql.com/bug.php?id=26026
Adding --lock-all-tables as in
mysqldump --lock-all-tables --no-data etc.
solved the problem.
- Original Message -
From: Moon's Father
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Saturday, June 21, 2
Thanks, but this is not the result I want. The SQL for the correct result
is at
http://dev.mysql.com/doc/refman/5.0/en/example-maximum-column-group.html and
I'm apparently using the correct SQL.
The problem is that the columns are not coming out correctly - the rows
considered for the max functio
Maybe you have to adjust your file limit by user named mysql.
On Sat, Jun 21, 2008 at 7:50 PM, <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I am running mysqldump with --no-data option, but it gives error:
> "can't exec 'show fields from ...' out of resources when opening file ...
> (errorcode 24) (2
Hi Joerg et al,
It's perhaps a tribute to the mysql team that I have actually managed
to build 3.23.32 and link php3 and php4 to it on RH EL 5.1 66 bit. The
server starts, we can access some legacy databases using the mysql
client and a couple of web sites seem to work connecting as well. Much
wor
Hi All,
I am running mysqldump with --no-data option, but it gives error:
"can't exec 'show fields from ...' out of resources when opening file ...
(errorcode 24) (23)"
perror 24 says: too many open files
perror 23 says: too many open files in system
mySQL show variables says: open_files_limit: 6
16 matches
Mail list logo
