; stack of each friend of the user (and remove
the last one). This way, your reads will be fast and you don't need
complex joins over multiple shards. Just one of my first ideas which
came up.
Any thoughts?
Best regards,
Sander
On 03/29/2011 07:50 PM, Gregory Magarshak wrote:
Hey there. My
the MySQL online reference manual to study for the cluster
certification, so that should be enough to pass the cluster exam ;-)
Sander
On 02/23/2011 09:18 AM, blue mary wrote:
Try search it on howtoforge.com
Or buy a book like "high performance mysql" for reference.
Regards,
mar
http://www.geonames.org/
http://download.geonames.org/export/dump/?C=S;O=D
On 02/02/2011 11:30 AM, viraj wrote:
dear list,
where can i find a list of map polygons for united states cities? any
open database? or tool to obtain correct coordinates?
i googled but couldn't find anything useful..
> exit mysql client and enter again.
Instead of exit client and enter again, just type \r (reconnect)
and you have a new session.
On 10/23/2010 06:44 PM, Claudio Nanni wrote:
Just a little note:
sometimes, if you are in command line session, you will not see the change
of the dynamic variabl
ALTER TABLE sometable AUTO_INCREMENT = 1000;
On 10/17/2010 07:03 AM, short cutter wrote:
Hi,
Is it possible to change this directive's value without modifition to
my.cnf and restart mysqld?
I remember there is a set @@variable syntax, but not sure.
Thanks.
2010/10/17 mos:
At 08:55 PM 1
Check whether mysql is running:
ps aux | grep mysqld
If MySQL is not running, check /var/log/mysql/error.log for errors.
Have you changed /etc/mysql/my.cnf and/or /etc/mysql/conf.d/*.cnf or are
are you still using the default config files from Ubuntu?
On 10/16/2010 06:30 PM, Dave M G wrote:
Setting this option is a trade-off between your durability requirement
and performance requirement.
http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html#sysvar_innodb_flush_log_at_trx_commit
0 gives best performance (write + flush once every second). 1 gives best
durability (write + f
se. Always use prepare() and execute() statements to feed the
userdata, or use the proper quote() calls...
Or explicitly state what characters you will allow and filter anything
but those characters from the user supplied data.
Kind regards,
Sander.
--
| Someone who thinks logically provides a ni
as gone away.
Really hard to debug this on a live system, but i thought i'd let you
guys know...
Thanks again for all the hints and help!
Kind regards,
Sander Smeenk.
--
| Just remember -- if the world didn't suck, we would all fall off.
| 1024D/08CEC94D - 34B3 3314 B146 E13C 70C8 9BDB
lication_timeout | 10|
| table_lock_wait_timeout | 50|
| wait_timeout | 28800 |
max_connections == 100. But nothing about a timeout or too many
connections is being logged. That's the strange part. There's no message
anywhere.
Thanks for all the ideas though!! Hope we ca
orking on an InnoDB table? Try turning on the InnoDB monitor
> while the query runs and see if you're getting any deadlocking.
> http://dev.mysql.com/doc/refman/5.0/en/innodb-monitor.html
We're using MyISAM tables.
Thanks for your ideas, i hope we can find out what's going
maybe the "You can also get these errors if you send a query to
the server that is incorrect or too large." topic. But still, explain to
me, why DOES it work when i run just that query, and why DOESN'T it work
when alot of other queries were in front of it...
:)
Sander.
--
| Depression i
eturns about 25 megabytes of
data, in ~540784 rows)
After that no more queries from the same connection ID are logged.
But that is expected, as the connection was lost ;)
Can anyone shed any light on this issue?
Thanks!!
Sander.
--
| Honk if you love peace and quiet.
| 1024D/08CEC94D - 34B
ng all the indexes on all the
tables. Since then this problem disappeared.
But what I did was copy the binary myisam tables from a 32 bit MySQL4
database to a 64 bit MySQL5 database.
Just an idea.
Regards,
Sander.
--
| Eat well, stay fit, die anyway.
| 1024D/08CEC94D - 34B3 3314 B146 E13C 70C8 9BD
QL datadirectory is full.
Either you or your hoster should clean it up ;)
With regards,
Sander.
--
| Junk is something you've kept for years and throw away three weeks
| before you need it.
| 1024D/08CEC94D - 34B3 3314 B146 E13C 70C8 9BDB D463 7E41 08CE C94D
--
MySQL General Mailing List
lock table
flush table
binary copy table* to tempdir
unlock table
}
}
What seems like a normal binary copy to me.
All three files were copied, the .frm, the .MYI and the .MYD.
Regards,
Sander.
--
| 't Gaat om 't spel, niet om de knikkers!
| 1024D/08CEC94D - 34B3 3314 B1
m 32bit systems over to 64bit systems. Is it as bad to binary
copy tables from 64bit to 32bit systems?
It's vital in our current setup that binary copy of tables works.
Or we need to set up replication right now ;)
Lemmeknow and Thanks!!
Sander.
--
| Lead me not into temptation... I can fi
Quoting [EMAIL PROTECTED] ([EMAIL PROTECTED]):
> Have you tried the following myisamchk option:
> --extend-check, -e
Yup. But that won't even work at ALL:
# myisamchk -e games.MYI
Checking MyISAM file: games.MYI
Data records: 10644 Deleted blocks: 0
- check file-size
- check record de
ue what might cause this
to happen? Disk looks fine too, no read or write errors whatsoever...
Thanks,
Sander.
--
| Just remember -- if the world didn't suck, we would all fall off.
| 1024D/08CEC94D - 34B3 3314 B146 E13C 70C8 9BDB D463 7E41 08CE C94D
--
MySQL General Mailing List
For li
switch "-r" or "-o"
| [1]17564 exit 255 myisamchk games.MYI
No matter WHAT i try, fixing with 'repair table' using mysqlcheck,
myisamchk, -o, -r, -f, it seems like i can't repair this table.
So what's going on? Does anyone have any clue?
Regards,
Sa
s only used for selects and not
inserts updates and crazy select with joins, group by's etc.
But what can the message indicate? All I got from Google was that it
probably had to do with buggy memory. But i ran memtest86+ on the server
and it had 17 passes with zero errors... :|
HTH,
Sander.
--
keeps crashing.
Any hints are welcome!
Thanks in advance!
Kind regards,
Sander Smeenk.
--
| For security, this message has been encrypted with ROT13 twice.
| 1024D/08CEC94D - 34B3 3314 B146 E13C 70C8 9BDB D463 7E41 08CE C94D
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
> Can anyone share and/or comment about the use of Epoch time,
> especially the hazards?
Using timestamps you can synch all your times with the server via
'now()' and the like. If you use the epoch time on the client side you
might have problems. What those problems are, I couldn't say- but I h
> -Original Message-
> From: Sergei Golubchik [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 08, 2002 12:53
> To: Sander Pilon
> Cc: [EMAIL PROTECTED]
> Subject: Re: MERGE & FULLTEXT, two years later.
>
>
> Hi!
>
> On Jul 08, Sander Pilon wrot
I searched the archives and in December 2000 it did 'not yet' work.
( http://listarchive.nextrieve.com/mysql//200012/msg00539.html )
Will MERGE tables and FULLTEXT indexes work together in 4.x?
Two-and-a-half years later?
Regards
Is it possible to run replication on tables that are updated with user
vars?
Example:
SET @id = 1; does not show up in binlog!!
INSERT INTO table SET id = @id;
Now, on the master it works fine. The slave fails because the SET does
not seem to show up in the binlog, @id is not set, and the
> -Original Message-
> From: Daniel Koch [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 27, 2002 13:11
> To: Arul
> Cc: MySQL
> Subject: Re: MYSQL 4.0
>
>
> Arul wrote:
>
> >Hi
> >
> >Any idea when MySQL 4.0 stable release will be made..
> >As of now only Alpha is released..
> >
>
When you have a table with both numeric and variable-length text data,
and you need to update the numeric part a lot, it made sense in MyISAM
to split the numeric from the textpart. (Because working on fixed-length
tables is so much faster.) Say...
Original:
Table 1: id1 int, id2 int, articlete
When you have a table with both numeric and variable-length text data,
and you need to update the numeric part a lot, it made sense in MyISAM
to split the numeric from the textpart. (Because working on fixed-length
tables is so much faster.) Say...
Original:
Table 1: id1, id2, articletext
MyIS
select count(*) from myTable where sal > 1000;
Ryan Sander
Web Developer
[EMAIL PROTECTED]
http://cantonrep.com
> --
> From: [EMAIL PROTECTED]
> Sent: Thursday, May 30, 2002 2:24 PM
> To: [EMAIL PROTECTED]
> Subject: count...I think
>
>
Hmmm. That's a pretty generic statement. There are lots of different ways
to get information from a database. Need more info.
Ryan Sander
Web Developer
[EMAIL PROTECTED]
http://www.cantonrep.com
> --
> From: sunil nair
> Sent: Wednesday, November 28
> -Original Message-
> From: Ryan Fox [mailto:[EMAIL PROTECTED]]
> Sent: 29 October 2001 00:55
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: Data Normalization Paradox
>
>
> > Among other criteria, it mentions that in first order normalization
> > "No
> repeating groups o
l over 100K
lines of C++.
I don't know if it works with the standard mysql++, as we use an
internal mysql++ clone.
Regards,
Sander
PS. For threads with C++ you should check out the QPThread library. It
greatly simplifies thread programming under C++, and provides
synchronisation entities
lower when there is a WHERE
clause present?
Regards,
Sander
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-ma
to contain hundredthousands of rows - and I
need to be able to filter on these flags effeciently.
I could make 20 separate rows as tinyint, but that seems like a lot of
overhead.
Anyone knows what's best in this situation?
-Sander
-
just add
mysql_init(&csql);
before accessing the struct for any purpose.
Sure it helps (I made the same mistake, got the same result ;-)
Uwe
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, September 01, 2001 8:25 PM
Subject: Mysql C API Problem
>
> MySQL - as I said at our meeting, we would not be comfortable
> with this
> as an enterprise strength solution. MySQL is unsupported freeware and
> lacks enterprise management functionality.
True, if you ask me.
> It has a small limited feature
> set compared to ORACLE, DB/2
True. No
Lose (some of) the keys!? Keys, especially on small rows (where a key
introduces a lot of overhead), can take a significant percentage of
space.
Turn on key compression? (dunno if innodb supports that)
Other then that I wouldn't know. But live with the fact that keys
introduce overhead. It will
>
> On Mon, Jul 16, 2001 at 05:50:53PM -0700, Jim Matzdorff wrote:
> >
> > >difficult to do (add the necessary code to MySQL),
> provided that the
> > >logging code is as straightforward as the binary logging code.
> >
> > i figured something like that, though i don't know the
> internals.
> So you're saying like this...?
>
> Albums
> --
> ID,Artist,Title,Label
>
> Tracks
> --
> Title,Length,TrackNumber,AlbumID
>
> Where there is one album table and one track table, and each
> track references back to the album that it is a member of?
> I'm liking that... It doesn't
>
> > the same time, a NuSphere-controlled mysql.org doesn't strike me
> > as a disaster, provided they can do it with out shooting
> > themselves in the foot, as they are doing now.
> >
>
>
> Nah
>
> There using it as a marketing ploy to dup the public.
>
> The should have released their G
You must compile PHP with the mysql module enabled. See the PHP manual
for more information.
(Or search the excellent php mailinglist archives at
http://www.php.net/support.php)
> -Original Message-
> From: Rick Makla [mailto:[EMAIL PROTECTED]]
> Sent: 18 July 2001 17:02
> To: [EMAIL PRO
> MySQL supports transactions if you are using either InnoDB or
> Gemini table types.
>
> Cal
Are we forgetting BDB tables? Yes.. yes.. I believe we are!
http://www.mysql.com/doc/B/D/BDB_characteristic.html
-
Before post
erparts? (Or
about as fast, etc.)
BLOB / TEXT support was one of the few reasons I haven't tried out
InnoDB so far (since I need to store large articles), but now that that
limitation is lifted I want to try it out A
k violation.
>
> Then, Marten, tell us what the status is of the trademark
> application? Under way, finished, or "in the mail" as
> suggested by the other post from Sander Pilon? (I don't know
> about US legal aspects here, but I'ld assume "in the mail&quo
>
> This is very interesting, this "Open Source Legal Resolution" ;-)
>
Indeed it is.
The thing I find most interesting, and a bit scary, is the way people
seem to pick sides.
For example - "vermin", "scum", "obscure", are just a few of the words
recently used to describe the likes of Nu
> Hi!
>
>
>
> Sander> I do not deny their claim on the trademark OR domain,
> but I am
> Sander> somewhat unpleasantly surprised by the means they try
> to resolve
> Sander> this matter, and the fact that nobody in a what I
> assume is an
> Sand
>
> "Sander Pilon" <[EMAIL PROTECTED]> writes:
>
> > > I think all of us should send a letter to the people who
> > > appropriated
> > > the MySQL.org name. In my opinion, if MySQL AB wants this
> domain they
> > > should h
d in this childish
conflict. I have always thought of Yahoo! and MySQL as the more friendly
companies - I guess I was off. Way off :(
This whole affair leaves a bad taste in my mouth - and it aint coming
from the MySQL.org website.
Regards,
Sander
--
My vote goes to a my.cnf configuration file. (/etc/my.cnf - or one of
the other possible locations)
It is, after all, a configuration option.
[Raid]
directory1=/disk1/mysql
directory2=/disk2/mysql
directory3=/disk3/mysql
etc..
> -Original Message-
> From: Markwalder Philip [mailto:[EMA
The answer to ALL your 'where can I get it' questions is -
1) Freshmeat. www.freshmeat.net (Search for 'cscope'.)
2) Google. www.google.com (Repeat search)
Seaarch 1 results in this url: http://freshmeat.net/projects/cscope/
-Sander
> -Original Message-
&
You can *STORE* Unicode (UTF-8) in MySQL just fine. Just don't expect
text-search (LIKE, =, etc) to do anything useful with it.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]] On Behalf Of md
> Sent: 1 June 2001 15:22
> To: [EMAIL PROTECTED]
> Subject: Unicod
. There are 3 frontends (Sun) webservers. We're
making about 15 connections per second. Has anybody any tips about the
configuration and give advice about how to prevent those errors.
Sander.
my.cnf parameters:
[client]
port= 3306
socket = /tmp/mysql.sock
# The MySQL
Compiled with -D_REENTRANT -D_PTHREADS -fPIC -DPIC -Wall
Linked with -pthread
but its not mysql. For mysql I just did ./configure; make; make install
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 16 May 2001 17:11
> To: Sander Pilon
&
Freebsd does not have a libpthreads file.
Just compile with -pthread(s) and it'll work. Well, it does for me.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 16 May 2001 16:18
> To: Sinisa Milivojevic
> Cc: [EMAIL PROTECTED]
> Subject: Re: Help with Fr
Hi,
we've got a customer with a large ms sql database but want to replicate a
smaller dataset to our own mysql server. Is this possible, and does anybody
have experiences with it,
regards,
Sander
No editing?!? Psch... louzy programmers.
( see http://www.jpsoft.com/index.htm for proof that consoles in NT/2K
consoled can edit just fine, etc.)
But... there are numerous mysql clients available, also for windows. I
bet you can find one with fine edit capabilities in the contrib section.
( I
Sent: 29 April 2001 14:32
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: Problems with MySQL++
>
>
> Sander Pilon writes:
> > >
> > > It is fine and complete will all chapters and in all formats.
> > >
>
> It is fine and complete will all chapters and in all formats.
>
This page used to have lots of cool documentation...
http://www.mysql.com/documentation/mysql++/5_Class.html
-
Before posting, please check:
http://ww
> Howdy,
>
> I posted this question over on the plusplus list, but so
> far I've not received a response. This list seems more
> active, so perhaps someone here can offer me a hand.
>
> I'm trying to get the 1.7.8 distribution of MySQL++ to
> build as directed in the README -- using auto
> OS: Red Hat Linux 6.0 / Intel
> 1GB RAM
>
> MySQL 3.23.36
> PHP4.0.4PL1
> Linux kernel 2.4.3
> Using the my.cnf for medium sized sites
>
> mySQL starts with safe_mysqld and there are three threads
> running. Queries come in and out and it's quite fast. Using
> mysqladmin proc status shows n
> We often get a message from MySQL that there are too many connections.
>
> What can we do ?
>
> Should we use connect rather than pconnect ?
>
> We use Php 4.04pl1, Linux, Apache 1.3.17 and MySQL 3.23.32
Yes, you should.
That, or increade the amount of allowed connections, or decrease t
"Aborted" in a C++ program usually means an exception was thrown that
you didnt catch. In this case, the connection constructor could have
thrown something.
try
{
Connection MySQL(db, host, user, pass);
}
catch(...)
{
cout << "Connection failed." << endl;
}
Check the e
UTF-8 is just another encoding scheme.
You can store UTF-8 just fine in MySQL (using BLOB, or perhaps even
CHAR), however you cannot do much more with it beyond storing.
Comparisons aren't likely to work, character-length calculations will
not work, etc. So if all you wanna do is store and retri
>
> Hi Sander!
>
> On Thu, Mar 29, 2001 at 02:11:02PM +0200, Sander Pilon wrote:
>
>
> > I'm getting a whole lot of mysql++ link problems on freebsd :/
> >
> > Used gcc 2.95.3, latest mysql++
> >
> > The program links fine under linux &
> -Original Message-
> From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
> Sent: 29 March 2001 14:56
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: MySQL++ Compile / link problems on freebsd
>
>
> Sander Pilon writes:
>
I'm getting a whole lot of mysql++ link problems on freebsd :/
Used gcc 2.95.3, latest mysql++
The program links fine under linux & win32.
Any idea's?
g++-L/usr/local/lib/mysql -L/usr/local/lib -L/usr/lib -pthread -o bord
main.o BMain.o options.o ../actioninterface/libactioninterface.a
..
educating, articles here too.)
http://www.ping.be/~ping0658/avrank.html#zipf
http://www.swtech.com/server/websvr/wsindex/
Regards,
Sander
> -Original Message-
> From: Cedric Veilleux [mailto:[EMAIL PROTECTED]]
> Sent: 23 March 2001 04:30
> To: [EMAIL PROTECTED]
> Subject: Larg
Hi,
I've compiled mysql 3.23.33 but while doing a 'make test'
the merge test fails (it passes all others). Any common
reason for this?
Thanks in advance.
Sander
-
Before posting, please check:
http:
Web robots are not search engines (just the things that fill the engines),
as far as I understand.
As I mailed to J. earlier, most searchengine algorithms aren't directly
compatible with (my)sql.
(Meaning that, for the best performance *you* have to do the searching, and
not mysql - once you have
I doing a newspaper site. My database has a different table for each
category (local, sports, etc). All of the columns are the same for each
table (Headline, byline, body, etc). Is there any way to search all of the
tables at once (since they all have the same columns)?
To further illustrate.
Right,
As far as *MySQL* goes I haven't noticed this in particular. That's because
most mysql reads are indexed and use keys/caches.
As far as general performance goes, I've definitely noticed it.
(Creation/Deletion of large and large number of files is much, MUCH faster
than ext2 - and reiserfs
Good questions - I have a few more :)
A) why does it seem to use fixed-size storage units. (The files)
B) what happens when they ar full?
C) can it auto-create new files as demand grows?
D) can you safely add new files when there is data in them already?
Regards,
Sander
> -Origi
> -Original Message-
> From: Simon Windsor [mailto:[EMAIL PROTECTED]]
> Sent: 22 February 2001 16:22
> To: [EMAIL PROTECTED]
> Subject: ReisserFS
>
>
> Hi
>
> Has anyone user MySql on a ReisserFS file system ?
>
> Where any problems encountered ? and do you have any pearls of
> wisdom th
> on 2/1/01 1:36 PM, Gonzalo Aguilar at [EMAIL PROTECTED] wrote:
>
> > Making search engines is not a trivial thing, but this may be an
> > aproach...
>
> I appreciate all the replies. In my original post I also asked about the
> FULL TEXT index type. If I may ask again, has anyone had any
> expe
>
> > Could be just parania. Several time a second is not much. My guess
> > is that you'll be fine. If it gets slower upgrade your hardware or
> > reconfigure your OS or/and FS or/and MySQL. Anyway, my string
> > opinion is that you should split the table. As i said before that
> > we've
> > been
>
> > René Tegel wrote:
> > >
> > > This is a very good idea, and in fact the only workable way.
> > > Your performance will not lower when retrieving the documents,
> cause those
> > > fields are indexed.
> > > Your memory use will decrease as well, since the file cache does
> not have to
> > >
>
> > > [1 ]
> > > I don't know if any of you people have ever had this trouble, but it's
> > > been a messy one here.
> >
> > > Whenever a website of ours get lots of traffic, MySQL gets too slow to
> > > connect. Whenever it connects, the queries are fast. Since lots of our
> > > scripts relie
Is this perhaps related to the 'slow thread creation' 'feature' of some
linux kernels?
http://lists.mysql.com/php/search.php?ps=10&q=fast+thread+creation+&ps=20&m=
and
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Leonardo Dias
> Sent: 29 Januar
> -Original Message-
> From: Nazeem Y [mailto:[EMAIL PROTECTED]]
> Sent: 27 January 2001 19:19
> To: [EMAIL PROTECTED]
> Subject: RAW Device support
>
>
> Does MySQl syupport RAW devices ?
>
> Thanks
You mean devices that can Read And Write?
Sure.
If you perhaps mean that it can address
ROM table WHERE ORDER BY S1 LIMIT P,1
But now I want the inverse - given an id X and a sort method, I want the
position.
something like: SELECT POSITION(X) FROM table WHERE . ORDER BY S1
Is there a way to do this?
-Sander
-
Our Exchange Server Detected a virus in all attachments from FUNKY GOA
Ryan Sander
Web Developer
330-580-8549
[EMAIL PROTECTED]
http://cantonrep.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the
82 matches
Mail list logo
