[example: Narrow Spikes With Small $L^p$ Mass]
Let $X=[0,1]$ with [Lebesgue measure](/page/Lebesgue%20Measure), fix $1\leq p<\infty$, and define
\begin{align*}
f_n(x)=n^{1/p}\mathbb{1}_{(0,1/n)}(x).
\end{align*}
For $x\in(0,1/n)$, one has $|f_n(x)|^p=(n^{1/p})^p=n$, while for $x\notin(0,1/n)$ one has $|f_n(x)|^p=0$. Hence
\begin{align*}
\int_0^1 |f_n(x)|^p\,dx=\int_0^{1/n} n\,dx.
\end{align*}
Since the integrand is constant on $(0,1/n)$,
\begin{align*}
\int_0^{1/n} n\,dx=n\left(\frac{1}{n}-0\right)=1.
\end{align*}
Therefore $\|f_n\|_p^p=1$, and so $\|f_n\|_p=1$ for every $n$.
Now define
\begin{align*}
g_n(x)=n^{1/p}\mathbb{1}_{(0,1/n^2)}(x).
\end{align*}
For $x\in(0,1/n^2)$, one has $|g_n(x)|^p=n$, and outside this interval the value is $0$. Thus
\begin{align*}
\|g_n\|_p^p=\int_0^1 |g_n(x)|^p\,dx=\int_0^{1/n^2} n\,dx.
\end{align*}
Again using constancy of the integrand,
\begin{align*}
\int_0^{1/n^2} n\,dx=n\left(\frac{1}{n^2}-0\right)=\frac{1}{n}.
\end{align*}
Thus $\|g_n\|_p^p=1/n$ and $\|g_n\|_p=n^{-1/p}\to 0$. The two families both form tall spikes near $0$, but $L^p$ size records the product of height-to-the-$p$ and supporting measure, not the visual height alone.
[/example]