Hi all!
Mark wrote:
> On my FreeBSD:
>
> usr/include/errno.h:#define EAGAIN 35 /* Resource temporarily unavailable
> */
> /usr/include/errno.h-#ifndef _POSIX_SOURCE
> /usr/include/errno.h-#define EWOULDBLOCK EAGAIN /* Operation would block */
Ok, next step then:
The OP wrote the problem was w
Hi,
I am trying:
[r...@server1 ~]# /etc/init.d/mysqld restart --init-file=cloudsql.sql
Stopping MySQL:[ OK ]
Starting MySQL:[ OK ]
the cloudsql.sql file contains:
UPDATE mysql.user SET Password=PASSWORD
Scott
Information_schema is a virtual database only. I think it was added in
MySQL 5.0.2 to comply with SQL:2003 specifications.
information_schema provides the same info as you can get from 'SHOW'
commands. Every user automatically has select privs for information_schema
and its not possible to
dear all,
please help us mien for select data from two table with details as follows:
primery tabel : bookcatalog
second table : pricelist
for seaching we will try to sort by price (in second table).
our databese details like this:
SELECT id, title, author from bookcatalog where isbn LIKE '%$q
hey jason,
you need to restart the *server* with the init-file option, have a look at:
http://dev.mysql.com/doc/refman/5.0/en/server-options.html
2009/4/28 Jason Todd Slack-Moehrle
> I am trying to start MySQL with --init-file but i get that it is an invalid
> option. the 'man' page and --he
I have been meaning to find out about this since I moved to mysql 5.
In version 4, I never saw the table "information schema". With it
being in version 5, I assume it was something only the root users, or
a higher level user could see.
I now know that it shows up under any account. I wil
We need to see your entire query and the table structure. timestamp
fields can have options set to auto update them, where order matters,
and only one field can support that feature.
Please supply more data.
On Apr 28, 2009, at 2:18 PM, Antonio PHP wrote:
You have an error in your SQL synt
I am trying to start MySQL with --init-file but i get that it is an
invalid option. the 'man' page and --help dont help me decide what is.
Here is what I am doing:
r...@server1 ~]# mysql start --init-file = cloudsql.txt
mysql: unknown option '--init-file'
Thoughts?
-Jason
--
MySQL General M
Hi there,
I would only like to stress that the only supported (and recommended)
replication solution in MySQL is
Master--->Slave replication.
In this scenario you can have ONLY one master and (virtually) any number
of slaves.
There is NO other safe replication solution.
The terms you mention
Can you please give the full table structure and query?
On Tue, Apr 28, 2009 at 23:18, Antonio PHP wrote:
> You have an error in your SQL syntax; check the manual that corresponds to
> your MySQL server version for the right syntax to use near 'Created = NOW(),
> Updated = NOW()' at line 8
>
> 'C
On my FreeBSD:
usr/include/errno.h:#define EAGAIN 35 /* Resource temporarily unavailable
*/
/usr/include/errno.h-#ifndef _POSIX_SOURCE
/usr/include/errno.h-#define EWOULDBLOCK EAGAIN /* Operation would block */
I still wouldn't discount the files resources limit; though obviously
I bow to Jörg's
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'Created = NOW(),
Updated = NOW()' at line 8
'Created' and 'Updated' are set to datetime (InnoDB).
The same syntax works for some newly created tables... and gives
Il giorno mar, 28/04/2009 alle 17.11 -0400, Baron Schwartz ha scritto:
> Hi,
>
> On Tue, Apr 28, 2009 at 1:04 PM, Rolando Edwards
> wrote:
> > Make sure the tables that the information_schema are not locked.
> >
> > This is because MyISAM tables, that are constantly being inserted into
> > (Each
Hi,
On Tue, Apr 28, 2009 at 1:04 PM, Rolando Edwards
wrote:
> Make sure the tables that the information_schema are not locked.
>
> This is because MyISAM tables, that are constantly being inserted into (Each
> insert, update, delete on a MyISAM table does a table lock), must update the
> TABLE_
On Tue, Apr 21, 2009 at 2:52 PM, Milan Andric wrote:
> Hello,
>
> I have a rather burly Drupal based site that seems to be causing some
> problems, today we had a major outage. There are many slow queries
> and also mysql related iowait that causes server processes to hang, at
> least that is the
on 4/28/09 3:30 PM, Joerg Bruehe at joerg.bru...@sun.com uttered the
following:
cxx: Error: ../../sql/log.h, line 140: identifier "pthread_mutex_destroy"
is
undefined
~st_log_info() { pthread_mutex_destroy(&lock);}
---^
cxx: Error: ../../sq
Make sure the tables that the information_schema are not locked.
This is because MyISAM tables, that are constantly being inserted into (Each
insert, update, delete on a MyISAM table does a table lock), must update the
TABLE_ROWS column in information_schema.tables to have the latest count.
If
Hi Didier, all,
just a follow-up on my own mail:
Joerg Bruehe wrote:
> Hi Didier, Walter, all!
>
>
> Didier Godefroy wrote:
>> [[...]]
>> I already had looked at this and I do have all the right flags. I was able
>> to build 5.1.33 and not 5.1.34, so something may have changed.
>
> Sure, 5.1.
In case anyone is interested, here is Monty's views on the Oracle buyout.
http://monty-says.blogspot.com/2009/04/to-be-free-or-not-to-be-free.html
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@ja
Hi Caldi,
Can I knew what kind of table type you are using and also try to send me
the explain plan of the query execution.
I would like to know what kind of keys are being used.
Thanks & Regards,
Dilipkumar
Mobile: +91-9884430998
E-mail: dilipkumar.par...@eds.com
-Original Message-
From
Hi friends
I have a proble with Copying to tmp table with large tables, table have more
than 3 million rows
EXPLAIN da Query :
Table : log0904
Type : ref
Possible_keys :
data_login_tplig,emp_grp_login_dtlig,grp_tiporeg_tipolig_dtlig,grp_dtlig_tplig,dtlig_num,grp_equipe_emp_d
Hi,
in Mysql 5.0 accessing information_schema.tables means almost
certainly dropping down the DBMS.
With my configuration
412 databases
357417 grants
every query to information_schema.tables takes minutes, while the
equivalent show tables from... (that I can't absolutely use)
is immediate.
Is
Hi Didier, Walter, all!
Didier Godefroy wrote:
> on 4/28/09 10:01 AM, walter harms at wha...@bfs.de uttered the following:
>
>>> cxx: Error: ../../sql/log.h, line 140: identifier "pthread_mutex_destroy" is
>>> undefined
>>> ~st_log_info() { pthread_mutex_destroy(&lock);}
>>>
Jörg
mgai...@martini ~
FGIN.sh 35 | fgrep errno
find: File system loop detected; `/usr/include/gnome-xml/libxml' is part of the
same file system loop as `/usr/include/gnome-xml'.
/usr/include/apr-1/apr_errno.h:806:#define SOCEWOULDBLOCK (SOCBASEERR+3
5)/* Operation would blo
On Thu, 2009-04-23 at 17:58 +0100, Gabriel - IP Guys wrote:
> > The real question is whether they will let MySQL
> > wither
> > and die by not providing updates for it?
>
> Well, MySQL is open source, right? And the source is available? I'm
> sure
> a team of devs will come to the rescue. As for
on 4/28/09 10:01 AM, walter harms at wha...@bfs.de uttered the following:
>> cxx: Error: ../../sql/log.h, line 140: identifier "pthread_mutex_destroy" is
>> undefined
>> ~st_log_info() { pthread_mutex_destroy(&lock);}
>> ---^
>> cxx: Error: ../../sql/log.h, line 401: id
>> I wish my id has the same length,auto_increment can do this?
>>
>
> I have a idear to generate unique primary key:
>
> select concat(cast(unix_timestamp() as char) , cast(substr(rand(),3,4) as
> char(4)));
>
> Is this ok? any good idear?
Your routine does not really guarantee uniqueness, If y
If you just don't want a primary key in your major data tables, then create
a table for the express purpose of generating primary keys that uses
auto_increment. Something like:
create table myseq (x serial;)
Each time you need a new key, get the next value from that table. It would
be more l
Testing multiple servers with MySQL
http://forge.mysql.com/wiki/Testing_Multiple_Servers_With_MySQL_Sandbox
This Thursday (April 30th, 14:00 UTC), Giuseppe Maxia will give a MySQL
University session on Testing Multiple Servers With MySQL Sandbox.
Giuseppe is the creator of MySQL Sandbox, and has r
Hi VeeJay, Mark, all,
VeeJay wrote:
> Hi Mark
>
> Yes, you are right. I should have provided complete information in order to
> get help...
>
> I am running
>
> DB: Server version: 5.0.77-log FreeBSD port: mysql-server-5.0.77_1
> OS: FreeBSD 7.1
>
> On Tue, Apr 28, 2009 at 10:44 AM,
> On Thu, 2009-04-23 at 17:58 +0100, Gabriel - IP Guys wrote:
>> > The real question is whether they will let MySQL
>> > wither
>> > and die by not providing updates for it?
>>
>> Well, MySQL is open source, right? And the source is available? I'm
>> sure
>> a team of devs will come to the rescue.
On Thu, 2009-04-23 at 17:58 +0100, Gabriel - IP Guys wrote:
> > The real question is whether they will let MySQL
> > wither
> > and die by not providing updates for it?
>
> Well, MySQL is open source, right? And the source is available? I'm
> sure
> a team of devs will come to the rescue. As for M
I happen to run the exact same MySQL version + OS version (although I'm
doing a huge upgrade to 5.1.34 today), and I have not experienced any such
issues. Granted, I only get ~60 queries/s, so your traffic is probably
much higer.
At any rate, the first place I'd look is for open files limit (and
'
Hi folks
then if I check with the process: I get following output:
# ps ax | grep mysqld
797 con- I 0:00.00 /bin/sh /usr/local/bin/mysqld_safe
--defaults-extra-file=/var/db/mysql/my.cnf --user=mysql
--datadir=/var/db/mysql --pid-file=/var/db/mysql/localhost.server1.pid
835 con- S 8:
Hi Mark
Yes, you are right. I should have provided complete information in order to
get help...
I am running
DB: Server version: 5.0.77-log FreeBSD port: mysql-server-5.0.77_1
OS: FreeBSD 7.1
On Tue, Apr 28, 2009 at 10:44 AM, Mark wrote:
> It would probably help if you told folks wh
It would probably help if you told folks what MySQL version you are running.
:)
- Mark
-Original Message-
From: VeeJay [mailto:maan...@gmail.com]
Sent: dinsdag 28 april 2009 10:22
To: mysql@lists.mysql.com; VeeJay
Subject: 1135: Can't create a new thread (errno 35); if you are not out o
Hello guys and gurus
I am keep getting this error after a while "*1135: Can't create a new thread
(errno 35); if you are not out of available memory, you can consult the
manual for a possible OS-dependent bug*"
Even though, I have 16GB memory and 32GB swap. But mysqlserver stops
answering. Could
Didier Godefroy schrieb:
> Hello all,
>
> I've been having troubles building mysql on Tru64 v5.1b.
> I tried several versions and there are always some kind of issues with
> undefined symbols and things to be changed in the source to allow the build
> to continue.
> Lately I've been trying to ge
Hi,
On Mon, Apr 27, 2009 at 7:33 PM, Randomcoder wrote:
> Hi,
>
> I'm using Mysql on Linux.
> How can I see the space a certain database is taking on disk ?
If you are using MyISAM you can pretty much just use du -sh /path/to/$table
Alternatively you can query the information_schema
http://www
39 matches
Mail list logo
