Re: Hypothetical design question regarding keyword searching

2007-07-19 Thread Mark Papadakis
s.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Mark Papadakis http://www.markpapadakis.com/ [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Abnormal mySQL service behavior / 5.0.26

2007-02-16 Thread Mark Papadakis
On 2/16/07, Juan Eduardo Moreno <[EMAIL PROTECTED]> wrote: On 2/16/07, Mark Papadakis <[EMAIL PROTECTED]> wrote: > Good day, R: are you using MyISAM or InnoDB tables? InnoDB, only. > For the past 2 weeks, we have been dealing with some rather strange problems. > Whi

Abnormal mySQL service behavior / 5.0.26

2007-02-16 Thread Mark Papadakis
Good day, For the past 2 weeks, we have been dealing with some rather strange problems. While nothing changed in terms of the mySQL server or clients configuration ( including the options provided to the server during startup, by either my.cnf or as arguments to the executable ), we are getting t

Re: How thread-safe is mysql_real_connect()?

2005-10-07 Thread Mark Papadakis
out some simple pieces of information, just let me > know and I will respond ASAP. Please remember to CC: both lists on all > responses. > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine > > > > > -- Mark Papadakis http://www.markpapadakis.com/ [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Some Assistance Please

2005-08-30 Thread Mark Papadakis
into play. Personally, I wouldn't use mySQL's LIKE or regular expression matching, nor it fulltext indices. I wouldn't even use mySQL for search at all. Still, you should try both ways ( and others, such as breaking down your text into words and mapping those words into objects -- I am s

Re: Got error 127 when reading table cat

2005-06-30 Thread Mark Papadakis
That's usually an I/O error, if memory serves me right. Try dumping the data, drop table, recreate it, and re-insert the data back-in. MarkP On Jun 30, 2005, at 14:34 , nikos wrote: Hello list Can somebody infor me what is the "Got error 127 when reading table cat"? Thank you Nikos -- M

Re: Central UDF project at mysql.com?

2005-03-30 Thread Mark Papadakis
itions. > > All the best, > Dan. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Mark Papadakis Head of R&D Phaistos Networks, S.A -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: QUERY ordering clarification

2005-03-28 Thread Mark Papadakis
$sku2, $sku3, > $sku4 order. > > Thanks, > Grant > > __ > Do you Yahoo!? > Yahoo! Small Business - Try our new resources site! > http://smallbusiness.yahoo.com/resources/ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql

Re: Social Networking querys

2005-02-02 Thread Mark Papadakis
t; peers rather than keep everything secret and hope that the other guy > screws up. Of course as long as help is reciprocal... > > Balazs > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com

Re: load balacing in a replicated environment

2005-01-21 Thread Mark Papadakis
least busy node will answer the next read query. There are more feautres planned, but I can't discuss it further until we launch the product (sometime in late Spring). Mark Papadakis On Fri, 21 Jan 2005 10:41:30 -0800 (PST), Atle Veka <[EMAIL PROTECTED]> wrote: > > The easiest wa

Re: cannot Connect to local MYSQL server through socket

2004-11-24 Thread Mark Papadakis
the chmod and chown fixes. What does the socks file do anyway? > > > >Thanks > > > >Andrew G Morris > >ILT Advisor (Technical) > >JISC RSC West Midlands > >01902 824434 > >07980 982738 > > > > > > > > > > > -- > My

Re: The better and more efficient way to store datetime data.

2004-11-24 Thread Mark Papadakis
> > Jose. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > -- Mark Papadakis Head of R&D Phaistos Networks, S.A -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql 4.1 and the LIMIT sql statement

2004-11-17 Thread Mark Papadakis
I suppose they fixed it. Relying on 'undocumented features' is a bad habbit. Update your code to exclude the LIMIT clause if you do not wish to use it. Its the best thing ou can do. Mark Papadakis On Wed, 17 Nov 2004 12:21:31 -0800, Matt Babineau <[EMAIL PROTECTED]> wrote: &g

Re: scalability of MySQL - future plans?

2004-11-13 Thread Mark Papadakis
osts 5.6 million US dollars. > > > Best regards, > > Jacek Becla > > Stanford University > > Best regards, > > Heikki Tuuri > Innobase Oy > Foreign keys, transactions, and row level locking for MySQL > InnoDB Hot Backup - a hot backup tool for InnoDB

mySQL Clustering and HA (NDB - Emic Networks Solution - Replication) : Enterpise Use

2004-11-04 Thread Mark Papadakis
- therefore not a complete HA solution. o Has anyone gotten replication to work right? Perhaps Multi-Master replication? Thank you very much in advance, MarkP -- Mark Papadakis Head of R&D Phaistos Networks, S.A -- MySQL General Mailing List For list archives: http://lists.mysql

Corrupted tables -- for 'no apparent' reason

2001-09-07 Thread Mark Papadakis
ySQLd. --skip-locking -O back_log=1024 -O table_cache=280 -O max_connections=2048 -O wait_timeout=30 -O interactive_timeout=30 -O long_query_time=2 --log-slow-queries=slow.log --big-tables Please reply to [EMAIL PROTECTED] Thank you in advance, Mark Papa

order by ( bug or undocumented feature )

2001-01-21 Thread Mark Papadakis
ed results set? Please, reply directly to me ( [EMAIL PROTECTED] ) if possible. Thank you, Mark Papadakis R&D Director - Web Division Phaistos Networks, S.A. - http://www.phaistosnetworks.gr [EMAIL PROTECTED] T:+30-892-23855 F:+30-892-22670 - A DOL D