Looking for a parseInt() / str_to_int() function...

2003-06-12 Thread Ken
Is there any built-in funtion at all, that allows us to parse number values from strings? This would be a huge aid in getting numeric sorting of results; something like: select scene, take from movie_table order by parseint(scene[,10]), scene, --> sc:8 | tk: sc:a9 | tk: sc:9 | tk

Query won't use index

2003-09-09 Thread Ken
| | ---- Thanks in advance! - Ken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

lock timeout error with MySQL 4.0.16 / InnoDB tables

2003-10-29 Thread Ken
K IN SHARE MODE (applied to a different table with the target row deliberately locked with a FOR UPDATE), mysql_query() returns 0 and only when mysql_store_result() returns NULL can I retrieve the lock timeout error code. Why does mysql_query() not consistently return the lock timeout error

missing /usr/lib/libsocket.so.2

2001-07-17 Thread ken
/usr/local/mysql-3.23.39-pc-sco3.2v5.0.6-i386/data ./bin/safe_mysqld: 24224 Killed 010717 12:07:10 mysqld ended -- Ken - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysq

Help somehow turn this into a single query

2001-09-06 Thread Ken
te. I can easily do this in two queries: select ... where recorddate < thisdate order by date desc limit 1 select ... where recorddate > thisdate order by date asc limit 1 Any ideas? - Ken [EMAIL PROTECTED] - Before posti

Re: Query question.

2001-09-06 Thread Ken
Sounds like a left join, maybe even a "natural join", which I haven't tried yet. select message from project left join daily on project.uid = daily.uid order by timestamp Check manual for syntax. Or am I missing something? - Ken [EMAIL PROTECTED] At 05:47 PM 9/6/01 -0700,

Win32 mysqld-opt: Invalid page fault on certain query

2001-11-02 Thread Ken
un my application in my development environment. Thanks immensely to anyone who can help! - Ken - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

--log-bin fails: "Server id is not set - binary logging disabled"

2002-01-25 Thread Ken
in my data dir. Looking at the .err log reveals: 020125 03:16:38 mysqld started 020125 3:16:38 Server id is not set - binary logging disabled What does this refer to, and how can I fix it? Thanks, Ken - Before posting, p

Security fix for 4.0.27?

