Re: MySQL server has gone away

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

mysql instance disk quota

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

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

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

Long time for client to connect; not for script.

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 To unsubscribe:http://lists.mysql.com/mysql

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

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

Help optimizing settings?

, 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 To unsubscribe

Database fundamentals: wanna learn.

-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? Thanks! -Ken -- This message has

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

% 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 needed it, either. Agreed. Thanks much! -Ken

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

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 allow you to rename a database? I can't

Intro to indexing?

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 viruses and dangerous content by MailScanner, and is believed

Re: What OS is the best platform for MySQL ?

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

.) 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, you might ask, index

Indexing? (Warning: relative 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 believed to be clean. -- MySQL General Mailing List For list

Re: Re: MySQL runs on 16-cores server

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 of work is going into making it scale better

Re: BSD/OS and 5.1

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/contrib/mysql

Re: Query Optimization

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

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

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

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

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 better. Ken Rene Fournier wrote: Thanks. I've read those

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

/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 Virtual Memory

Re: PHP, MySQL questions

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

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

Re: enable and disable keys

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

Re: R: rename database in 4.1

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)

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

Re: mysqld startup failure

- Original Message - From: Chris [EMAIL PROTECTED] To: jekillen [EMAIL PROTECTED] Cc: mysql@lists.mysql.com 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

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

)); 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 PROTECTED] -- http://www.fastmail.fm - Accessible with your email software or over

Re: servers full potential / FT searches locking tables

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

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 General Mailing List For list archives: http://lists.mysql.com

Re: Best way to backup three live databases

. 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' mysql@lists.mysql.com Sent: Monday, July 30, 2007 7:20 PM Subject: Re: Best way

Re: sequences and auto_increment

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 January 2007 16

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

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: mysql@lists.mysql.com Cc: [EMAIL PROTECTED] Sent: Tuesday, October 03, 2006 4:13 PM Subject: FreeBSD 6.1 + Libthr + MySQL 5.0.24a max

Re: MySQL 4.0.27-client and MySQL-4.1.21 server

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: mysql@lists.mysql.com Sent: Tuesday, August 22, 2006 1:38 PM Subject: MySQL 4.0.27-client and MySQL

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

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

RE: if else statement

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 from table2 where table2.id = 1

if else statement

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?

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

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 is

Table grows much faster than others.

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?

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

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

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

Result row count *without* buffering all results?

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

RE: how to find out the name of the server

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

installation

of MySQL. Ken Hundzinski

Complicated Subquery help

for doing the selection? Thanks for the help! ken === Diplomacy is the weapon of the Civilized Warrior - Hun, A.T. Ken Gieselman [EMAIL PROTECTED

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

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.

'); --- 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 syntax error when running the command? Thanx, Ken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

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

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

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

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: App: (pid=1188) When: 12/17/2004 @ 09:07:05.253 Exception

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

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 become portable. Thank you, Ken -- MySQL General Mailing List

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

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 become portable. Thank you, Ken -- MySQL General Mailing List

Re: Porting Tables Between Windows and Linux Version of MySQL

|| 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 translation I can think of. Best, ken Alan Scott - Yahoo

Re: Partial Row Reads?

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! Appreciate all the suggestions that you guys are throwing into the hat! ken

Partial Row Reads?

should be a relatively simple calculation within a row. Any/all suggestions, comments, even flames are welcoome :) Thanks in advance! ken === Diplomacy is the weapon of the Civilized Warrior

RE: Partial Row Reads?

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 the weapon of the Civilized Warrior

Re: Question about [mysql defunct] processes

Subject: Re: Question about [mysql defunct] 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 with RedHat's distro mysql-server 3.23.58-1.9

Question about [mysql defunct] processes

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

Prepared Statement questions/issues

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 === Diplomacy is the weapon of the Civilized Warrior

Re: FreeBSD and MySQL - mysqld eats CPU alive

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 a few different sites, and I

Re: table_cache size for large value in opened_tables

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 tuning guide) Thanks! Here's my status Variable_name,Value, Aborted_clients

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

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.

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

Two problems with prepared statements in ver 5.0.0

, Ken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

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,

Re: can't load library

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 PROTECTED] To: [EMAIL PROTECTED] Sent

count() on multiple similar tables?

of the 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 Warrior

Re: count() on multiple similar tables?

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 -- Trying to come up with a way to count across

Re: InnoDB - Foreign Key - Error 150.

! 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 - Error 150. Hi, I don't think mysqldump takes foreign key

Re: [client] var not working

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, April 29, 2004 10:38 AM Subject

Re: table locking using perl DBI

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, 2004 10:01 PM Subject: table locking

Re: mysql using big two tables in BSD

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: 10 minutes seems excessive...

=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. The explain below shows we'll be working

Re: Problems building readline on Solaris 7

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, 2004 8:44 AM Subject

Re: FBSD 5.2.CURRENT-p4 and mysqld problems

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 locks mysql server any further processing. I'm using mysql-4.0.18

Re: How to protect MySQL server from intruders ?

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

Re: Perl Modelues

: 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 PROTECTED] Sent: Thursday, April 08, 2004 1

Re: Could some one help !

this 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 Subject: Could some one help ! Hi

Re: Perl Modelues

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: [EMAIL PROTECTED] Sent

How to diagnose MySQL syntax error

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

there dealing with large volumes of numeric data? Thanks in advance, Ken === Diplomacy is the weapon of the Civilized Warrior - Hun, A.T. Ken Gieselman

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

.* 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 - From: samana [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 24, 2004 7:57 PM Subject: aide urgente site

Re: Enabling Logging

every time. Either way if there is an error the text of the error will get mailed to you. /UNIX 101 Hope this helps, ken - Original Message - From: Jai Jones [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 13, 2004 3:22 AM Subject: Enabling Logging Hi, I am a little

Re: problem with sql as a service

?! The 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 pc, after unzipping the files

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

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-4.0.18/client hill ./mysql ld.so.1

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

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 [EMAIL PROTECTED] To: [EMAIL

Re: two masters, one slave

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: [EMAIL PROTECTED] Sent: Friday

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

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] To: Sasha Pachev

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

start mysql. I hope I have include all relevant info, hope some one can point me the right way! Thanks Ken much cut ../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

Re: InnoDB tables using 90% cpu

://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] To: [EMAIL PROTECTED] Sent

Newbie: Rewriting A Query- How?

AND 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

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 fichiers windev5 Bonjour, La

Re: MySQL Backup advice

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: Thursday, March 04, 2004 12:09 PM Subject: Re: MySQL Backup

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

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 PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday

Re: my.cnf in MySQL-Server-4.0.17

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-Server-4.0.17 Hi All, I´m trying

RE: MySql and Oracle Forms 6i

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 Griffiths [mailto

MySql and Oracle Forms 6i

Is there any way of using MySql as a back end to Oracle Forms? Ken Desperately trying to justify not going back to oracle db Brown

Passwords and ODBC - what am I missing

So what have I done wrong? Ken

RE: Passwords and ODBC - what am I missing

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 installed 4.1.1 on windows 2000

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

I need to do this to get round password issues as -old-passwords doesn't work Anyone any ideas? Kwn

Oracle Question

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

  1   2   3   4   5   >