Re: max_rows query + SegFaulting at inopportune times

2007-03-22 Thread JP Hindin
MySQL. > > -Micah > > On 03/22/2007 01:02 PM, JP Hindin wrote: > > Addendum; > > > > On Thu, 22 Mar 2007, JP Hindin wrote: > > > >> Zero improvement. I used the following CREATE: > >>MAX_ROWS=10; > >> > > > > At first I th

Re: max_rows query + SegFaulting at inopportune times

2007-03-22 Thread JP Hindin
Mea culpa, mea culpa, mea maxima culpa. I slink to my corner with Google in hand and apologise for wasting your time. Here's hoping, of course, in four days I don't find out I'm wrong about the 4.2b rows part. - JP On Thu, 22 Mar 2007, JP Hindin wrote: > Addendum; > > On

Re: max_rows query + SegFaulting at inopportune times

2007-03-22 Thread JP Hindin
Addendum; On Thu, 22 Mar 2007, JP Hindin wrote: > Zero improvement. I used the following CREATE: > MAX_ROWS=10; At first I thought I had spotted the obvious in the above - the MAX_ROWS I used is smaller than the Max_data_length that resulted, presumably MySQL being smarter

Re: max_rows query + SegFaulting at inopportune times

2007-03-22 Thread JP Hindin
ng to get quite confused as to how my efforts seem to return me to the same problem time and time again. I look forward to any further suggestions you may have; JP On Thu, 15 Mar 2007, Brent Baisley wrote: > You probably did not change the max_rows setting when you created the table

Re: max_rows query + SegFaulting at inopportune times

2007-03-15 Thread JP Hindin
o 2 TB in size. > On 3/15/07, JP Hindin <[EMAIL PROTECTED]> wrote: > > > > Greetings all; > > > > I have a quandary regarding table limits, and clearly I am not > > understanding how this all works together. I have a test database which > > needs to keep

max_rows query + SegFaulting at inopportune times

2007-03-15 Thread JP Hindin
h is a factor in the max_data_length of the table, and is my above query going to release me from my hovering 4GB table limit? Has anyone seen this blasted SegFault issue before? I appreciate any help I can get with this one, I'm obviously missing something, flame away. Many thanks. - JP -

Invitación: Webinar MySQL 5.0 - Nuevas funcionalidades para la Empresa

2006-01-26 Thread JP Files
Amigos me llegó este mail, quiza les sea de ayuda. Jorge Paiva Lima - Peru MySQL 5.0 - Nuevas funcionalidades para la Empresa Miércoles 1 de Febrero de 2006 MySQL les invita a participar en el primer webinar en castellano para España y L

oledb provider with transaction support?

2003-07-07 Thread jp
i downloaded oledb provider from mysql.com, i use Delphi's ADO. but i found that this oledb provider does not support transaction. is there any oledb provider that does support transaction? thanks

RE: having trouble killing mysqld to restart and change root

2002-02-11 Thread JP Audette
et the monitor started? JP At 03:20 PM 2/6/2002 -0600, you wrote: >If you need to, use the "kill -9 > >-9 is a definite kill and it will work > > >-Original Message- >From: JP Audette [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, February 06, 2002 2:52 PM >

RE: having trouble killing mysqld to restart and change root

2002-02-11 Thread JP Audette
a ps I can see that it's definitely been started, but the fact that I can't do anything with mysqladmin makes me think that it hasn't loaded the way it needs to. JP Ye, that did the trick. I was able to get the daemon restarted using the --skip-grant-tables & option,

monitor will not start

2002-02-06 Thread JP Audette
like maybe that's not the problem (unless the monitor has different disk space needs than the tables). Are there any other reasons why the monitor won't start? I can't get mysqladmin to function properly either (same problem - hung cursor after entering t

RE: having trouble killing mysqld to restart and change root pass word

2002-02-06 Thread JP Audette
a ps I can see that it's definitely been started, but the fact that I can't do anything with mysqladmin makes me think that it hasn't loaded the way it needs to. JP Ye, that did the trick. I was able to get the daemon restarted using the --skip-grant-tables & option,

RE: having trouble killing mysqld to restart and change root pass word

2002-02-06 Thread JP Audette
et the monitor started? JP At 03:20 PM 2/6/2002 -0600, you wrote: >If you need to, use the "kill -9 > >-9 is a definite kill and it will work > > >-Original Message- >From: JP Audette [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, February 06, 2002 2:52 PM >

having trouble killing mysqld to restart and change root password

2002-02-06 Thread JP Audette
sing the --skip-grant-tables option. Can someone help me understand which of the pid's is the actual one, and how I can kill it? Thanks, JP - Before posting, please check: http://www.mysql.com/manual.php (the manual)

need developer to help transfer our site

2002-01-17 Thread JP Audette
r for this project. The site is not very big, and our new host is already in place, so it should be mostly a matter of transferring files. If anyone on this list is interested in our meager project please reply to me directly at [EMAIL PROTECTED] Thank

Grant problems

2001-05-18 Thread jp
I have successfully installed MySQL 3.23.38. I can start the server and log in as root. When I try to grant new users using: grant insert to test.* for testuser identified by 'testpassword'; It comes back saying 0 rows affected. I can go the the MySQL db and look at the grant table and it

Re: Configuring PHP for MySQL

2001-05-17 Thread jp
. Like I said I'm a newbie. JP - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTEC

Re: Configuring PHP for MySQL

2001-05-17 Thread jp
Sorry Jorge. I thought that the individuals on this list would be more qualified to answer a question regarding where a specific installation (3.23.38 RPM) of MySQL placed specific files ( "header files"? ) than would PHP users. Justin Pease On 17 May 2001, at 9:53, Jorge del Conde wrote: >

Configuring PHP for MySQL

2001-05-17 Thread jp
Thanks for the responses. Unfortunately they didn't work. I tried /usr/local /usr/local/mysql /usr/lib /usr/lib/mysql /usr/var /usr/var/mysql and /usr/bin for the --with-mysql=/. command to configure PHP4. It still says "Header files not found at .. " Does anyone know what

Configuring PHP for MySQL

2001-05-16 Thread jp
I just installed the latest version of MySQL (3.23.38 I believe) from an RPM on Red Hat Linux 7.0. My question is when configuring PHP4 I need to include the --with-mysql= ? statement. Where would the correct file be with the RPM install. I have tried almost every directory I can find t