mysqld freeze at 100% load

Ubuntu 4.4.3-4ubuntu5' --with-bugurl=file:///usr/share/doc/gcc-4.4/R Thread model: posix gcc version 4.4.3 (Ubuntu 4.4.3-4ubuntu5) Compilation info (call): CC='gcc' CFLAGS='-O3 -DBIG_JOINS=1 -fno-strict-aliasing' CXX='g++' CXXFLAGS='-O3 -DBIG_JOINS=1 -- ~ Eli ~

table lock

Hey there I have an external script that generates a lot of data and dumps it into a table. Prior to this ,it removes all the data in this specific table. It requires both read and write privileges. The web site on the other end reads all the data from the table and generates standard ht

RE: crash

] Sent: Wednesday, February 13, 2008 8:05 AM To: Eli Shemer Subject: Re: crash Hi, The below information shows that innodb data get crashed and then started the recovery of data. During recovery of data there was a memory shortage (Out of memory). At last recovery gets completed. Thanks

crash

Can someone explain this? Thanks. 080212 15:54:39 mysqld started 080212 15:54:39 InnoDB: Started; log sequence number 0 43743 080212 15:54:40 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.0.54-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution N

RE: Decimal - Maximum is 30

cimal - Maximum is 30 Eli Shemer wrote: > > Is there any possible way to increase this limit ? I'm curious to know what it is you're doing where you need accuracy better than one part in a nonillion. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Decimal - Maximum is 30

Hey there Is there any possible way to increase this limit ? Internal Virus Database is out-of-date. Checked by AVG Free Edition. Version: 7.5.503 / Virus Database: 269.16.4/1146 - Release Date: 22/11/2007 18:55

optimization - directories and sub-directories (with descendants)

Hi, I have a table of directories. Each row represents a directory, which holds his name and desc. Another table lists sub-directories from each directory source to its sub-directories targets. dirs: +--+--++ | dir_id | dir_name | dir_desc | +--

Re: spanned indexes

table would be helpful if UNION on same-defined tables was used.. It seems that the solution for this (as for now) is to combine all the tables into one big table and index fields over it. -thanks, Eli -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubs

Re: spanned indexes

that the way to overcome this problem is to have one big table joined from all the smaller tables. Problem is that it will be real big with many-many fields and some long TEXT/BLOB fields. Thanks for the help, -Eli. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

spanned indexes

Hi, Is it possible, or probably will be possible, to define indexes spanned on more than one table? I mean that if I have column col_a from table tbl_A, and col_b from table tbl_B.. Can I define a KEY with both those columns? Where will the index be saved? -thanks. -- MySQL General Mailing

Re: Speeding UNION with merging indexes

n to use it and when not to use it. What are your ideas? Shawn Green Database Administrator Unimin Corporation - Spruce Pine Eli Hen <[EMAIL PROTECTED]> wrote on 08/03/2005 04:44:55 PM: > Hi, > > In the example you gave, it seems that MySQL doesn't merge the index of >

RE: Speeding UNION with merging indexes

Hi, In the example you gave, it seems that MySQL doesn't merge the index of t1 in both sub-queries (which is the same index).. but it runs the sub-queries seperatedly, using the index on each sub-query seperatedly.. Mabye I wasn't clear enough with my question.. let me phrase it again: Say I

Speeding UNION with merging indexes

Hello, MySQL implemented index_merge in version 5... Does MySQL supports something like index_merge to speed up UNION queries? If yes, for which version (assumed release time)? Does anyone know of other DBs systems that can speed up UNION queries? This issue is quite critical for our system..

INSERT with ON DUPLICATE error

ON DUPLICATE KEY UPDATE id=id; but I get the next error: ERROR 1110 (42000): Column 'id' specified twice When I remove the fields list (id,value), then it works, and as expected the duplicated key rows are not changed. It doesn't matter if I use INSERT-SELECT or regular SELECT.

Re: Subquery speed : IN (SELECT ...) versus IN (X, Y, Z, ...)

