Re: Delayed insert record visibility
Hi Peter, - Original Message - From: "Peter Thomas" Sent: Saturday, May 01, 2004 11:24 PM Subject: Delayed insert record visibility > I'm trying to understand the delayed insert process to see whether I can use > it to reduce the load on mysql, and have the following question. > > Are 'delayed inserts' which are queued but not yet actually added to the > database by the handler visible to selects on the table? > > I'm assuming they are not. Hence, if I am using a table effectively as a > queue, where I insert records on one end and select.. limit 1 to pull them > off the other end, I could end up being told by the select that there is > nothing left in the queue, when in reality there could be a dozen records > waiting in the delayed insert handler waiting to be put into the table. > > Is my assumption correct? Yes it is. > Cheers > Peter Matt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Performance Tuning on FreeBSD
At 11:50 PM 5/1/2004, you wrote: Hi all, I have a db that is connection heavy running on FreeBSD 4.9. The server was compiled with Linux Threads enabled. I am searching for performance tuning information. Outside of enabling Linux Threads I haven't been able to find much else. I am under the impression that I should be using innodb tables instead of myisam, and I am sure there are a slew of other things that I could tune. Is there a site/document dedicated to this? My copy of high performany mysql by Jeremy Zawodny is in the mail, so any help in the mean time would be greatly appreciated. I am getting "cannot create new thread" errors on my system when load gets extremely heavy, are there any additional things I can do to help this? Would FreeBSD 5.1 be any better? Thanks in advance, -Max Max, From my experience MyISAM tables are faster for Selects, and InnoDb is faster for many simultaneous updates/inserts from various users. Single user updates are faster for MyISAM. For tuning into have you tried: http://www.google.ca/search?q=mysql+performance+tuning&ie=UTF-8&oe=UTF-8&hl=en&btnG=Google+Search&meta= or http://dev.mysql.com/doc/mysql/en/InnoDB_tuning.html http://www.linux-mag.com/2001-06/mysql_01.html Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Indexing
I know this is an elementary question, but I am getting two sets of instructions from different MySQL manuals about setting an index on a prefix of a column of a table. One says to use: KEY indexName (colName(length)) and the other says to use INDEX indexName (colName(length)) Are both all right? Any light shed on indexing columns would be much appreciated. Thanks, John -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Performance Tuning on FreeBSD
Hi all, I have a db that is connection heavy running on FreeBSD 4.9. The server was compiled with Linux Threads enabled. I am searching for performance tuning information. Outside of enabling Linux Threads I haven't been able to find much else. I am under the impression that I should be using innodb tables instead of myisam, and I am sure there are a slew of other things that I could tune. Is there a site/document dedicated to this? My copy of high performany mysql by Jeremy Zawodny is in the mail, so any help in the mean time would be greatly appreciated. I am getting "cannot create new thread" errors on my system when load gets extremely heavy, are there any additional things I can do to help this? Would FreeBSD 5.1 be any better? Thanks in advance, -Max -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Delayed insert record visibility
I'm trying to understand the delayed insert process to see whether I can use it to reduce the load on mysql, and have the following question. Are 'delayed inserts' which are queued but not yet actually added to the database by the handler visible to selects on the table? I'm assuming they are not. Hence, if I am using a table effectively as a queue, where I insert records on one end and select.. limit 1 to pull them off the other end, I could end up being told by the select that there is nothing left in the queue, when in reality there could be a dozen records waiting in the delayed insert handler waiting to be put into the table. Is my assumption correct? Cheers Peter -___- Peter Thomas, WebTrax Web Services Email: [EMAIL PROTECTED] Mobile: 0402 204 220, Phone/Fax: 61 2 6251 1818 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Accessing DBMS remotely: MySQL? FireBird?
Hi, Some of our customers have remote offices. I was wondering if it'd be safe to have a DBMS running at their central office, and have our client application running on hosts in the branches connect to it through a VPN via the Net? What happens if the connection goes south while a branch office was making changes? Does the DBMS just rollbacks changes automatically after a time-out? Should we set up some kind of replication instead? Also, are there compeling reasons to go for Firebird instead of MySQL? I don't know enough about the capabilities of each DBMS today to make an educated choice. Thank you for any tip Fred. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Repair tables
At 18:12 -0500 5/1/04, Mike Blezien wrote: Hello, What is the recommend alternative to REPAIR TABLE for InnoDB tables, this does not work with Innodb table types ?? Dump and reload. http://dev.mysql.com/doc/mysql/en/Backing_up.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Repair tables
Hello, What is the recommend alternative to REPAIR TABLE for InnoDB tables, this does not work with Innodb table types ?? TIA -- MikeBlezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Quality Web Hosting http://www.justlightening.net MSN Messager: [EMAIL PROTECTED] Cell:1.985.320.1191 - Office:1.712.737.2548 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: triggers (or too-many-crappy-questions)
> I found that the Postgres mailing list was full of very polite, super > helpful people. I found that the MySQL list was full of relatively cranky > people with little patience. > > Over that last year, I've I think I've discovered why. The average quality > of the questions posted on the MySQL list are quite low (compared to the > Postgres lists), and I think many of the people who are in a position to > respond are fed up. That's part of the price of "fame." You get more people who know of MySQL as a "buzzword," so think "Oh, I'll try that." In addition, there are a lot of open source programs out there that use MySQL as their back end, thus, many more people are trying to install MySQL. In the end, you get the people that don't and/or refuse to read documentation, and just post to the list. > "Sir, > > How I use MySQL? Why I want use it? Where I download from? > > Kindest regard." Not to disparage our foreign members, but it does seem that often those for whom English is not their mother tongue do not want to read through pages of English documentation. There are other languages for the docs I believe, but those don't always get found. > Maybe a new MySQL list is needed - one called Dumb Questions, and when > someone posts one to any other list, someone can quickly respond, "Please > repost this on the MySQL Dumb Questions list, as that's where it belongs". What is needed is moderation. I would happily volunteer to serve as moderator on this list (check back later to see if I've changed my mind :), as it is not terribly high traffic (and would be even lower if we eliminated all the newbie posts). When a post came across the list that is answered in the archives or the docs, a message could be bounced back saying so. It would probably cut list traffic by half. j- k- -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: libmysql setting it's own signal handlers?
OK...thanks for the clarification. It helps. And it's good to know that what I'm doing won't break anything. j- k- On Thursday 29 April 2004 07:16 pm, Sasha Pachev said something like: > Joshua J. Kugler wrote: > > I have a program that is using (via a front end library) libmysql. If I > > set up a signal handler before I initialize libmysql, my signal handler > > is not called when that signal is sent to the process. If I move the > > line of code that sets the signal handler to *after* the line that > > initializes libmysql, my signal handler works fine. > > > > What does libmysql do to the signal handlers when it initializes? I > > don't have the source for it in front of my, or I would probably go > > digging my self. Running up against a deadline as it is. :) > > mysql client library traps SIGPIPE to deal with some weird threading > issues. The problem is that is some cases, a threaded program might get a > spurious SIGPIPE, and then the program crashes if it is not handled. What > you are doing should be just fine - all that happens inside is that SIGPIPE > is ignored. The only problem is if you really want to handle SIGPIPE while > in the middle of a mysql call. In that case, recomple the client without > --enable-thread-safe-client or hack the source. > > -- > Sasha Pachev > Create online surveys at http://www.surveyz.com/ -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connect string for ASP
Ummm...you can't do that. The MyODBC driver is used by the script to connect via ODBC. It has to be in a place where ASP can find and use it. It does no good if it is on another machine. The driver does not need to reside on the server machine: it is a client-side piece of software. j- k- On Thursday 29 April 2004 11:06 am, michael johnson said something like: > The connection I am trying to make is from a website where the hosting > machine will not have Myodbc installed and the database I am trying to > connect to is on another Internet visible server where MySQL is installed > and myodbc is installed. > > -Original Message- > From: Victor Pendleton [mailto:[EMAIL PROTECTED] > Sent: 29 April 2004 19:54 > To: 'Joy Johnson '; Victor Pendleton; ''michael johnson ' '; > ''[EMAIL PROTECTED] mysql. com ' ' > Subject: RE: Connect string for ASP > > > You will need to have MyODBC installed. You do not need to create a DSN. > > -Original Message- > From: Joy Johnson > To: 'Victor Pendleton'; 'michael johnson '; '[EMAIL PROTECTED] mysql. com ' > Sent: 4/29/04 1:50 PM > Subject: RE: Connect string for ASP > > I presume I do not need myodbc installed anywhere to do this. > > Thanks for the prompt response > > BPEnet Sales & Support Team > > BPEnet EMEA > Sun iForce Premier Solution, Sales, Change Management & Development > Partner > Part of the BPE Group Limited > 13 Austin Friars > London > EC2N 2JX > Tel: 0870 922 0247 / 0207 670 1690 > Fax: 0207 670 1717 > E-mail: [EMAIL PROTECTED] > Web: www.bpenet.net > BPEnet Offices in: Sussex, London & Dublin > > > -Original Message- > From: Victor Pendleton [mailto:[EMAIL PROTECTED] > Sent: 29 April 2004 19:46 > To: 'michael johnson '; '[EMAIL PROTECTED] mysql. com ' > Cc: 'Joy Johnson ' > Subject: RE: Connect string for ASP > > > ConnectStr = "Driver={MySQL ODBC 3.51 Driver};server=;DB=;UID=;PWD=" > > > -Original Message- > From: michael johnson > To: [EMAIL PROTECTED] mysql. com > Cc: Joy Johnson > Sent: 4/29/04 1:33 PM > Subject: Connect string for ASP > > Dear All > > I am using ASP. Can anyone give me the connection code to connect to a > MySQL database without using ODBC DSN? > > Thanks > > Michael Johnson > Director > > BPEnet EMEA > Sun iForce Premier Solution, Sales, Change Management & Development > Partner Part of the BPEnet Group Limited 13 Austin Friars London EC2N > 2JX Tel:. +44 (0)870 922 0247 / (0)207 670 1690 > Fax: +44 (0)207 670 1717 > E-mail: [EMAIL PROTECTED] > Web: www.bpenet.net > BPEnet Offices in ~ Sussex, London & Dublin -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: triggers (or too-many-crappy-questions)
At 12:22 -0700 on 04/30/2004, Eric wrote about Re: triggers (or too-many-crappy-questions): Hi, Can we have list for people who just like to give newbies shit? How about [EMAIL PROTECTED] How much have you guys paid for your support hmm? This is a free mailing list and I don't really see why people have to moan about a few simple questions every once in a while. The people who moan about RTFM crap are much more of a bother to me than a poor guy who doesn't know his way around mysql yet, doesn't get how useful and complete the manual is, and needs some basic help. Thanks, Eric I've been on mailing lists that have attempted to TRY TO solve this problem by sending a "Top 10 FAQS" Message along with a "Welcome - You're now Subscribed" one to all new subscribers. This seems to help keep the RTFM type of questions to a lower level. Putting a mail-to link to request a new copy of the Top 10 message in the list signature (for those lists that add a footer signature) keeps the address visible once the user is on the list. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fwd: [xbasic] Re: Calls to C libs (database)
Howdy -- I've been tinkering with Xbasic(http://xbasic.org). While there isn't any native DB support (ODBC is in the works). This got me to thinking about making calls to MySQL libs or dll(s) (in the case of Windows). Being mainly a PHP person (and no C), I'm hoping than someone will explain the forwarded email to me (example would be great), also here is alink to a "how-to" for using 3rd party dll and libs: http://xbnotes.freehosting.net/dllprimer.html TIA, David - Forwarded message from Ken Minogue <[EMAIL PROTECTED]> - Date: Sat, 01 May 2004 01:04:02 - From: Ken Minogue <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Subject: [xbasic] Re: Calls to C libs (database) To: [EMAIL PROTECTED] --- In [EMAIL PROTECTED], "davidjayjakson" <[EMAIL PROTECTED]> wrote: > Howdy -- > I read the reply previous post about SQL Server/MySQL support > mentioned ODBC? > What's the status of that, and can I get a lib to test? > > My other question(s) are, Can I make a call to a C lib? Or maybe > directly to MySQL lib or MySQL API? > > Links to doc/examples explaining how to make calls to C libs in > general as well as links, example dealing with MySQL would be > appreciated. > > TIA, > David Jackson Can't help you on MySQL, but you can get general information about calling other-language DLLs at http://xbnotes.freehosting.net/dllprimer.html Ken Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/xbasic/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - End forwarded message - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
No Posting
Test message. This is a test message. I have not received any post from MySQL for two days. I just want to make sure that this message gets back to me. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: lower_case_table_names
At 13:23 + 5/1/04, shaun thornburgh wrote: Hi, I am trying to set the mysql variable lower_case_table_names to 2, however I am having serious difficulties! I understand I need to do this at the command line but I have tried the following (with many variations) without success: C:\mysql\bin>mysqld --SET-lower_case_table_names=2; Where did you get this command from? I hope it's not in the manual, because that's not legal syntax. The option would be specified like this: --lower_case_table_names=2 Ideally I would like this to be permanet so I have also investagated editing the my.cnf file: 4.1.2 `my.cnf' Option Files MySQL can, since Version 3.22, read default startup options for the server and for clients from option files. On Windows, MySQL reads default options from the following files: Filename Purpose windows-directory\my.ini Global options C:\my.cnf Global options windows-directory is the location of your Windows directory. But neither of these files exist on my system. I would be most grateful if someone could show me how to run the command line option or edit the necessary file to make these changes permanent. If an option file doesn't exist, just create it with a text file editor. Put this in it: [mysqld] lower_case_table_names=2 -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Users Table
At 12:53 + 5/1/04, shaun thornburgh wrote: Hi, I have just installed MySQL on Windows 2000, after inspecting the mysql users table I have noticed that there are four users: Host User localhost root gcw root % root gcw Three of the accounts have a root name and one has a blank name? Normally, two will say root and two will be blank. What version of MySQL did you install? Did you change the user table? I know about the two root accounts but where did the gcw user come from, there is no documentation on the mysql site? root is a username gcw is a hostname The MySQL manual says nothing about "gcw", it's true. Is that your hostname? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
lower_case_table_names
Hi, I am trying to set the mysql variable lower_case_table_names to 2, however I am having serious difficulties! I understand I need to do this at the command line but I have tried the following (with many variations) without success: C:\mysql\bin>mysqld --SET-lower_case_table_names=2; Ideally I would like this to be permanet so I have also investagated editing the my.cnf file: 4.1.2 `my.cnf' Option Files MySQL can, since Version 3.22, read default startup options for the server and for clients from option files. On Windows, MySQL reads default options from the following files: Filename Purpose windows-directory\my.ini Global options C:\my.cnf Global options windows-directory is the location of your Windows directory. But neither of these files exist on my system. I would be most grateful if someone could show me how to run the command line option or edit the necessary file to make these changes permanent. Thanks for your help _ Express yourself with cool emoticons - download MSN Messenger today! http://www.msn.co.uk/messenger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL Users Table
your hostname ? -Original Message- From: shaun thornburgh [mailto:[EMAIL PROTECTED] Sent: Saturday, May 01, 2004 10:53 PM To: [EMAIL PROTECTED] Subject: MySQL Users Table Hi, I have just installed MySQL on Windows 2000, after inspecting the mysql users table I have noticed that there are four users: Host User localhost root gcw root % root gcw I know about the two root accounts but where did the gcw user come from, there is no documentation on the mysql site? THanks for your help _ Sign-up for a FREE BT Broadband connection today! http://www.msn.co.uk/specials/btbroadband -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Users Table
Hi, I have just installed MySQL on Windows 2000, after inspecting the mysql users table I have noticed that there are four users: Host User localhost root gcw root % root gcw I know about the two root accounts but where did the gcw user come from, there is no documentation on the mysql site? THanks for your help _ Sign-up for a FREE BT Broadband connection today! http://www.msn.co.uk/specials/btbroadband -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ERROR 2026: SSL connection error
Hello! I'm using MySQL 4.0.18 on a SuSE 9.0 machine. I compiled it with ./configure \ --with-vio \ --with-openssl \ --without-debug \ --without-bench \ --enable-assembler I've created the certs & keys with the following commands: openssl req -new -x509 -keyout $PRIV/cakey.pem -out $DIR/cacert.pem -config $DIR/openssl.cnf openssl req -new -keyout $DIR/server-key.pem -out $DIR/server-req.pem -days 730 -config $DIR/openssl.cnf openssl rsa -in $DIR/server-key.pem -out $DIR/server-key.pem openssl ca -policy policy_anything -out $DIR/server-cert.pem -config $DIR/openssl.cnf -infiles $DIR/server-req.pem openssl req -new -keyout $DIR/client-key.pem -out $DIR/client-req.pem -days 730 -config $DIR/openssl.cnf openssl rsa -in $DIR/client-key.pem -out $DIR/client-key.pem openssl ca -policy policy_anything -out $DIR/client-cert.pem -config $DIR/openssl.cnf -infiles $DIR/client-req.pem My /etc/my.cnf looks like this: --- /etc/my.cnf [client] ssl-ca=/etc/mysql/cacert.pem ssl-cert=/etc/mysql/client-cert.pem ssl-key=/etc/mysql/client-key.pem socket=/dat1/srv/chroot/mysqld/tmp/mysql.sock [mysqld] port=3306 user=mysql safe-show-database skip-symlink safe-user-create log=/var/log/mysql/mysql.log log-slow-queries=/var/log/mysql/slow_queries.log ssl ssl-ca=/etc/mysql/cacert.pem ssl-cert=/etc/mysql/server-cert.pem ssl-key=/etc/mysql/server-key.pem set-variable=local-infile=0 -- EOF SSL connections worked fine for a cuple of hours, but then I get this SSL error: ERROR 2026: SSL connection error When I delete the certs & keys and creating them again, all works fine for some time. But then the same error occurs. What did I wrong??? It seems, that the certs & keys are vaild only for some hours. Maybe someone could help me. Thanks. Tobias Gunkel Germany -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Win & Linux
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 | | 4) My question is: Is it possible that de datadir was the same to | Win and Linux because i can't duplicate my databases? The disk2 is | read and write. If it is possible, how? You can create a symlink. Have you tested compatibility between MySQL 5 and 4 concerning authentification? You should install the same versions even if it doesn't fix this error. Ivan - -- To mess up a Linux box, you need to work at it; to mess up your Windows box, you just need to work on it. - - Scott Granneman, Security Focus -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFAk4MDTGB93IULb3YRAnmjAKCA/OYTxhHwKDhxrcsVk9trcttXBQCfSe4n pzotE7mWlxu9zEet6KmP5O4= =ayfv -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Win & Linux
Hi all! I want you to present this question: 1) I'm working finely with Mysql 5 over W2k without problems on Disk1. My datadir is on Disk2. Ok. 2) One mounth ago, i've installed Linux (Debian) and yesterday i've instaled mysql 4.00 on a partition of the Disk1. Without problems. 3) I'm trying to change the datadir of 'my.cnf' to my database of mys Disk2 and when i reboot, Mysql server says "Can't connect to localhost Mysql server". Change the previous my.cnf, restart mysql server and connect ok. 4) My question is: Is it possible that de datadir was the same to Win and Linux because i can't duplicate my databases? The disk2 is read and write. If it is possible, how? Reggards, Segismundo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]