отчет об ошибке

2008-03-17 Thread Алексей
Не инсталируется MySQL при конфигурации жалуется на библиотеку С хотя уже установил gcc-4.2.0_20061014 и glib-2.12.4 помогите плиз. Алексей Finding system information for a MySQL bug report test -x /usr/bin/vi Using editor /usr/bin/vi You can change editor by setting the environment variable

помогите с инсталяцией

2008-03-17 Thread Алексей
Release: mysql-5.0.18 (Source distribution) C compiler:gcc (GCC) 3.3.3 20040412 (Red Hat Linux 3.3.3-7) C++ compiler: gcc (GCC) 3.3.3 20040412 (Red Hat Linux 3.3.3-7) Environment: machine, os, target, libraries (multiple lines) System: FreeBSD technomet.poltava.ua 6.2-RELEASE

Fw: помогите с инсталяцией

2008-03-17 Thread Алексей
Release: mysql-5.0.18 (Source distribution) C compiler:gcc (GCC) 3.3.3 20040412 (Red Hat Linux 3.3.3-7) C++ compiler: gcc (GCC) 3.3.3 20040412 (Red Hat Linux 3.3.3-7) Environment: machine, os, target, libraries (multiple lines) System: FreeBSD technomet.poltava.ua

Fw: помогите с инсталяцией

2008-03-17 Thread Алексей
Release: mysql-5.0.18 (Source distribution) C compiler:gcc (GCC) 3.3.3 20040412 (Red Hat Linux 3.3.3-7) C++ compiler: gcc (GCC) 3.3.3 20040412 (Red Hat Linux 3.3.3-7) Environment: machine, os, target, libraries (multiple lines) System: FreeBSD technomet.poltava.ua

Re: how to use index with order by here

2008-03-17 Thread Sebastian Mendel
Rob Wultsch schrieb: On Sat, Mar 15, 2008 at 2:42 PM, Nacho Garcia [EMAIL PROTECTED] wrote: Hi, im having troubles with one query, hope someone can help. on this table: messages: id_fromint(10) id_toint(10) textvarchar(1000) time with index on id_form and id_to i want to

Re: db design

2008-03-17 Thread Sebastian Mendel
Brett Harvey schrieb: which method is better to do. I have 5 tables. They represent sections/parts of a companies standards. There are 13 main categories, each of those categories has subsections (some with 3, some with 10 or more), those subsections have subsections, etc. Which table

Re: how to use index with order by here

2008-03-17 Thread Arthur Fuller
I love when this happens. I woke in the middle of the night with an idea for you. It now occurs to me that the query you want is dead simple. It just took me a while to see: SELECT * FROM messages WHERE id_from = 1 AND id_to = 2 UNION SELECT * FROM messages WHERE id_from = 2 AND id_to = 1 ORDER

Re: [ANN] PBXT storage engine version 1.0-Alpha released

2008-03-17 Thread Paul McCullagh
Hi Giuseppe, On Mar 16, 2008, at 8:13 PM, Giuseppe Maxia wrote: Congratulations on this release! Thanks! About alpha status, well done! It shows that you have studied software engineering! Two questions: * Do you have a policy for code contribution? Yes please! But seriously. I would

Re: how to use index with order by here

2008-03-17 Thread Rob Wultsch
On Mon, Mar 17, 2008 at 4:36 AM, Arthur Fuller [EMAIL PROTECTED] wrote: I love when this happens. I woke in the middle of the night with an idea for you. It now occurs to me that the query you want is dead simple. It just took me a while to see: SELECT * FROM messages WHERE id_from = 1

Re: slow-query log analysis

2008-03-17 Thread Soenke Ruempler - NorthClick
hi again, for those that are interested: the problem was indeed the filesystem with slow lookups of BIG directories (this had nothing to do with mysql but caused much iowait and therefore the mysql process had been heavily impacted). Soenke Ruempler - NorthClick wrote: I assume that those

Re: slow-query log analysis

2008-03-17 Thread Baron Schwartz
Hi, On Mon, Mar 17, 2008 at 12:59 PM, Soenke Ruempler - NorthClick [EMAIL PROTECTED] wrote: hi again, for those that are interested: the problem was indeed the filesystem with slow lookups of BIG directories (this had nothing to do with mysql but caused much iowait and therefore the mysql

Re: slow-query log analysis

2008-03-17 Thread Soenke Ruempler - NorthClick
Hi Baron, Baron Schwartz wrote: I'd be interested to know what filesystem you're using and how big the directories are. When you say big, do you mean number of entries in the directory, or space used? There were about 70k files in /tmp (caused by a mistake). the web application on this

Re: slow-query log analysis

2008-03-17 Thread Arthur Fuller
Wow! 70k files in /tmp. Hell of a mistake :) I hope it doesn't happen often. Arthur On 3/17/08, Soenke Ruempler - NorthClick [EMAIL PROTECTED] wrote: Hi Baron, There were about 70k files in /tmp (caused by a mistake). the web application on this server had many lookups to tmp and those were