at describes you how the tables are joined. (see: http://dev.mysql.com/doc/mysql/en/explain.html ) You may post here your EXPLAIN results. Also note that when you use the second query (B), you also spend time on the SQL1 query that you didn't consider about its time. -Eli HMax wrote: Hel

Full-Text scoring (MySQL 4.1 and future)

y time is constant. Does anyone know if MySQL tends to calculate scoring also from fields out of the full-text table? (Mabye it is available for MySQL 5 even in its beta?) Please, that's important for me to design my DB. -thanks, Eli -- MySQL General Mailing List For list archives: h

Convert to character set (upgrading from 4.0 to 4.1)

mailing list using Thunderbird. (On PHP mailing list replying works). please help... -thanks, Eli -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Error 1271 (HY000) - Illegal mix of collations

ation 'UNION' I tried to look after it on the net, but couldn't find anything meaningful. thanks in advance, -Eli. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Selecting first non-null values from a set of rows

Eli <[EMAIL PROTECTED]> wrote on 02/08/2005 02:26:41 PM: Hello, Say I get these rows in a regular query: col1 col2col3 --- NULLB1NULL NULLNULLNULL A3 B3 NULL A4 NULLC4 A5 B5 C5 NULLB6 C6 (It's important

Selecting first non-null values from a set of rows

t non-null values from every column.. the row: A3 B1 C4. Like the COALESCE function in MySQL, but on rows. Please help... -thanks, Eli -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

ERROR 1062: Duplicate entry

(0.00 sec) ## no indexes at all currently mysql> show index from URL; Empty set (0.00 sec) Thanks. Eli Shemer. Siteware. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

checking that any element from one group appears in another group?

ERE ('a','f','g') IN ('a','b','c','d') ... 'a' in the first group appears in the second group, so it will return true, no matter if 'f' or 'g' exist in too. Well, is there anything like above tha

Re: Fulltext creation on 4.1: ERROR 1034

"Kurt Haegeman" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Sergei Golubchik wrote: > > >Hi! > > > >On Jan 13, Kurt Haegeman wrote: > > > > > >>Hi, > >> > >>When trying to create a fulltext index on my large table, I get the > >>following error: > >> > >>ERROR 1034 (HY000): 121 wh

REGEXP or LIKE

Hello, With your experience.. which runs better: REGEXP or LIKE? assuming you can express the query in both forms. I found that LIKE is twice faster than REGEXP using i.e: LIKE '%1068812942%' REGEXP '1068812942' -thanks, Eli -- MySQL General Mailing List For

Re: Multiple Roles

"Caroline Jen" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > In case that a user has multiple roles; for example, > John Dole is both author and editor, > > 1. I should have two rows for John Dole? > >John Dole author >John Dole editor > >or. I should have only

InnoDB size against MyISAM size

Hello, My HDD is running low and I MyISAM tables are keep crashing... I think that converting to InnoDB will be more stable, but what about the data files sizes? convertion to InnoDB will need more or less disk space than MyISAM? -thanks, Eli -- MySQL General Mailing List For list archives

Re: Two many key part specified

> On 3 Sep 2003 at 18:59, eli wrote: > >> EXCEPTION java.sql.SQLEXCEPTION:Invalid argument value, message from >> server "Two many key part specified. Max 16 parts allowed". >> [...] >> INDEX(ID, Field_1, Field_2,Field_3, Field_23) >> ) >>

Two many key part specified

INDEX(ID, Field_1, Field_2,Field_3, Field_23) ) I was supossed the maximum number of index was 32. Am I wrong? This message didn't tell me this? If not, what does it tell me? Thanks in advanced. Eli -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

Two many key part specified

D, Field_1, Field_2,Field_3, Field_23) ) I was supossed the maximum number of index was 32. Am I wrong? This message didn't tell me this? If not, what does it tell me? Thanks in advanced. Eli _

Use Like or =

Hi, I have a question about using LIKE or equal. I mean, comparing two strings with exact coincidence, without case sensitive, which is better? Or are they the same? Do they work equal? For Instance. "abc"="abc" Or "abc" LIKE "abc" I use

Connections

Thank you for the information about LIKE and equal. I have another question. What is better/quicly 50 simultaneously query/update at the same time from 50 different users or 50 simultaneously query/update at the same time from one user? Thanks for your information in advanced, eli > At

Command "Show Column"

Hi again, I know that "Show Column" query shows the name of all variables with their characteristics. I want to know if there is a command that ONLY shows the name of the varibales of a column (without characteristics). Thanks a

Re: Relationships in Mysql

el [DATE], [NAME] en [ADDRESS] escribió: Thank you for your help and for the lesson. Eli > I would just add a few words to Nils' excellent reply: > > In the most general sense, a foreign key is just a primary > key value that occurs outside of its native table (i.e. in &g

FW: Relationships in Mysql

Hi, Can anyone explain me how to create relationships between tables in Mysql? For making some kind of functions like joins, it is indispensable to have relationships defined? Thanks in advanced. eli -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To