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,

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

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

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

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

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

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

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

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

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

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

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: 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: 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: 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-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: 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: 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: 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: 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: Error in /index.php: Access denied for user 'apache'@'localhost' (using password: NO)

2008-02-02 Thread Ken Odoki-Olam
My guess is that you have the privileges set on your local box that allow connections with those credentials but the same privileges are not set up on your clients machines. Although using apache as a user without a password is quite a security risk. And then mailing those details to a public mail

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

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

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: 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: if else statement

2006-06-22 Thread Song Ken Vern-E11804
is. Examples only show numeric and string functions. -Original Message- From: Peter Lauri [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 21, 2006 4:43 PM To: [EMAIL PROTECTED]; Song Ken Vern-E11804 Cc: mysql@lists.mysql.com Subject: RE: if else statement SELECT IF(col1=3, (Select col2 f

if else statement

2006-06-21 Thread Song Ken Vern-E11804
onal test using a subquery? Am I on the right track or is there another way to do this? Thanks -- Ken e11804 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

mysqlcc temp table created for queries

2006-03-28 Thread Song Ken Vern-E11804
Hi, I am using mysqlcc 0.9.4-beta to browse my DB. Server side am using 5.0.18-nt. However, when I try to double click on a table to see the data, it will always return the error. "[localhost] ERROR 1146: Table 'test.1' doesn't exist" The SQL query for this is "SELECT * FROM `test`" The query i

Table grows much faster than others.

2006-02-19 Thread Song Ken Vern-E11804
Hi, I have one table which grows at a much faster rate than the rest. It has 80 times more entries than the second largest table, which has 10k rows. What are the steps I can take to slow down the growth? Can I partition the table? Will the size of the table affect the perfomance of queries? I

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

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: how to find out the name of the server

2005-08-10 Thread Ken Y. Brown
Is this information exposed anywhere or am I going to have to write something In particular I want the connection ID And Is the application at the source exposed And Can you trap the login event as a trigger yet? Kn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

installation

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

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

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]

Error when reading back dump file.

2004-12-22 Thread Song Ken Vern-E11804
SERT INTO `tasklist` VALUES (67,'user','test','','test','','2004-12-22'); --- However when I log into client and issue :- mysql> source ./zztest_irt.sql; Query OK, 0 rows affected (0.00 sec) it seem to work fine. Is there 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:

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

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

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

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

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

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]

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 ===

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

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

using a column value in IN() in a join condition.

2004-06-11 Thread Ken Easson
ite a number of Join types, all to no avail. any help would be great. ken easson justken.net [EMAIL PROTECTED] justken web programming and technical support. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL limits.

2004-05-21 Thread Ken Menzel
Hi, Signal 11 can also indicate hardawre problems on BSD. Also FreeBSD might get you more answers quickly as there are more of us running FreeBSD with MYSQL for some reason. We runn FreBSD w MySQL/Linux threads on 4.9 and 5.2 and both work just fine. Ken - Original Message - From

Two problems with prepared statements in ver 5.0.0

2004-05-08 Thread Ken Paradox
hese features? Is anyone using this? Thanks, Ken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: can't load library

2004-05-06 Thread Ken Menzel
y previous runs of ldconfig are also rescanned for new shared libraries. So I would guess you want ldconfig -m, or reboot your system and I am sure it will scan for new shared libraries. Best of luck. Ken - Original Message - From: "Bob DeBolt" <[EMAIL PROTE

Re: Range query on datetime with index - any optimization?

2004-05-06 Thread Ken Menzel
Should work fine. Quick test from a large sales test table (1.9 million rows): mysql> select count(*) from sali; +--+ | count(*) | +--+ | 1983026 | +--+ 1 row in set (0.00 sec) mysql> select salidate,sum(saliQtySold) from sali where salidate > DATE_SUB(CURRENT_DATE, INTER

Re: InnoDB - Foreign Key - Error 150.

2004-05-04 Thread Ken Menzel
e end! Best of luck, Ken - Original Message - From: "Marvin Wright" <[EMAIL PROTECTED]> To: "Tucker, Gabriel" <[EMAIL PROTECTED]>; "Mysql General (E-mail)" <[EMAIL PROTECTED]> Sent: Tuesday, May 04, 2004 10:22 AM Subject: RE: InnoDB - Foreign Key -

Re: count() on multiple similar tables?

2004-05-04 Thread Ken Gieselman
Great! Thanks for the quick pointer! ken Quoting Diana Soares <[EMAIL PROTECTED]>: > You may use MERGE TABLES: > > http://dev.mysql.com/doc/mysql/en/MERGE.html > > -- > Diana Soares > > On Tue, 2004-05-04 at 10:08, Ken Gieselman wrote: > > Heya folks -- &

count() on multiple similar tables?

2004-05-04 Thread Ken Gieselman
tables individually and add the results, but looking for a more graceful way of doing it, hopefully. Thanks in advance! ken === "Diplomacy is the weapon of the Civilized Wa

Re: [client] var not working

2004-04-29 Thread Ken Menzel
hi Lou, I believe this is a recent feature so make sure you on on 4.0.18 if possible, I know is was added before 4.0.14. I am not sure this works on 3.23. Ken - Original Message - From: "Lou Olsten" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, A

Re: table locking using perl DBI

2004-04-28 Thread Ken Menzel
connections might be an option, but you can't guarantee your CGI will get the same connection and be able to release the lock! Hope this helps, Ken - Original Message - From: "Andy Ford" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 26, 2

Re: 10 minutes seems excessive...

2004-04-22 Thread Ken Menzel
=month_day then? Ken - Original Message - From: "Mailing Lists" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 21, 2004 3:04 AM Subject: 10 minutes seems excessive... > Hello all... > > Source table has approximately 23,000,000 rows.

Re: mysql using big two tables in BSD

2004-04-22 Thread Ken Menzel
Hi Kamlesh, You should send an explain of the query, but if there is no index on tableB.user_id your join will not work well, since the actual join would be on tableB.user_id=tableA.user_id Either change your index on table b to be user_id,user_data2 or add this index. Hope this helps, Ken

Re: How to protect MySQL server from intruders ?

2004-04-12 Thread Ken Menzel
world. If you need to allow outside access use a VPN. If that is not an option some systems employ "wrappers" look at /etc/hosts.allow or hosts_access. You could also install a software firewall on your system. But this is outside the scope of this mailing list. Hope this helps, Ken

Re: FBSD 5.2.CURRENT-p4 and mysqld problems

2004-04-12 Thread Ken Menzel
ged and fixed. Hope this helps, Ken - Original Message - From: "Ganbold" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, April 11, 2004 11:35 PM Subject: FBSD 5.2.CURRENT-p4 and mysqld problems > Hi, > > I found some problematic queries which loc

Re: Problems building readline on Solaris 7

2004-04-12 Thread Ken Menzel
Hi Erek, This seems familiar to me, are use still using Solaris make? If yes, try using GNU (gmake) it looks like a make problem. Hope this helps, Ken - Original Message - From: "Erek Dyskant" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 12

Re: Perl Modelues

2004-04-08 Thread Ken Menzel
S] Options: etc The perl DBD module should be able to find and use this program to configure itself. If you get a command not found error add the mysql bin driectory to the path. Ken - Original Message - From: "Kirti S. Bajwa" <[EMAIL PROTECTED]> To: <[EMAIL PROTECT

Re: Perl Modelues

2004-04-07 Thread Ken Menzel
Just type in the empty search box at the top of the screen: DBI returns: http://search.cpan.org/~timb/DBI-1.42/DBI.pm mysql returns: http://search.cpan.org/~rudy/DBD-mysql-2.9003/ Hope that helps Ken - Original Message - From: "Kirti S. Bajwa" <[EMAIL PROTECTED]> To: &

Re: Could some one help !

2004-04-07 Thread Ken Menzel
command: ./scripts/mysql_install_db --user=mysql RTFM Step 2 http://www.mysql.com/doc/en/Unix_post-installation.html Hope this helps, Ken - Original Message - From: "Ravi T" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 07, 2004 4:50 PM Subjec

How to diagnose MySQL syntax error

2004-03-29 Thread Ken Elder
hanks in advance for any advice! Ken Elder Oklahoma City -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Reading Binary Data

2004-03-27 Thread Ken Gieselman
nts for them. Anyone else out there dealing with large volumes of numeric data? Thanks in advance, Ken === "Diplomacy is the weapon of the Civilized Warrior"

Re: aide urgente site d'une association que nous n'arrivons plus a reinstaller

2004-03-26 Thread Ken Menzel
l de site de web avec le usager et mot de passe correspondants. GRANT ALL ON nom-de-BD.* TO 'usager'@'localhost' identified by 'mot-de-passe' vois: http://www.mysql.com/doc/fr/GRANT.html espère que ça t'aide, Amicalement, Ken Menzel - Original Message

Re: problem with sql as a service

2004-03-13 Thread Ken Menzel
execution path should be correct and set when you installed the service! Thanks Ken - Original Message - From: "Charles Fletcher" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, March 13, 2004 2:18 PM Subject: problem with sql as a service i put mysql on my p

Re: Enabling Logging

2004-03-13 Thread Ken Menzel
et a mail every time. Either way if there is an error the text of the error will get mailed to you. Hope this helps, ken - Original Message - From: "Jai Jones" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, March 13, 2004 3:22 AM Subject: Enabling Log

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

2004-03-12 Thread Ken Menzel
OK, sorry to answer my own post, libgcc was is /usr/local/lib which did not get properl added with crle! crle -u -l /usr/local/lib Problem gone! Sorry to waste bandwidth (we are just learning solaris!). Ken - Original Message - From: "Ken Menzel" <[EMAIL PROTECTED

Re: two masters, one slave

2004-03-12 Thread Ken Menzel
Not at this time, however you could have two different slaves on the same physical server using mysql_mutli type of configuration. http://www.mysql.com/doc/en/mysqld_multi.html Hope it helps Ken - Original Message - From: "Ari Davidow" <[EMAIL PROTECTED]> To: <[EMA

Re: mysql-4.0.18 build problem in FreeBSD-5.2-CURRENT

2004-03-12 Thread Ken Menzel
table or FreeBSD 4.9 for production or even 5.2. I know there have been massive threads changes on -current. see also http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/eresources.html#ERESOURCES-MAIL Hope that helps, Ken - Original Message - From: "Ganbold" <[EM

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

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

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

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

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

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

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

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

  1   2   3   4   5   >