Re: Examples of savepoints and transactions

Kind Regards / Med venlig hilsen Lars Nielsen > - Original Message - >> From: "Lars Nielsen" >> To: "MySql" >> Sent: Tuesday, 23 January, 2018 23:19:29 >> Subject: Re: Examples of savepoints and transactions > >>> D

Re: Examples of savepoints and transactions

Den 22-01-2018 kl. 22:01 skrev shawn l.green: Hello Lars, On 1/21/2018 3:37 PM, Lars Nielsen wrote: Hi, I have a system that uses begin and commit transactions. It works like a dream! ;) Now I want to test it by creating test data. This how ever cannot be rolled back. I think the solution

Examples of savepoints and transactions

scenario. Are there some good guides or tutorials out there somewhere? Any suggestions are welcome. Best regards Lars Nielsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

SV: Mysql goes down when executing query

Hi Try setting these variables in you conf: set-variable = innodb_buffer_pool_size=128M set-variable = innodb_additional_mem_pool_size=10M you have to experiment with the size as it depends on how much ram you hardware has. Nickolai Nielsen -Oprindelig meddelelse- Fra: [EMAIL PROTECTED

SV: ASP Connection to Mysql fails

Hi Try doing a "response.write conn" after you have made a connection with the DSN that should print out the connection string the DSN is using i hope this help debug the problem Nickolai Paul Stearns wrote: > Actually I can connect from the web server to the DB server using DSN (the odbc tool

SV: MySQL/InnoDB crashes system

. Nickolai -Oprindelig meddelelse- Fra: Nickolai Nielsen [mailto:[EMAIL PROTECTED] Sendt: 10. juli 2004 16:28 Til: [EMAIL PROTECTED] Emne: SV: MySQL/InnoDB crashes system Hi I still got this freeze problem, i have found out that this bug is related to InnoDB, i converted the table that

SV: MySQL/InnoDB crashes system

996B Gigabit NIC The servers have SP4 and all updates if anyone have an idea on how to troubleshoot this? Thanks Nickolai Nielsen -Oprindelig meddelelse- Fra: Heikki Tuuri [mailto:[EMAIL PROTECTED] Sendt: 9. juli 2004 05:07 Til: [EMAIL PROTECTED] Emne: Re: MySQL/InnoDB crashes system

MySQL/InnoDB crashes system

ey: -1 len: 0 init_read_record: info: using rr_sequential init_io_cache: info: init_io_cache: cachesize = 131072 *** here it crashed *** Thanks Nickolai Nielsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Obscure FULLTEXT search problems

eNum varchar(20) NOT NULL default '', Timestamp datetime NOT NULL default '-00-00 00:00:00', Body text NOT NULL, Footer varchar(255) NOT NULL default '', PRIMARY KEY (ArticleId), KEY Timestamp (Timestamp), FULLTEXT KEY Title (Title,Body) ) TYPE=MyISAM;

Re: HELP - Having serious trouble here...

On Mon, 2002-10-14 at 17:29, Anders Nielsen wrote: > On Mon, 2002-10-14 at 16:51, John Hinton wrote: > > I'm having the same problems. I'm on a RedHat machine... 7.2 running > > MySQL ver. 3.23.41. I've been told to upgrade my package. > > > > Me too.

Re: HELP - Having serious trouble here...

he problems (my problems started after upgrading glibc). After I downgraded glibc back to glibc-2.2.4-29 on the server I could once again connect to mysql over network. -- Anders Nielsen <[EMAIL PROTECTED]> - Before

Mysql eating up diskspace.

Hello everyone. I have had this very strange problem with Mysql, it seems to start eating diskspace untill the disk is full, restarting the mysql process seems to free all the used space again. Any idea what could be wrong? Kind regards Michael Wulff Nielsen

Re: Non Ascii characters

hey If the text is supposed to be parsed from a mySQL to a HTML webpage, using € or € should display a € sign. A simple replace would then do the trick. Doc - Original Message - From: "Haapanen, Tom" <[EMAIL PROTECTED]> To: "Mysql@Lists. Mysql. Com" <[EMAIL PROTECTED]> Sent: Wednesday,

Replication question

o the external server, but the external server can't open a connection to the local server. Please help me out! -- Jakob Vad Nielsen System Developer NHST/TDN/EUROPOWER - Before posting, please check: http://www.mysql.com/

RE: NT installation

TED]] > Sent: Tuesday, March 27, 2001 11:47 AM > To: Chad Nielsen > Cc: [EMAIL PROTECTED] > Subject: Re: NT installation > > > Hi Chad > > You do not need a Telnet client. Just install Myodbc and the mysql client. > > To connect to your server, type "mysql -h yo

NT installation

Hi, I'm trying to install mySQL on NT Server 4.0 I guess I need to install a Telnet Server so I can manage mySQL from a workstation. What's a good Cheap or Free Telnet Server for NT? Also, any instructions on how to set this up would be great. Thanks, Chad Chad M. Nielsen, GIS

searching tables.

d not know what "id" it was, is there a way i can "search" the table, and only show the relevent information that i need? Thanks in Advanced. John Nielsen. - Before posting, please check: http://www.mysq

auto_increments

Hey everyone, This may have already come up a couple of times in the mailling list, but I I was wondering with mysql-3.22.32 if you can have two auto_increment's in one table, e.g.: +--+--+--+-+-++ | Field| Type | Null | Key | Def

RE: CREATE TABLE / Telnet (Linux / Unix server)

/ssh/ssh2/etc), you can execute the command. And, no, the extension may be anything (all you're doing is redirecting the contents of the file (via '<') into the 'mysql ' command. HTH, Jon A. Nielsen. ---

General MySQL Questions

dvice) --- Jon A. Nielsen Lazarus of Spear of Insanity MUD http://spear.kilnar.com/ telnet://spear.kilnar.com:1066/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysq