Re: size of database on disk

Hi, On Mon, Apr 27, 2009 at 7:33 PM, Randomcoder randomcod...@gmail.com 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

Re: Building 5.1 on Tru64 5.1b

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 get

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

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

Re: 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

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

RE: 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

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

RE: Oracle , what else ?

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 MySQL, as

Re: 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

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, Mark

MySQL University session on April 30: Testing multiple servers with MySQL

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

RE: Oracle , what else ?

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 MySQL, as

Re: How to generate unique primary key in MySQL?

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

Re: How to generate unique primary key in MySQL?

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 you mean

Re: Building 5.1 on Tru64 5.1b

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: identifier

RE: Oracle , what else ?

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 MySQL, as

RE: 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

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

Re: 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

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 ad...@asarian-host.net wrote: It would probably

Re: Building 5.1 on Tru64 5.1b

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);} ---^

Extremely slow access to information_schema

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

Copying to tmp table

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 :

RE: Copying to tmp table

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-

RE: Oracle , what else ?

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:

Re: Building 5.1 on Tru64 5.1b

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.34 had

RE: Extremely slow access to information_schema

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

Re: Building 5.1 on Tru64 5.1b

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: ../../sql/log.h, line 401:

Re: Optimizing iowait with tmpdir and tmpfs or ramfs?

On Tue, Apr 21, 2009 at 2:52 PM, Milan Andric mand...@gmail.com 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

Re: Extremely slow access to information_schema

Hi, On Tue, Apr 28, 2009 at 1:04 PM, Rolando Edwards redwa...@logicworks.net 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

Re: Extremely slow access to information_schema

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 redwa...@logicworks.net wrote: Make sure the tables that the information_schema are not locked. This is because MyISAM tables, that are constantly being inserted

Now() : SQL syntax error. But why?

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

RE: 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

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

Re: Now() : SQL syntax error. But why?

Can you please give the full table structure and query? On Tue, Apr 28, 2009 at 23:18, Antonio PHP php.anto...@gmail.com 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 =

Re: Question on replication terminology

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

Start MySQL with --intit-file?

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

Re: Now() : SQL syntax error. But why?

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

Information Schema

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 will

Re: Start MySQL with --intit-file?

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 mailingli...@mailnewsrss.com I am trying to start MySQL with --init-file but i get that it is an invalid

select data from two table and will sort by price in second table

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

Re: Information Schema

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

Re: Start MySQL with --intit-file?

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