2006-06-05 Thread Ken Williams
Anyone know if 4.0.27 will be fixed for the mysql_real_escape issue? (http://lists.mysql.com/announce/364) 4.1 and 5 have been already, kinda wondering why 4.0 hasn't. Thanks. [EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the

Re: mysqldump large file (>2GBs) : some tests

2006-08-04 Thread Ken Menzel
Hi, I just saw your e-mail. We use mysqldump on solaris 9 with large files all the time. Is the partition you are writng the file to mounted with the largefiles option in /etc/mnttab? Our mysql dump files are 25 gig. Ken - Original Message - From: "Duhaime Johanne&quo

Re: MySQL 4.0.27-client and MySQL-4.1.21 server

2006-08-22 Thread Ken Menzel
http://dev.mysql.com/doc/refman/4.1/en/password-hashing.html enable old-passwords in my.cnf Hope that helps, Ken - Original Message - From: "Odhiambo Washington" <[EMAIL PROTECTED]> To: Sent: Tuesday, August 22, 2006 1:38 PM Subject: MySQL 4.0.27-client and MySQL-4.1.

Re: FreeBSD 6.1 + Libthr + MySQL 5.0.24a max connection issue or bug?

2006-10-04 Thread Ken Menzel
ki on Freebsd and MySQL at http://wikitest.freebsd.org/MySQL Hope this helps, Ken - Original Message - From: "Abdullah Ibn Hamad Al-Marri" <[EMAIL PROTECTED]> To: Cc: <[EMAIL PROTECTED]> Sent: Tuesday, October 03, 2006 4:13 PM Subject: FreeBSD 6.1 + Libthr + MySQL 5.0.

Result row count *without* buffering all results?

2005-09-17 Thread Ken Gieselman
before dealing with the entire result set from the main query. Is there a good way to execute multiple queries in parallel via one connection? Suggestions, questions, even flames welcome. Thanks in advance! ken ===

Re: Result row count *without* buffering all results?

2005-09-18 Thread Ken Gieselman
Scott Gifford wrote: Ken Gieselman <[EMAIL PROTECTED]> writes: [...] So, here's my question: How can I find out how many rows are being returned by a query, without using mysql_stmt_store_result() to buffer all the rows back to the client? One straightforward way is to replace

Re: Result row count *without* buffering all results?

2005-09-19 Thread Ken Gieselman
Harrison Fisk wrote: Hi Ken, On Sep 18, 2005, at 3:53 PM, Ken Gieselman wrote: Scott Gifford wrote: Ken Gieselman <[EMAIL PROTECTED]> writes: [...] So, here's my question: How can I find out how many rows are being returned by a query, without using mysql_stmt_store_result() to

Re: Query Optimization

2009-01-13 Thread Ken Menzel
Try a union instead of an or condition. http://dev.mysql.com/doc/refman/5.0/en/union.html Johnny Withers wrote: I have the following tables: Customer: id,ssn Customer_Id: id,customer_id,id_num The customer table holds customers along with their SSN and the customer_id table holds identificatio

Re: BSD/OS and 5.1

2009-03-11 Thread Ken Menzel
really suggest trying those first. Hope this helps, Ken Dave Shariff Yadallee - System Administrator a.k.a. The Root of the Problem wrote: I mean MySQL 5.1 I compile MySQL 5.1.32 and on tests I got gmake -k test cd unittest && gmake test gmake[1]: Entering directory `/usr/src/contr

Re: Re: MySQL runs on 16-cores server

2009-04-11 Thread Ken Jacobs
ility. It's worth remembering that the enhanced version of InnoDB, the InnoDB Plugin, is available on http://www.innodb.com/innodb_plugin/, in addition to the forks Baron mentions. Ken Baron Schwartz wrote: MySQL isn't multi-process, it's single-process and multi-threaded. A lot

Indexing? (Warning: relative newbie.)

2009-06-24 Thread Ken D'Ambrosio
e direction for stuff like this? Sorry for all the newbie questions, but I haven't done serious database stuff since Foxbase/dBase III days. Things have changed a little since then. Thanks! -Ken -- This message has been scanned for viruses and dangerous content by MailScanner, and is believe

RE: Indexing? (Warning: relative newbie.)

2009-06-26 Thread Ken D'Ambrosio
.) Wow. Thanks for the help, all! -Ken On Wed, June 24, 2009 12:03 pm, Little, Timothy wrote: > To answer your questions in no particular order, YES you can speed it up > with indexing. > > You might want to first create an index on ( blocksize AND > physmessage_id ). > > Why, yo

Re: What OS is the best platform for MySQL ?

2009-07-08 Thread Ken Menzel
http://people.freebsd.org/~kris/scaling/mysql.html Ken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Intro to indexing?

2009-07-27 Thread Ken D'Ambrosio
ack and white; usually, they'd give an example or two, but were awfully sparse on the "whys and wherefores." So, if anyone has something they could point me to -- electronic or dead tree -- I'd be deeply appreciative. Thanks! -Ken -- This message has been scanned for vi

Re: Are you serious? mySQL 5.0 does NOT have a RENAME DATABASE?

2009-12-10 Thread Ken D'Ambrosio
ata, I would suggest either testing, or hearing from someone more knowledgeable than I, but I think this problem is substantially smaller than you've let yourself believe. -Ken On Thu, December 10, 2009 11:35 pm, Daevid Vincent wrote: > How can it possibly be that mySQL doesn't al

Re: Are you serious? mySQL 5.0 does NOT have a RENAME DATABASE?

2009-12-11 Thread Ken D'Ambrosio
ma.table; Just to be 100% clear -- I assume you have to first create the destination database, and then do this for all the tables in the source database? > I agree that it's a silly thing to not have, but I can't say that I've > encountered a whole lot of instances where I n

Database fundamentals: wanna learn.

2009-12-28 Thread Ken D'Ambrosio
lots of ground-level stuff. Call me a "user", and you'd be right -- an administrator of databases? Not so much. So, any suggestions -- books, courses, web sites, what-have-you -- that I should be hitting up so I can have a better grasp of what's going on behind the scenes? T

Help optimizing settings?

2010-02-05 Thread Ken D'Ambrosio
at, generically, would be the best way to go forward to take advantage of the extra RAM? Thanks! -Ken -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: MySQL 5.0.44 with Innodb Max memory problem :-(

2010-07-22 Thread Ken Menzel
On 7/21/2010 12:16 PM, Nunzio Daveri wrote: database is around 150GB with over 5,000 tables. To make things worse, if I shutdown MySQL, top-c still says all the memory is still used? Is this a bug, why would it say all the memory is used when I turn off MySQL. The weird thing is that when I rebo

Long time for client to connect; not for script.

2014-11-10 Thread Ken D'Ambrosio
this disparity? (My initial suspicion would be a reverse DNS resolution issue -- which I can't easily check from the DB host -- but wouldn't that affect both script and client the same?) Thanks! -Ken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql T

Re: mysqld startup failure

2007-12-12 Thread Ken Menzel
- Original Message - From: "Chris" <[EMAIL PROTECTED]> To: "jekillen" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, December 11, 2007 9:12 PM Subject: Re: mysqld startup failure jekillen wrote: Hello: The saga of this machine continues: FreeBSD v6.2 latest mysql version installed from ports

Re: R: rename database in 4.1

2008-02-12 Thread Ken Menzel
able newdbname.table. You can list multiple tables. You could script it. Ken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: enable and disable keys

2008-06-12 Thread Ken Menzel
Ananda Kumar wrote: Hi All, We are doing load data into a table using LOAD DATA INFILE process. Below is the method we are following. 1. create empty table with all the indexes. 2. disable keys 3. Load data using LOAD DATA INFILE, close to 99 Million records which takes around 3 hrs 4 . Enable k

Re: enable and disable keys

2008-06-12 Thread Ken Menzel
Ananda Kumar wrote: We have 200GB of free space on the file system where our database is located. On 6/12/08, Ken Menzel <[EMAIL PROTECTED]> wrote: Ananda Kumar wrote: Hi All, We are doing load data into a table using LOAD DATA INFILE process. Below is the method we are following. 1.

Re: PHP, MySQL questions

2008-07-23 Thread Ken Menzel
mysql.html http://wiki.freebsd.org/MySQL Hope this provides some confidence, Ken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Ancient, unsolved high-CPU problem -- vmstat, top and ps

2008-09-23 Thread Ken Menzel
.html http://bugs.mysql.com/bug.php?id=414 http://www.mail-archive.com/mysql@lists.mysql.com/msg87497.html Hope this helps, Ken Rene Fournier wrote: In case a bit more data might help, here's what the server looks like right now, while experiencing the strange high-CPU load: VM_STAT sayeth: Mach

Re: Ancient, unsolved high-CPU problem -- vmstat, top and ps

2008-09-24 Thread Ken Menzel
calhost. Don't forget to restart the server after the change in the my.cnf file. Hopefully Apple will rebranch Darwin from a more current freebsd, there have been many improvements in threading, SMP scheduling and performance, and I highly recommend version 7 and 8 looks like it will be even

Re: Ancient, unsolved high-CPU problem -- vmstat, top and ps

2008-09-30 Thread Ken Menzel
le. If you want to use 127.0.0.1 or have programs that use that then you will need to specify 127.0.0.1 when using skip-dns option. It does not hurt to grant both localhost and 127.0.0.1 if you are unsure when you are not using DNS. Ken |**||* *||* Rene Fournier wrote: So with skip-name-r

Re: sequences and auto_increment

2007-01-02 Thread Ken Brown
your login or your primary key in it. Not at a machine where I have the code handy and not sure if mysql has implemented an autonomous pragma for this kind of thing yet but select for update should deal with things as long as you keep the function tight Ken Luca Ferrari wrote: On Tuesday 02 Ja

Re: Best way to backup three live databases

2007-08-01 Thread Ken Jacobs
the backup. See the InnoDB website for more details: http://www.innodb.com/hot-backup. Regards, Ken - Original Message - From: "Baron Schwartz" <[EMAIL PROTECTED]> To: "Daevid Vincent" <[EMAIL PROTECTED]> Cc: "'MySQL General'"

Re: servers full potential / FT searches locking tables

2007-08-28 Thread Ken Peng
ire mysqld server including its child,modules should only use 4G memory? If so,the config below for 32 bit OS is may wrong,is it?Thanks. key_buffer_size=2G innodb_buffer_pool_size=2G -- Ken Peng [EMAIL PROTECTED] -- http://www.fastmail.fm - The way an email service should be -- MySQL

Re: servers full potential / FT searches locking tables

2007-08-29 Thread Ken Peng
ly,but each directive is 2G. Is this right for a 32bit system?Thanks. -- Ken Peng [EMAIL PROTECTED] -- http://www.fastmail.fm - I mean, what is it about a decent email service? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: converting some rows from utf-8 to iso-8859-1

2007-08-30 Thread Ken Peng
; my $iso_str = encode('iso-8859-1',decode('utf8',$utf8_str)); first you select utf8 string from db one by one and store it to $utf8_str,then use the function above to be converted to iso-8859-1,then insert it again to mysql. -- Ken Peng [EMAIL PROTECTE

mysql instance disk quota

2015-09-06 Thread Ken Peng
Hello, We have some instances running in a hardware server, each instance has different port. For quota limits, we can adjust my.cnf to control each instance's memory usage, also can use cgroups to set CPU quota. But what's the general solution to setup the disk quota? For example, I want

Re: mysql instance disk quota

2015-09-06 Thread Ken Peng
Hi, If disk quota is reached, an error can be threw out. we can accept this policy. Thanks. On 2015/9/6 17:28, Reindl Harald wrote: Am 06.09.2015 um 11:08 schrieb Ken Peng: We have some instances running in a hardware server, each instance has different port. For quota limits, we can

Re: mysql instance disk quota

2015-09-06 Thread Ken Peng
How to set OS disk quota? On 2015/9/6 17:52, Reindl Harald wrote: set OS disk quota for them -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: MySQL server has gone away

2017-04-03 Thread Ken D'Ambrosio
Basically, it says that MySQL is not responding to queries. So it likely has died, or perhaps is mis-configured. On April 3, 2017 7:07:25 AM EDT, Mahmood N wrote: >Hi,I am using Moodle which itself uses SQL for the database. Problem is >that, when I run the email plugin and execute the command,

Complicated Subquery help

2005-03-01 Thread Ken Gieselman
ld I be better off writing a specific program for doing the selection? Thanks for the help! ken === "Diplomacy is the weapon of the Civilized Warrior" - Hun, A.T. Ke

installation

2005-03-17 Thread Ken Hundzinski
of MySQL. Ken Hundzinski

Re: MySQL License

2003-12-10 Thread Ken Menzel
Len, You shouldn't post private information to a public mailing list (never do that!). Please send these type of questions to [EMAIL PROTECTED] But my guess is you should download and install it if you have not already done so. Ken - Original Message - From: "Len Buchana

Re: How to keep multiple instances of the same information from being displayed

2003-12-12 Thread Ken Menzel
Perhas you want SELECT DISTINCT ? http://www.mysql.com/doc/en/SELECT.html Hope that helps, Ken - Original Message - From: "Hunter, Jess" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, December 12, 2003 10:47 AM Subject: How to keep multiple instances o

Re: One Slave Many Master

2003-12-29 Thread Ken Menzel
Hi Leo, a quick search for "multiple daemons" at www.mysql.com/doc reveals: http://www.mysql.com/doc/en/Multiple_servers.html This should give you all your answers and make it possible to do what you want. Hope this helps, Ken - Original Message - From: "Leo" &l

WEEKOFMONTH

2004-01-05 Thread Ken Kyler
I need a WEEKOFMONTH function for a calendar query. Does anyone have such a function already? Ken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: WEEKOFMONTH

2004-01-06 Thread Ken Kyler
> >I need a WEEKOFMONTH function for a calendar query. Does > anyone have such a function already? > > What are the semantics? What I need is the "first Monday of each month" type of function. "WHERE DATE_FORMAT(".$this->objE->_table.".cal_datetime, '%Y-%m-%d') <= DATE_FORMAT('$dt', '%Y-%m-%d

Newbie - from Oracle

2004-01-14 Thread Ken Brown
I have to wait for triggers? Thanks Ken

Re: Repeated 100% CPU problem in FreeBSD

2004-01-20 Thread Ken Menzel
Hi Arnaud, I did not see an answer to this so; I think the info you need is here http://jeremy.zawodny.com/blog/archives/000203.html and here http://jeremy.zawodny.com/blog/archives/000697.html But I think you want "skip-name-resolve" to be specified in my.cnf. Ken I have in

Passwords and ODBC - what am I missing

2004-01-31 Thread Ken Brown
lient" So what have I done wrong? Ken

RE: Passwords and ODBC - what am I missing

2004-01-31 Thread Ken Brown
uld advise otherwise - or at the very least how to switch on a security log Ken -Original Message----- From: Ken Brown [mailto:[EMAIL PROTECTED] Sent: 31 January 2004 15:56 To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: Passwords and ODBC - what am I missing Just instal

How do I - upgrade client libraries to 4.1.1 on Windows?

2004-01-31 Thread Ken Brown
I need to do this to get round password issues as -old-passwords doesn't work Anyone any ideas? Kwn

Oracle Question

2004-01-31 Thread Ken Brown
Anyone managed to get oracle forms 6i to talk to MySQL - if so how? I've got ODBC working but it will not connect and the ODBC trace is less than useful Ken

RE: Passwords and ODBC - what am I missing

2004-01-31 Thread Ken Brown
Oh, and one other thing, you have to create the passwords AFTER you use the switch! That was probably obvious to you but it took me a while to figure out. Randy Randy Chrismon wrote: > Ken Brown wrote: > >> Just installed 4.1.1 on windows 2000 with current odbc layer >> >

MySql and Oracle Forms 6i

2004-02-02 Thread Ken Brown
Is there any way of using MySql as a back end to Oracle Forms? Ken Brown

RE: MySql and Oracle Forms 6i

2004-02-03 Thread Ken Brown
Yip I kinda figured that and tend to code that way anyhow But There is OCA which does work with a number of other database it's just there isn't a ready built MySql setup. I'll try converting one of the others to run Thanks anyhow Ken -Original Message- From: David Gr

Re: my.cnf in MySQL-Server-4.0.17

2004-02-20 Thread Ken Menzel
Hi Ronan, Did you perhaps set MAXDSIZ is your kernel configuration above "(2047UL*1024*1024)" ? Ken - Original Message - From: "Ronan Lucio" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 19, 2004 3:06 PM Subject: my.cnf in MySQL

Re: Can't create a new thread (errno 11)

2004-02-23 Thread Ken Menzel
Hi Christof, You don't mention the OS version you are using (So I will assume Linux) is there a sysctl for the max number of threads on your OS? Ken - Original Message - From: "Christof Egner" <[EMAIL PROTECTED]> To: "James Kelty" <[EMAIL PROTEC

Re: MySQL Backup advice

2004-03-04 Thread Ken Menzel
Hi Andre, I think you are looking for this: http://www.mysql.com/doc/en/Binary_log.html Hope it helps, Ken - Original Message - From: "Andre MATOS" <[EMAIL PROTECTED]> To: "Ware Adams" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursda

Re: Simultaneus TCP/IP connections

2003-06-17 Thread Ken Menzel
rvers. Best of luck. Ken - Original Message - From: "Maciej Zagozda" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 16, 2003 12:20 PM Subject: Simultaneus TCP/IP connections > I have the following problem: many ISPs reject to offer mySQL hosting >

Re: Help me!!!

2003-06-19 Thread Ken Menzel
mailto:[EMAIL PROTECTED] - Original Message - From: "Luis Enrique Bauzá Peña" <[EMAIL PROTECTED]> To: "Lista Mysql Inglés" <[EMAIL PROTECTED]> Sent: Thursday, June 19, 2003 11:59 AM Subject: Help me!!! Hi, I need some link to a spanish mysql list, would you ...? -- MySQL General Mai

Re: selecting PRIMARY KEY when there is no unique value

2003-06-19 Thread Ken Menzel
e examples including SQL variables or an autoincrement key, program variables, etc) gives a natural and consistant order to the invoice. I hope this helps, Ken > Don't use 2). There is no guarantee a TIMESTAMP value will be unique > among records with the same invoice number. That

Searchable docs in french, german, russian etc

2003-06-24 Thread Ken Menzel
yet). Thanks for the very helpful documentation, you guys do a fantastic job! Ken ----- Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Aborted clients

2003-07-25 Thread Ken Menzel
you don't believe you should have 100 connections? If you do SHOW PROCESSLIST are they all valid connections? Do you need more than 100? Did you perhaps copy an example config file or are you not using any config file? Have to run to a meeting now. Hope this bring some ideas to the table. Ken

Re: MySQL 3.23.51 Reference Manual needed

2003-07-25 Thread Ken Menzel
Hi Venelin, If you have the source code go into the ./Docs directory of the source tree and read the Makefile on how to build the format you want (PDF, HTML etc) if that is the machine you built on there may already be the HTML format document there. Hope this helps, Ken - Original

Re: Aborted clients

2003-07-25 Thread Ken Menzel
Hi Jeff, Just a quick guess did you change the max_connections variable up from the default of 100? You did not provide a show variables so I can only guess. >From the [mysqld] section of /etc/my.cnf set-variable= max_connections=500 Ken - Original Message - From: "Jef

Partial Row Reads?

2004-10-21 Thread Ken Gieselman
f each row? With a fixed row format, each field offset should be a relatively simple calculation within a row. Any/all suggestions, comments, even flames are welcoome :) Thanks in advance! ken ===

RE: Partial Row Reads?

2004-10-21 Thread Ken Gieselman
iciently, particularly when it comes to subsetting the data based on individual location, time, or detector values. Thanks for all the input! I appreciate it deeply. ken === "Diplomacy is

Re: Partial Row Reads?

2004-10-25 Thread Ken Gieselman
values, or other data like geolocation or time, and just related to this table by the 3 id fields. I'd be willing to give it a shot, but not sure what an autoincrement field would gain when the queries aren't based on insert-order. Thanks for the insight! Apprecia

MySQL non-portable with Oracle, MS-SQL, Sybase SQL statements due to ISO non-conformant backslash

2004-12-16 Thread Ken Johanson
startup option, but that apparently only changes the treatment of double quotes, and requiring single quotes for strings... '\' for example still needs a non-standard treatment. What I'd like to be able to do is have \",\\,\0 characters treated as any other so that statements bec

Re: MySQL non-portable with Oracle, MS-SQL, Sybase SQL statements due to ISO non-conformant backslash

2004-12-17 Thread Ken Johanson
Thanks!!! Yes, I found the bug on it, but it looks like its not working yet Is the bug simply no updated to show the fix perhaps? ken Sergei Golubchik wrote: Hi! On Dec 17, Sergei Golubchik wrote: On Dec 16, Ken Johanson wrote: Hi all, Does anyone know fo a way to run the server in more of a

Re: MySQL non-portable with Oracle, MS-SQL, Sybase SQL statements due to ISO non-conformant backslash

2004-12-17 Thread Ken Johanson
Tried the build 5.0.2-alpha-nt: select 'te\''st' returns "te''t" and select 'te\'''st' causes a fast server crash: -ken (the function symbols are missing so a stacktrace is a bit hard) Application exception occurred:

Eliminating special string quoting requirements, for non single-quote characters (ANSI/ISO)

2004-12-10 Thread Ken Johanson
startup option, but that apparently only changes the treatment of double quotes, and requiring single quotes for strings... '\' for example still needs a non-standard treatment. What I'd like to be able to do is have \",\\,\0 characters treated as any other so that statements bec

Re: Porting Tables Between Windows and Linux Version of MySQL

2004-12-10 Thread Ken Johanson
from testtable" || "select 8 from testTable" == okay on windows "select 8 from testtable" || "select 8 from testTable" == error on *nix. As far as moving the tables over, just a straight file copy of data/ should be fine. my.ini - my.cnf is the only stand-out other

Re: Fixing "the worst InnoDB corruption bug in 3 years" - when

2005-01-06 Thread Ken Menzel
"demonstrated performance increases" we would love to start using it! Thanks, Ken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: table_cache size for large value in opened_tables

2004-07-26 Thread Ken Menzel
nd user that runs mysql is not exceeded. Run limit to determine what this is and make sure that you check for the user that runs MySQL. Hope this helps, Ken > > OS: RH9 > Dual 2.4 Xeon > 1 GIG RAM > > (btw, this kind of question i linked to my previous post for a > performance

Re: FreeBSD and MySQL - mysqld eats CPU alive

2004-08-02 Thread Ken Menzel
same problem and everything runs great now. Ken - Original Message - From: "adp" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, July 30, 2004 2:58 PM Subject: FreeBSD and MySQL - mysqld eats CPU alive > I have several MySQL and FreeBSD installs across

Prepared Statement questions/issues

2004-08-18 Thread Ken Gieselman
0 running Solaris 9. Any suggestions as to how to do this more efficiently/faster? Or how to increase the buffer space for the prepared statements, so as to do the inserts in larger groups? Thanks in advance! Ken ===

Question about [mysql ] processes

2004-08-19 Thread Ken Sorensen
ses. Any ideas where to start looking/testing? Your help in this matter would be greatly appreciated. Thanks for you help, Ken -- _ Ken Sorensen <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Question about [mysql ] processes

2004-08-31 Thread Ken Sorensen
> Subject: Re: Question about [mysql ] processes > Ken Sorensen <[EMAIL PROTECTED]> wrote: > > > I am stumped. I have a very busy MySQL db that we've run for > > about 3 years with no problems. A couple of months ago we upgraded > > the system to RH-3AS wit

Re: FreeBSD 4.8 runaway MySQL 4.0.14

2003-08-28 Thread Ken Menzel
will settle this down some as I don't see the need to go to LINUX Threads for a single proc machine! Best of Luck Ken - Original Message - From: "Nick Gaugler" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 28, 2003 3:53 PM Subject: FW: FreeB

Re: "No more room in index file"

2003-10-06 Thread Ken Menzel
TABLE STATUS before the change then again after the change. Have you done this already? Ken - Original Message - From: "Jacco van Schaik" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 06, 2003 8:44 AM Subject: "No more room in index file"

Re: "No more room in index file"

2003-10-06 Thread Ken Menzel
ou did not hit the error 135 first. I hope this takes care of it for you, we have created very large tables (150 million rows) and had good success, as have others. If this does not fix it we may have dig a little deeper. Let us know. Best of luck, Ken - Original Message - From: "J

Re: Views in MYSQL

2003-10-13 Thread Ken Menzel
don't need or want that feature. They do not force everyone to take a performance hit so a new ferature can be implemented quickly. This works well for most MySQL users. If it does not they usually migrate to a more fully featured DBMS such as DB2, Oracle or MSSQL. Regards, Ken &g

Re: connexion avec un pocket pc

2003-10-13 Thread Ken Menzel
message: [EMAIL PROTECTED] S'abonner: [EMAIL PROTECTED] Se désabonner : [EMAIL PROTECTED] Ecrire au proprio : [EMAIL PROTECTED] URL sur Yahoo : http://fr.groups.yahoo.com/group/mysql-france/ J'espère que ça t'aide. Amicalement, Ken - Original Message ---

Re: deleting rows which table1.row=table2.row

2003-10-13 Thread Ken Menzel
ify multiple tables in the DELETE statement to delete rows from one or more tables depending on a particular condition in multiple tables. However, you can not use ORDER BY or LIMIT in a multi-table DELETE. Hope that helps, Ken - Original Message - From: <[EMAIL PROTECTED]> To

Re: repair with keycache during ADD INDEX

2003-10-20 Thread Ken Menzel
the change then again after the change. Have you done this already? Ohterwisde your key size will be too small. Ken - Original Message - From: "Franz, Fa. PostDirekt MA" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, October 17, 2003 2:34 AM Subject

Re: InnoDB or OS restriction?

2003-10-21 Thread Ken Menzel
it cputime unlimited filesizeunlimited datasize1581056 kbytes stacksize 524288 kbytes coredumpsizeunlimited memoryuse unlimited vmemoryuse unlimited descriptors 19000 memorylockedunlimited maxproc 5547 sbsize unlimited % Hope this

Re: Errors with MySQL

2003-11-20 Thread Ken Menzel
Hi Rob, My guess would be you did not see this in the Fine Manual http://www.mysql.com/doc/en/Post-installation.html or this http://www.mysql.com/doc/en/Starting_server.html Hope this helps, Ken - Original Message - From: "Rob Snow" <[EMAIL PROTECTED]> To: <[EMA

Re: Inquery from Varian Medical Systems

2003-11-24 Thread Ken Menzel
security or compress and forward or do it in multiple steps. But if it completes without errors all data will be present on the remote system. Hope this helps, Ken - Original Message - From: "robertxu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, Nov

Re: lire des fichiers windev5

2004-03-05 Thread Ken Menzel
n plus s'il est possible ce liste est en anglais. Je crois que le list mysql en français est mort. Amicalement, Ken - Original Message - From: "sa cefrais" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 05, 2004 12:20 PM Subject: lire des fichie

Newbie: Rewriting A Query- How?

2004-03-09 Thread Ken Brown
PROGID IN ( SELECT PROGID FROM SL_PORTPROG WHERE SNAPSHOTID = 56 AND PORTID IN(100994,100996) ) ) AND PROJECTSTATUS <> 'Potential' Ken <mailto:[EMAIL PROTECTED]>

Re: InnoDB tables using 90% cpu

2004-03-10 Thread Ken Menzel
://jeremy.zawodny.com/blog/archives/000458.html for Jeremey's building hints. I would also examine your innodb configuration and buffer sizes and isolation level. These are separate from myisam. Best of luck, Ken - Original Message - From: "Cliff" <[EMAIL PROTECTED]>

link error gcc compiling mysql on solaris 9 (lib not found)

2004-03-11 Thread Ken Menzel
ary when I start mysql. I hope I have include all relevant info, hope some one can point me the right way! Thanks Ken ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -ldl -lz -lposix4 -lcrypt -lgen -lsocket -ln sl -lm -lpthread -lthread ld: fatal: library -lrt: not found ld: fatal: li

Re: link error gcc compiling mysql on solaris 9 (lib not found)

2004-03-12 Thread Ken Menzel
work on Solaris. I tried linking statically because of the error on the mysql-test script from the mysql client. So now I am back to a dynamic compile, which completes just fine and the mysqld starts OK! But now I get an error from the command line mysql: hill> pwd /export/home/ken/mysql/mysql

  1   2   3   4   5   >